Release Notes

August 2025

We have made the following changes to the Schema tab for connections set up before July 19, 2024:

We display all table names in lowercase
We display all the tables, including the empty tables
We no longer support table-level selection or deselection

We have made the following changes for connections set up before July 21, 2024:

Added two new columns, id and type, to the PAYMENT_METHOD table
Added two new tables, PAYMENT_METHOD_STORED_INSTRUMENT and PAYMENT_METHOD_SUPPORTED_INSTRUMENT
Removed the CATEGORY table and its data is now available in the CATEGORY_TREE table
Replaced the BILLING_ADDRESS_CUSTOM_FIELD table with two new tables, CHECKOUT_BILLING_ADDRESS_CUSTOM_FIELD and CONSIGNMENT_BILLING_ADDRESS_CUSTOM_FIELD
Renamed the timestamp column of the ORDER_SHIPPING_ADDRESS_QUOTE table to timestamps
Renamed the option_id column of the PRODUCT_VARIANT_OPTIONS_VALUE table to product_variant_option_id
Renamed the offline column of the ORDER_REFUND_PAYMENT table to offlines
Renamed the primary key, tag, of the STORE_BLOG_TAG table to tags
Changed the primary key from index to _fivetran_id for the following tables:
- CATEGORY_SETTING
- CUSTOMER_SETTING_PER_CHANNEL
- EMAIL_SETTING
- LOCALE_SETTING
- PRICE_LIST_RECORD
- ROBOT_SETTING
- SEARCH_SETTING
- SECURITY_SETTING
- SEO_SETTING
- STATUS_SETTING
- STORE_PROFILE_SETTING
- STOREFRONT_PRODUCT_SETTING

May 2025

The BigCommerce connector's priority-first sync now fetches the most recent 15 days' worth of data. Previously, the priority fetch period was 2 days.

March 2025

We have added a new table, CATALOG_VARIANT_METAFIELD, to track updates to product variant metafields.

July 2024

We have made the following changes to the Schema tab for connections created on or after July 19, 2024:

We display all table names in lowercase
We display all the tables, including the empty tables
We no longer support table-level selection or deselection for syncing

We have made the following schema changes for new connections created on or after July 21, 2024:

Added two new columns, id and type, in the PAYMENT_METHOD table
Added two new table, PAYMENT_METHOD_STORED_INSTRUMENT and PAYMENT_METHOD_SUPPORTED_INSTRUMENT
Removed the CATEGORY table and sync the category data in the CATEGORY_TREE table
Removed the BILLING_ADDRESS_CUSTOM_FIELD table and added two new tables, CHECKOUT_BILLING_ADDRESS_CUSTOM_FIELD and CONSIGNMENT_BILLING_ADDRESS_CUSTOM_FIELD
Renamed the timestamp column to timestamps in the ORDER_SHIPPING_ADDRESS_QUOTE table
Renamed the primary key column from tag to tags in the STORE_BLOG_TAG table
Changed the primary key, from index to _fivetran_id, for the following tables:
- CATEGORY_SETTING
- CUSTOMER_SETTING_PER_CHANNEL
- EMAIL_SETTING
- LOCALE_SETTING
- PRICE_LIST_RECORD
- ROBOT_SETTING
- SEARCH_SETTING
- SECURITY_SETTING
- SEO_SETTING
- STATUS_SETTING
- STORE_PROFILE_SETTING
- STOREFRONT_PRODUCT_SETTING

March 2024

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

July 2023

We have renamed the CUSTOMER_TEMPLATE_ASSOSCIATION table to CUSTOM_TEMPLATE_ASSOSCIATION.

We have changed the data types of following columns in the tables below:

Table Name	Column Name	Old Data Type	New Data Type
`COUPON`	`date_created`	STRING	INSTANT
`CURRENCIES`	`last_updated`	STRING	INSTANT
	`currency_exchange_rate`	STRING	DOUBLE
`CUSTOM_TEMPLATE_ASSOSCIATION`	`date_created`	STRING	INSTANT
	`date_modified`	STRING	INSTANT
`GIFT_CERTIFICATE`	`expiry_date`	STRING	INSTANT
	`purchase_date`		STRING
	`amount`	STRING	DOUBLE
	`balance`	STRING	DOUBLE
