HCL Commerce Version 9.1.4.0 or later

Configuration du serveur de transactions

Pour terminer l'intégration entre un React Store et Google Tag Manager, vous devez ajouter les paramètres requis au serveur de transactions.

Obtention des paramètres du conteneur Google Tag Manager

  1. Sélectionnez Google Tag Manager.
  2. Sélectionnez le conteneur et accédez à onglet Admin > Environnements.
  3. Cliquez sur Actions > Obtenir un extrait de code pour la production.
  4. Copiez les valeurs gtm_auth et gtm_preview .
HCL Commerce Version 9.1.4.0

Exemples d'instructions SQL pour ajouter l'ID de client OAuth configuré via la console d'API Google

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

Exemple d'instruction SQL pour configurer le serveur de transactions pour le magasin Emerald B2C

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); 
HCL Commerce Version 9.1.6.0 or later
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);
HCL Commerce Version 9.1.12.0 or later

EmeraldMP

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

Exemple d'instruction SQL pour configurer le serveur de transactions pour le magasin Emerald/EmeraldMP B2C

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); 

Exemple d'instruction SQL pour configurer le serveur de transactions pour le magasin Sapphire B2B

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); 
HCL Commerce Version 9.1.6.0 or later
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);
HCL Commerce Version 9.1.12.0 or later

SapphireMP

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

Exemple d'instruction SQL pour configurer le serveur de transactions pour le magasin Sapphire/SapphireMP B2B

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); 
HCL Commerce Version 9.1.14.0 or later

Ruby

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (41, 'google.analytics.versions', 'GA4', 0)
HCL Commerce Version 9.1.14.0 or later

Exemples d'instructions SQL permettant de configurer le serveur Transaction pour le magasin 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);
HCL Commerce Version 9.1.14.0 or later

Boutique Ruby B2B

INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE, OPTCOUNTER) VALUES (42, 'google.analytics.versions', 'GA4', 0);
HCL Commerce Version 9.1.14.0 or later

Exemples d'instructions SQL permettant de configurer le serveur Transaction pour le magasin Ruby B2B

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);

Configurations de base de données pour queManagement Center se connecte à Google Analytics

Table 1. Données exemple
Configuration Table dans la base de données Nom du paramètre Description et valeur
Compte de service : Portées autorisées.

Utilisé par le serveur de transactions pour générer un jeton d'accès.

STORECONF google.analytics.service.account.scopes Les portées autorisées par OAuth auxquelles ce compte de service Google est autorisé à accéder.

https://developers.google.com/identity/protocols/oauth2/scopes#analyticsreporting

ou

https://www.googleapis.com/auth/analytics.readonly

HCL Commerce Version 9.1.4.0ID du client OAuth

Utilisé par le Centre de gestion pour se connecter à Google Analytics

STORECONF google.analytics.client.id L'ID de client OAuth configuré via la console d'API Google.

Cette opération est requise pour que HCL Commerce s'authentifie auprès de Google et soit autorisé avec Google Analytics.

Compte de service - ID de vue STORECONF google.analytics.service.account.view.id Par exemple : 226858278.

HCL Commerce Version 9.1.12.0 or laterL'ID de propriété pour le compte GA4

STORECONF google.analytics.property.ga4 Par exemple : 263926965.

Configuration de la base de données pour que React Store se connecte à Google Tag Manager

Table 2. Données exemple
Table dans la base de données STOREENT_ID Nom du paramètre Valeur
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 Votre ID de conteneur de magasin Sapphire à partir de la configuration de Google Tag Manager.
STORECONF 12 google.tag.manager.auth Votre valeur Auth de magasin Sapphire à partir de la configuration de Google Tag Manager.
STORECONF 12 google.tag.manager.preview Votre valeur d'aperçu de magasin Sapphire à partir de la configuration 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