Salesforce Commerce Cloud
Salesforce Commerce Cloud is an ecommerce platform that provides unified, intelligent digital commerce experiences, both online and in the store.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | CATALOG, CATEGORY, SHARED_PRODUCT_OPTION, SHARED_PRODUCT_OPTION_VALUE, GIFT_CERTIFICATE, GIFT_CERTIFICATE_TRANSACTION, PROMOTION, COUPON, SOURCE_CODE_GROUP, CUSTOMER_GROUP, CUSTOM_OBJECT_ATTRIBUTE_DEFINITION, CUSTOM_OBJECT_ATTRIBUTE_GROUP, STORE, INVENTORY_LIST and INVENTORY_LIST_RECORD tables. |
| History mode | check | ORDER table. Stores history based on its last_modified column. |
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | CAMPAIGN, COUPON_REDEMPTION, CUSTOMER, ORDER, and PRODUCT tables |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Salesforce Commerce Cloud setup guide to connect Salesforce Commerce Cloud with your destination using Fivetran connectors.
Sync overview
Fivetran supports both Salesforce Commerce APIs (SCAPI) and Salesforce Open Commerce API (OCAPI) endpoints.
Supported Salesforce Open Commerce API tables
The following tables are supported through Open Commerce API:
CUSTOMER_GROUPCUSTOM_OBJECTCUSTOM_OBJECT_ATTRIBUTE_DEFINITIONCUSTOM_OBJECT_ATTRIBUTE_GROUPINVENTORY_LISTINVENTORY_LIST_RECORDSTORESHARED_PRODUCT_OPTIONSHARED_PRODUCT_OPTION_VALUE
Salesforce Commerce Cloud API version
Fivetran uses version V1 for all Salesforce Commerce Cloud APIs.
Schema information
This schema applies to all Salesforce Commerce Cloud connectors.
To zoom, open the ERD in a new window.Sync limitation
Salesforce doesn't support multiple certificates for their staging environment. If you use a custom certificate, we can't sync your data from your staging environment.
Sync notes
- Salesforce Commerce has deprecated the
variation-valueattribute from the catalog XML. You may receive a Salesforce error if you include this attribute. - If you have configured multiple Salesforce Commerce Cloud connectors for the same organization with different Site IDs, we recommend you to use the
CATALOGtable from only one of the connectors. As theCATALOGtable doesn't have any site-specific filters, using multiple connectors causes the TOO_MANY_REQUEST error because all the connectors use the same API endpoint. - If the
shipmentNovalue forORDER_SHIPMENTis null, we use a combination of the numeric IDs and thefivetran_prefix. For example,fivetran_1. If you fix these orders in your Salesforce Commerce Cloud account, Fivetran automatically updates the correctshipmentNovalues in the destination.