Skip to main content
All CollectionsIntegrationsShoplineData sync
Sync customer fields from Shopline
Sync customer fields from Shopline

Sync the correct customer fields and data types from Shopline to contact data fields in Dotdigital.

Gareth Burroughes avatar
Written by Gareth Burroughes
Updated over a week ago

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.

For newer installations of the Dotdigital for Shopline connector, contact data fields are automatically created and mapped to the corresponding customer fields.

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

Did this answer your question?