Skip to content
Book a demoStart free
Connectors

BigCommerce connector

Set up the BigCommerce connector in Kaivo: authentication, configuration, the 10 BigQuery tables it syncs, and answers to common questions.

BigCommerce connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your BigCommerce data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your e-commerce data instead of moving it.

Sync your BigCommerce store data into BigQuery with Kaivo to analyse orders, products, and customers without exporting reports by hand.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service

Getting started with the BigCommerce connector

Section titled “Getting started with the BigCommerce connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your BigCommerce account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Access Token.

Field Description
Access Token
Access token for making authenticated requests.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

| | Store Hash |

Your store’s unique hash code, found in your BigCommerce API URL (e.g. for https://api.bigcommerce.com/stores/HASH_CODE/v3/, the hash is HASH_CODE).

|

Tables and columns synced from BigCommerce

Section titled “Tables and columns synced from BigCommerce”

Kaivo syncs 10 tables from BigCommerce into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

brands (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
custom_url__is_customized BOOL
custom_url__url STRING
id INT64
image_url STRING
meta_description STRING
name STRING
page_title STRING
search_keywords STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
categories (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
custom_url__is_customized BOOL
custom_url__path STRING
default_product_sort STRING
id INT64
image_url STRING
is_visible BOOL
layout_file STRING
meta_description STRING
name STRING
page_title STRING
parent_id INT64
search_keywords STRING
sort_order INT64
views INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
channels (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
date_created TIMESTAMP
date_modified TIMESTAMP
external_id STRING
icon_url STRING
id INT64
is_enabled BOOL
is_listable_from_ui BOOL
is_visible BOOL
name STRING
platform STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address_count INT64
attribute_count INT64
authentication__force_password_reset BOOL
company STRING
customer_group_id INT64
date_created TIMESTAMP
date_modified TIMESTAMP
email STRING
first_name STRING
id INT64
last_name STRING
notes STRING
phone STRING
registration_ip_address STRING
tax_exempt_category STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accepts_product_review_abandoned_cart_emails BOOL
address1 STRING
address2 STRING
address_type STRING
city STRING
company STRING
country STRING
country_code STRING
customer_id INT64
first_name STRING
id INT64
last_name STRING
origin_channel_id INT64
phone STRING
postal_code STRING
state_or_province STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__addresses__channel_ids

Section titled “Subtable: customers__addresses__channel_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__addresses__form_fields

Section titled “Subtable: customers__addresses__form_fields”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__addresses__store_credit_amounts

Section titled “Subtable: customers__addresses__store_credit_amounts”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
order_products (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
base_cost_price STRING
base_price STRING
base_total STRING
base_wrapping_cost STRING
bin_picking_number STRING
brand STRING
cost_price_ex_tax STRING
cost_price_inc_tax STRING
cost_price_tax STRING
depth STRING
ebay_item_id STRING
ebay_transaction_id STRING
event_date STRING
event_name STRING
external_id STRING
fixed_shipping_cost STRING
fulfillment_source STRING
gift_certificate_id INT64
height STRING
id INT64
is_bundled_product BOOL
is_refunded BOOL
name STRING
name_customer STRING
name_merchant STRING
option_set_id INT64
order_address_id INT64
order_id INT64
parent_order_product_id INT64
price_ex_tax STRING
price_inc_tax STRING
price_tax STRING
product_id INT64
quantity FLOAT64
quantity_refunded FLOAT64
quantity_shipped FLOAT64
refund_amount STRING
return_id FLOAT64
sku STRING
total_ex_tax STRING
total_inc_tax STRING
total_tax STRING
upc STRING
variant_id INT64
weight STRING
width STRING
wrapping_cost_ex_tax STRING
wrapping_cost_inc_tax STRING
wrapping_cost_tax STRING
wrapping_id STRING
wrapping_message STRING
wrapping_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: order_products__applied_discounts

Section titled “Subtable: order_products__applied_discounts”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: order_products__configurable_fields

Section titled “Subtable: order_products__configurable_fields”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
orders (78 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
base_handling_cost STRING
base_shipping_cost STRING
base_wrapping_cost JSON
billing_address__city STRING
billing_address__company STRING
billing_address__country STRING
billing_address__country_iso2 STRING
billing_address__email STRING
billing_address__first_name STRING
billing_address__last_name STRING
billing_address__phone STRING
billing_address__state STRING
billing_address__street_1 STRING
billing_address__street_2 STRING
billing_address__zip STRING
cart_id STRING
channel_id INT64
coupon_discount STRING
coupons__resource STRING
coupons__url STRING
currency_code STRING
currency_exchange_rate STRING
currency_id INT64
customer_id INT64
customer_locale STRING
customer_message STRING
date_created TIMESTAMP
date_modified TIMESTAMP
date_shipped TIMESTAMP
default_currency_code STRING
default_currency_id INT64
discount_amount STRING
ebay_order_id STRING
external_id STRING
external_source STRING
geoip_country STRING
geoip_country_iso2 STRING
gift_certificate_amount STRING
handling_cost_ex_tax STRING
handling_cost_inc_tax STRING
handling_cost_tax STRING
handling_cost_tax_class_id INT64
id INT64
ip_address STRING
is_deleted BOOL
is_email_opt_in BOOL
items_shipped INT64
items_total INT64
order_is_digital BOOL
order_source STRING
payment_method STRING
payment_status STRING
products__resource STRING
products__url STRING
refunded_amount STRING
shipping_address_count INT64
shipping_addresses__resource STRING
shipping_addresses__url STRING
shipping_cost_ex_tax STRING
shipping_cost_inc_tax STRING
shipping_cost_tax STRING
shipping_cost_tax_class_id INT64
staff_notes STRING
status STRING
status_id INT64
store_credit_amount STRING
subtotal_ex_tax STRING
subtotal_inc_tax STRING
subtotal_tax STRING
tax_provider_id STRING
total_ex_tax STRING
total_inc_tax STRING
wrapping_cost_ex_tax STRING
wrapping_cost_inc_tax STRING
wrapping_cost_tax STRING
wrapping_cost_tax_class_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: orders__billing_address__form_fields

Section titled “Subtable: orders__billing_address__form_fields”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pages (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
body STRING
channel_id INT64
contact_fields STRING
email STRING
feed STRING
id INT64
is_customers_only BOOL
is_homepage BOOL
is_visible BOOL
link STRING
meta_description STRING
meta_keywords STRING
meta_title STRING
name STRING
parent_id INT64
search_keywords STRING
sort_order INT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (67 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
availability STRING
availability_description STRING
base_variant_id INT64
bin_picking_number STRING
brand_id INT64
brand_name_or_brand_id STRING
calculated_price FLOAT64
condition STRING
cost_price FLOAT64
custom_url__is_customized BOOL
custom_url__url STRING
date_created TIMESTAMP
date_modified TIMESTAMP
depth FLOAT64
fixed_cost_shipping_price FLOAT64
gift_wrapping_options_type STRING
gtin STRING
height FLOAT64
id INT64
inventory_level INT64
inventory_tracking STRING
inventory_warning_level INT64
is_condition_shown BOOL
is_featured BOOL
is_free_shipping BOOL
is_preorder_only BOOL
is_price_hidden BOOL
is_visible BOOL
layout_file STRING
map_price FLOAT64
meta_description STRING
mpn STRING
name STRING
open_graph_description STRING
open_graph_title STRING
open_graph_type STRING
open_graph_use_image BOOL
open_graph_use_meta_description BOOL
open_graph_use_product_name BOOL
option_set_display STRING
option_set_id INT64
order_quantity_maximum INT64
order_quantity_minimum INT64
page_title STRING
preorder_message STRING
preorder_release_date TIMESTAMP
price FLOAT64
price_hidden_label STRING
product_tax_code STRING
retail_price FLOAT64
reviews_count INT64
reviews_rating_sum INT64
sale_price FLOAT64
search_keywords STRING
sku STRING
sort_order INT64
tax_class_id INT64
total_sold INT64
upc STRING
view_count INT64
warranty STRING
weight FLOAT64
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
amount INT64
id INT64
quantity_max INT64
quantity_min INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__gift_wrapping_options_list

Section titled “Subtable: products__gift_wrapping_options_list”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
date_modified TIMESTAMP
id INT64
image_file STRING
image_url STRING
is_thumbnail BOOL
product_id INT64
sort_order INT64
url_standard STRING
url_thumbnail STRING
url_tiny STRING
url_zoom STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__checkbox_label STRING
config__checked_by_default BOOL
config__date_earliest_value DATE
config__date_latest_value DATE
config__date_limit_mode STRING
config__date_limited BOOL
config__default_value STRING
config__file_max_size INT64
config__file_types_mode STRING
config__number_highest_value FLOAT64
config__number_integers_only BOOL
config__number_limit_mode STRING
config__number_limited BOOL
config__number_lowest_value FLOAT64
config__product_list_adjusts_inventory BOOL
config__product_list_adjusts_pricing BOOL
config__product_list_shipping_calc STRING
config__text_characters_limited BOOL
config__text_lines_limited BOOL
config__text_max_length INT64
config__text_max_lines INT64
config__text_min_length INT64
display_name STRING
id INT64
name STRING
product_id INT64
required BOOL
sort_order INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__modifiers__config__file_types_other

Section titled “Subtable: products__modifiers__config__file_types_other”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__modifiers__config__file_types_supported

Section titled “Subtable: products__modifiers__config__file_types_supported”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__modifiers__option_values

Section titled “Subtable: products__modifiers__option_values”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
adjusters__image_url STRING
adjusters__price__adjuster STRING
adjusters__price__adjuster_value FLOAT64
adjusters__purchasing_disabled__message STRING
adjusters__purchasing_disabled__status BOOL
adjusters__weight__adjuster STRING
adjusters__weight__adjuster_value FLOAT64
id INT64
is_default BOOL
label STRING
option_id INT64
sort_order INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__checkbox_label STRING
config__checked_by_default BOOL
config__date_earliest_value DATE
config__date_latest_value DATE
config__date_limit_mode STRING
config__date_limited BOOL
config__default_value STRING
config__file_max_size INT64
config__file_types_mode STRING
config__number_highest_value FLOAT64
config__number_integers_only BOOL
config__number_limit_mode STRING
config__number_limited BOOL
config__number_lowest_value FLOAT64
config__product_list_adjusts_inventory BOOL
config__product_list_adjusts_pricing BOOL
config__product_list_shipping_calc STRING
config__text_characters_limited BOOL
config__text_lines_limited BOOL
config__text_max_length INT64
config__text_max_lines INT64
config__text_min_length INT64
display_name STRING
id INT64
option_values__id INT64
option_values__is_default BOOL
option_values__label STRING
option_values__sort_order INT64
product_id INT64
sort_order INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__options__config__file_types_other

Section titled “Subtable: products__options__config__file_types_other”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__options__config__file_types_supported

Section titled “Subtable: products__options__config__file_types_supported”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bin_picking_number STRING
calculated_price FLOAT64
calculated_weight FLOAT64
cost_price FLOAT64
depth FLOAT64
fixed_cost_shipping_price FLOAT64
height FLOAT64
id INT64
inventory_level INT64
inventory_warning_level INT64
is_free_shipping BOOL
mpn STRING
price FLOAT64
product_id INT64
purchasing_disabled BOOL
purchasing_disabled_message STRING
retail_price FLOAT64
sale_price FLOAT64
sku STRING
sku_id INT64
upc STRING
weight FLOAT64
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__variants__option_values

Section titled “Subtable: products__variants__option_values”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
label STRING
option_display_name STRING
option_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
id INT64
length STRING
product_id INT64
sort_order INT64
title STRING
video_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
store (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_uuid STRING
address STRING
admin_email STRING
control_panel_base_url STRING
country STRING
country_code STRING
currency STRING
currency_symbol STRING
currency_symbol_location STRING
decimal_places INT64
decimal_separator STRING
default_channel_id INT64
default_site_id INT64
dimension_decimal_places INT64
dimension_decimal_token STRING
dimension_thousands_token STRING
dimension_units STRING
domain STRING
favicon_url STRING
features__checkout_type STRING
features__facebook_catalog_id STRING
features__graphql_storefront_api_enabled BOOL
features__multi_storefront_enabled BOOL
features__shopper_consent_tracking_enabled BOOL
features__sitewidehttps_enabled BOOL
features__stencil_enabled BOOL
features__wishlists_enabled BOOL
first_name STRING
id STRING
industry STRING
is_price_entered_with_tax BOOL
language STRING
last_name STRING
name STRING
order_email STRING
phone STRING
plan_is_trial BOOL
plan_level STRING
plan_name STRING
secure_url STRING
status STRING
store_id INT64
thousands_separator STRING
timezone__date_format__display STRING
timezone__date_format__export STRING
timezone__date_format__extended_display STRING
timezone__dst_offset INT64
timezone__name STRING
timezone__raw_offset INT64
weight_units STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: store__active_comparison_modules

Section titled “Subtable: store__active_comparison_modules”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transactions (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
avs_result__code STRING
avs_result__message STRING
avs_result__postal_match STRING
avs_result__street_match STRING
credit_card__card_expiry_month INT64
credit_card__card_expiry_year INT64
credit_card__card_iin STRING
credit_card__card_last4 STRING
credit_card__card_type STRING
currency STRING
custom__payment_method STRING
cvv_result__code STRING
cvv_result__message STRING
date_created STRING
event STRING
fraud_review BOOL
gateway STRING
gateway_transaction_id STRING
gift_certificate__code STRING
gift_certificate__original_balance INT64
gift_certificate__remaining_balance INT64
gift_certificate__starting_balance INT64
gift_certificate__status STRING
id INT64
method STRING
offline__display_name STRING
order_id STRING
payment_instrument_token STRING
payment_method_id STRING
reference_transaction_id INT64
status STRING
store_credit__remaining_balance INT64
test BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where BigCommerce supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for BigCommerce?

Section titled “How long does the initial sync take for BigCommerce?”

It depends on how much history is in your BigCommerce account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when BigCommerce’s schema changes?

Section titled “What happens when BigCommerce’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in BigCommerce, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in BigCommerce instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the BigCommerce connector in Kaivo and all of its synced data is deleted with it.

Combine orders, order_products, and transactions to track revenue and average order value over time.

Join order_products with products and categories to see best sellers and margin by category.

Use customers to measure repeat purchase rates and lifetime value.

Bring channels and store data together to compare performance across sales channels.

Use BigCommerce data in your AI and BI tools

Section titled “Use BigCommerce data in your AI and BI tools”

Once BigCommerce data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with BigCommerce data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for BigCommerce connector pricing and plan details.