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.
Learn more in Map Shopify customer data to Dotdigital contact data fields.
For newer installations of the Dotdigital for Shopify connector, contact data fields are automatically created and mapped to the corresponding customer fields.
Learn more in Set up Shopify with Dotdigital.
New mappings
Mapping new data fields will cause a full historical resync of all existing mapped customers. This process can take several hours depending on how many customers you have.
Learn about Shopify customer fields and data types
To make sure you get the customer fields and their data types right, here’s a list of them below:
Customer field | Data type |
First name | Text |
Last name | Text |
Login | 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 |
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