The Dotdigital for Magento connector fully utilises the Dotdigital OrderInsight module.
Enabling this feature allows you to synchronise your customers' order information and current basket contents. This allows for deep segmentation within Dotdigital, enabling highly targeted email marketing.
Orders are synced and batched once they are created, but are also updated in Dotdigital when any modifications are made to the quote after their creation.
In addition to the default data that we sync across, we also offer a range of configurable options to allow you to customise the data and the format of the data which is sent to Dotdigital.
Learn more in Insight data - Settings.
Before you start
Things you need to know:
To be able to synchronise your customers' order information, you must have OrderInsight enabled for your Dotdigital account. Contact your Customer Success representative if you need help with this.
Enable order data sync
Go to System > Configuration > Dotdigital > Sync Settings.
Under Order Sync, expand the Enabled drop-down menu and select Yes.
Select Save Config. Magento will then
You see a confirmation that the settings have been saved, the synchronisation begins and the order data becomes available in your Dotdigital account.
List of synced order data
The order data that is synced includes:
Name |
| Description | Type |
ID |
| The Magento database ID for the order. | Text |
order_total |
| The total amount the customer paid. | Numerical |
payment |
| The payment method the customer used. | Text |
delivery_method |
| The delivery method selected. | Text |
delivery_total |
| The amount paid for delivery. | Numerical |
currency |
| The currency the order was placed in. | Text |
couponcode |
| The coupon code used on the order, if applicable. | Text |
order_status |
| The current status of the order. | Text |
| The email address of the contact who placed the order. | Text | |
store_name |
| The Magento store name the order was placed on. | Text |
quote_id |
| The database quote ID the order was created from. | Text |
purchased_date |
| The date and time of the order. | Date |
billing_address |
| The address that the payment method is registered to. |
|
| billing_address_1 |
| Text |
| billing_address_2 |
| Text |
| billing_city |
| Text |
| billing_country |
| Text |
| billing_postcode |
| Text |
delivery_address |
| The address that the order is delivered to. |
|
| delivery_address_1 |
| Text |
| delivery_address_2 |
| Text |
| delivery_city |
| Text |
| delivery_country |
| Text |
| delivery_postcode |
| Text |
order_subtotal |
| The order subtotal. | Numerical |
base_subtotal_inc_tax |
| The order subtotal including tax. | Numerical |
discount_amount |
| The total amount discounted on the order. | Numerical |
The following information is also synced for each product in the order:
Name |
|
| Description | Type |
products |
|
|
| Array |
| name |
| The name of the product. | Text |
| price |
| The price paid for the product. | Numerical |
| sku |
| The SKU of the product. | Text |
| qty |
| The quantity of the product purchased. | Numerical |
| attribute-set |
| The attribute set from Magento assigned to the product. | Text |
| categories |
| The categories associated with the product. | Array |
|
| name |
| Text |
I've enabled the order sync but nothing is displaying in Dotdigital. Why is this?
This could be for the following reasons:
You don't have valid API credentials or saved details.
OrderInsight is not enabled on your Dotdigital account.
Cron is not running on your site
The importer is currently processing other imports and hasn't got to the order import yet.
I have order data in Dotdigital but some of the values for orders are empty. Why would that be the case?
This could either be that the data doesn't exist for that order - for example, if the delivery amount wasn't paid - or the source data in Magento no longer exists, for example if you had old payment methods in Magento that no longer exist.
Why is the order data marked as imported in Magento but not displaying in Dotdigital?
Insight data can take several minutes to import and show in Dotdigital, even after a sync is complete. You might want to ensure you don't already have order data imported with matching IDs, perhaps coming from a staging site, as this key must be unique.