Shopify Data Reference

Products

One row per product variant. Useful for catalog snapshots, pricing, inventory, and metafield reporting. Full export each run: always current catalog data; the date range does not apply.

Column	Description
Product ID	Shopify's numeric ID for the product (the parent of all variants).
Product Title	Display title of the product.
Variant ID	Numeric ID of the specific variant for this row.
Variant Title	Variant name (e.g. "Small / Red"). "Default Title" when there is only one variant.
SKU	Stock Keeping Unit for the variant.
Barcode	Barcode (UPC/EAN/ISBN) for the variant.
Product Type	Free-form product category set in Shopify admin.
Vendor	Brand or supplier name.
Product Tags	Comma-separated list of tags applied to the product.
Description	Product description (HTML stripped to plain text).
Price	Current selling price for the variant in the store currency.
Compare at Price	Original / strike-through price used for showing discounts.
Weight	Variant weight in the unit specified by Weight Unit.
Weight Unit	Unit for the weight value (e.g. `kg`, `lb`).
Inventory Quantity	Total quantity available across all locations for this variant.
Inventory Policy	Shopify's setting for whether to allow purchase when out of stock.
Requires Shipping	Whether the variant is shipped (vs digital).
Taxable	Whether tax is collected on this variant.
Status	Product status: `ACTIVE`, `ARCHIVED`, or `DRAFT`.
Published	Whether the product is visible on the storefront.
Published Date	Timestamp the product was first published.
Created Date	Timestamp the product was created.
Updated Date	Timestamp the product was last modified.
Handle	URL-safe identifier (the slug used in storefront URLs).
Image URL	URL of the variant's primary image (or product image if the variant has none).
Collections	Comma-separated list of collections containing this product.
Options	Variant option values rolled up as a string (e.g. `Color: Red, Size: M`).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

You can also add up to 8 product metafield columns (e.g. custom.brand) — see Product metafield columns.

Orders

One row per order. Date range: filtered by the order's created_at. Total Price, Subtotal and Refunded Amount reflect the order's current state (post-refund). Customer Address columns come from the customer's current default account address; Shipping Address columns are the ship-to snapshot stored on the order at checkout (use these when you need where each order actually shipped).

