The Shopline connector synchronises standard contact information, billing and shipping information, tags, notes, and some calculated order details for all of your Shopline customers. This information is stored against Dotdigital contact data fields.
Contact data fields are automatically created and mapped to your Shopline customer fields that are in your Shopline 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 Shopline customer data to Dotdigital contact data fields.
For newer installations of the Dotdigital for Shopline connector, contact data fields are automatically created and mapped to the corresponding customer fields.
Learn more in Set up Shopline 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 Shopline 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:
Field | Data type |
FIRSTNAME | Text |
LASTNAME | Text |
Login | Text |
Created date | Date |
Birthday | Date |
Note | Text |
Tags | Text |
Last order ID | Numeric |
Orders count | Numeric |
Billing address 1 | Text |
Billing address 2 | Text |
Billing phone | Text |
Billing city | Text |
Billing postcode | Text |
Billing state | Text |
Billing country | Text |
Billing company | 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 |
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:
Shopline-LOGIN-UK-PROD
CREATEDATE-UK-PROD
Shopline-NOTES-UK-PROD
US store:
Shopline-LOGIN-US-PROD
CREATEDATE-US-PROD
Shopline-NOTES-US-PROD