Release Notes

March 2025

We now retrieve historical data only upto January 1, 2015, for the COUPON, ORDERS, and PRODUCT tables.

November 2024

The following Lite connectors now support the Hybrid Deployment model:

February 2024

We have added the following new metadata tables:

• COUPON_METADATA
• CUSTOMER_METADATA
• ORDER_LINE_ITEM_METADATA
• ORDER_METADATA
• PRODUCT_METADATA
• PRODUCT_VARIATION_METADATA
• REFUND_METADATA

We have added two new tables, ORDER_LINE_ITEM and REFUND_LINE_ITEM.

We have removed the LINE_ITEM and METADATA tables.

We have changed the composite primary keys of the ORDER_LINE_ITEM_TAX and REFUND_LINE_ITEM_TAX tables:

• For the ORDER_LINE_ITEM_TAX table, the new composite primary key is a combination of the id, order_id, and order_line_item_id columns.
• For the REFUND_LINE_ITEM_TAX table, the new composite primary key is a combination of the id, refund_id, and refund_line_item_id columns.

Previously, the composite primary key of these tables was a combination of the id and line_item_id columns.

July 2023

We have combined the following metadata tables into a new table, METADATA:

• COUPON_METADATA
• CUSTOMER_METADATA
• ORDER_LINE_ITEM_METADATA
• ORDER_METADATA
• PRODUCT_METADATA
• PRODUCT_VARIATION_METADATA
• REFUND_METADATA

We have combined the ORDER_LINE_ITEM and REFUND_LINE_ITEM tables into a new table, LINE_ITEM.

We have renamed the ORDER table to ORDERS.

We have added a new primary key column, product_id, to the PRODUCT_ATTRIBUTE table.

We have added three new primary key columns to the PRODUCT_ATTRIBUTE_OPTION table:

• product_attribute_id
• product_attribute_index
• product_id

We have renamed the order column to orders in the following tables:

• PAYMENT_GATEWAY
• SHIPPING_ZONE
• SHIPPING_ZONE_METHOD
• TAX_RATE

We have renamed the following columns in the PRODUCT_VARIATION table:

• dimensions_length to dimension_length
• dimensions_width to dimension_width
• dimensions_height to dimension_height

If you want to sync historical data for these tables and columns, contact our support team.

June 2023

The WooCommerce connector now supports table-level re-syncs.

December 2022

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

October 2022

Lite connectors are now available for the following sources:

• Chargebee Product Catalog 2.0
• Gong
• Ironclad
• WooCommerce