Sales - Stockful

Fulfilled order lines: units, revenue and margin over a date range.

Example

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

Metrics

Metric	Type	Description
`units_sold`	Number	Units sold in the selected period.
`line_count`	Number	Number of fulfilled order lines 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.

Dimensions

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.

Filters

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.
`vendor`	Text	Product vendor.
`product_type`	Text	Shopify product type.
`sku`	Text	Variant SKU.
`barcode`	Text	Variant barcode.
`location_name`	Text	Sales location name.
`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.
`promotion`	Text	Name of the declared promotion covering the sale date. Null outside every declared window.

Order channel is recorded from the point it was added, so orders older than that, and orders whose channel has not yet been filled in by the nightly sync, group under Unknown rather than being counted as direct sales.