Orders, catalog, inventory, and custom fields basic extractors skip, without enterprise connector pricing or waiting on procurement. Free plan, then from $19/mo.
Free plan · No credit card · From $19/mo
Connect, choose data, open the report
Ship deep Shopify store data into BigQuery, including orders, catalog, inventory, and custom fields basic extractors skip. Tables follow your export tabs so SQL models stay predictable.
Reporting ready before standup, without enterprise connector pricing or waiting on procurement. Join store and ads sources in the warehouse you control. SyncRange maintains the pipe so you keep the model.
Send your Shopify data directly to Google BigQuery for enterprise-grade data warehousing. Build a central analytics repository, run SQL across massive datasets, and power large-scale reporting without managing pipelines or writing ETL code.
What we can export, and how it lands
Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination(worksheets in Google Sheets or Excel, or BigQuery columns) when you choose BigQuery.
Export product and variant information
| Columns |
|---|
| Product ID |
| Product Title |
| Variant ID |
| Variant Title |
| SKU |
| Barcode |
| Product Type |
| Vendor |
| Product Tags |
| Description |
| Price |
| Compare at Price |
| Weight |
| Weight Unit |
| Inventory Quantity |
| Inventory Policy |
| Requires Shipping |
| Taxable |
| Status |
| Published |
| Published Date |
| Created Date |
| Updated Date |
| Handle |
| Image URL |
| Collections |
| Options |
| Date Exported |
Export order and sales information
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Customer ID |
| Customer Name |
| Customer Email |
| Customer Phone |
| Customer Address Line 1 |
| Customer Address Line 2 |
| Customer City |
| Customer Province/State |
| Customer Country |
| Customer Country Code |
| Customer Zip/Postal Code |
| Shipping Address Line 1 |
| Shipping Address Line 2 |
| Shipping City |
| Shipping Province/State |
| Shipping Country |
| Shipping Country Code |
| Shipping Zip/Postal Code |
| Fulfillment Status |
| Financial Status |
| Currency |
| Subtotal |
| Shipping |
| Taxes |
| Discounts |
| Gross Price |
| Total Price |
| Refunded Amount |
| Quantity Sold |
| Discount Codes Applied |
| Discount Code IDs |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Discount Code IDs (JSON) |
| Order Level Discount Codes |
| Order Level Discount Codes (JSON) |
| Order Level Discount Amounts (JSON) |
| Order Level Discount Total |
| Order Source |
| Referring Site |
| Landing Site |
| Order Tags |
| Product Tags |
| Order Note |
| Order Note Attributes |
| Fulfillment ID |
| Date Exported |
Export detailed line item information from orders
| Columns |
|---|
| Line Item ID |
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Line Item Name |
| Line Item Type |
| Quantity |
| Unit Price |
| Discounted Unit Price |
| Currency |
| Gross Price |
| Total Price |
| Discounted Price |
| Refunded Amount |
| Discount Amount |
| Discount Amount Breakdown |
| Order Discount Amount |
| Discount Codes Applied |
| Discount Code IDs |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Discount Code IDs (JSON) |
| Tax Amount |
| Tax Rate |
| Tax Name |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Product Tags |
| Event Date |
| Event Time |
| Bundle Title |
| Order Fulfillment Status |
| Financial Status |
| Line Item Fulfillment Status |
| Fulfilled Quantity |
| Unfulfilled Quantity |
| Is Gift Card |
| Refundable Quantity |
| Fulfillment Date |
| Fulfillment Date Time |
| Fulfillment ID |
| Refund Status |
| Date Exported |
One row per line item with order details repeated (combined Orders and Line Items)
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Customer ID |
| Customer Name |
| Customer Email |
| Customer Phone |
| Customer Address Line 1 |
| Customer Address Line 2 |
| Customer City |
| Customer Province/State |
| Customer Country |
| Customer Country Code |
| Customer Zip/Postal Code |
| Shipping Address Line 1 |
| Shipping Address Line 2 |
| Shipping City |
| Shipping Province/State |
| Shipping Country |
| Shipping Country Code |
| Shipping Zip/Postal Code |
| Order Fulfillment Status |
| Financial Status |
| Currency |
| Order Subtotal |
| Order Shipping |
| Order Taxes |
| Order Discounts |
| Order Gross Price |
| Order Total Price |
| Order Refunded Amount |
| Order Quantity Sold |
| Order Discount Codes Applied |
| Order Discount Code IDs |
| Order Manual Discount Codes |
| Order Automatic Discount Titles |
| Order Discount Codes Applied (JSON) |
| Order Discount Code IDs (JSON) |
| Order Level Discount Codes |
| Order Level Discount Codes (JSON) |
| Order Level Discount Amounts (JSON) |
| Order Level Discount Total |
| Order Tags |
| Order Note |
| Order Note Attributes |
| Order Source |
| Referring Site |
| Landing Site |
| Line Item ID |
| Line Item Name |
| Line Item Type |
| Quantity |
| Unit Price |
| Discounted Unit Price |
| Gross Price |
| Line Total Price |
| Discounted Price |
| Line Refunded Amount |
| Line Discount Amount |
| Line Discount Amount Breakdown |
| Line Order Discount Amount |
| Line Discount Codes Applied |
| Line Discount Code IDs |
| Line Manual Discount Codes |
| Line Automatic Discount Titles |
| Line Discount Codes Applied (JSON) |
| Line Discount Code IDs (JSON) |
| Tax Amount |
| Tax Rate |
| Tax Name |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Product Tags |
| Event Date |
| Event Time |
| Bundle Title |
| Line Item Fulfillment Status |
| Fulfilled Quantity |
| Unfulfilled Quantity |
| Is Gift Card |
| Refundable Quantity |
| Fulfillment Date |
| Fulfillment Date Time |
| Fulfillment ID |
| Refund Status |
| Date Exported |
Export store information
| Columns |
|---|
| Store ID |
| Store Name |
| Store Email |
| Store Domain |
| Primary Domain |
| Plan Name |
| Shopify Plus |
| Currency |
| Country |
| City |
| Zip/Postal Code |
| Contact Email |
| Customer Accounts |
| Taxes Included |
| Tax Shipping |
| Has Gift Cards |
| Has International Domains |
| Date Exported |
Export inventory cost and value information
| Columns |
|---|
| Inventory Item ID |
| Variant ID |
| Product ID |
| Product Title |
| Variant Title |
| SKU |
| Quantity |
| Cost per Item |
| Currency |
| Total Value |
| Tracked |
| Country of Origin |
| Province of Origin |
| HS Code |
| Product Type |
| Vendor |
| Date Exported |
Export inventory data with location information
| Columns |
|---|
| Inventory Item ID |
| SKU |
| Tracked |
| Variant ID |
| Variant Title |
| Variant Price |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Location ID |
| Location Name |
| Quantity |
| Date Exported |
Export customer information
| Columns |
|---|
| Customer ID |
| First Name |
| Last Name |
| Phone |
| Notes |
| Customer Tags |
| Account Created Datetime |
| Account Created Date |
| Account Age in Days |
| Last Order Created Datetime |
| Last Order Created Date |
| Address Line 1 |
| Address Line 2 |
| City |
| Province/State |
| Country |
| Country Code |
| Zip/Postal Code |
| Customer Segment IDs |
| Customer Segment Names |
| Customer Segment IDs (JSON) |
| Customer Segment Names (JSON) |
| Date Exported |
Export detailed sales metrics and financial data
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Customer Name |
| Gross Sales |
| Discounts |
| Returns |
| Net Sales |
| Shipping |
| Tax |
| Duties |
| Total Sales |
| Currency |
| Payment Method |
| Payment Gateway |
| Payment Wallet |
| Payment ID |
| Fulfillment Status |
| Financial Status |
| Date Exported |
Export store locations and fulfillment centers
| Columns |
|---|
| Location ID |
| Location Name |
| Address Line 1 |
| Address Line 2 |
| City |
| Province/State |
| Zip/Postal Code |
| Country |
| Country Code |
| Phone |
| Is Active |
| Fulfills Online Orders |
| Has Active Inventory |
| Ships Inventory |
| Date Exported |
Export collection information with optional metafield columns
| Columns |
|---|
| Collection ID |
| Title |
| Handle |
| Description |
| Sort Order |
| Products Count |
| Updated At |
| Date Exported |
Export one row per customer per segment membership. Covers every segment in the store.
| Columns |
|---|
| Segment ID |
| Segment Name |
| Customer ID |
| Customer Display Name |
| First Name |
| Last Name |
| Number of Orders |
| Amount Spent |
| Amount Spent Currency |
| Date Exported |
Export discount definitions. One row per discount code; automatic discounts produce one row.
| Columns |
|---|
| Discount ID |
| Discount Type |
| Discount Title |
| Discount Summary |
| Status |
| Discount Code |
| Total Used Count |
| Code Used Count |
| Limit Total Times |
| Limit One Use Per Customer |
| Starts At |
| Ends At |
| Created At |
| Updated At |
| Discount Value Type |
| Discount Value |
| Value Currency |
| Minimum Purchase Type |
| Minimum Value |
| Eligibility Type |
| Eligibility Values |
| Eligibility Customer Segment IDs |
| Eligibility Customer Segment Names |
| Eligibility Customer Segment IDs (JSON) |
| Eligibility Customer Segment Names (JSON) |
| Combines With Order Discounts |
| Combines With Product Discounts |
| Combines With Shipping Discounts |
| Discount URL |
| Date Exported |
Per-product or per-variant revenue over the selected date range: gross sales, discounts, returns, net sales, tax, units, and order counts (from line items and refunds, streamed for large stores). Optional breakdown by variant for SKU- or size-level metrics.
| Columns |
|---|
| Product ID |
| Variant ID |
| Variant Title |
| SKU |
| Product Title |
| Product Type |
| Vendor |
| Currency |
| Gross Sales |
| Discounts |
| Returns |
| Net Sales |
| Tax |
| Total Sales |
| Units Sold |
| Orders |
| Date Exported |
Per-product refund stats over the selected date range: refunded units, refund amount, refund counts, refund rates vs sales, average refund value, and average days from order to refund (streamed for large stores).
| Columns |
|---|
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Currency |
| Units Sold |
| Gross Sales |
| Orders With Product |
| Refunded Units |
| Refund Amount |
| Refund Line Items |
| Orders Refunded |
| Net Units |
| Net Sales |
| Refund Rate (Units) |
| Refund Rate ($) |
| Avg Refund Value |
| Avg Refund Quantity |
| Avg Days to Refund |
| Date Exported |
Export issued gift cards with balance, customer, order, and recipient details. Requires the read_gift_cards OAuth scope (reconnect store if needed).
| Columns |
|---|
| Gift Card ID |
| Created At |
| Updated At |
| Deactivated At |
| Enabled |
| Expires On |
| Last Characters |
| Masked Code |
| Initial Value |
| Balance |
| Currency |
| Note |
| Customer ID |
| Customer Email |
| Customer First Name |
| Customer Last Name |
| Order ID |
| Order Number |
| Recipient Preferred Name |
| Recipient Message |
| Recipient Notification At |
| Template Suffix |
| Date Exported |
Export Content → Metaobjects entries with one row per entry. Optionally split into one sheet/table per definition (typed field columns), or keep a single tab with Fields JSON. Requires read_metaobjects and read_metaobject_definitions (reconnect store if needed).
| Columns |
|---|
| Metaobject ID |
| Type |
| Type Name |
| Handle |
| Display Name |
| Status |
| Updated At |
| Fields JSON |
| Date Exported |
Export Shopify Payments bank transfer summaries with rolled-up charge, refund, and adjustment fees. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes.
| Columns |
|---|
| Payout ID |
| Payout Date |
| Status |
| Type |
| Net Amount |
| Currency |
| Charges Gross |
| Charges Fee |
| Refunds Gross |
| Refunds Fee |
| Adjustments Gross |
| Adjustments Fee |
| Date Exported |
Export every Shopify Payments charge, refund, and adjustment with gross, fee, net, order link, and payout link. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes.
| Columns |
|---|
| Balance Transaction ID |
| Transaction Date |
| Type |
| Source Type |
| Test |
| Order ID |
| Order Number |
| Payout ID |
| Payout Status |
| Gross Amount |
| Fee Amount |
| Net Amount |
| Currency |
| Source ID |
| Source Order Transaction ID |
| Adjustment Reason |
| Date Exported |
One row per refund line item over the selected date range with return reason, restock type, and customer note (streamed for large stores).
| Columns |
|---|
| Refund Line ID |
| Order ID |
| Order Name |
| Order Date |
| Order Date Time |
| Refund Date |
| Line Item Name |
| Refunded Quantity |
| Refund Price (per unit) |
| Refund Amount |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Return Reason |
| Return Reason Note |
| Customer Note |
| Restock Type |
| Restocked |
| Discount Codes Applied |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Is Gift Card |
| Date Exported |
Daily online store sessions, visitors, funnel, and conversion metrics
| Columns |
|---|
| Date |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by referrer channel and UTM
| Columns |
|---|
| Date |
| Referrer Source |
| Referring Channel |
| Referring Medium |
| UTM Source |
| UTM Medium |
| UTM Campaign |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by landing page path and type
| Columns |
|---|
| Date |
| Landing Page Path |
| Landing Page Type |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by device type, browser, and OS
| Columns |
|---|
| Date |
| Device Type |
| Browser |
| Operating System |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by visitor country and region
| Columns |
|---|
| Date |
| Country |
| Country Code |
| Region |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily campaign-attributed sales and orders across Shopify attribution models
| Columns |
|---|
| Date |
| Campaign ID |
| Last Click Orders |
| Last Click Sales |
| Last Click AOV |
| Last Non-Direct Click Orders |
| Last Non-Direct Click Sales |
| First Click Orders |
| First Click Sales |
| Linear Orders |
| Linear Sales |
| Date Exported |
Daily session and funnel metrics for marketing campaign traffic
| Columns |
|---|
| Date |
| Campaign ID |
| Sessions |
| Visitors |
| Pageviews |
| Bounce Rate |
| Sessions With Cart Additions |
| Sessions Reached Checkout |
| Sessions Completed Checkout |
| Conversion Rate |
| Date Exported |
Channel-reported marketing spend, impressions, clicks, and sales
| Columns |
|---|
| Marketing Activity ID |
| Marketing Activity Title |
| Channel |
| Platform |
| Ad Spend |
| Impressions |
| Clicks |
| Unique Clicks |
| Sends |
| Orders (Channel-Reported) |
| Sales (Channel-Reported) |
| First-Time Customers |
| Returning Customers |
| Unsubscribes |
| Date Exported |
Daily on-site search query volume and intent
| Columns |
|---|
| Date |
| Search Query |
| Search Intent |
| Results Returned |
| Searches |
| Date Exported |
Daily on-site search funnel from search to purchase
| Columns |
|---|
| Date |
| Sessions With Searches |
| Search Sessions With Clicks |
| Search Click Rate |
| Search Sessions With Cart Additions |
| Search Added To Cart Rate |
| Search Sessions Completed Checkout |
| Search Conversion Rate |
| Date Exported |
Daily Core Web Vitals and page load metrics by page type and device
| Columns |
|---|
| Date |
| Page Type |
| Device Type |
| Page Loads |
| LCP p75 (ms) |
| LCP Good Views |
| LCP Poor Views |
| CLS Good Views |
| CLS Poor Views |
| INP p75 (ms) |
| INP Poor Views |
| TTFB p75 (ms) |
| FCP p75 (ms) |
| Date Exported |
Daily Shop Campaign sales, ad spend, ROAS, and acquisition cost
| Columns |
|---|
| Date |
| Shop Campaign Name |
| Target Segment |
| Sales |
| Ad Spend |
| ROAS |
| Avg CAC |
| Customers |
| AOV |
| Date Exported |
See how teams export clean ecommerce and marketing data to BigQuery, Google Sheets, or Excel without manual work.
Shopify Store and Food delivery
Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.
Multi-brand Shopify Plus Operator
We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.
Large marketplace
We struggled to find a Shopify extraction tool that went beyond basic product, order, and customer data until we found SyncRange. It effortlessly pulls everything we require, including metaobjects and custom fields. SyncRange's hands-on guidance has given us complete confidence.
Large Shopify Store
SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.
Connect your account, then follow the configuration guide for your first export.
Other data sources you can sync to BigQuery
Install on Shopify