All Collections
Integrations
Cin7
Integrate Cin7 with Dotdigital
Integrate Cin7 with Dotdigital

Take advantage of our commerce intelligence tools to enrich your marketing and customer engagement.

Gareth Burroughes avatar
Written by Gareth Burroughes
Updated over a week ago

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 is only compatible with Cin7 Omni.


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:

  1. Go to Audience > Lists.

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

EMAIL

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:

  1. Go to Connect > Contact insight data.

    • Your order data is stored in an insight data collection called orders.

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

Email

email

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.

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.

Did this answer your question?