Insight data: Order data - Magento 1

Sync your customers' order information and basket contents to Dotdigital.

Henry Huish avatar
Written by Henry Huish
Updated over a week ago

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

  1. Go to System > Configuration > Dotdigital > Sync Settings.

  2. Under Order Sync, expand the Enabled drop-down menu and select Yes.

    mag_order_sync.png

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

email

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.
This must be a positive value.

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.

Did this answer your question?