Enabling privacy policy acceptance (SQL statements)

When the store function is enabled for requesting shoppers to accept the privacy policy of a store, the Just-in-Time Privacy Notice page is added as a pop-up window to your store. The page can be displayed as a pop-up window on any store page. Each shopper that visits your store must select the check box to accept the privacy policy before the pop-up window closes and the shopper can continue to use your site.

If your site and organization need to meet the European Union (EU) General Data Protection Regulation (GDPR), enable the privacy policy acceptance functionality for your custom store. Enabling this store function and updating the store to provide just-in-time privacy notice capabilities can help your organization on its journey to GDPR readiness.

You can also enable the store function for privacy policy acceptance by using the Store Management tool in Management Center. For more information, see Enabling privacy policy acceptance (Store Management tool).

Procedure

To enable the privacy policy acceptance, run the following SQL statements:

insert into emspot (emspot_id, storeent_id, name, description, usagetype, optcounter) values ($consentOpt_espotId, $storeId, 'ConsentOptions', 'ConsentOptions','STOREFEATURE',1);
insert into emspot (emspot_id, storeent_id, name, description, usagetype, optcounter) values ($mkdConset_espotId, $storeId, 'MarketingConsent', 'MarketingConsent','STOREFEATURE',1);
insert into emspot (emspot_id, storeent_id, name, description, usagetype, optcounter) values ($sesson_espotId, $storeId, 'Session', 'Session','STOREFEATURE',1);
insert into emspot (emspot_id, storeent_id, name, description, usagetype, optcounter) values ($permanent_espotId, $storeId, 'Permanent', 'Permanent','STOREFEATURE',1);
Where:
emspot_id
The unique ID of the e-Marketing Spot that is used for displaying the consent management content.
storeent_id
The store entity ID as defined in the STORE_ID column of the STORE table. Set the value to be '$storeId'
name
Indicates the store function configuration that is being inserted. Insert rows to define the following configurations:
ConsentOptions
Enable store privacy policy page acceptance.
MarketingConsent
Enable the functionality for processing shopper behavior tracking consent for marketing purposes.
Session
Temporarily remember the customer's privacy policy acceptance for the browser session. When configured, the acceptance of the privacy policy is remembered for only the shopper's current browsing session. The shopper must accept the privacy policy again whenever they revisit the store after they close and reopen the browser.
Permanent
Permanently remember the customer's decision using the browser cache. When configured, the acceptance of the privacy policy is remembered until the shopper removes the store cookie from the browser or 30 days elapse from the date that the cookie is created. After the cookie is removed, the shopper must accept the privacy policy again when they next visit the store.
description
The description of the e-Marketing Spot, such as its expected use.
usagetype
Defines the usage of the e-Marketing Spot. Set the value for each store function configuration to be 'STOREFEATURE'.
optcounter
The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented. Set the value for each configuration to be '1'
insert into dmemspotdef values ($dmsptodefId,$consentOpt_espotId,$storeId,'FeatureEnabled','false',0,1);
insert into dmemspotdef values ($dmsptodefId,$mkdConset_espotId,$storeId,'FeatureEnabled','false',0,1);
insert into dmemspotdef values ($dmsptodefId,$sesson_espotId,$storeId,'FeatureEnabled','false',0,1);
insert into dmemspotdef values ($dmsptodefId,$permanent_espotId,$storeId,'FeatureEnabled','false',0,1);
Where:
DMEMSPOTDEF_ID
The unique ID of the E-marketing Spot default content. Set the value to be 'dmsptodefId'
EMSPOT_ID
The unique ID of the e-Marketing Spot that is used for displaying the consent management content. Load data for each of the following e-Marketing Spots:
$consentOpt-espotId
The e-Marketing Spot unique id of the ConsentOptionsstore feature.
$mkdconset_espotId
The e-Marketing Spot unique id of the MarketingConsentstore feature.
$session_espotId
The e-Marketing Spot unique id of the Sessionstore feature.
$permanent_espot_id
The e-Marketing Spot unique id of the Permanentstore feature.
STOREENT_ID
The store entity ID as defined in the STORE_ID column of the STORE table. Set the value to be '$storeId'
CONTENTTYPE
The type of content that is to display in the e-Marketing Spot. Set the value for each configuration to be 'FeatureEnabled'.
CONTENT
The unique identifier of the content. Set the value for the configuration to be 'false',
SEQUENCE
The sequence that the content displays within the e-Marketing Spot. If the content is the only content to display in the e-Marketing Spot, set the value to '0'.
OPTCOUNTER
The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented. Set the value for each configuration to be '1'.

Results

The store function is enabled. When a shopper visits your store after your configuration changes take effect, a pop-up window is displayed that includes the privacy policy. The shopper must accept the store's privacy policy before they can continue to browse the store. The acceptance of the policy is remembered according to the setting that is configured in the Store Management tool.