--- title: "Shopify to Google BigQuery Connector | OWOX" canonical: "https://www.owox.com/connectors/free-shopify-connector-to-google-bigquery" updated: "2026-09-21" --- # Collect Shopify Data into Google BigQuery Own your Shopify data in Google BigQuery with OWOX Data Marts. Collect orders, customers, products, and transaction data directly into BigQuery, control schema and refresh logic, and reuse the data across BI tools and AI Insights. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## Shopify Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/shopify/readme/) 25 Shopify endpoints you can import. Each lands in its own table in your warehouse. * [Abandoned Checkouts Checkout sessions that did not complete — customer info, items, and pricing for recovery campaigns. 20 fields · Time series](/data-sources/shopify#schema-abandoned-checkouts) * [Article Metafields Custom metadata attached to articles — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-article-metafields) * [Articles Blog articles — title, author, publication status, and timestamps. 15 fields](/data-sources/shopify#schema-articles) * [Blog Metafields Custom metadata attached to blogs — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-blog-metafields) * [Blogs Blogs in the store — title, handle, and template settings. 6 fields](/data-sources/shopify#schema-blogs) * [Collection Metafields Custom metadata attached to collections — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-collection-metafields) * [Collections Product collections — title, sort order, product count, and last updated. 10 fields](/data-sources/shopify#schema-collections) * [Customer Metafields Custom metadata attached to customers — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-customer-metafields) * [Customers Customer accounts — contact info, marketing consent, order history, and lifetime spend. 22 fields · Time series](/data-sources/shopify#schema-customers) * [Discount Codes Discount codes — type, status, usage limits, and validity window. 12 fields](/data-sources/shopify#schema-discount-codes) * [Fulfillment Orders Fulfillment orders — items to ship, assigned location, delivery method, and status. 11 fields](/data-sources/shopify#schema-fulfillment-orders) * [Inventory Items Inventory items (SKUs) — tracking status, shipping requirements, and country of origin. 9 fields](/data-sources/shopify#schema-inventory-items) * [Location Metafields Custom metadata attached to locations — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-location-metafields) * [Locations Physical and virtual store locations — activity status, fulfillment capabilities, and address. 19 fields](/data-sources/shopify#schema-locations) * [Order Metafields Custom metadata attached to orders — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-order-metafields) * [Orders Orders placed in the store — financial and fulfillment status, customer info, totals, and timestamps. 47 fields · Time series](/data-sources/shopify#schema-orders) * [Page Metafields Custom metadata attached to pages — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-page-metafields) * [Pages Static store pages — title, handle, publication status, and timestamps. 10 fields](/data-sources/shopify#schema-pages) * [Product Metafields Custom metadata attached to products — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-product-metafields) * [Product Variant Metafields Custom metadata attached to product variants — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-product-variant-metafields) * [Product Variants Product variants — SKU, price, inventory quantity, and availability. 18 fields](/data-sources/shopify#schema-product-variants) * [Products Products in the store catalog — vendor, type, status, inventory, and price range. 21 fields · Time series](/data-sources/shopify#schema-products) * [Shop Store settings — domain, currency, timezone, and plan details. 20 fields](/data-sources/shopify#schema-shop) * [Shop Metafields Custom metadata attached to the shop — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-shop-metafields) * [Tender Transactions Payment tender transactions — amount, currency, order reference, and processing time. 7 fields](/data-sources/shopify#schema-tender-transactions) ## S01 · Step 1 ## Step 1: Create a Google BigQuery Data Storage Start by connecting your Google BigQuery project as a [data storage](/data-storages). * Use your Google Cloud project and BigQuery dataset * Authorize with a Google account or service account * Keep full ownership of Shopify data in your warehouse [Connect BigQuery](https://www.owox.com/app-signup) ![Step 1: Create a Google BigQuery Data Storage](https://cdn.owox.ai/www/portfolio-management-connectors/free-shopify-connector-to-google-bigquery/body/1.png/public) ## S02 · Step 2 ## Step 2: Create Shopify Data Mart(s) Create a new Data Mart and choose Connector as the definition type. * Select Shopify as the data source * Authorize access to your Shopify store by adding a Shop Domain and the Admin API Access Token * Define which e-commerce entities you want to collect [Create Data Mart](https://www.owox.com/app-signup) ![Step 2: Create Shopify Data Mart(s)](https://cdn.owox.ai/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/1.png/public) ## S03 · Step 3 ## Step 3: Select Shopify Database & Fields Choose exactly which Shopify data should be collected. * Select entities such as orders, order items, products, customers, and refunds * Define the dataset and table where data will be stored * Publish Shopify Data Mart once configuration is complete [Collect Shopify Data](https://www.owox.com/app-signup) ![Step 3: Select Shopify Database & Fields](https://cdn.owox.ai/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/2.png/public) ## S04 · Step 4 ## Step 4: Run & Schedule Shopify Data Collection Once published, control how and when Shopify data is imported. * Run manually and select Backfill to load historical data * Add a Connector run Trigger so Shopify data is collected on your schedule * All runs are logged and visible in Run History [Run Data Mart](https://www.owox.com/app-signup) ![Step 4: Run & Schedule Shopify Data Collection](https://cdn.owox.ai/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/3.png/public) ## S05 · Step 5 ## Step 5: Get more from your Shopify Analytics Your Shopify data is now available in BigQuery. * Build revenue, orders, and product performance reports * Blend Shopify data with ad platforms, GA4, or CRM data * Enable Shopify Analytics AI Insights delivered on a schedule to Slack, MS Teams or by Email [Send Data to Sheets](https://www.owox.com/app-signup) ![Step 5: Get more from your Shopify Analytics](https://cdn.owox.ai/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/4.png/public) ## Related connectors [Bank of Canada Connector to Google BigQuery](/connectors/bank-of-canada-connector-to-google-bigquery) [Criteo Ads to Google BigQuery Connector](/connectors/free-criteo-ads-connector-to-google-bigquery) [Facebook Ads to Google BigQuery Connector](/connectors/free-facebook-ads-connector-to-google-bigquery) ## What users are saying ## Every claim has a receipt. Real things real customers said — each quote pinned to a specific claim, straight from the quotes database. A3 · re: trusting AI ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_ C9 · re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack® > _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_ E7 · re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ ## Recent updates * [0.34.0 · Temporary BigQuery faults no longer fail the whole import](https://docs.owox.com/docs/changelog/#temporary-bigquery-faults-no-longer-fail-the-whole-import-0340) * [0.33.0 · Calculated Fields in the Output Schema](https://docs.owox.com/docs/changelog/#calculated-fields-in-the-output-schema-0330) * [0.33.0 · Cheaper incremental imports into Google BigQuery](https://docs.owox.com/docs/changelog/#cheaper-incremental-imports-into-google-bigquery-0330) * [0.33.0 · Checkout and cart tokens for Shopify orders](https://docs.owox.com/docs/changelog/#checkout-and-cart-tokens-for-shopify-orders-0330) * [0.32.0 · AI metadata generation for SQL data marts: no dataset-creation permission, and visible failures](https://docs.owox.com/docs/changelog/#ai-metadata-generation-for-sql-data-marts-no-dataset-creation-permission-and-visible-failures-0320) ## Turn Shopify Data into Business Decisions Schedule a quick walkthrough to see how OWOX Data Marts helps you collect Shopify data in Google BigQuery, reduce reporting complexity, and scale analytics with confidence. [Get Started Free](https://www.owox.com/app-signup) ## References 1. Internal OWOX data as of 2026-10-02 2. [G2 reviews of OWOX](https://www.g2.com/products/owox/reviews) 3. [npm installs stat](https://npm-stat.com/charts.html?package=owox&from=2025-01-01&to=2028-01-01) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/shopify/readme) - [Abandoned CheckoutsCheckout sessions that did not complete — customer info, items, and pricing for…](https://www.owox.com/data-sources/shopify) — /data-sources/shopify.md - [data storage](https://www.owox.com/data-storages) — /data-storages.md - [Bank of Canada Connector to Google BigQuery](https://www.owox.com/connectors/bank-of-canada-connector-to-google-bigquery) — /connectors/bank-of-canada-connector-to-google-bigquery.md - [Criteo Ads to Google BigQuery Connector](https://www.owox.com/connectors/free-criteo-ads-connector-to-google-bigquery) — /connectors/free-criteo-ads-connector-to-google-bigquery.md - [Facebook Ads to Google BigQuery Connector](https://www.owox.com/connectors/free-facebook-ads-connector-to-google-bigquery) — /connectors/free-facebook-ads-connector-to-google-bigquery.md - [0.34.0 · Temporary BigQuery faults no longer fail the whole import](https://docs.owox.com/docs/changelog)