BigCommerce
BigCommerce is an ecommerce platform for retailers.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | check | |
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | CHANNEL, CUSTOMER, ORDERS, PRODUCT, PRICE_LIST, SUBSCRIBER and their child tables tables. |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step BigCommerce setup guide to connect BigCommerce with your destination using Fivetran connectors.
Sync overview
We sync updates to the following tables based on the date_modified parameter currently set to Date, not DateTime.
CHANNELCUSTOMERORDERSPRICE_LISTPRODUCTSUBSCRIBER
This means we only sync data for the specific date indicated by BigCommerce. Since BigCommerce might generate data at the start or end of a day, there could be a slight delay in receiving updates, even with frequent syncs.
Fivetran skips the PAYMENT_METHOD table if the required API scope is unavailable. If you obtain the necessary scope after completing the historical sync, you can contact Fivetran Support or manually initiate a re-sync. In this case, Fivetran re-syncs only the ORDERS table to retrieve payment data for all orders.
Syncing empty tables and columns
Fivetran can sync empty tables and columns for your BigCommerce connection.
We create a table in the destination even if we can't retrieve the source table data from BigCommerce. For more information, see our Features documentation.
Schema information
This schema applies to all BigCommerce connections.