Reorder history - Stockful

One row per SKU per night it was on the reorder list - what was recommended, and when.

Example

FROM reorder_history
  SHOW units_to_order, recommended_spend
  GROUP BY product
  ORDER BY units_to_order DESC

Metrics

Metric	Type	Description
`units_to_order`	Number	Recommended order quantity on the most recent day in the range, after netting off incoming stock.
`recommended_spend`	Currency	Cost of the recommended order on the most recent day in the range.
`skus_to_order`	Number	Number of variants recommended on the most recent day in the range.
`units_on_hand`	Number	Stock held by the flagged SKUs on the most recent day. Covers recommended rows only - it will not match total inventory.
`units_incoming`	Number	Inbound stock against the flagged SKUs on the most recent day.
`avg_days_of_supply`	Number	Mean cover across the flagged SKUs on the most recent day.
`avg_daily_velocity`	Units per day	Mean daily sales rate across the flagged SKUs on the most recent day.
`as_of_date`	Date	The most recent day in the range that has logged recommendations.
`sku_days_flagged`	Number	Days spent on the reorder list, summed across SKUs - a variant flagged for 3 days counts 3.
`skus_flagged`	Number	Distinct variants that appeared on the reorder list at any point in the range.
`times_flagged`	Number	Separate spells on the reorder list - consecutive days count once, so a SKU flagged, restocked, then flagged again counts twice.
`sku_days_snoozed`	Number	Of the days flagged, how many the recommendation was snoozed on.
`avg_daily_units_to_order`	Number	Recommended order quantity averaged over the days in the range. Safe to chart.
`avg_daily_recommended_spend`	Currency	Recommended order cost averaged over the days in the range. Safe to chart.
`first_flagged_date`	Date	Earliest day in the range the SKU appeared on the reorder list.
`last_flagged_date`	Date	Most recent day in the range the SKU appeared on the reorder list.

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.
`location`	The location the recommendation was made for.
`vendor`	Product vendor, grouping under a blank value when unset.
`product_type`	Product type, grouping under a blank value when unset.
`forecast_model`	The demand model that produced the recommendation (linear, trend, day-of-week, seasonal, intermittent).
`snapshot_date`	The day the recommendation was live.

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.
`product_title`	Text	Product title.
`sku`	Text	Variant SKU.
`vendor`	Text	Product vendor.
`product_type`	Text	Product type.
`location_name`	Text	Location name.
`forecast_model`	Text	The demand model behind the recommendation.
`snoozed`	Text	Whether the recommendation was snoozed on that day.
`quantity_to_order`	Number	Recommended order quantity on that day.
`days_of_supply`	Number	Cover remaining on that day.