Bigcommerce

Bigcommerce ETL connector for data replication

Snapshot

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

Integrate BigCommerce with Daton

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. Provide BigCommerce Store Hash, Client ID, Access Token. Follow the link to get your details

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

Workflow

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

BigCommerce Data

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