Column	Description
Order ID	Shopify's numeric order ID.
Order Number	Customer-facing order number (e.g. `1042`; the leading `#` is stripped).
Order Date	Date the order was created (`YYYY-MM-DD`). New: date-only column.
Order Date Time	Full timestamp the order was created (`YYYY-MM-DD HH:MM:SS`). Add this if you need time-of-day precision.
Customer ID	Numeric Shopify customer ID (blank for guest orders).
Customer Name	Customer first + last name.
Customer Email	Customer email address.
Customer Phone	Customer phone number.
Customer Address Line 1	Customer's current default account address, line 1 (can change over time and may not match where a past order shipped).
Customer Address Line 2	Customer's current default account address, line 2.
Customer City	Customer's current default account address, city.
Customer Province/State	Customer's current default account address, province or state.
Customer Country	Customer's current default account address, country name.
Customer Country Code	ISO country code for the customer's current default account address.
Customer Zip/Postal Code	Customer's current default account address, postal code.
Shipping Address Line 1	Ship-to address line 1 as stored on the order at checkout.
Shipping Address Line 2	Ship-to address line 2 as stored on the order at checkout.
Shipping City	Ship-to city as stored on the order at checkout.
Shipping Province/State	Ship-to province or state as stored on the order at checkout.
Shipping Country	Ship-to country name as stored on the order at checkout.
Shipping Country Code	ISO country code for the ship-to address on the order.
Shipping Zip/Postal Code	Ship-to postal code as stored on the order at checkout. Blank for digital orders or orders with no shipping address.
Fulfillment Status	Shopify display status (e.g. `FULFILLED`, `UNFULFILLED`, `PARTIALLY_FULFILLED`).
Financial Status	Shopify display status (e.g. `PAID`, `REFUNDED`, `PARTIALLY_REFUNDED`).
Currency	Order currency code (ISO 4217, e.g. `USD`).
Subtotal	Current subtotal (line items only, after refunds; matches Shopify's "Total sales" view, excludes shipping).
Shipping	Shipping charged to the customer at order time.
Taxes	Total tax charged on the order.
Discounts	Total discount amount applied to the order.
Total Price	Current order total (after refunds; matches Shopify's "Total sales" view).
Refunded Amount	Cumulative amount refunded against this order.
Quantity Sold	Total units sold across all line items in the order.
Discount Codes Applied	Comma-separated list of discount codes/titles applied to the order.
Discount Code IDs	Comma-separated catalog discount IDs (when resolvable for code-based discounts).
Manual Discount Codes	Customer-typed discount codes plus admin-applied manual discount titles.
Automatic Discount Titles	Titles of automatic discounts applied to the order.
Discount Codes Applied (JSON)	JSON array of the same values as Discount Codes Applied (for BigQuery/Apps Script parsing).
Discount Code IDs (JSON)	JSON array of the resolvable catalog discount IDs.
Order Source	Where the order came from (e.g. `web`, `pos`, `shopify_draft_order`).
Order Tags	Comma-separated list of tags applied to the order.
Product Tags	Comma-separated unique tags from products on the order (from line items).
Order Note	Free-form note attached to the order.
Order Note Attributes	JSON array of additional details (key/value pairs) on the order; preserves duplicate keys.
Fulfillment ID	Optional. Comma-separated Shopify fulfilment names for the order (e.g. `#1001.1`). Only fetched when this column is selected.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Up to 3 order metafield columns are also available — see Order metafield columns.

Line Items

One row per line item, shipping line, or refund line on an order. Date range: products and shipping are filtered by the order's created_at; refund rows are filtered by the refund's processed date so refunds on older orders are still picked up. See Reconciling Orders and Line Items for the full filter behaviour.

Column	Description
Line Item ID	Shopify's ID for the line item. For refunds this is `{refund_id}_{refund_line_item_id}` so it's unique per row.
Order ID	Numeric ID of the parent order. Use this to join back to the Orders tab.
Order Number	Customer-facing order number from the parent order.
Order Date	Date the parent order was created (`YYYY-MM-DD`). Same value across all line items of the same order.
Order Date Time	Full timestamp the parent order was created (`YYYY-MM-DD HH:MM:SS`). Add for time-of-day analysis.
Line Item Name	Product/variant name on the line, the shipping method title, or the refund line's product name.
Line Item Type	`Product`, `Shipping`, or `Refund`.
Quantity	Quantity sold (or refunded for refund rows).
Unit Price	Per-unit price after line-level discounts (i.e. Total Price / Quantity).
Currency	Currency of the line.
Total Price	Net price for the line after discounts. Negative for refund rows.
Refunded Amount	Amount refunded for this specific line. Populated on refund rows (positive number, equal to `-Total Price`); `0` for product and shipping rows. Sum across an order to get the total refunded for that order.
Discount Amount	Amount of discount allocated to this specific line.
Discount Codes Applied	Comma-separated codes/titles of discounts allocated to this line.
Discount Code IDs	Comma-separated resolvable catalog discount IDs for this line.
Manual Discount Codes	Customer-typed codes plus admin-applied manual discount titles allocated to this line.
Automatic Discount Titles	Titles of automatic discounts allocated to this line.
Discount Codes Applied (JSON)	JSON array form of Discount Codes Applied (good for BigQuery/Apps Script).
Discount Code IDs (JSON)	JSON array form of Discount Code IDs.
Discounted Price	Equivalent to Total Price for product/shipping rows; provided for backwards compatibility.
Tax Amount	Tax allocated to this line.
Tax Rate	Tax rate applied (decimal, e.g. `0.05`).
Tax Name	Tax label (e.g. `GST`, `VAT`).
SKU	SKU of the variant (also populated on refund rows).
Variant ID	Numeric variant ID (also populated on refund rows).
Variant Title	Variant title (e.g. `Small / Red`).
Product ID	Numeric product ID (also populated on refund rows so per-product revenue queries work).
Product Title	Product title.
Product Type	Product type/category.
Vendor	Vendor / brand for the product.
Product Tags	Comma-separated tags from the product (empty for shipping rows).
Order Fulfillment Status	Parent order fulfillment status.
Financial Status	Parent order financial status (e.g. `PAID`, `REFUNDED`, `PARTIALLY_REFUNDED`).
Line Item Fulfillment Status	Per-line fulfillment status derived from fulfilled vs unfulfilled quantity.
Fulfilled Quantity	Units fulfilled on this line.
Unfulfilled Quantity	Units not yet fulfilled on this line.
Is Gift Card	Whether the underlying product is a gift card.
Refundable Quantity	Quantity still eligible for refund on this line.
Fulfillment Date	Optional. Date the line became fully fulfilled (blank if partial/unfulfilled or for refund rows). Only fetched when this column is selected.
Fulfillment ID	Optional. Comma-separated fulfilment names for this line (e.g. `#1001.1`, `#1001.2`). Only fetched when selected.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Refund rows currently appear at the end of the Line Items export rather than interleaved with their order's product/shipping rows. Group by Order ID to see all rows for an order together.

Orders + Line Items

One row per line item, shipping line, or refund line, with selected order fields repeated on each row. Use this when you want a single denormalized sheet (order customer, shipping, and status next to each product line) without joining Orders and Line Items yourself. Date range: grain and date filtering match the Line Items tab. Shared identity fields (Order ID, Order Number, Order Date, Currency) are merged into one column; order-level money and line-level money stay separate so you do not double-count when summing. Order totals are available but off by default. Filters (fulfillment, payment status, tags, and so on) use one filter set for the whole tab. See Reconciling Orders and Line Items for refund date behaviour.

Column	Description
Order ID	Shopify's numeric order ID. Same value on every line for that order.
Order Number	Customer-facing order number (leading `#` stripped). Same across lines of the same order.
Order Date	Date the parent order was created (`YYYY-MM-DD`).
Order Date Time	Full timestamp the parent order was created (`YYYY-MM-DD HH:MM:SS`).
Customer ID	Numeric Shopify customer ID (blank for guest orders). Repeated from the parent order.
Customer Name	Customer first + last name from the parent order.
Customer Email	Customer email from the parent order.
Customer Phone	Customer phone from the parent order.
Customer Address Line 1	Customer's current default account address, line 1 (can change over time).
Customer Address Line 2	Customer's current default account address, line 2.
Customer City	Customer's current default account address, city.
Customer Province/State	Customer's current default account address, province or state.
Customer Country	Customer's current default account address, country name.
Customer Country Code	ISO country code for the customer's current default account address.
Customer Zip/Postal Code	Customer's current default account address, postal code.
Shipping Address Line 1	Ship-to address line 1 as stored on the order at checkout. Repeated on every line of the order.
Shipping Address Line 2	Ship-to address line 2 as stored on the order at checkout.
Shipping City	Ship-to city as stored on the order at checkout.
Shipping Province/State	Ship-to province or state as stored on the order at checkout.
Shipping Country	Ship-to country name as stored on the order at checkout.
Shipping Country Code	ISO country code for the ship-to address on the order.
Shipping Zip/Postal Code	Ship-to postal code as stored on the order at checkout.
Order Fulfillment Status	Order-level Shopify display fulfillment status (e.g. `FULFILLED`, `UNFULFILLED`).
Financial Status	Order-level payment status (e.g. `PAID`, `REFUNDED`).
Currency	Currency code for the line (falls back to the order currency when the line has none, e.g. some refund rows).
Order Subtotal	Current order subtotal after refunds (excludes shipping). Repeated on every line; do not sum across lines.
Order Shipping	Shipping charged on the order. Repeated on every line; do not sum across lines.
Order Taxes	Total tax on the order. Repeated on every line; do not sum across lines.
Order Discounts	Total discount amount on the order. Repeated on every line; do not sum across lines.
Order Total Price	Current order total after refunds. Repeated on every line; do not sum across lines.
Order Refunded Amount	Cumulative amount refunded against the order. Repeated on every line; do not sum across lines.
Order Quantity Sold	Total product units on the order. Repeated on every line; do not sum across lines.
Order Discount Codes Applied	Comma-separated discount codes/titles applied at the order level.
Order Discount Code IDs	Comma-separated catalog discount IDs for order-level discounts (when resolvable).
Order Manual Discount Codes	Customer-typed codes plus admin-applied manual discount titles on the order.
Order Automatic Discount Titles	Titles of automatic discounts applied to the order.
Order Discount Codes Applied (JSON)	JSON array of order-level discount codes/titles.
Order Discount Code IDs (JSON)	JSON array of resolvable order-level catalog discount IDs.
Order Tags	Comma-separated tags on the parent order.
Order Note	Free-form note on the parent order.
Order Note Attributes	JSON array of order custom attributes (key/value pairs).
Order Source	Where the order came from (e.g. `web`, `pos`).
Referring Site	Referrer URL from the customer journey on the order (when available).
Landing Site	Landing page from the customer journey on the order (when available).
Line Item ID	Shopify's ID for the line item. For refunds this is `{refund_id}_{refund_line_item_id}`.
Line Item Name	Product/variant name, shipping method title, or refund line product name.
Line Item Type	`Product`, `Shipping`, or `Refund`.
Quantity	Quantity sold (or refunded for refund rows).
Unit Price	Per-unit price after line-level discounts (Line Total Price / Quantity).
Line Total Price	Net price for this line after discounts. Negative for refund rows. Safe to sum across rows.
Line Refunded Amount	Amount refunded for this line. Populated on refund rows; `0` for product and shipping.
Line Discount Amount	Discount allocated to this specific line.
Line Discount Codes Applied	Comma-separated codes/titles of discounts allocated to this line.
Line Discount Code IDs	Comma-separated resolvable catalog discount IDs for this line.
Line Manual Discount Codes	Customer-typed codes plus admin-applied manual titles allocated to this line.
Line Automatic Discount Titles	Titles of automatic discounts allocated to this line.
Line Discount Codes Applied (JSON)	JSON array form of Line Discount Codes Applied.
Line Discount Code IDs (JSON)	JSON array form of Line Discount Code IDs.
Discounted Price	Equivalent to Line Total Price for product/shipping rows; kept for compatibility with Line Items.
Tax Amount	Tax allocated to this line.
Tax Rate	Tax rate applied (decimal, e.g. `0.05`).
Tax Name	Tax label (e.g. `GST`, `VAT`).
SKU	SKU of the variant (also populated on refund rows).
Variant ID	Numeric variant ID.
Variant Title	Variant title (e.g. `Small / Red`).
Product ID	Numeric product ID.
Product Title	Product title.
Product Type	Product type/category.
Vendor	Vendor / brand for the product.
Product Tags	Comma-separated tags from the product on this line (empty for shipping rows).
Line Item Fulfillment Status	Per-line fulfillment status (e.g. `FULFILLED`, `UNFULFILLED`, `PARTIALLY_FULFILLED`, or `Refunded`).
Fulfilled Quantity	Units fulfilled on this line.
Unfulfilled Quantity	Units still unfulfilled on this line.
Is Gift Card	Whether the underlying product is a gift card.
Refundable Quantity	Quantity still eligible for refund on this line.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

When summing money, use Line Total Price (and other Line* money columns). Order Total Price and related Order* money columns repeat on every line of a multi-item order.

Product Analysis

Date range: one row per product and currency for the selected export date range by default, or one row per variant (and currency) when One row per variant (SKU / size) is enabled on the Product Analysis tab. Metrics are rolled up from Product and Refund line items only (same pipeline as the Line Items tab: bulk line items plus refund rows). Shipping lines and rows without a product ID are excluded. With Since last export, the same incremental rules apply as for Line Items (order date for product lines; refund processed date for refunds). Rows are sorted by Product ID, then variant ID when that mode is on, then currency.

Column	Description
Product ID	Numeric Shopify product ID.
Variant ID	Numeric Shopify variant ID. Populated when One row per variant is enabled; otherwise blank.
Variant Title	Variant option label (e.g. size). Populated for per-variant rollups; otherwise blank.
SKU	Variant SKU when per-variant rollups are enabled; otherwise blank.
Product Title	Product display title (from the first line seen for that bucket in the window).
Product Type	Product type / category.
Vendor	Vendor / brand.
Currency	Line-item shop currency for this bucket (multi-currency stores can produce multiple rows per product or variant).
Gross Sales	Product price × quantity from sales in the window, before discounts and before refunds. Matches Shopify's Sales by product Gross sales.
Discounts	Sum of line-level discount amounts on sales (positive number; reduces Net Sales).
Returns	Sum of refunded amounts in the window (positive number; reduces Net Sales).
Net Sales	`Gross Sales − Discounts − Returns`. Matches Shopify's Sales by product Net sales.
Tax	Sum of line tax on sales (refund rows carry no tax in this pipeline).
Total Sales	`Net Sales + Tax`.
Units Sold	Net items sold: quantities sold minus quantities refunded.
Orders	Count of distinct Order ID values that include this product or variant (sales or refunds) in the window.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Append is off by default for this tab. See Configuring Shopify exports for date-range and refund behaviour.

Refund Analysis

Date range: one row per product and currency for the selected export date range, only for products with at least one refund in the window — products with sales but no refunds are not included. Combines Product lines (units and gross sales) with Refund lines (refunded units, refund amount, refund line count, distinct orders with a refund). Shipping lines and rows without a product ID are excluded. With Since last export, the same incremental rules apply as for Line Items (order date for product lines; refund processed date for refunds). Rows are sorted by Refund Amount descending so the highest-refund products appear first.

Column	Description
Product ID	Numeric Shopify product ID.
Product Title	Product display title (from the first line seen for that product in the window).
Product Type	Product type / category.
Vendor	Vendor / brand.
Currency	Line-item shop currency for this bucket when known from product rows (multi-currency stores can produce multiple rows per product).
Units Sold	Quantity sold (gross), from Product lines only. Refunds are tracked separately as Refunded Units.
Gross Sales	Product price × quantity from sales in the window, before discounts and before refunds. Same Gross Sales basis as Product Analysis (Shopify Sales by product).
Orders With Product	Count of distinct Order ID values that have at least one product line for this product in the window.
Refunded Units	Sum of absolute quantities on Refund rows.
Refund Amount	Sum of Refunded Amount on refund rows (positive subtotal refunded).
Refund Line Items	Number of refund line-item rows in the window (not the same as refunded units when partial lines refund multiple times).
Orders Refunded	Count of distinct Order ID values that have at least one refund line for this product in the window.
Net Units	`Units Sold − Refunded Units`.
Net Sales	`Gross Sales − Discounts − Refund Amount`. Matches Shopify's Sales by product Net sales (line discounts on the original sales are subtracted internally even though Discounts is not a column on this tab).
Refund Rate (Units)	`Refunded Units ÷ Units Sold` when units sold > 0; otherwise 0.
Refund Rate ($)	`Refund Amount ÷ Gross Sales` when gross sales > 0; otherwise 0.
Avg Refund Value	`Refund Amount ÷ Refund Line Items` when there is at least one refund line; otherwise 0.
Avg Refund Quantity	`Refunded Units ÷ Refund Line Items` when there is at least one refund line; otherwise 0.
Avg Days to Refund	Average calendar days between the order `createdAt` and the refund processed time (Refund Date), over refund lines where both timestamps parse.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Append is off by default for this tab. See Configuring Shopify exports for date-range and refund behaviour.

Refund Line Analysis

Date range: one row per refund line item over the selected export date range, with return reason metadata when the refund came from a Shopify Return. Same refund pipeline as the Line Items tab. With Since last export, refund rows are matched against the refund processed date, so refunds processed in the window are included even when the underlying order was created earlier.

Column	Description
Refund Line ID	Composite ID combining the Shopify refund ID and the refund line item ID.
Order ID	Numeric Shopify order ID.
Order Name	Shopify order name (e.g. `1001`, with the leading `#` stripped).
Order Date	Original order creation date (`YYYY-MM-DD`).
Order Date Time	Original order creation timestamp (`YYYY-MM-DD HH:MM:SS`).
Refund Date	Refund processed date.
Line Item Name	Original line item name from the order.
Refunded Quantity	Units refunded on this refund line.
Refund Price (per unit)	Refund Amount divided by Refunded Quantity (0 when quantity is 0).
Refund Amount	Refund subtotal in shop currency for this line (positive value).
SKU / Variant ID / Variant Title	Original variant identity for the refunded line.
Product ID / Product Title / Product Type / Vendor	Original product identity for the refunded line.
Return Reason	Shopify `ReturnReason` value when a customer-initiated Shopify Return is associated with this refund (e.g. `DEFECTIVE`, `WRONG_ITEM`, `SIZE_TOO_SMALL`, `UNWANTED`, `OTHER`). Blank for merchant-initiated refunds without a Return.
Return Reason Note	Free-text note that accompanies the return reason on the Shopify Return.
Customer Note	Customer-supplied note on the Shopify Return.
Restock Type	Shopify `RestockType` on the refund line: `NO_RESTOCK`, `CANCEL`, `RETURN`, or `LEGACY_RESTOCK`.
Restocked	Yes/No — whether the refund line was restocked.
Discount Codes Applied / Manual Discount Codes / Automatic Discount Titles / Discount Codes Applied (JSON)	Discount code context inherited from the parent order (refunds don't carry their own discount codes).
Is Gift Card	Yes/No — whether the refunded product is a gift card.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Append is off by default for this tab. Refunds without an associated Shopify Return (e.g. merchant-initiated refunds) leave Return Reason / Note / Customer Note blank but still report Restock Type and Restocked.

Customers

One row per customer. Date range: filtered by customer creation date — customers who only placed orders in the window but were created earlier are not included.

Tip: If the export is taking a long time, remove the customer segment columns from the Customers tab to improve efficiency, unless you need that data. More ideas: Export efficiency tips.

Column	Description
Customer ID	Numeric Shopify customer ID.
First Name	Customer first name.
Last Name	Customer last name.
Email	Customer email address.
Notes	Free-form notes recorded against the customer.
Customer Tags	Comma-separated list of tags on the customer (same idea as order tags).
Account Created Datetime	Full timestamp the customer account was created.
Account Created Date	Date-only version of Account Created Datetime.
Account Age in Days	Days between account creation and today.
Last Order Created Datetime	Timestamp of the customer's most recent order.
Last Order Created Date	Date-only version of the above.
Address Line 1	Default shipping/billing address line 1.
Address Line 2	Default address line 2.
City	Default address city.
Province/State	Default address province or state.
Country	Default address country name.
Country Code	ISO country code.
Zip/Postal Code	Default address postal code.
Customer Segment IDs	Comma-separated list of segment IDs the customer belongs to.
Customer Segment Names	Comma-separated list of segment names.
Customer Segment IDs (JSON)	JSON array variant of Customer Segment IDs.
Customer Segment Names (JSON)	JSON array variant of Customer Segment Names.
Date Exported	Timestamp this row was written by SyncRange.

You can also add up to 8 customer metafield columns (e.g. custom.loyalty_tier) — see Customer metafield columns.

Customer Segments

One row per (segment, customer) membership across every segment in the store. Full export each run: always current membership; the date range does not apply. Use Customer ID to join back to the Customers tab; Shopify does not return email on segment member rows.

Column	Description
Segment ID	Numeric ID of the segment.
Segment Name	Display name of the segment.
Customer ID	Numeric customer ID for the membership.
Customer Display Name	Best-available display name for the customer.
First Name	Customer first name.
Last Name	Customer last name.
Number of Orders	Total orders for the customer at the time of export.
Amount Spent	Customer lifetime spend.
Amount Spent Currency	Currency code for Amount Spent.
Date Exported	Timestamp this row was written by SyncRange.

Discounts

One row per discount code. Automatic discounts (no code) emit a single row with blank code fields. Full export each run: always current discount catalog; the date range does not apply.

Column	Description
Discount ID	Numeric ID of the discount in Shopify's catalog.
Discount Type	Type of discount (e.g. `code`, `automatic`).
Discount Title	Title given to the discount in Shopify admin.
Discount Summary	Human-readable summary (e.g. "10% off all products").
Status	Discount status (e.g. `ACTIVE`, `EXPIRED`, `SCHEDULED`).
Discount Code	The code customers enter (blank for automatic discounts).
Total Used Count	Total times this discount has been used (across all codes for the same discount).
Code Used Count	Times this specific code has been used.
Limit Total Times	Maximum total uses configured (blank if unlimited).
Limit One Use Per Customer	Whether use is limited to once per customer.
Starts At	Datetime the discount becomes active.
Ends At	Datetime the discount stops being active (blank if no end).
Created At	Datetime the discount was created.
Updated At	Datetime the discount was last modified.
Discount Value Type	Whether the value is `percentage` or fixed amount.
Discount Value	The discount value (e.g. `10` for 10% or 10 currency units).
Value Currency	Currency code when the value is a fixed amount.
Minimum Purchase Type	Type of minimum-purchase requirement (e.g. quantity vs subtotal).
Minimum Value	Threshold value for the minimum-purchase requirement.
Eligibility Type	Who the discount applies to (e.g. all customers, specific segments).
Eligibility Values	Comma-separated list of eligibility values (segment names, customer IDs, etc).
Eligibility Customer Segment IDs	Comma-separated segment IDs the discount is restricted to.
Eligibility Customer Segment Names	Comma-separated segment names the discount is restricted to.
Eligibility Customer Segment IDs (JSON)	JSON array variant of the segment IDs above.
Eligibility Customer Segment Names (JSON)	JSON array variant of the segment names above.
Combines With Order Discounts	Whether this stacks with other order-level discounts.
Combines With Product Discounts	Whether this stacks with product-level discounts.
Combines With Shipping Discounts	Whether this stacks with shipping discounts.
Discount URL	Shareable Shopify discount URL (when available).
Date Exported	Timestamp this row was written by SyncRange.

Payouts

One row per Shopify Payments bank transfer. Date range: filtered by issued_at; supports Since last export. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes — see Shopify Payments exports.

Column	Description
Payout ID	Numeric Shopify payout ID (bank transfer reference).
Payout Date	Datetime the payout was issued to your bank account.
Status	Payout status (e.g. `PAID`, `SCHEDULED`, `FAILED`).
Type	Transfer direction (e.g. `DEPOSIT` to your bank, `WITHDRAWAL` back to Shopify Payments).
Net Amount	Net amount transferred in this payout.
Currency	Currency code for the payout (ISO 4217).
Charges Gross	Total gross amount from charges included in this payout.
Charges Fee	Total processing fees from charges included in this payout.
Refunds Gross	Total gross amount from refunds included in this payout.
Refunds Fee	Total processing fees from refunds included in this payout.
Adjustments Gross	Total gross amount from adjustments (including disputes) in this payout.
Adjustments Fee	Total fees from adjustments in this payout.
Date Exported	Timestamp this row was written by SyncRange.

Balance Transactions

One row per Shopify Payments ledger entry (charge, refund, adjustment, etc.). Date range: filtered by processed_at; supports Since last export. This is the source of truth for per-transaction processing fees and links to orders and payouts. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts scopes.

Column	Description
Balance Transaction ID	Numeric ID of the balance transaction.
Transaction Date	Datetime the transaction was processed.
Type	Transaction type (e.g. `CHARGE`, `REFUND`, `ADJUSTMENT`).
Source Type	Source category for the transaction (e.g. charge, refund, payout).
Test	Whether this was a test transaction.
Order ID	Numeric order ID when the transaction is linked to an order. Use to join to the Orders tab.
Order Number	Customer-facing order number when linked to an order.
Payout ID	Numeric payout ID when this transaction is included in a bank transfer. Use to join to the Payouts tab.
Payout Status	Status of the associated payout (when present).
Gross Amount	Gross amount for this transaction (before processing fees).
Fee Amount	Shopify Payments processing fee for this transaction — the per-transaction platform charge.
Net Amount	Net amount credited or debited after the processing fee.
Currency	Currency code (ISO 4217).
Source ID	ID of the underlying resource (e.g. order transaction) that created this balance entry.
Source Order Transaction ID	Order transaction ID when applicable.
Adjustment Reason	Reason for adjustment-type transactions (blank for charges and refunds).
Date Exported	Timestamp this row was written by SyncRange.

Join to the Orders tab on Order ID for per-order fee analysis.

Inventory (cost)

One row per inventory item, with cost and value. Full export each run: always current inventory; the date range does not apply.

Column	Description
Inventory Item ID	Numeric ID of the inventory item.
Variant ID	Variant ID this inventory item belongs to.
Product ID	Product ID this inventory item belongs to.
Product Title	Product display title.
Variant Title	Variant display title.
SKU	Stock Keeping Unit.
Quantity	Total quantity tracked for this inventory item across locations.
Cost per Item	Unit cost configured in Shopify.
Currency	Currency code for cost values.
Total Value	Quantity × Cost per Item.
Tracked	Whether inventory is tracked for this item.
Country of Origin	Country where the item was produced.
Province of Origin	Province / state of origin (where applicable).
HS Code	Harmonized System tariff classification code.
Product Type	Product type/category.
Vendor	Vendor / brand.
Date Exported	Timestamp this row was written by SyncRange.

Inventory by Location

Inventory broken down per location — one row per (inventory item, location). Full export each run: always current stock by location; the date range does not apply.

Column	Description
Inventory Item ID	Numeric ID of the inventory item.
SKU	Stock Keeping Unit.
Tracked	Whether inventory is tracked for this item.
Variant ID	Variant ID associated with the inventory item.
Variant Title	Variant display title.
Variant Price	Selling price for the variant.
Product ID	Product ID for the variant.
Product Title	Product display title.
Product Type	Product type/category.
Vendor	Vendor / brand.
Location ID	Numeric ID of the location.
Location Name	Display name of the location.
Quantity	Quantity available at this location.
Date Exported	Timestamp this row was written by SyncRange.

Locations

Store locations and fulfillment centers. Full export each run: always current locations; the date range does not apply.

Column	Description
Location ID	Numeric Shopify location ID.
Location Name	Display name of the location.
Address Line 1	Street address line 1.
Address Line 2	Street address line 2.
City	City.
Province/State	Province or state.
Zip/Postal Code	Postal code.
Country	Country name.
Country Code	ISO country code.
Phone	Phone number.
Is Active	Whether the location is active.
Fulfills Online Orders	Whether the location fulfills online orders.
Has Active Inventory	Whether the location has any inventory tracked.
Ships Inventory	Whether the location ships inventory.
Date Exported	Timestamp this row was written by SyncRange.

Collections

One row per collection. Full export each run: always current collections; the date range does not apply. Optional collection metafields can be added — see Collection metafield columns.

Column	Description
Collection ID	Numeric collection ID.
Title	Collection display title.
Handle	URL-safe collection handle.
Description	Collection description (HTML stripped).
Sort Order	Configured sort order for the collection.
Products Count	Number of products in the collection.
Updated At	Timestamp the collection was last modified.
Date Exported	Timestamp this row was written by SyncRange.

Store

A single row of store-level information. Full export each run: always current store settings; the date range does not apply.

Column	Description
Store ID	Numeric Shopify shop ID.
Store Name	Public store name.
Store Email	Primary store email address.
Store Domain	The `*.myshopify.com` domain.
Primary Domain	The customer-facing primary domain.
Plan Name	Shopify plan (e.g. `basic`, `shopify`, `advanced`, `plus`).
Shopify Plus	Whether the store is on Shopify Plus.
Currency	Default store currency code.
Country	Store address country name.
City	Store address city.
Zip/Postal Code	Store address postal code.
Contact Email	Customer-facing contact email.
Customer Accounts	Customer-account configuration setting (e.g. optional, required).
Taxes Included	Whether prices include tax in admin.
Tax Shipping	Whether shipping is taxed.
Has Gift Cards	Whether the store sells gift cards.
Has International Domains	Whether the store has international/markets domains.
Date Exported	Timestamp this row was written by SyncRange.

Sales Metrics

One row per order with derived sales metrics matching Shopify's reports view. Date range: filtered by order creation date.

Column	Description
Order ID	Numeric order ID.
Order Number	Customer-facing order number.
Order Date	Date the order was created.
Customer Name	Customer first + last name.
Gross Sales	Sum of line item original prices before discounts and refunds.
Discounts	Total discount allocated to the order (negative impact on net sales).
Returns	Total refunded subtotal for line items returned.
Net Sales	Gross Sales − Discounts − Returns.
Shipping	Shipping charged on the order.
Tax	Tax collected on the order.
Duties	Duties collected on the order.
Total Sales	Net Sales + Shipping + Tax + Duties.
Currency	Order currency code.
Payment Method	Buyer-facing method when available (e.g. Visa, PayPal, Apple Pay). Blank when Shopify does not provide payment details.
Payment Gateway	Shopify payment gateway name(s) (e.g. `shopify_payments`, `paypal`). Blank when none.
Fulfillment Status	Order fulfillment status.
Financial Status	Order financial status.
Date Exported	Timestamp this row was written by SyncRange.

Analytics (ShopifyQL)

Aggregated Shopify Analytics reports via ShopifyQL. In the exporter UI these are grouped into six tabs with selectable breakdowns; each breakdown still writes its own destination table. Require the read_reports scope. Date range: all Analytics tabs use the export date range. These tabs do not duplicate Orders, Sales Metrics, Product Analysis, or other entity-level exports.

Analytics Sessions Daily

Daily online store sessions, visitors, funnel, and conversion metrics. Filtered by the export date range.

Column	Description
Date	`day`
Sessions	`sessions`
Visitors	`online_store_visitors`
Pageviews	`pageviews`
Pageviews Per Session	`pageviews_per_session`
Avg Session Duration (sec)	`average_session_duration`
Bounces	`bounces`
Bounce Rate	`bounce_rate`
Sessions With Cart Additions	`sessions_with_cart_additions`
Added To Cart Rate	`added_to_cart_rate`
Sessions Reached Checkout	`sessions_that_reached_checkout`
Reached Checkout Rate	`reached_checkout_rate`
Sessions Completed Checkout	`sessions_that_completed_checkout`
Conversion Rate	`conversion_rate`
Checkout Conversion Rate	`checkout_conversion_rate`
Date Exported	`exportDate`

Analytics Sessions by Source

Daily sessions broken down by referrer channel and UTM. Filtered by the export date range.

Column	Description
Date	`day`
Referrer Source	`referrer_source`
Referring Channel	`referring_channel`
Referring Medium	`referring_medium`
UTM Source	`utm_source`
UTM Medium	`utm_medium`
UTM Campaign	`utm_campaign`
Sessions	`sessions`
Visitors	`online_store_visitors`
Pageviews	`pageviews`
Pageviews Per Session	`pageviews_per_session`
Avg Session Duration (sec)	`average_session_duration`
Bounces	`bounces`
Bounce Rate	`bounce_rate`
Sessions With Cart Additions	`sessions_with_cart_additions`
Added To Cart Rate	`added_to_cart_rate`
Sessions Reached Checkout	`sessions_that_reached_checkout`
Reached Checkout Rate	`reached_checkout_rate`
Sessions Completed Checkout	`sessions_that_completed_checkout`
Conversion Rate	`conversion_rate`
Checkout Conversion Rate	`checkout_conversion_rate`
Date Exported	`exportDate`

Analytics Sessions by Landing Page

Daily sessions broken down by landing page path and type. Filtered by the export date range.

Column	Description
Date	`day`
Landing Page Path	`landing_page_path`
Landing Page Type	`landing_page_type`
Sessions	`sessions`
Visitors	`online_store_visitors`
Pageviews	`pageviews`
Pageviews Per Session	`pageviews_per_session`
Avg Session Duration (sec)	`average_session_duration`
Bounces	`bounces`
Bounce Rate	`bounce_rate`
Sessions With Cart Additions	`sessions_with_cart_additions`
Added To Cart Rate	`added_to_cart_rate`
Sessions Reached Checkout	`sessions_that_reached_checkout`
Reached Checkout Rate	`reached_checkout_rate`
Sessions Completed Checkout	`sessions_that_completed_checkout`
Conversion Rate	`conversion_rate`
Checkout Conversion Rate	`checkout_conversion_rate`
Date Exported	`exportDate`

Analytics Sessions by Device

Daily sessions broken down by device type, browser, and OS. Filtered by the export date range.

Column	Description
Date	`day`
Device Type	`session_device_type`
Browser	`session_device_browser`
Operating System	`session_device_os`
Sessions	`sessions`
Visitors	`online_store_visitors`
Pageviews	`pageviews`
Pageviews Per Session	`pageviews_per_session`
Avg Session Duration (sec)	`average_session_duration`
Bounces	`bounces`
Bounce Rate	`bounce_rate`
Sessions With Cart Additions	`sessions_with_cart_additions`
Added To Cart Rate	`added_to_cart_rate`
Sessions Reached Checkout	`sessions_that_reached_checkout`
Reached Checkout Rate	`reached_checkout_rate`
Sessions Completed Checkout	`sessions_that_completed_checkout`
Conversion Rate	`conversion_rate`
Checkout Conversion Rate	`checkout_conversion_rate`
Date Exported	`exportDate`

Analytics Sessions by Country

Daily sessions broken down by visitor country and region. Filtered by the export date range.

Column	Description
Date	`day`
Country	`session_country`
Country Code	`session_country_code`
Region	`session_region`
Sessions	`sessions`
Visitors	`online_store_visitors`
Pageviews	`pageviews`
Pageviews Per Session	`pageviews_per_session`
Avg Session Duration (sec)	`average_session_duration`
Bounces	`bounces`
Bounce Rate	`bounce_rate`
Sessions With Cart Additions	`sessions_with_cart_additions`
Added To Cart Rate	`added_to_cart_rate`
Sessions Reached Checkout	`sessions_that_reached_checkout`
Reached Checkout Rate	`reached_checkout_rate`
Sessions Completed Checkout	`sessions_that_completed_checkout`
Conversion Rate	`conversion_rate`
Checkout Conversion Rate	`checkout_conversion_rate`
Date Exported	`exportDate`

Analytics Campaign Sales

Daily campaign-attributed sales and orders across Shopify attribution models. Filtered by the export date range.

Column	Description
Date	`day`
Campaign ID	`campaign_id`
Last Click Orders	`campaign_last_click_order_count`
Last Click Sales	`campaign_last_click_total_sales`
Last Click AOV	`campaign_last_click_total_average_order_value`
Last Non-Direct Click Orders	`campaign_last_non_direct_click_order_count`
Last Non-Direct Click Sales	`campaign_last_non_direct_click_total_sales`
First Click Orders	`campaign_first_click_order_count`
First Click Sales	`campaign_first_click_total_sales`
Linear Orders	`campaign_linear_order_count`
Linear Sales	`campaign_linear_total_sales`
Date Exported	`exportDate`

Analytics Campaign Sessions

Daily session and funnel metrics for marketing campaign traffic. Filtered by the export date range.

Column	Description
Date	`day`
Campaign ID	`campaign_id`
Sessions	`campaign_sessions`
Visitors	`campaign_online_store_visitors`
Pageviews	`campaign_pageviews`
Bounce Rate	`campaign_bounce_rate`
Sessions With Cart Additions	`campaign_sessions_with_cart_additions`
Sessions Reached Checkout	`campaign_sessions_that_reached_checkout`
Sessions Completed Checkout	`campaign_sessions_that_completed_checkout`
Conversion Rate	`campaign_conversion_rate`
Date Exported	`exportDate`

Analytics Marketing Engagements

Channel-reported marketing spend, impressions, clicks, and sales for the export date range (one row per marketing activity; this schema has no daily breakdown).

Column	Description
Marketing Activity ID	`marketing_activity_id`
Marketing Activity Title	`marketing_activity_title`
Channel	`channel_handle`
Platform	`marketing_platform`
Ad Spend	`engagements_ad_spend`
Impressions	`engagements_impressions`
Clicks	`engagements_clicks`
Unique Clicks	`engagements_unique_clicks`
Sends	`engagements_sends`
Orders (Channel-Reported)	`engagements_orders`
Sales (Channel-Reported)	`engagements_total_sales`
First-Time Customers	`engagements_first_time_customers`
Returning Customers	`engagements_returning_customers`
Unsubscribes	`engagements_unsubscribes`
Date Exported	`exportDate`

Analytics Search Queries

Daily on-site search query volume and intent. Filtered by the export date range.

Column	Description
Date	`day`
Search Query	`search_query`
Search Intent	`search_query_intent`
Results Returned	`search_results_were_returned`
Searches	`searches`
Date Exported	`exportDate`

Analytics Search Conversions

Daily on-site search funnel from search to purchase. Filtered by the export date range.

Column	Description
Date	`day`
Sessions With Searches	`sessions_with_searches`
Search Sessions With Clicks	`search_sessions_with_clicks`
Search Click Rate	`search_click_rate`
Search Sessions With Cart Additions	`search_sessions_with_cart_additions`
Search Added To Cart Rate	`search_added_to_cart_rate`
Search Sessions Completed Checkout	`search_sessions_that_completed_checkout`
Search Conversion Rate	`search_conversion_rate`
Date Exported	`exportDate`

Analytics Web Performance

Daily Core Web Vitals and page load metrics by page type and device. Filtered by the export date range.

Column	Description
Date	`day`
Page Type	`page_type`
Device Type	`device_type`
Page Loads	`page_loads`
LCP p75 (ms)	`lcp_p75_ms`
LCP Good Views	`lcp_good_view_count`
LCP Poor Views	`lcp_poor_view_count`
CLS Good Views	`cls_good_view_count`
CLS Poor Views	`cls_poor_view_count`
INP p75 (ms)	`inp_p75_ms`
INP Poor Views	`inp_poor_view_count`
TTFB p75 (ms)	`ttfb_p75_ms`
FCP p75 (ms)	`fcp_p75_ms`
Date Exported	`exportDate`

Analytics Shop Campaign Insights

Daily Shop Campaign sales, ad spend, ROAS, and acquisition cost. Filtered by the export date range.

Column	Description
Date	`day`
Shop Campaign Name	`shop_campaign_name`
Target Segment	`shop_campaign_target_name`
Sales	`shop_campaign_sales`
Ad Spend	`shop_campaign_ad_spend`
ROAS	`shop_campaign_return_on_ad_spend`
Avg CAC	`shop_campaign_average_customer_acquisition_cost`
Customers	`shop_campaign_customers`
AOV	`shop_campaign_average_order_value`
Date Exported	`exportDate`