Connector

Collect Shopify data in Google BigQuery

Load Shopify orders, customers, products and payments into your own BigQuery tables with OWOX Data Marts: one table per endpoint, a business-friendly schema, refreshed on a schedule. Join it with your accounting data so every team reports the same revenue.

ShopifyConnectedAbandoned Checko…Article Metafiel…ArticlesBlog Metafields
Data MartPublishedone definition
Google BigQueryIdAband…Compl…Daily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

Shopify orders in several currencies get added up as one number, and the monthly revenue figure is quietly wrong.

Paste this into your AI assistant. It loads Shopify orders into Google BigQuery tables with OWOX Data Marts and keeps currency, discounts and refunds as their own columns, so revenue is summed correctly.

The prompt

load Shopify orders into Google BigQuery and report monthly revenue per currency code, with total price, discounts and refunds as separate columns and net revenue per currency

Endpoints

Shopify Endpoints

Documentation

25 Shopify endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

Why join Shopify with your accounting and ad data

Ask what revenue was last month and Shopify gives one number while the accounting system gives another. Refunds, discounts, taxes, currencies and payment timing each move the figure. To see where the two differ, both have to sit in one data warehouse.

  • Reconcile Shopify orders with accounting records in one query
  • Separate gross sales from discounts, refunds and cancellations
  • Set daily orders beside daily ad spend
ShopifyOrders, refunds
AccountingInvoices, payments
Ad platformsSpend
Your data warehouseBigQueryShopifyAccountingAd spendJoined by idOrder placedRevenue reportedOne query shows where they differ.

S01 · Step 1

Step 1: Connect Shopify and pick the fields

Create a Data Mart, choose Shopify as the data source, add your shop domain and Admin API access token, open an endpoint and tick only the fields you need.

  • 25 endpoints and 337 fields to choose from
  • Orders alone has 47 fields: totals, discounts, refunds, status, customer
New Data MartChoose a sourceFacebook AdsShopifyGoogle AdsAuthorizeConnectedEndpointOrdersAbandoned Checkou…Article MetafieldsArticles
Orders96 fieldscreatedAttotalPricetotalDiscountstotalRefundedcurrencyCodedisplayFinancialStatus

S02 · Step 2

Step 2: Load Shopify into a BigQuery table

The dataset and table in your data storage are pre-filled, and you can change them. Run it and the first load lands in your own BigQuery project.

  • Each endpoint gets its own table, not one table for the whole store
  • Every run is logged in Run History
DestinationBigQueryDatasetshopifyTableordersRun
Run HistoryPendingRunningSuccessIncremental load
Tableshopify.orders

S03 · Step 3

Step 3: Get a business-friendly output schema

After the first run you get the output schema: every field with a readable description. Your data quality checks can read it too.

  • Descriptions say what a field holds, for example the total amount refunded
  • Finance and marketing read the same column names
shopify.ordersOutput schemaFieldDescriptioncreatedAtThe date and time when the…totalPriceThe total price of the order.totalDiscountsThe total discounts applied.totalRefundedThe total amount refunded.currencyCodeThe currency of the order.displayFinancialStatusThe financial status of the…

S04 · Step 4

Step 4: Keep the Shopify tables linked

Customers, orders and payment transactions stay separate tables, joined by ids. Together they become one Shopify data model, ready to join to accounting.

  • Orders carry customerId; tender transactions carry orderId
  • Add accounting, ad spend and web analytics tables to the same model
CustomersiddisplayNamenumberOfOrders
OrdersidcustomerIdtotalPrice
Tender Transactio…orderIdamountprocessedAt

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A daily scheduled refresh keeps the tables current, and a manual backfill loads any past period.

  • Daily runs with no pipeline to maintain
  • Backfill order history the first time you connect
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same table everywhere

One table feeds your data model, spreadsheets, dashboards, AI assistants like Claude and ChatGPT, and scheduled AI insights in Slack or email.

  • Define revenue once
  • Every report reads the same table
ShopifyData MartPublished
Your data model
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for Shopify in BigQuery

Shopify reports, hand-built API scripts or a generic ETL tool each get the orders out. OWOX also keeps them yours, readable and ready to join to accounting.

  • You own the data. It lands in your own data warehouse, in tables you control.
  • A business-friendly schema. Readable field names and descriptions, not API identifiers.
  • Ready for a data model. Separate tables per endpoint, joined by ids, built to connect to accounting, ad spend and web analytics.
  • Maintained for you. No scripts to fix when Shopify changes its API.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers