All Collections
Integrations
ecforce
Integrate ecforce with Dotdigital
Integrate ecforce with Dotdigital

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

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

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:

  1. Go to Audience > Lists.

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

  1. Go to Connect > Contact insight data.

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

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

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.

Did this answer your question?