Release Notes

October 2025

We have added a new column, customer_is_guest, to the ORDERS_HISTORY table. Be sure to re-sync the ORDERS_HISTORY table to backfill the data for the new column.

September 2025

We now sync all additional fields for the onlineFlag field in the PRODUCTS table. You can now see the site-specific columns for the online status of products, such as online_flag_default@Site1 and online_flag_default@Site2.

Be sure to re-sync the PRODUCTS table to backfill the data for these new columns.

August 2025

We have discontinued the ADDRESS table and will no longer sync it. Use the CUSTOMER_ADDRESS table.

July 2025

We have added a new table, CUSTOMER_ADDRESS, to the Salesforce Commerce Cloud connector. This table now contains all customer addresses, and it can be joined to the CUSTOMER table using the customerNo column.

June 2025

We now use the following new columns in the CUSTOMER table to store each customer’s primary address details:

primary_address_address_1
primary_address_address_2
primary_address_city
primary_address_company_name
primary_address_country_code
primary_address_creation_date
primary_address_etag
primary_address_first_name
primary_address_full_name
primary_address_job_title
primary_address_last_modified
primary_address_last_name
primary_address_phone
primary_address_post_box,
primary_address_postal_code
primary_address_salutation
primary_address_second_name
primary_address_state_code
primary_address_suffix
primary_address_suite
primary_address_title

May 2025

We have removed the PRODUCT_VARIANT table because the Products API response does not include product variant data.

We added a new column, primary_address_id, to the CUSTOMER table to store each customer’s primary address ID. You can use this column to join the CUSTOMER and ADDRESS tables to retrieve a customer’s primary address details.

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:

CATALOG
CATEGORY
COUPON
CUSTOMER_GROUP
CUSTOM_OBJECT_ATTRIBUTE_DEFINITION
CUSTOM_OBJECT_ATTRIBUTE_GROUP
GIFT_CERTIFICATE
GIFT_CERTIFICATE_TRANSACTION
INVENTORY_LIST
INVENTORY_LIST_RECORD
PROMOTION
SHARED_PRODUCT_OPTION
SHARED_PRODUCT_OPTION_VALUE
SOURCE_CODE_GROUP
STORE

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