With the Marketing integration for Cin7, you can import your order and product data, as well as your contacts, into your Marketing account.
Before you start
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 Marketing
Once the integration setup has been completed, your historical data begins to sync and should be visible in your Marketing 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 Marketing 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.
Mapped contact fields
Mapped contact fields
Cin7 Data field label | Marketing 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 Marketing, 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 Marketing Sync direction:
When a contact in Cin7 has
receive_emailchecked, it updates thenewsletter_subscriberdata field in Marketing to YES.If a contact in Cin7 unchecks the
receive_emailoption, it updates thenewsletter_subscriberdata field in Marketing to NO.
Marketing to Cin7 sync direction:
If a contact unsubscribes from an email and gets suppressed in Marketing, this information is synced to Cin7, causing the
receive_emailfield 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 Marketing | receive_email | Check receive_email (Active) | newsletter_subscriber | YES |
Cin7 to Marketing | receive_email | Uncheck receive_email (Inactive) | newsletter_subscriber | NO |
Marketing 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 Marketing.
If a non-subscribed contact is synced from Cin7 into Marketing, 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.
Mapped order fields
Mapped order fields
Cin7 Order attribute field label | Marketing 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.
Mapped product fields
Mapped product fields
Cin7 product attribute field label | Marketing 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 Marketing. 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 Add the Dotdigital Tag to your website and Extend the Dotdigital Tag for abandoned cart and browse.