The Shopify connector synchronises standard contact information, billing and shipping information, tags, notes and some calculated order details for all of your Shopify customers. This information is stored against Dotdigital contact data fields.
Contact data fields must be created manually and then mapped to your Shopify customer fields that are in your Shopify connector settings. It's important for contact data fields in Dotdigital to have the correct data type. If the data type is incorrect, the sync fails.
Before you start
Things you need to know:
Your Shopify store must be connected to Dotdigital.
Learn how in Set up Shopify with Dotdigital.
New mappings
Mapping new custom data fields causes a full historical resync of all existing mapped customers. This process can take several hours depending on how many customers you have.
Customer data you can map to Dotdigital
These are all the Shopify customer data fields you can map to your Dotdigital data fields:
Customer field | Data type |
First name | Text |
Last name | Text |
Login | Text |
Account status | Text |
Created date | Date |
Phone* | Text |
Note | Text |
Tags | Text |
Has account | Text |
Last order ID | Numeric |
Orders count | Numeric |
Total spent | Numeric |
Billing address 1 | Text |
Billing address 2 | Text |
Billing phone | Text |
Billing fax | Text |
Billing city | Text |
Billing postcode | Text |
Billing state | Text |
Billing region | Text |
Billing country | Text |
Billing company | Text |
Shipping address 1 | Text |
Shipping address 2 | Text |
Shipping phone | Text |
Shipping fax | Text |
Shipping city | Text |
Shipping postcode | Text |
Shipping state | Text |
Shipping region | Text |
Shipping country | Text |
Shipping company | Text |
* This field automatically syncs to the Dotdigital data field MobileNumberID for both Customers and Subscribers. It can also be mapped to a Custom Data Field too. However, the sync fails if there is a channel conflict, which is caused when the mobile number already belongs to another contact.
Avoid overwriting similar data fields for different stores during a sync
We recommend creating and mapping different data fields for each of your stores. For example, if you have a UK and a US store, suffix each data field with the store region to avoid overwriting the wrong data fields during a sync:
UK store:
SHOPIFY-LOGIN-UK-PROD
CREATEDATE-UK-PROD
SHOPIFY-NOTES-UK-PROD
US store:
SHOPIFY-LOGIN-US-PROD
CREATEDATE-US-PROD
SHOPIFY-NOTES-US-PROD
Allow blank values
You can enable a setting to allow blank values from a field in Shopify to overwrite existing values in the corresponding Dotdigital data field.
To do this:
Go to Connect, and under Installed integrations and extensions, select the Shopify tile.
On the Store tab, under Contacts, set Allow overwriting data with blank values to YES.
Select SAVE.
Map customer fields to Dotdigital
Go to Connect.
Under Installed integrations and extensions, select the Shopify tile, then select the Field mapping tab. This tab shows you a list of all the data that you can import into Dotdigital. By default, we map First name and Last name for you.
Find the Shopify customer data you want to map, expand its data field drop-down menu, then choose the Dotdigital data field you want to map it to.
Once you've mapped all the data fields you need, select SAVE.
You can also map Customer Meta Fields from Shopify to Dotdigital custom data fields.