Once you've successfully installed the connector, in your store settings, you can access data synchronisation, contact synchronisation and program enrolment settings. You can also remove your Salesforce Commerce Cloud connection completely if you wish.
Data synchronisation
You can turn data sync between Salesforce Commerce Cloud and Dotdigital on or off, or force a manual sync, from your store settings.
To turn data sync on or off:
In Dotdigital, go to Connect and select the Salesforce Commerce Cloud tile under Installed integrations and extensions.
Under Connected store, for Data sync, select ON or OFF.
To perform a manual sync, select SYNC NOW.
Data sync must be set to ON.Select SAVE.
Customer sync
New Salesforce Commerce Cloud customers are synced when the next synchronisation takes place. We attempt synchronisation five minutes after the last sync process finishes. Depending on the amount of data you're processing, the time each sync takes to complete might be between a few seconds to many hours.
A full sync is also done every 24 hours to pick up any customer data modifications.
It’s possible to enable incremental customer syncs. If you’d like to do this, contact us.
The first synchronisation syncs the entire customer list. New or modified customers are only processed once the initial sync job has fully caught up with the old ones.
Customers are the users that have an account in your store, including those who aren't opted into your marketing. We also sync contacts placing orders as guests, as part of the Customers group.
Order sync
New and modified orders sync every five minutes.
The first synchronisation syncs the order history. New or modified orders are only processed once the initial sync job has fully caught up with the old ones.
Orders are stored against Dotdigital contacts as Insight data.
Order Insight data schema
Attribute |
| Type |
id |
| text |
order_total |
| numerical |
payment |
| text |
delivery_method |
| text |
delivery_total |
| numerical |
currency |
| text |
order_status |
| text |
| text | |
quote_id |
| text |
purchase_date |
| date |
billing_address |
|
|
| Id | numerical |
| type | text |
| first_name | text |
| last_name | text |
| delivery_postcode | text |
| delivery_address_1 | text |
| delivery_address_2 | text |
| phone | numerical |
| delivery_city | text |
| delivery_country | text |
| state | text |
| company | text |
| fax | numerical |
| region | text |
| default | boolean |
| text | |
delivery_address |
|
|
| Id | numerical |
| type | text |
| first_name | text |
| last_name | text |
| delivery_postcode | text |
| delivery_address_1 | text |
| delivery_address_2 | text |
| phone | numerical |
| delivery_city | text |
| delivery_country | text |
| state | text |
| company | text |
| fax | numerical |
| region | text |
| default | boolean |
| text | |
products |
| array |
| Product #1 |
|
| name | text |
| price | numerical |
| sku | text |
| qty | numerical |
| product_id | text |
| parent_id | text |
| price_inc_tax | numerical |
|
|
|
| Product #2 |
|
| ... |
|
order_subtotal |
| numerical |
base_subtotal_incl_tax |
| numerical |
discount_amount * |
| numerical |
coupon_code |
| text |
payment_status |
| text |
store_name |
| text |
* The discount amount that's deducted from the order total. This should be a positive value.
Product sync
New products in the store’s product catalog are synced when the next synchronisation takes place.
An incremental sync is done every five minutes from the last successful sync to pick up any product data modifications or stock updates.
The first synchronisation syncs the entire site’s product catalog. New or modified products are only processed once the initial sync job has fully caught up with the old ones.
Products are stored as Insight data in Dotdigital as AccountInsight.
To view your catalog data:
Go to Connect > Account insight data.
Select the catalog name you want to view.
Learn more in the Non-developer’s guide to Insight data.
Product Insight data schema
Attribute | Type |
id | numerical |
parent_id | numerical |
name | string |
price | numerical |
type | string (variant, single, and configurable) |
url | string |
sku | string |
stock | numerical |
status | string |
image_path | string |
specialPrice | numerical |
price_books | array |
attributes | list |
categories | array |
brand | text |