Skip to main content
SourceMedium syncs one Magento Open Source or Adobe Commerce website’s orders, credit memos, 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

  • Magento Open Source or Adobe Commerce 2.4.4 or newer, self-hosted or on Adobe Commerce Cloud (PaaS), served over HTTPS on the standard port. Adobe Commerce as a Cloud Service (SaaS) is not supported yet.
  • An integration created and activated in the Magento Admin (System, Extensions, Integrations), with access to these resources: Sales operations (orders and credit memos), Customers, Catalog products, and Stores settings. Its four OAuth values: consumer key, consumer secret, access token, and access token secret.
  • Your store’s base URL, and the website code to sync if your installation has more than one website.
Some of these Magento permissions also allow changes. SourceMedium only reads data and never writes to your store.

What data will sync

The first sync covers two years of order history. One connection covers one website. Custom extension fields are not synced.

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. Order and credit memo cash totals are retained. Component quantities for completely free dynamic bundles and selected configurable-option attribution need additional source data. Magento’s invoiced and payment reports also use a different basis from placed-order sales.

How to connect

  1. Open your store’s data sources in SourceMedium and choose Magento.
  2. Enter your Store URL and all four OAuth values. Add the Website code if the store has several websites.
  3. Save. SourceMedium tests the required read access before confirming the connection.
Reconnect rotates credentials for the same Magento installation and website. Use a separate SourceMedium store to connect a different Magento installation and website.

Notes

  • Magento is a storefront. It is not Loop Subscriptions and it is not Loop Returns.