---
title: "Medusa integration"
description: "SourceMedium syncs your Medusa store's orders, customers, products, and inventory through a read-only reporting API on your backend, then shapes them into the same commerce reporting Shopify brands use, so headless doesn't mean reporting-blind."
url: "https://sourcemedium.com/integrations/medusa"
---

# Headless commerce data, analytics-ready in BigQuery

SourceMedium syncs your Medusa store's orders, customers, products, and inventory through a read-only reporting API on your backend, then shapes them into the same commerce reporting Shopify brands use, so headless doesn't mean reporting-blind.

## Integration Snapshot

- Platform: Medusa
- Category: Ecommerce & Subscription
- Availability: Generally available
- Documentation: [View docs](https://sourcemedium.com/docs/data-inputs/platform-integration-instructions/medusa-integration)

## Why teams connect Medusa

Medusa gives your engineering team full control of the commerce stack, but that flexibility usually means building analytics yourself. SourceMedium reads Medusa through a lightweight reporting projection and delivers order, product, customer, and subscription reporting without maintaining the downstream analytics pipeline.

## Key capabilities

- Full order detail: Orders sync with line items, shipping, fulfillments, refunds, and payment capture details, ready for revenue, AOV, and fulfillment analysis.
- Shopify-parity schema: Medusa data lands in the same table shape as Shopify, so commerce reporting works consistently across platforms.
- Catalog and inventory: Products, variants, and inventory levels stay current for merchandising and stock analysis.
- Subscription reporting: For stores with a subscription module, recurring orders link back to their subscriptions for retention and LTV analysis.

## Example BigQuery tables

- `obt_orders`: Medusa orders with revenue, status, and channel (source_system = 'medusa')
- `obt_order_lines`: Product-level order lines with SKU, quantity, price, and discounts
- `obt_customers`: Customer analytics with LTV, cohort, and acquisition metrics

## Common enrichments

- Subscription linkage projected onto recurring orders
- Payment capture ledger preserved per order
- Pre- and post-discount amounts separated at the line level

## Questions you can ask

- What's our repeat purchase rate by cohort?
- Show revenue by product this quarter
- Which customers have the highest lifetime value?
- What's our refund rate by month?
- How many orders are currently unfulfilled?

## Joins with

- [Meta Ads](https://sourcemedium.com/integrations/meta-ads)
- [Google Ads](https://sourcemedium.com/integrations/google-ads)
- [Klaviyo](https://sourcemedium.com/integrations/klaviyo)

## How it works

1. Enable the reporting API: Your developer exposes a read-only reporting projection on your Medusa backend using our checklist.
2. Share your credentials: Send SourceMedium your publishable API key and store URL; we provision the connection.
3. Validated historical backfill: We validate the data contract, backfill the available history exposed by the reporting projection, and start scheduled syncs.

## Related integrations

- [Meta Ads](https://sourcemedium.com/integrations/meta-ads)
- [Google Ads](https://sourcemedium.com/integrations/google-ads)
- [Klaviyo](https://sourcemedium.com/integrations/klaviyo)
- [Shopify](https://sourcemedium.com/integrations/shopify)