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