`ORDER_COUPON`	`amount`	STRING	INSTANT
`ORDER_PRODUCT`	`cost_price_ex_tax`	STRING	DOUBLE
	`cost_price_inc_tax`	STRING	DOUBLE
	`cost_price_tax`	STRING	DOUBLE
	`price_ex_tax`	STRING	DOUBLE
	`price_inc_tax`	STRING	DOUBLE
	`price_tax`	STRING	DOUBLE
	`total_ex_tax`	STRING	DOUBLE
	`total_inc_tax`	STRING	DOUBLE
	`total_tax`	STRING	DOUBLE
	`wrapping_cost_inc_tax`	STRING	DOUBLE
	`wrapping_cost_tax`	STRING	DOUBLE
	`wrapping_cost_ex_tax`	STRING	DOUBLE
`ORDER_SHIPPING_ADDRESS`	`base_cost`	STRING	DOUBLE
	`cost_ex_tax`	STRING	DOUBLE
	`cost_inc_tax`	STRING	DOUBLE
	`cost_tax`	STRING	DOUBLE
	`base_handling_cost`	STRING	DOUBLE
	`handling_cost_ex_tax`	STRING	DOUBLE
	`handling_cost_inc_tax`	STRING	DOUBLE
`ORDER_SHIPMENT`	`date_created`	STRING	INSTANT
`ORDER_TAX`	`rate`	STRING	DOUBLE
	`priority_amount`	STRING	DOUBLE
	`line_amount`	STRING	DOUBLE
`ORDERS`	`subtotal_tax`	STRING	DOUBLE
	`shipping_cost_tax`	STRING	DOUBLE
	`handling_cost_tax`	STRING	DOUBLE
	`wrapping_cost_tax`	STRING	DOUBLE
	`store_credit_amount`	STRING	DOUBLE
	`gift_certificate_amount`	STRING	DOUBLE
	`currency_exchange_rate`	STRING	DOUBLE
	`coupon_discount`	STRING	DOUBLE
	`base_handling_cost`	STRING	DOUBLE
	`base_shipping_cost`	STRING	DOUBLE
	`discount_amount`	STRING	DOUBLE
	`handling_cost_ex_tax`	STRING	DOUBLE
	`handling_cost_inc_tax`	STRING	DOUBLE
	`refunded_amount`	STRING	DOUBLE
	`shipping_cost_ex_tax`	STRING	DOUBLE
	`shipping_cost_inc_tax`	STRING	DOUBLE
	`subtotal_ex_tax`	STRING	DOUBLE
	`subtotal_inc_tax`	STRING	DOUBLE
	`total_ex_tax`	STRING	DOUBLE
	`total_inc_tax`	STRING	DOUBLE
	`wrapping_cost_ex_tax`	STRING	DOUBLE
	`wrapping_cost_inc_tax`	STRING	DOUBLE
	`date_created`	STRING	INSTANT
	`date_modified`	STRING	INSTANT
	`date_shipped`	STRING	INSTANT
`PRODUCT_IMAGE`	`date_created`	STRING	INSTANT
`SHIPPING_ZONE`	`handling_fees_fixed_surcharge`	STRING	INSTANT
	`handling_fees_percentage_surcharge`	STRING	INSTANT
	`minimum_sub_total`	STRING	DOUBLE
`STORE_BLOG_POST`	`date`	STRING	INSTANT
	`published_date_iso8601`	STRING	INSTANT
`TAX_CLASS`	`created_at`	STRING	INSTANT
	`updated_at`	STRING	INSTANT

The BigCommerce connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. BigCommerce's priority-first syncs fetch the most recent two days' worth of data from the following tables:

CHANNEL
CUSTOMER
ORDERS
PRODUCT
PRICE_LIST
SUBSCRIBER

To learn more, see our priority-first sync documentation.

June 2023

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

May 2023

We have added two new tables, COUPON_STATE_RESTRICTION and COUPON_ZIP_RESTRICTION.

November 2022

We have added two new tables, PRODUCT_OPTION_CONFIG and PRODUCT_VARIANT_OPTION_CONFIG.

October 2022

BigCommerce is an ecommerce platform that provides software as a service to retailers.

Read our BigCommerce connector documentation.