Bigcommerce
Bigcommerce ETL connector for data replication
Features | Details |
Release Status | Released |
Source API Version | V2,V3 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | BigCommerce Store Hash
BigCommerce Client ID
BigCommerce Access Token |
Replication Type | Full Replication
Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | 1hr |
Tables/APIs Supported | ​ |
Catalog | Brands |
Categories | Products |
StoreCurrencies | Orders |
Customers | Subscribers |
PriceLists | Banners |
Coupons | ​ |
- 1.Signin to Daton
- 2.Select BigCommerce from the list of Integrations
- 3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Catalog
Purpose: This API is used to get the list of all varients in the catelog.
Source API Documentation https://developer.bigcommerce.com/api-reference/catalog/catalog-api/catalog/getvariants​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
product_id | INTEGER |
sku | STRING |
sku_id | INTEGER |
price | INTEGER |
calculated_price | INTEGER |
sale_price | STRING |
retail_price | STRING |
map_price | STRING |
weight | INTEGER |
calculated_weight | INTEGER |
width | INTEGER |
height | STRING |
depth | STRING |
is_free_shipping | BOOLEAN |
fixed_cost_shipping_price | STRING |
purchasing_disabled | BOOLEAN |
purchasing_disabled_message | STRING |
image_url | STRING |
cost_price | INTEGER |
upc | STRING |
mpn | STRING |
gtin | STRING |
inventory_level | INTEGER |
inventory_warning_level | INTEGER |
bin_picking_number | STRING |
option_values | record |
Brands
Purpose: This API is used to get the list of all brands.
Source API Documentation https://developer.bigcommerce.com/api-reference/catalog/catalog-api/brands/getbrands​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
page_title | STRING |
meta_keywords | STRING |
meta_description | STRING |
image_url | STRING |
search_keywords | STRING |
custom_url | record |
Categories
Purpose: This API is used to get the list of all Categories
Source API Documentation https://developer.bigcommerce.com/api-reference/catalog/catalog-api/category/getcategories​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
parent_id | INTEGER |
name | STRING |
description | STRING |
views | INTEGER |
sort_order | INTEGER |
page_title | STRING |
meta_keywords | STRING |
meta_description | STRING |
layout_file | STRING |
image_url | STRING |
is_visible | BOOLEAN |
search_keywords | STRING |
default_product_sort | STRING |
custom_url | record |
Products
Purpose: This API returns the list of all products.
Source API Documentation https://developer.bigcommerce.com/api-reference/catalog/catalog-api/products/getproducts​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
parent_id | INTEGER |
name | STRING |
description | STRING |
views | INTEGER |
sort_order | INTEGER |
page_title | STRING |
meta_keywords | STRING |
meta_description | STRING |
layout_file | STRING |
image_url | STRING |
is_visible | BOOLEAN |
search_keywords | STRING |
default_product_sort | STRING |
custom_url | record |
StoreCurrencies
Purpose: This API returns the list of all store currencies.
Source API Documentation https://developer.bigcommerce.com/api-reference/store-management/currency-api/currency/getcurrencies​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
is_default | BOOLEAN |
last_updated | TIMESTAMP |
country_iso2 | STRING |
currency_code | STRING |
currency_exchange_rate | STRING |
name | STRING |
token | STRING |
auto_update | BOOLEAN |
token_location | STRING |
decimal_token | STRING |
thousands_token | STRING |
decimal_places | INTEGER |
enabled | BOOLEAN |
Orders
Purpose: This API is used to get the list of orders with parametered filters.
Source API Documentation https://developer.bigcommerce.com/api-reference/orders/orders-api/orders/getorders​
Replication: Key-Based Incremental
Replication Key: max_date_modified
Fields
Name | Target Datatype |
id | INTEGER |
customer_id | INTEGER |
date_created | TIMESTAMP |
date_modified | TIMESTAMP |
date_shipped | STRING |
status_id | INTEGER |
status | STRING |
subtotal_ex_tax | STRING |
subtotal_inc_tax | STRING |
subtotal_tax | STRING |
base_shipping_cost | STRING |
shipping_cost_ex_tax | STRING |
shipping_cost_inc_tax | STRING |
shipping_cost_tax | STRING |
shipping_cost_tax_class_id | INTEGER |
base_handling_cost | STRING |
handling_cost_ex_tax | STRING |
handling_cost_inc_tax | STRING |
handling_cost_tax | STRING |
handling_cost_tax_class_id | INTEGER |
base_wrapping_cost | STRING |
wrapping_cost_ex_tax | STRING |
wrapping_cost_inc_tax | STRING |
wrapping_cost_tax | STRING |
wrapping_cost_tax_class_id | INTEGER |
total_ex_tax | STRING |
total_inc_tax | STRING |
total_tax | STRING |
items_total | INTEGER |
items_shipped | INTEGER |
payment_method | STRING |
payment_provider_id | STRING |
payment_status | STRING |
refunded_amount | STRING |
order_is_digital | BOOLEAN |
store_credit_amount | STRING |
gift_certificate_amount | STRING |
ip_address | STRING |
geoip_country | STRING |
geoip_country_iso2 | STRING |
currency_id | INTEGER |
currency_code | STRING |
currency_exchange_rate | STRING |
default_currency_id | INTEGER |
default_currency_code | STRING |
staff_notes | STRING |
customer_message | STRING |
discount_amount | STRING |
coupon_discount | STRING |
shipping_address_count | INTEGER |
is_deleted | BOOLEAN |
ebay_order_id | STRING |
cart_id | STRING |
billing_address | record |
is_email_opt_in | BOOLEAN |
credit_card_type | STRING |
order_source | STRING |
channel_id | INTEGER |
external_source | STRING |
products | record |
shipping_addresses | record |
coupons | record |
external_id | STRING |
external_merchant_id | STRING |
tax_provider_id | STRING |
custom_status | STRING |
Customers
Purpose: This API is used to get the list of all Customers.
Source API Documentation https://developer.bigcommerce.com/api-reference/customer-subscribers/v3-customers-api/customers/customersget​
Replication: Key-Based Incremental
Replication Key: max_date_modified
Fields
Name | Target Datatype |
id | INTEGER |
company | STRING |
first_name | STRING |
last_name | STRING |
email | STRING |
phone | STRING |
form_fields | record |
date_created | TIMESTAMP |
date_modified | TIMESTAMP |
store_credit | STRING |
registration_ip_address | STRING |
customer_group_id | INTEGER |
notes | STRING |
tax_exempt_category | STRING |
reset_pass_on_login | BOOLEAN |
accepts_marketing | BOOLEAN |
addresses | record |
Subscribers
Purpose: This API returns list of all Subscribers
Source API Documentation https://developer.bigcommerce.com/api-reference/customer-subscribers/subscribers-api/subscribers/getsubscribers​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
company | STRING |
first_name | STRING |
last_name | STRING |
email | STRING |
phone | STRING |
form_fields | record |
date_created | TIMESTAMP |
date_modified | TIMESTAMP |
store_credit | STRING |
registration_ip_address | STRING |
customer_group_id | INTEGER |
notes | STRING |
tax_exempt_category | STRING |
reset_pass_on_login | BOOLEAN |
accepts_marketing | BOOLEAN |
addresses | record |
PriceLists
Purpose: This API returns all Price Lists.
Source API Documentation https://developer.bigcommerce.com/api-reference/catalog/pricelists-api/price-lists/getpricelistcollection​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
date_created | TIMESTAMP |
date_modified | TIMESTAMP |
active | BOOLEAN |
Banners
Purpose: This API returns all banners
Source API Documentation https://developer.bigcommerce.com/api-reference/marketing/marketing-api/banners/getallbanners​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
content | STRING |
page | STRING |
item_id | STRING |
location | STRING |
date_created | STRING |
date_type | STRING |
date_from | STRING |
date_to | STRING |
visible | STRING |
Coupons
Purpose: This API returns all the coupons.
Source API Documentation https://developer.bigcommerce.com/api-reference/marketing/marketing-api/coupons/getallcoupons​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
type | STRING |
amount | STRING |
min_purchase | STRING |
expires | STRING |
enabled | BOOLEAN |
code | STRING |
applies_to | record |
num_uses | INTEGER |
max_uses | INTEGER |
max_uses_per_customer | INTEGER |
shipping_methods | STRING |
date_created | TIMESTAMP |
Last modified 3yr ago