BigCommerce
BigCommerce is a popular and robust e-commerce platform that empowers businesses to create and manage online stores with ease. It offers a comprehensive suite of tools and features designed to help merchants build, customize, and scale their e-commerce websites.
Data Schema
Loading diagram…
order
order
id
longcustomer_id
longcurrency_id
longdate_created
datedate_modified
datedate_shipped
datestatus_id
longstatus
stringsubtotal_ex_tax
doublesubtotal_inc_tax
doublesubtotal_tax
doublebase_shipping_cost
doubleshipping_cost_ex_tax
doubleshipping_cost_inc_tax
doubleshipping_cost_tax
doubleshipping_cost_tax_class_id
longbase_handling_cost
doublehandling_cost_ex_tax
doublehandling_cost_inc_tax
doublehandling_cost_tax
doublehandling_cost_tax_class_id
longbase_wrapping_cost
doublewrapping_cost_ex_tax
doublewrapping_cost_inc_tax
doublewrapping_cost_tax
doublewrapping_cost_tax_class_id
longtotal_ex_tax
doubletotal_inc_tax
doubletotal_tax
doubleitems_total
intitems_shipped
intpayment_method
stringpayment_provider_id
stringpayment_status
stringrefunded_amount
doubleorder_is_digital
booleanstore_credit_amount
doublegift_certificate_amount
doubleip_address
stringip_address_v6
stringgeoip_country
stringgeoip_country_iso2
stringcurrency_code
stringcurrency_exchange_rate
doubledefault_currency_id
longdefault_currency_code
stringstaff_notes
stringcustomer_message
stringdiscount_amount
doublecoupon_discount
doubleshipping_address_count
intis_deleted
booleanebay_order_id
stringcart_id
stringbilling_address_first_name
stringbilling_address_last_name
stringbilling_address_company
stringbilling_address_street_1
stringbilling_address_street_2
stringbilling_address_city
stringbilling_address_state
stringbilling_address_zip
stringbilling_address_country
stringbilling_address_country_iso2
stringbilling_address_phone
stringbilling_address_email
stringbilling_address_form_fields
stringis_email_opt_in
booleancredit_card_type
stringorder_source
stringchannel_id
longexternal_source
stringexternal_id
stringexternal_merchant_id
stringtax_provider_id
stringcustomer_locale
stringexternal_order_id
stringstore_default_currency_code
stringstore_default_to_transactional_exchange_rate
doublecustom_status
stringorder_line_items
id
longorder_id
longproduct_id
longvariant_id
longorder_address_id
longname
stringname_customer
stringname_merchant
stringsku
stringupc
stringtype
stringbase_price
doubleprice_ex_tax
doubleprice_inc_tax
doubleprice_tax
doublebase_total
doubletotal_ex_tax
doubletotal_inc_tax
doubletotal_tax
doubleweight
doublewidth
doubleheight
doubledepth
doublequantity
intbase_cost_price
doublecost_price_inc_tax
doublecost_price_ex_tax
doublecost_price_tax
doubleis_refunded
booleanquantity_refunded
doublerefund_amount
doublereturn_id
longwrapping_id
longwrapping_name
stringbase_wrapping_cost
doublewrapping_cost_ex_tax
doublewrapping_cost_inc_tax
doublewrapping_cost_tax
doublewrapping_message
stringquantity_shipped
intevent_name
stringevent_date
datefixed_shipping_cost
doubleebay_item_id
stringebay_transaction_id
stringoption_set_id
longparent_order_product_id
longis_bundled_product
booleanbin_picking_number
stringexternal_id
stringfulfillment_source
stringbrand
stringgift_certificate_id
longproduct_options
stringconfigurable_fields
stringorder_line_item_discounts
id
stringorder_id
longorder_line_item_id
longname
stringcode
stringtarget
stringamount
doubleorder_shipping_addresses
id
longorder_id
longfirst_name
stringlast_name
stringcompany
stringstreet_1
stringstreet_2
stringcity
stringzip
stringcountry
stringcountry_iso2
stringstate
stringemail
stringphone
stringitems_total
intitems_shipped
intshipping_method
stringbase_cost
doublecost_ex_tax
doublecost_inc_tax
doublecost_tax
doublecost_tax_class_id
longbase_handling_cost
doublehandling_cost_ex_tax
doublehandling_cost_inc_tax
doublehandling_cost_tax
doublehandling_cost_tax_class_id
longshipping_zone_id
longshipping_zone_name
stringform_fields
stringorder_coupons
id
longorder_id
longcoupon_id
longcode
stringamount
doubletype
stringdiscount
doubleorder_taxes
id
longorder_id
longorder_address_id
longtax_rate_id
longsales_tax_id
stringtax_class_id
longname
stringclass
stringrate
doublepriority
intpriority_amount
doubleline_amount
doublecustomer
customer
id
longauthentication_force_password_reset
booleancompany
stringcustomer_group_id
longemail
stringfirst_name
stringlast_name
stringnotes
stringphone
stringregistration_ip_address
stringtax_exempt_category
stringdate_created
datedate_modified
dateaccepts_product_review_abandoned_cart_emails
booleanorigin_channel_id
longchannel_ids
stringcustomer_addresses
id
longcustomer_id
longaddress1
stringaddress2
stringaddress_type
stringcity
stringcompany
stringcountry
stringcountry_code
stringfirst_name
stringlast_name
stringphone
stringpostal_code
stringstate_or_province
stringcustomer_form_fields
customer_id
longname
stringvalue
stringrefund
refund
id
longorder_id
longuser_id
longcreated
datereason
stringtotal_amount
doubletotal_tax
doubleuses_merchant_override_values
booleanrefund_line_items
refund_id
longproduct_id
longitem_type
stringquantity
intrequested_amount
doublereason
stringrefund_payments
id
longrefund_id
longprovider_id
stringamount
doubleoffline
booleanis_declined
booleandeclined_message
stringproduct
product
id
longbrand_id
longname
stringtype
stringsku
stringdescription
stringweight
doublewidth
doubledepth
doubleheight
doubleprice
doublecost_price
doubleretail_price
doublesale_price
doublemap_price
doubletax_class_id
longproduct_tax_code
stringcalculated_price
doubleoption_set_id
longoption_set_display
stringinventory_level
intinventory_warning_level
intinventory_tracking
stringreviews_rating_sum
intreviews_count
inttotal_sold
intfixed_cost_shipping_price
doubleis_free_shipping
booleanis_visible
booleanis_featured
booleanwarranty
stringbin_picking_number
stringlayout_file
stringupc
stringmpn
stringgtin
stringsearch_keywords
stringavailability
stringavailability_description
stringgift_wrapping_options_type
stringgift_wrapping_options_list
stringsort_order
intcondition
stringis_condition_shown
booleanorder_quantity_minimum
intorder_quantity_maximum
intpage_title
stringmeta_keywords
stringmeta_description
stringdate_created
datedate_modified
dateview_count
intpreorder_release_date
datepreorder_message
stringis_preorder_only
booleanis_price_hidden
booleanprice_hidden_label
stringcustom_url_url
stringcustom_url_is_customized
booleanbase_variant_id
longopen_graph_type
stringopen_graph_title
stringopen_graph_description
stringopen_graph_use_meta_description
booleanopen_graph_use_product_name
booleanopen_graph_use_image
booleanproduct_category
product_id
longcategory_id
longproduct_variant
product_id
longvariant_id
longsku
stringsku_id
longprice
doublecalculated_price
doublesale_price
doubleretail_price
doublemap_price
doubleweight
doublewidth
doubleheight
doubledepth
doubleis_free_shipping
booleanfixed_cost_shipping_price
doublecalculated_weight
doublepurchasing_disabled
booleanpurchasing_disabled_message
stringimage_url
stringcost_price
doubleupc
stringmpn
stringgtin
stringinventory_level
intinventory_warning_level
intbin_picking_number
doubleoption_values
stringproduct_custom_fields
product_id
longname
stringvalue
stringproduct_related_products
product_id
longrelated_product_id
longproduct_bulk_pricing_rules
product_id
longrule_id
longamount
doublequantity_max
intquantity_min
inttype
stringcurrency
id
longis_default
booleanlast_updated
datecountry_iso2
stringdefault_for_country_codes
stringcurrency_code
stringcurrency_exchange_rate
doublename
stringtoken
stringauto_update
booleantoken_location
stringdecimal_token
stringthousands_token
stringdecimal_places
intenabled
booleanis_transactional
booleanuse_default_name
booleancategory
id
longparent_id
longname
stringdescription
stringviews
intsort_order
intpage_title
stringmeta_keywords
stringmeta_description
stringlayout_file
stringimage_url
stringis_visible
booleansearch_keywords
stringdefault_product_sort
stringcustom_url_url
stringcustom_url_is_customized
booleanbrand
id
longname
stringpage_title
stringmeta_keywords
stringmeta_description
stringimage_url
stringsearch_keywords
stringcustom_url_url
stringcustom_url_is_customized
booleanTable
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Open full-page schema explorer
Setup Guide
Step 1 - Create an API Account
- In your BigCommerce account, go to Settings > API > API Accounts

- Click Create an API Account
Step 2 - Select OAuth Scopes
- Select V2/V3 API Token option as Token type
- Give your API Account an arbitrary name
- Select the OAuth scopes you want to give Weld permissions to (note that any sync initiated without the required scopes will result in failure and you will need to create a new API account)

Step 3 - Paste credentials and give access to Weld
As a result, you will get a .txt file with all the credentials for your API account. To give Weld access to your BigCommerce account, you will have to insert two things:
- ACCESS TOKEN - found in your
.txtfile - STORE HASH - found in your
.txtfile inAPI PATH(https://api.bigcommerce.com/stores/{{YOUR_STORE_HASH}}/v3)