Skip to main content
SourceMedium syncs your BigCommerce store’s orders, refunds, customers, products and store settings into BigQuery. These records feed the same sales, refund, product, customer and lifetime value models as Shopify, while the raw tables remain available for your own queries.

What you will need

  • A store-level API account created in your BigCommerce control panel (Settings, API, Store-level API accounts).
  • These read-only OAuth scopes: Information, Orders, Customers, and Products. SourceMedium never writes to your store.
  • The account’s store hash and access token.
BigCommerce does not let you change an API account’s scopes after you create it. If a scope is missing, create a replacement account and reconnect with it.

What data will sync

The first sync covers two years of order history. One connection covers every channel of the store.

Reporting

Reporting is built automatically for connected stores. No separate enablement is needed. Use the shared order analytics, order lines customer analytics and cohort lifetime value tables for sales, product performance, customer cohorts and lifetime value. Lifetime value covers the captured order history. Guest orders contribute to sales, but lack a registered customer identity. When comparing with the platform’s own reports, use the same currency, timezone, date basis, order statuses and refund window; native finance and settlement reports are outside this reporting scope. Recorded refund cash is included. Product-level refund allocation and a separate shipping-tax refund breakdown are not certified because the source data does not provide a reliable allocation. Unallocated amounts remain visible in order totals rather than being assigned to a product.

How to connect

  1. Open your store’s data sources in SourceMedium and choose BigCommerce.
  2. Enter your store hash and the read-only API account access token.
  3. Save. SourceMedium tests the required read access before confirming the connection.
Reconnect rotates credentials for the same BigCommerce store. Use a separate SourceMedium store to connect a different BigCommerce store.