Configuring BigCommerce Exports

Set up BigCommerce exports to send store data into Google Sheets, BigQuery, or Excel.

Overview

After connecting your store, use the Export Builder to create exports by data type. Each export can include one or more tabs and writes to a single destination spreadsheet, dataset, or Excel file.

Prerequisites

BigCommerce store connected (see Connecting Your BigCommerce Store)
A Google Sheets, BigQuery, or Excel destination configured

Create an export

Go to Export Builder and create a new export.
Select BigCommerce as the source and choose your connected store.
Select a destination (Google Sheets, BigQuery, or Excel).
Give the export a name.
On the configuration page, choose a date range and select the data tabs and columns you want.
Save the export and run it manually to validate the output.

Available data tabs

Orders - order headers, totals, payment status, and billing address fields.
Order Line Items - products within orders for the selected date range.
Order Shipping Addresses - shipping addresses for orders in the selected date range.
Order Shipments - shipments and tracking for orders in the selected date range.
Order Transactions - payment transactions and refunds for orders in the selected date range.
Customers - customer profiles and contact details.
Products - catalog products with pricing, inventory, and SEO fields.
Product Variants - catalog variants with SKU, price, and inventory fields.
Categories - catalog category tree.
Brands - catalog brands.
Coupons - marketing coupons.
Gift Certificates - gift certificate balances and status.
Inventory Locations - warehouse and store locations.
Inventory Levels - per-location inventory for products and variants.
Channels - sales channels for multi-storefront setups.
Product Channel Assignments - which products are assigned to which channels.

Date range presets apply to Orders, Order Line Items, Order Shipping Addresses, Order Shipments, and Order Transactions. Catalog, inventory, and channel tabs export the full current dataset on each run.

Append vs replace

For each tab you can choose to append new rows on each run or replace the existing destination tab. For incremental order exports, use a preset like Since last export with append enabled on the Orders tab.

Scheduling

After saving an export, set a schedule from the export detail page. Scheduled runs use the same date preset and column selections you configured.