Once you connect your BigCommerce store to Dotdigital, we automatically map some of your customer data to data fields in your Dotdigital account. But, if you want, you can also choose to sync additional customer information.
Before you start
Things you need to know:
Your BigCommerce store must be connected to Dotdigital.
Learn how in Set up BigCommerce with Dotdigital.
Any additional data fields you wish to use to store your data must be created in Dotdigital before they can be mapped.
Learn how in Create, delete, and edit Custom data fields.
New mappings
Mapping new 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
This table lists all the BigCommerce customer fields you can map to your Dotdigital data fields.
If you have more than one BigCommerce store connected to Dotdigital, it is important to understand that you can’t use the same data field mapping for all stores. This is to prevent data from being overwritten between different stores.
We recommend creating new data fields for each store. Data fields marked with an asterisk (*) in the table indicate the fields that are affected by this requirement.
Customer field | Data type |
First name | Text |
Last name | Text |
Created date* | Date |
Company | Text |
Phone | Text |
Note* | Text |
Has account* | Text |
Customer group* | Text |
Customer group ID* | Text |
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 |
Map customer data to Dotdigital
In Dotdigital, go to Connect and select the BigCommerce tile under Installed integrations and extensions.
On the Dotdigital BigCommerce settings page, select the Field mapping tab.
This tab shows you a list of all the data that you can import into Dotdigital. We automatically map Dotdigital's default contact data fields to their equivalent BigCommerce customer field for you.
Find the BigCommerce 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 fields you need, select SAVE.
You can also do the same for your custom fields, which are mapped from your form fields in BigCommerce. Custom fields allow you to capture more customer data and allow you to bring this into your data fields in Dotdigital.
The below form field types can be mapped to these data field types in your field mapping area:
Check box
Text
Date
Date or text
Multi-line text
Text
Numbers only
Text or numeric
Password
Text
Radio button
Text or yes/no
Text field
Text
Pick list
Text or yes/no
If you map a BigCommerce PICKLIST to a yes/no field in Dotdigital, it only works if the list of possible values are yes/no or true/false.
Allow blank values
You can enable a setting to allow blank values from a field in BigCommerce to overwrite existing values in the corresponding Dotdigital data field.
To do this:
Go to Connect, and under Installed integrations and extensions, select the BigCommerce tile.
On the Store tab, under Contacts, set Allow overwriting data with blank values to YES.
Select SAVE.
Field types
We don't check the data type for your custom fields. So, if, for example, you try to map a text field in BigCommerce to a date field in Dotdigital, it fails.
We add new fields as we find them from new or modified customers. For example, if you have a new form field in BigCommerce, it's only available to map after you sync a customer that has the same field.
It's up to you which BigCommerce customer fields that you wish to synchronise. Leave them unmapped if you don't want to sync that specific data to Dotdigital.
Select SAVE once you're happy with your mapping settings and begin syncing to these Dotdigital contact data fields.
If you no longer want to sync data from a BigCommerce customer field, you can simply deselect the mapping and select SAVE to update your mapping settings. The next time a sync runs, your BigCommerce data no longer syncs to this Dotdigital contact data field.
Custom From Address fields
We currently don't support Custom From Address fields.