Orders

Order lines by the day the order was placed, shipped or not: units, revenue, orders and margin over a date range.

Example

FROM orders
  SHOW units_sold, line_count
  GROUP BY product
  ORDER BY units_sold DESC

Metric	Type	Description
`units_sold`	Number	Units sold in the selected period.
`line_count`	Number	Number of order lines placed in the period.
`total_revenue`	Currency	Gross revenue from sales in the period.
`unit_cost`	Currency	Cost per unit; 0 when no cost is set.
`total_cogs`	Currency	Cost of goods sold (units sold × unit cost) in the period.
`gross_profit`	Currency	Revenue minus cost of goods sold in the period.
`landed_cogs`	Currency	Cost of goods sold at true landed cost, including allocated freight and duties.
`landed_gross_profit`	Currency	Revenue minus landed cost of goods sold - margin after freight and duties.
`period_days`	Number	How many days the report’s date range covers.
`landed_margin_pct`	Percent	Landed gross profit as a percentage of revenue.
`profit_margin`	Percent	Gross profit as a percentage of revenue.
`order_count`	Number	Number of orders placed in the period.
`avg_order_value`	Currency	Revenue per order in the period, counting only the lines in this report’s scope.

Dimension	Description
`product`	Product with image, rendered as a single cell (variants roll up).
`sku`	Variant SKU - splits a product-grain report into variant rows.
`variant`	Variant title (e.g. “Small / Blue”), shown as a dash for products without options. Group by product too - on its own, variants sharing a title across different products fall into one row.
`barcode`	Variant barcode (GTIN/UPC/EAN/ISBN), grouping under a blank value when none.
`category`	Shopify product category (full taxonomy path).
`collection`	Shopify collection - a SKU appears under each collection it belongs to (cross-collection totals overlap), grouping under a blank value when it is in none.
`location`	Sales location.
`vendor`	Product vendor.
`product_type`	Shopify product type.
`tag`	Individual product tag - a SKU appears under each of its tags (cross-tag totals overlap).
`location_role`	Whether the fulfilling location acts as a hub or a fulfillment location.
`order_channel`	The channel the order came through, such as the online store, POS, or a marketplace. Orders with no recorded channel group under Unknown.
`order_source`	Where the order was placed: web, POS, or a channel app. Coarser than order channel; use it to split online from in-person.
`promotion`	The declared promotion covering the sale date, from the promotion calendar. Days outside every declared window group under None.

Filter	Type	Description
`collection`	Number	Restrict to products in the selected collection(s).
`category`	Text	Restrict to products in the selected category (matches sub-categories too).
`sales_channel`	Number	Restrict to products published to the selected sales channel.
`region_catalog`	Number	Restrict to products in the selected region (market) catalog.
`b2b_catalog`	Number	Restrict to products in the selected B2B (market) catalog.
`company_location_catalog`	Number	Restrict to products in the selected company-location catalog.
`order_channel`	Text	The channel the order came through. Distinct from sales channel, which filters on where a product is listed rather than where an order came from.
`order_source`	Text	Where the order was placed: web, POS, or a channel app.
`vendor`	Text	Product vendor.
`product_type`	Text	Shopify product type.
`product_title`	Text	Product title.
`sku`	Text	Variant SKU.
`barcode`	Text	Variant barcode.
`location_name`	Text	Sales location name.
`promotion`	Text	Name of the declared promotion covering the sale date. Null outside every declared window.