Release Notes

July 2024

We have made the following changes to the Schema tab for connectors 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 connectors 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.