With the Dotdigital integration for Cin7, you can import your order and product data, as well as your contacts, into your Dotdigital account.
Before you start
Things you need to know:
You must have a Cin7 account.
You must be able to provide access to the Cin7 API.
This integration supports Cin7 Omni and Cin7 Core.
Install the integration
To ensure that the integration installs correctly, a member of our team must complete this process for you.
To activate the integration, contact your Customer Success Representative.
Cin7 data in Dotdigital
Once the integration setup has been completed, your historical data begins to sync and should be visible in your Dotdigital account after 24 hours. Subsequent data syncs are performed 3 minutes after the previous sync has completed.
Contact data
Your subscribed contacts and customers are synced into two new Dotdigital lists:
List | Description |
Cin7 subscribers | Contains all contacts with receive_email = YES. |
Cin7 customers | All customers and subscribers. |
To view the contacts in the list:
Go to Audience > Lists.
Search for Cin7 subscribers or Cin7 customers and select the list name.
The following data fields are created in Dotdigital and mapped to Cin7:
Cin7 Data field label | Dotdigital Data field label | Data type |
Customer ID | CUSTOMER_ID | Text |
First Name | FIRSTNAME | Text |
last name | LASTNAME | Text |
Company | COMPANY | Text |
Mobile | MOBILE NUMBER | Numeric |
Email_ID | Text | |
DOB | DOB | Date |
Billing street | BILLING_ADDRESS_1 | Text |
Billing state | BILLING_STATE | Text |
Billing Zip | BILLING_POSTCODE | Text |
Billing Country | BILLING_COUNTRY | Text |
Billing phone1 | BILLING_TELEPHONE | Text |
If a contact already exists in Dotdigital, they are added to the Cin7 subscribers list, and their data field values are overwritten by the data stored in Cin7. Contact records are matched by email address.
Subscribes and unsubscribes
The integration manages subscribes and unsubscribes in the following manner:
Cin7 to Dotdigital Sync direction:
When a contact in Cin7 has receive_email checked, it updates the newsletter_subscriber data field in Dotdigital to YES.
If a contact in Cin7 unchecks the receive_email option, it updates the newsletter_subscriber data field in Dotdigital to NO.
Dotdigital to Cin7 sync direction:
If a contact unsubscribes from an email and gets suppressed in Dotdigital, this information is synced to Cin7, causing the receive_email field in Cin7 to become unchecked.
The table below shows a more concise representation of this information:
Sync direction | Source data field | Subscription status in source | Target data field | Updated value |
Cin7 to Dotdigital | receive_email | Check receive_email (Active) | newsletter_subscriber | YES |
Cin7 to Dotdigital | receive_email | Uncheck receive_email (Inactive) | newsletter_subscriber | NO |
Dotdigital to Cin7 | Suppressed contact | Unsubscribe from an email and get suppressed (Inactive/unsubscribed) | receive_email | Unchecked |
Order data
The integration tries to sync all of your orders from Cin7, as long as the corresponding contact is present in Dotdigital.
If a non-subscribed contact is synced from Cin7 into Dotdigital, their corresponding orders are also synced through
To view your order insight data collection:
Go to Connect > Contact insight data.
Your order data is stored in an insight data collection called orders.
Select the Properties icon to enable a retention policy for this data or to adjust your tax settings.
To view the orders report, go to Analytics > Reports, then expand the MORE REPORTS drop-down menu and select Commerce, then the Orders tab.
Learn more in Commerce orders.
The following order data fields are created in Dotdigital and mapped to Cin7:
Cin7 Order attribute field label | Dotdigital order attribute |
id | id |
Order_total | order_total |
status | order_status |
currency | currency |
CreatedAt | purchase_date |
|
|
Billing city
| billing_city |
Billing country | billing_country |
Billing Zip | billing_postcode |
Billing Street | billing_address_1 |
|
|
Shipping Street
| delivery_address_1
|
Shipping Country | delivery_country |
Shipping City | delivery_city |
Shipping Zip | delivery_postcode |
|
|
productName | Name |
productName | Variant_name |
unitPrice | price |
productid | sku |
qty | qty
|
Branchid | Branchid |
Product data
We sync your product data into an account insight collection called catalog_cin7.
Your product data is synced following the correct schema for use with our Product recommendations feature.
To view your product data, go to Content > Products.
Learn more in Get started with product recommendations and Product catalogs.
The data fields mappings for products:
Cin7 product attribute field label | Dotdigital product attribute |
merchantVariantId | sku |
available | status |
title | name |
price | price |
| special price |
stockQuantity | stock |
| currency |
| image_path |
brand | brand |
| url |
Ways to use your data
There are many ways to make the most of your Cin7 data once it’s been imported to Dotdigital. Here are just a few ideas:
Enrol your contacts into automated programs and send them on customised user journeys. Learn more.
Gain insights into your sales using our retail dashboard. Learn more.
Sort your customers using RFM analysis, and target your efforts where they are needed most to maximise ROI. Learn more.
Enable AI-powered product recommendations. Learn more.
Set up an abandoned cart program to recover potentially lost sales.
To use Abandoned cart, you must install scripts on your website. Learn how in Setting up abandoned carts and Abandoned cart JSON breakdown.