Release Notes
May 2025
We have removed the PRODUCT_VARIANT table because the Products API response does not include product variant data.
February 2025
We have updated the connector's sync strategy. We now perform a daily backfill for the PRODUCT endpoint to capture the previous day's data. As a result, you may notice a temporary increase in your Monthly Active Rows (MAR) usage at the beginning of each month, reflecting the final day’s data from the previous month.
We have added a new column, cancel_code to the ORDERS_HISTORY table. To backfill the data for this column, you can perform a re-sync for the ORDERS_HISTORY table or contact our support team to re-sync the table for you.
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:
CATALOGCATEGORYCOUPONCUSTOMER_GROUPCUSTOM_OBJECT_ATTRIBUTE_DEFINITIONCUSTOM_OBJECT_ATTRIBUTE_GROUPGIFT_CERTIFICATEGIFT_CERTIFICATE_TRANSACTIONINVENTORY_LISTINVENTORY_LIST_RECORDPROMOTIONSHARED_PRODUCT_OPTIONSHARED_PRODUCT_OPTION_VALUESOURCE_CODE_GROUPSTORE
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_GROUPCUSTOM_OBJECTCUSTOM_OBJECT_ATTRIBUTE_DEFINITIONCUSTOM_OBJECT_ATTRIBUTE_GROUPINVENTORY_LISTINVENTORY_LIST_RECORDSHARED_PRODUCT_OPTIONSHARED_PRODUCT_OPTION_VALUESOURCE_CODE_GROUPSTORE
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:
ADDRESSCAMPAIGNCATALOGCATEGORYCOUPONCOUPON_REDEMPTIONCUSTOMERGIFT_CERTIFICATEGIFT_CERTIFICATE_TRANSACTIONORDER_BILLING_ADDRESSORDER_HISTORYORDER_PAYMENT_INSTRUMENTORDER_PRODUCT_ITEMORDER_SHIPMENTORDER_SHIPMENT_ADDRESSORDER_SHIPPING_ITEMPAYMENT_INSTRUMENTPRODUCTPROMOTION
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:
creationDatecodecustomerEmail
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.