All Collections
Integrations
Shopify and Shopify Plus
Customers and subscribers
Map Shopify customer data to Dotdigital contact data fields
Map Shopify customer data to Dotdigital contact data fields

Connect your customer data between your accounts.

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

Once you connect your Shopify store to Dotdigital, we automatically match your customers' first and last names to data fields in your Dotdigital account. But, if you want, you can also choose to sync additional customer information – for example, phone number, billing and shipping address, and much more.


Before you start

Things you need to know:

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

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


Map customer fields to Dotdigital

  1. Go to Connect.

  2. 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.
    ​
    ​

  3. 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.

  4. 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.

Did this answer your question?