Release Notes

October 2024

We now use a combination of the numeric IDs and the fivetran_ prefix as the primary key for the ORDER_SHIPMENT records if their shipmentNo value is null. For example, fivetran_1.

If you fix these orders in your Salesforce Commerce Cloud account, Fivetran automatically updates the correct shipmentNo values in the destination.

May 2024

We now capture deletes for the following tables:

• 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
• INVENTORY_LIST_RECORD

March 2024

We have changed the primary key in the ORDER_SHIPMENT_ADDRESS table. The new primary key is a combination of the order_id and shipment_id columns. Previously, the shipment_id column was the primary key for this table.

January 2024

We have added the following new tables:

• CUSTOMER_GROUP
• CUSTOM_OBJECT
• CUSTOM_OBJECT_ATTRIBUTE_DEFINITION
• CUSTOM_OBJECT_ATTRIBUTE_GROUP
• INVENTORY_LIST
• INVENTORY_LIST_RECORD
• SHARED_PRODUCT_OPTION
• SHARED_PRODUCT_OPTION_VALUE
• SOURCE_CODE_GROUP
• STORE

We support the tables using the Salesforce Open Commerce APIs. For more information, see our Salesforce Commerce Cloud Setup Guide. We do not support syncing these tables using our REST API.

We have changed our sync strategy for the CATALOG table to fix data integrity issues of the child tables. We now re-import the table. Previously, we incrementally synced the table.

October 2023

We have added a new table, SOURCE_CODE_GROUP.

September 2023

The Salesforce Commerce Cloud connector now supports syncing custom fields in the following tables:

• ADDRESS
• CAMPAIGN
• CATALOG
• CATEGORY
• COUPON
• COUPON_REDEMPTION
• CUSTOMER
• GIFT_CERTIFICATE
• GIFT_CERTIFICATE_TRANSACTION
• ORDER_BILLING_ADDRESS
• ORDER_HISTORY
• ORDER_PAYMENT_INSTRUMENT
• ORDER_PRODUCT_ITEM
• ORDER_SHIPMENT
• ORDER_SHIPMENT_ADDRESS
• ORDER_SHIPPING_ITEM
• PAYMENT_INSTRUMENT
• PRODUCT
• PROMOTION

August 2023

We have added a new table, PRICE_ADJUSTMENT, to store the data from the PriceAdjustment endpoint. To sync the historical data of the PRICE_ADJUSTMENT table, you must re-sync the parent table, ORDER.

June 2023

The Salesforce Commerce Cloud connector now supports priority-first sync for the COUPON_REDEMPTION table. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Salesforce Commerce Cloud's priority-first syncs fetch the most recent 15 days' worth of data from the supported tables. We are gradually rolling out this change to all existing connectors. To learn more, see our priority-first sync documentation.

May 2023

The Salesforce Commerce Cloud connector now supports priority-first sync for the CAMPAIGN and CATALOG tables. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Salesforce Commerce Cloud's priority-first syncs fetch the most recent 15 days' worth of data from the supported tables. We are gradually rolling out this change to all existing connectors. To learn more, see our priority-first sync documentation.

April 2023

We have added the following new columns to the COUPON_REDEMPTION table:

• creationDate
• code
• customerEmail

March 2023

You can now configure your Salesforce Commerce Cloud connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

February 2023

The Salesforce Commerce Cloud connector now supports table blocking for all Salesforce Commerce Cloud tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables. If you want to sync a child table, you must include the parent table in the sync.

October 2022

We have added a new column, orderId, to the ORDER_SHIPPING_ITEM and ORDER_SHIPMENT_ADDRESS tables.

We have changed the primary key of the ORDER_SHIPMENT table. The new primary key is a combination of the shipmentNo and shipment_id columns. Previously, we used only the shipment_id column as the primary key.

September 2022

Our Salesforce Commerce Cloud connector is now generally available.

Read our Salesforce Commerce Cloud connector documentation.

July 2022

Salesforce Commerce Cloud is an ecommerce platform that provides unified, intelligent digital commerce experiences, both online and in the store.

Read our Salesforce Commerce Cloud connector documentation.