---
title: "WooCommerce integration"
description: "WooCommerce sales sit inside WordPress. Bring sales, refunds, products and customer lifetime value into reporting alongside your other storefronts."
url: "https://sourcemedium.com/integrations/woocommerce/"
---

# WordPress storefront data beyond the admin screen

WooCommerce sales sit inside WordPress. Bring sales, refunds, products and customer lifetime value into reporting alongside your other storefronts.

## Integration Snapshot

- Platform: WooCommerce
- Category: Ecommerce & Subscription
- Availability: Supported integration
- Documentation: [View docs](https://sourcemedium.com/docs/data-inputs/platform-integration-instructions/woocommerce-integration)
- Supported version: WooCommerce 9.0 or newer, using a read-only REST key
- MCP server: Official server, checked September 2026 ([WooCommerce MCP server](https://sourcemedium.com/mcp-directory/woocommerce/))

## Why teams connect WooCommerce

Connect a self-hosted installation through its canonical HTTPS address. Reviewed attribution metadata and shopper relationships stay attached to each order document, while raw tables remain available for your own queries.

## Key capabilities

- Item-level refunds: Recorded refund lines retain their order-item relationships for product analysis.
- Catalog relationships: Products and their variations retain native identities even when a SKU is blank.

## 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.
- WooCommerce Analytics date basis: WooCommerce Analytics can use Date Paid and a different status selection. Align those settings before comparing it with placed-order sales. [Details in the docs](https://sourcemedium.com/docs/data-inputs/platform-integration-instructions/woocommerce-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

- Which WooCommerce products drive repeat purchases?
- How do WooCommerce customer cohorts compare with our other storefronts?

## Joins with

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

## How it works

1. Create a REST API key: Choose Read permission in WooCommerce settings.
2. Connect your installation: Save its HTTPS URL, consumer key and consumer secret in SourceMedium.
3. Use shared reporting: Sales, refunds, products and customers enter the commerce models automatically.

## Related integrations

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