---
title: "BigCommerce integration"
description: "BigCommerce refunds and repeat sales are hard to compare across stores. Use shared sales, product and customer lifetime value reporting."
url: "https://sourcemedium.com/integrations/bigcommerce/"
---

# BigCommerce sales and customer value beside your other stores

BigCommerce refunds and repeat sales are hard to compare across stores. Use shared sales, product and customer lifetime value reporting.

## Integration Snapshot

- Platform: BigCommerce
- Category: Ecommerce & Subscription
- Availability: Supported integration
- Documentation: [View docs](https://sourcemedium.com/docs/data-inputs/platform-integration-instructions/bigcommerce-integration)
- Access: A store-level API account with read-only permissions
- MCP server: Official server, but not for your account data, checked September 2026 ([BigCommerce MCP server](https://sourcemedium.com/mcp-directory/bigcommerce/))

## Why teams connect BigCommerce

A read-only API connection covers every channel of your BigCommerce store. Source-scoped identities keep overlapping order and customer numbers distinct when you also sell through Shopify or another platform.

## Key capabilities

- Refund-aware sales: Recorded refund cash flows into the shared transaction ledger on its own event date.
- Current reference data: Customer addresses, product variants and store settings use complete daily snapshots.

## Before you analyze

- Compare the same reporting basis: Align currency, timezone, date basis, order statuses and refund window before comparing native totals. Finance, payouts and settlement reports are outside this reporting scope.
- Lifetime value covers captured history: Purchases outside the synced history are not included. Guest orders contribute to sales but lack a registered customer identity.
- Refund breakdown limits: Product-level refund allocation and separate shipping-tax refund reporting are not certified. Known refund amounts remain in order totals without an invented allocation. [Details in the docs](https://sourcemedium.com/docs/data-inputs/platform-integration-instructions/bigcommerce-integration)

## Example BigQuery tables

- `obt_orders`: Sales, refunds and customer order history on shared commerce definitions
- `obt_order_lines`: Product-level quantities and recorded order amounts
- `obt_customers`: Customer profiles and acquisition identities
- `rpt_cohort_ltv_by_first_valid_purchase_attribute_no_product_filters`: Customer cohort lifetime value over captured history
- `dim_product_variants`: Source-scoped product variants and catalog attributes

## Common enrichments

- New and repeat customer classification
- Acquisition cohorts over captured history

## Questions you can ask

- How much sales revenue remains after BigCommerce refunds?
- Which BigCommerce customer cohorts return to purchase again?

## Joins with

- [Shopify](https://sourcemedium.com/integrations/shopify)
- [WooCommerce](https://sourcemedium.com/integrations/woocommerce)
- [Magento](https://sourcemedium.com/integrations/magento)

## How it works

1. Create a read-only API account: Grant Information, Orders, Customers and Products read-only scopes.
2. Connect your store: Save your store hash and access token in SourceMedium.
3. Use shared reporting: Sales, refunds, products and customers enter the commerce models automatically.

## Related integrations

- [Magento](https://sourcemedium.com/integrations/magento)
- [WooCommerce](https://sourcemedium.com/integrations/woocommerce)
- [Shopify](https://sourcemedium.com/integrations/shopify)
- [Amazon Seller Central](https://sourcemedium.com/integrations/amazon-seller-central)