Release Notes

November 2024

The commercetools connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

October 2024

Effective October 1, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

These schema changes are required to resolve data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

4 total changes • 4 possible breaking changes

Table/column	Change type	New name	Notes
`PRODUCT_VARIANT_ATTRIBUTE`
column	Primary Key Change	`product_id` 🔑	New primary key.
`PRODUCT_VARIANT_IMAGE`
column	Primary Key Change	`product_id` 🔑	New primary key.
`PRODUCT_VARIANT_PRICE_TIER`
column	Primary Key Change	`product_id` 🔑	New primary key.
`PRODUCT_VARIANT_PRICES`
column	Primary Key Change	`product_id` 🔑	New primary key.

July 2024

We now support priority-first sync for the following tables and their child tables:

CART
CUSTOMER
INVENTORY
ORDERS
PAYMENT
PRODUCT

Effective July 25, 2024 we use a new July 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to implement priority-first sync and improve schema usability.

7 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`MASTER_VARIANT`
table	New Table
`MASTER_VARIANT_ASSET`
table	New Table
`MASTER_VARIANT_ASSET_SOURCE`
table	New Table
`MASTER_VARIANT_ATTRIBUTE`
table	New Table
`MASTER_VARIANT_IMAGE`
table	New Table
`MASTER_VARIANT_PRICE`
table	New Table
`MASTER_VARIANT_PRICE_TIER`
table	New Table

April 2024

Our commercetools connector is now generally available. Read our commercetools connector documentation..

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

March 2024

We now support syncing data from text columns in all locales in our commercetools connector. Previously, we supported only the de-DE and en-US locales for syncing data from text columns.

February 2024

We have added a new table, ORDER_PAYMENT_INFO.

October 2023

We have added new columns, shipping_address_* and billing_address_*, to the ORDERS table.

We have removed the foreign key relationship of the shipping_address_id and billing_address_id columns to the CUSTOMER_ADDRESS table, in the ORDERS table.

August 2023

commercetools is a cloud-based commerce solution for global businesses. Read our commercetools connector documentation.