Configuración del servidor de transacciones

Obtención de los parámetros de contenedor de Google Tag Manager

Vaya a Google Tag Manager.
Seleccione el contenedor y vaya a la pestaña Administrador > Entornos.
Pulse la opción Acciones > Obtener fragmento de código.
Copie los valores gtm_auth y gtm_preview.

Instrucciones SQL de ejemplo para añadir el ID de cliente de OAuth configurado mediante la consola de la API de Google

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (0, 'google.analytics.client.id', <YOUR CLIENT ID FROM GOOGLE API CONSOLE>, 0);

Instrucciones SQL de ejemplo para configurar el servidor de transacciones para la tienda B2C Emerald

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.analytics.service.account.view.id',<YOUR VIEW ID FROM THE GOOGLE ANALYTICS EMERALD STORE PROPERTY>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.tag.manager.container.id', <YOUR EMERALD STORE CONTAINER ID FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.tag.manager.auth', <YOUR EMERALD STORE AUTH VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.tag.manager.preview',<YOUR EMERALD STORE PREVIEW VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0);

Specify the Google Analytics version. You can specify the version as UA, GA4 or both. INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.analytics.versions', 'UA,GA4', 0);

EmeraldMP

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (31, 'google.analytics.property.ga4', <YOUR GA4 PROPERTY ID FOR EMERALDMP>, 0);

Instrucciones SQL de ejemplo para configurar el servidor de transacciones para la tienda B2C Emerald/EmeraldMP

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.analytics.service.account.view.id',<YOUR VIEW ID FROM THE GOOGLE ANALYTICS EMERALD STORE PROPERTY>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.tag.manager.container.id', <YOUR EMERALD STORE CONTAINER ID FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.tag.manager.auth', <YOUR EMERALD STORE AUTH VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (11, 'google.tag.manager.preview',<YOUR EMERALD STORE PREVIEW VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0);

Instrucciones SQL de ejemplo para configurar el servidor de transacciones para la tienda B2B Sapphire

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.analytics.service.account.view.id', <YOUR VIEW ID FROM THE GOOGLE ANALYTICS SAPPHIRE STORE PROPERTY>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.tag.manager.container.id',<YOUR SAPPHIRE STORE CONTAINER ID FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.tag.manager.auth', <YOUR SAPPHIRE STORE AUTH VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.tag.manager.preview', <YOUR SAPPHIRE STORE PREVIEW VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0);

Specify the Google Analytics version. You can specify the version as UA, GA4 or both. INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.analytics.versions', 'UA,GA4', 0);

SapphireMP

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (32, 'google.analytics.property.ga4', <YOUR GA4 PROPERTY ID FOR SAPPHIREMP>, 0);

Instrucciones SQL de ejemplo para configurar el servidor de transacciones para la tienda B2B Sapphire/SapphireMP

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.analytics.service.account.view.id', <YOUR VIEW ID FROM THE GOOGLE ANALYTICS SAPPHIRE STORE PROPERTY>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.tag.manager.container.id',<YOUR SAPPHIRE STORE CONTAINER ID FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.tag.manager.auth', <YOUR SAPPHIRE STORE AUTH VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (12, 'google.tag.manager.preview', <YOUR SAPPHIRE STORE PREVIEW VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0);

Ruby

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (41, 'google.analytics.versions', 'GA4', 0)

Instrucciones SQL de ejemplo para configurar el servidor de transacciones para la tienda Ruby

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (41, 'google.tag.manager.container.id', <YOUR RUBY STORE CONTAINER ID FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (41, 'google.tag.manager.auth',<YOUR RUBY STORE AUTH VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (41, 'google.tag.manager.preview', <YOUR RUBY STORE PREVIEW VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (41, 'google.analytics.property.ga4', <YOUR GA4 PROPERTY ID FOR RUBY>, 0);

Tienda B2B Ruby

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (42, 'google.analytics.versions', 'GA4', 0);

Instrucciones SQL de ejemplo para configurar el servidor de transacciones para la tienda B2B Ruby

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (42, 'google.tag.manager.container.id',<YOUR RUBY STORE CONTAINER ID FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (42, 'google.tag.manager.auth',<YOUR RUBY STORE AUTH VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (42, 'google.tag.manager.preview', <YOUR RUBY STORE PREVIEW VALUE FROM THE GOOGLE TAG MANAGER CONFIGURATION>, 0); INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (42, 'google.analytics.property.ga4', <YOUR GA4 PROPERTY ID FOR RUBY>, 0);

Configuraciones de base de datos para que Management Center se conecten a Google Analytics

Table 1. Datos de ejemplo
: configuración	Tabla en la base de datos	Nombre de parámetro	Descripción y valor
Cuenta de servicio: Alcances permitidos. Lo utiliza el servidor de transacciones para generar un token de acceso.	STORECONF	google.analytics.service.account.scopes	Los ámbitos de OAuth permitidos a los que puede acceder esta cuenta de servicio de Google. https://developers.google.com/identity/protocols/oauth2/scopes#analyticsreporting o bien https://www.googleapis.com/auth/analytics.readonly
ID de cliente de OAuth Utilizado por el Centro de gestión para conectarse a Google Analytics	STORECONF	google.analytics.client.id	ID de cliente de OAuth configurada mediante la consola de API de Google. Esto es necesario para que HCL Commerce se autentique con Google y se autorice con Google Analytics.
Cuenta de servicio - ID de vista	STORECONF	google.analytics.service.account.view.id	Por ejemplo: 226858278.
ID de propiedad para la cuenta GA4	STORECONF	google.analytics.property.ga4	Por ejemplo: 263926965.

Configuración de la base de datos de React Store para conectarse a Google Tag Manager

Table 2. Datos de ejemplo
Tabla en la base de datos	STOREENT_ID	Nombre de parámetro	Valor
STORECONF	11	google.tag.manager.container.id	LFR-KJED23K
STORECONF	11	google.tag.manager.auth	Osdfs78hk3dsfo8kKE
STORECONF	11	google.tag.manager.preview	Serv-2
STORECONF	12	google.tag.manager.container.id	ID de contenedor de la tienda Sapphire de la configuración de Google Tag Manager.
STORECONF	12	google.tag.manager.auth	Valor Auth de la tienda Sapphire de la configuración de Google Tag Manager.
STORECONF	12	google.tag.manager.preview	Valor de la vista previa de la tienda Sapphire de la configuración de Google Tag Manager.
STORECONF	41	google.tag.manager.container.id	GTM-KHSCNPNZ
STORECONF	41	google.tag.manager.auth	_WkSmERf8gYhBxZMoQKIQQ
STORECONF	41	google.tag.manager.preview	env-1
STORECONF	42	google.tag.manager.container.id	GTM-THZ55JNP
STORECONF	42	google.tag.manager.auth	n0AokPyKCkpPEjvzNQACEg
STORECONF	42	google.tag.manager.preview	env-1