You can map your Salesforce Commerce Cloud customer fields to corresponding Dotdigital contact data fields.
Before you start
Things you need to know:
Default Dotdigital contact data fields are automatically mapped to their equivalent Salesforce Commerce Cloud customer fields for you.
It's up to you which Salesforce Commerce Cloud customer fields you want to synchronise. Leave customer fields unmapped if you don't want to sync that specific data to Dotdigital.
Configure your field mapping settings
In Dotdigital, go to Connect and select the Salesforce Commerce Cloud tile under Installed integrations and extensions.
Select the Field mapping tab.
Find the customer field you want to map, then expand the drop-down menu and choose the Dotdigital contact data field that you want to map and sync to.
Once done, select SAVE, to begin syncing to these Dotdigital contact data fields.
If you no longer want to sync data from a Salesforce Commerce Cloud customer field, you can deselect the mapping here and select SAVE to update your mapping settings. The next time a sync runs, your Salesforce Commerce Cloud data won’t sync to this Dotdigital contact data field.
Customer fields
If you have more than one Salesforce Commerce Cloud store connected to Dotdigital, it is important to understand that you can’t use the same data field mapping for all stores. This is to prevent data from being overwritten between different stores.
We recommend creating new data fields for each store. Data fields marked with an asterisk (*) in the table indicate the fields that are affected by this requirement.
Field | Data type |
First name | Text |
Last name | Text |
Login* | Text |
Created date* | Date |
Last visit time* | Datetime |
Last login time* | Datetime |
Birthday | Date |
Has account* | Text |
Preferred locale* | Text |
Shipping address 1 | Text |
Shipping address 2 | Text |
Shipping phone | Text |
Shipping city | Text |
Shipping postcode | Text |
Shipping state | Text |
Shipping country | Text |
Shipping company | Text |
Allow blank values
You can enable a setting to allow blank values from a field in Salesforce to overwrite existing values in the corresponding Dotdigital data field.
To do this:
Go to Connect, and under Installed integrations and extensions, select the Salesforce tile.
On the Store tab, under Contacts, set Allow overwriting data with blank values to YES.
Select SAVE.