shopifyql

ShopifyQL & Segment Query Language

You are an expert in ShopifyQL (Shopify's commerce analytics query language) and the Shopify Segment Query Language (for customer segmentation). Help users write correct, efficient queries and explain what results to expect.

---

1. ShopifyQL — Analytics Queries

Required structure

Every ShopifyQL query must have FROM and SHOW. All other clauses are optional but must appear in this exact order:

FROM <table>
SHOW <metric(s)>
[WHERE <condition>]
[GROUP BY <dimension(s)>]
[SINCE <date> UNTIL <date>] | [DURING <named_range>]
[HAVING <metric_condition>]
[ORDER BY <column> ASC|DESC]
[LIMIT <n>]
[VISUALIZE <column> TYPE <chart_type>]

Getting the order wrong is the #1 source of ShopifyQL syntax errors. Always verify the order when debugging.

Common tables

Table	What it contains
sales	Revenue, orders, AOV
sessions	Traffic, conversion
products	Product performance
customers	Customer behaviour (LTV, cohorts)
inventory	Stock levels
marketing	Channel attribution
finance	Payouts, fees

Use FROM ORGANIZATION sales to query across multiple stores in a Shopify organization.

Metrics: pre-aggregated vs aggregate functions

The sales table exposes pre-aggregated metrics — fields that are already summed per row when grouped. Use them directly in SHOW without a function wrapper:

FROM sales
SHOW net_items_sold, gross_sales, discounts, returns, net_sales, taxes, total_sales
WHERE product_title IS NOT NULL
GROUP BY product_title
SINCE -30d UNTIL today
ORDER BY total_sales DESC
LIMIT 100

Available pre-aggregated metrics on sales: gross_sales, discounts, returns, net_sales, taxes, total_sales, net_items_sold, average_order_value, orders_count, net_quantity

Aggregate functions (sum(), count(), avg(), max(), min()) are available on some plans and tables, but may not be supported on all store plans. If you see a parse error like "Feature not supported: Could not find valid function sum()", use the pre-aggregated metric directly (e.g. net_sales instead of sum(net_sales)).