Release Noteslink
March 2024link
Our BigCommerce connector is now generally available.
Read our BigCommerce documentation.
July 2023link
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 2023link
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 2023link
We have added two new tables, COUPON_STATE_RESTRICTION
and COUPON_ZIP_RESTRICTION
.
November 2022link
We have added two new tables, PRODUCT_OPTION_CONFIG
and PRODUCT_VARIANT_OPTION_CONFIG
.
October 2022link
BigCommerce is an ecommerce platform that provides software as a service to retailers.