Editing any of your data mapping settings after you already have contacts synced to Dotdigital resets all of your contacts in Magento to re-sync with the new corresponding contact data fields.
As standard, the normal synchronisation process only synchronises your customers' and newsletter subscribers' email addresses. However, the connector provides you with the ability to map other key retail information that you store about your contacts from your Magento website to your Dotdigital account.
This can be general customer information, which includes title, customer ID, first name, last name, and so on, including the total number of reviews a customer has left and the date they last left a review.
The full contact data field information outlined below only syncs for your registered customers. Contacts who are subscribers or guests are limited to having just an email address and store name synced to Dotdigital.
Subscriber status can also be mapped, enabling you to send relevant dynamic content based on whether a customer is subscribed or not.
Additionally, you can map address and sales information, including a customer's last quote ID, so you can send relevant product recommendations based on a customer's last abandoned cart. Customer trend data can also be synced and mapped, such as most frequent day/month of purchase and most purchased category/brand.
Custom Magento attributes can also be added and then mapped to Dotdigital contact data fields.
If you integrate with Sweet Tooth, then you can map a customer's Sweet Tooth rewards information to your Dotdigital contact data fields.
Learn more in Data syncing - Sweet Tooth loyalty.
Map Magento data to contact data fields
Create the relevant contact data fields in your Dotdigital account.
Go to System > Dotdigital > Data Mapping.
Expand the drop-down menu for each of your Magento fields and select the Dotdigital contact data field you want to map to.
Select Save Config.
Map newsletter subscribers' opt-in types from Magento to Dotdigital
When newsletter subscribers are synchronised to Dotdigital, the synchronised contacts have either a single opt-in type or a double opt-in type in Dotdigital, depending on your Magento store's Need to confirm subscription option.
To check the subscription option, go to System > Configuration > Customers > Newsletter > Need to Confirm.
When the subscription option is Yes, new newsletter subscribers are sent a confirmation email that asks them to confirm their opt-in. Then, those newsletter subscribers are given a double opt-in type in Dotdigital.
When this subscription option is No, new newsletter subscribers are stored with opt-in type: unknown in Dotdigital.
Add new custom attributes
You can also add any custom attributes that you've created in Magento for capturing customer information and map these to your Dotdigital contact data fields.
To do this:
Under Custom Attributes, select Add New Attribute
Expand the drop-down menu for each custom attribute and select the Dotdigital Contact data field to map to.
Select Save Config.
Create a new contact data field
It could be that you don't have an appropriate existing contact data field to map an attribute to in your Dotdigital account. In which case, you have the ability to create a new Dotdigital contact data field within the connector.
To do this:
Select Create Data Field.
Enter your new contact data field name, select a contact data field value type from the dropdown list, enter a default value if you want to (useful for campaign personalisation purposes), and choose the visibility of the field.
Select Create New Data Field.
The new data field is created in your Dotdigital account and available to map to your Magento fields from the dropdown list.
Make sure you select the appropriate data field type to match the sort of data that is going to be stored in the new data field: string, numeric, date or Boolean (true/false or yes/no).
Learn more about creating and setting up new contact data fields in Dotdigital.
Data field definitions
The definitions for the data fields are as follows:
Customer information
Title - The customer's title.
Customer ID - The Magento database ID for a customer.
First Name - The customer's first name.
Last Name - The customer's last name.
D.O.B - The customer's date of birth.
Gender - The customer's gender.
Account Created Date - The date/time the customer's account was created.
Last Logged In Date - The date/time the customer last logged into their account.
Customer Group - The customer group the customer is currently assigned to.
Customer Review Count - The number of approved reviews the customer has left.
Last Review Date - The date of the customer's last approved review.
Subscriber status - The customer's subscriber status as taken from Newsletter Subscribers.
Address
Billing Address Line 1 - The customer's default billing address line 1.
Billing Address Line 2 - The customer's default billing address line 2.
Billing State/Region - The customer's default billing state/region.
Billing City - The customer's default billing city.
Billing Country - The customer's default billing country.
Billing Zip/Postcode - The customer's default billing zip/postcode.
Billing Telephone - The customer's default billing telephone.
Delivery Address Line 1 - The customer's default delivery address line 1.
Delivery Address Line 2 - The customer's default delivery address line 2.
Delivery State/Region - The customer's default delivery state/region.
Delivery City - The customer's default delivery city.
Delivery Country - The customer's default delivery country.
Delivery Zip/Postcode - The customer's default delivery zip/postcode.
Delivery Telephone - The customer's default delivery telephone.
Delivery Company Name - The customer's default delivery company name.
Sales
Total Number of Orders - The number of orders placed as a customer. The orders used in the calculation can be configured in the Data Fields section in Configuration.
Average Order Value - The average order value of the customer's orders. The orders used in the calculation can be configured in the Data Fields section in Configuration.
Total Spend - The total value of the customer's orders. The orders used in the calculation can be configured in the Data Fields section in Configuration.
Last Purchase Date - The date of the last order placed as a customer.
Last Increment ID - The friendly order number of the customer's last order.
Total Refund - The total amount the customer has had refunded through Magento.
Most Purchased Category - The category a customer has most frequently purchased from based on their history. If there's no clear winner then the category with the highest spend wins.
Most Purchased Brand - The brand a customer has most frequently purchased from based on their history. If there's no clear winner then the brand with the highest spend wins. The attribute used to define brand can be altered in the Data Fields section in Configuration.
Most Frequent Day of Purchase - The most frequent day of the week the customer makes an order on. If there's no clear winner then the day with the highest spend wins.
Most Frequent Month of Purchase - The most frequent month of the year the customer makes orders in. If there's no clear winner then the month with the highest spend wins.
First Category Purchased - The first category the customer purchased from. If the order contained multiple categories then the highest value category wins.
Last Category Purchased - The last category the customer purchased from. If the order contained multiple categories then the highest value category wins.
First Brand Purchased - The first brand the customer purchased from. If the order contained multiple brands then the highest value brand wins. The attribute used to define brand can be can be altered in the Data Fields section in Configuration.
Last Brand Purchased - The last brand the customer purchased from. If the order contained multiple brands then the highest value brand wins. The attribute used to define brand can be altered in the Data Fields section in Configuration.
System Values
These values need to be mapped for all of the URLs within the Dynamic Content section to work. These data fields only get updated through the connector when an email is triggered that requires the values to be populated with the corresponding data for the email.
Website name - The website the contact originated from.
Store name - The store name the contact originated from.
Last Order ID - The database ID of the last order the customer placed.
Last Quote ID - The database ID of the last quote the customer had.
Abandoned Product Name - The most expensive product's name for the current abandoned cart.
The dropdown to map to Dotdigital contact data fields is empty. Why is that?
You need to ensure you have valid and saved Dotdigital API credentials.
Why do I only have a couple of contact data fields to pick from?
You need to create contact data fields in your Dotdigital account.