With the Dotdigital integration for ecforce, 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 an ecforce account.
You must be able to provide access to the ecforce API.

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.

ecforce 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
ecforce subscribers	Contains all contacts with `receive_email` = YES.
ecforce customers	All customers and subscribers.

To view the contacts in the list:

Go to Audience > Lists.
Search for ecforce subscribers or ecforce customers and select the list name.

The following data fields are created in Dotdigital and mapped to ecforce:

ecforce data field	Dotdigital Data field label	Data type
email	EMAIL	String
tel01	MOBILENUMBERID	numerical
name01	FIRSTNAME	String
name02	LASTNAME	String
full_name	FULLNAME	String
optin	NEWSLETTER_SUBSCRIBER	Boolean
birth	DOB	Date
company_name	COMPANY_NAME	String
id	CUSTOMER_ID	String
customer_type_name	CUSTOMER_TYPE	String
addr01	BILLING_ADDRESS_1	String
full_zip	BILLING_POSTCODE	String
prefecture_name	BILLING_PREFACTURE	String
tel01	BILLING TELEPHONE	numerical
full_address	SHIPPING_ADDRESS_1	String
full_zip	SHIPPING_POSTCODE	String
prefecture_name	SHIPPING_PREFACTURE	String
tel01	SHIPPING TELEPHONE	numerical
job	PROFESSION	String
sex	SEX	String
point	POSSESION_POINTS	numerical
point_expired_at	POINTS_EXPIRY_DATE	Date
state	CUSTOMER_STATUS	String
customer_rank_name	RANKING	String
member_groups	MEMBER_GROUP	String
blacklist	BLACKLIST	String
labels	CUSTOMER_LABEL	String

If a contact already exists in Dotdigital, they are added to the ecforce subscribers list, and their data field values are overwritten by the data stored in ecforce. Contact records are matched by email address.

Subscribes and unsubscribes

The integration manages subscribes and unsubscribes in the following manner:

ecforce to Dotdigital Sync direction:

When a contact in ecforce has receive_email checked, it updates the newsletter_subscriber data field in Dotdigital to YES.
If a contact in ecforce unchecks the receive_email option, it updates the newsletter_subscriber data field in Dotdigital to NO.

Dotdigital to ecforce sync direction:

If a contact unsubscribes from an email and gets suppressed in Dotdigital, this information is synced to ecforce, causing the receive_email field in ecforce 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
ecforce to Dotdigital	`receive_email`	Check `receive_email` (Active)	`newsletter_subscriber`	YES
ecforce to Dotdigital	`receive_email`	Uncheck `receive_email` (Inactive)	`newsletter_subscriber`	NO
Dotdigital to ecforce	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 ecforce, as long as the corresponding contact is present in Dotdigital.

If a non-subscribed contact is synced from ecforceinto 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 ecforce:

EC force Attributes	Dotdigital Data field label	Type
id	id	string
total	order_total	numerical
*[default currency]	currency	string
state	order_status	string
email	email	string
created_at	purchase_date	date
addr01	billing_address_1	string
addr02	billing_address_2	string
prefecture_name	billing_city	string
full_zip	billing_postcode	string
addr01	delivery_address_1	string
addr02	delivery_address_2	string
prefecture_name	delivery_city	string
full_zip	delivery_postcode	string
product_name	name	string
sales_price	price	numerical
variant_sku	sku	string
quantity	qty	numerical
subtotal	order_subtotal	numerical
discount	discount_amount	numerical
coupons	couponCode	string
grant_plan_point	expected point	numerical
reward_point	added point	numerical

*[default currency] - this is the default currency that is defined during setup.

Product data

We sync your product data into an account insight collection called catalog_ecforce.

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:

ECforce attribute	Dotdigital Data field label	Type
N/A	id	string
name	name	string
master_list_price	price	numerical
master_sales_price	specialPrice	numerical
master_sku	sku	string
volume	stock	numerical
state	status	string
url	image_path	string
product_categories	categories	array

Ways to use your data

There are many ways to make the most of your ecforce 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.

Integrate eStar with Dotdigital

Integrate Maropost Commerce Cloud (Neto) with Dotdigital

Integrate commercetools with Dotdigital

Integrate Retail Express with Dotdigital

Integrate Cin7 with Dotdigital