Product Demand

What it is

How fast each variant sells, and how long the stock lasts. Sold 30/90/180d are raw units. Sales/day (weighted) blends those windows — recent weeks count more. Sales/day (season removed) is the same rate with the seasonal swing taken out, so periods are comparable. Planned demand/day is what procurement actually plans with: the weighted rate times the season factor of the period a purchase placed today would cover, times lifecycle and any manual factor. Days of Stock is stock divided by planned demand. Every factor is exposed as its own column, so an agent can cite the exact calculation path for any number it reports. demand_status (READY / LOW_HISTORY / NO_SALES_HISTORY / MANUAL_FORECAST / INSUFFICIENT_DATA) and demand_confidence (high / medium / low) say how much history backs the rate: under 180 days of history the windows shrink and the weights renormalize (READY); under 30 days the rate is measured since launch (LOW_HISTORY); no sales plus a manual target becomes MANUAL_FORECAST.

How it gets data

Computed view — derived automatically from Orders / Order Line Items, Products, and Procurement Config. Read-only; no ingest endpoint. To change the numbers, change the inputs (sales data, product master data, config). Sales are counted per variant on orders.placed_at, with refunded/expired/voided orders excluded via financial_status. Both shops are summed when several feed one workspace.

Fields

Identity & stock

Field	Label	Type	Description
`sku`	SKU	text	Variant SKU
`product_name`	Product	text	Variant title
`product_family_label`	Family	text	Human-readable model family
`product_family`	—	text	Source product-group id (API only — not a registered app column)
`product_id`	Product (internal)	text	Joins to `products.id`
`stock_on_hand`	Stock	number	Current stock from the shop sync
`inventory_synced_at`	Inventory synced	datetime	When stock was last synced
`days_of_stock`	Days of Stock	number	Stock ÷ planned demand/day — how long the shelf lasts at the planned rate
`lifecycle_status`	Lifecycle	text	Lifecycle stage from the product master
`seasonality_profile`	Season Profile	text	Seasonality profile assigned to the variant
`calculated_at`	Calculated	datetime	When the view was computed

Raw sales windows

Field	Label	Type	Description
`units_sold_14d`	Units 14d	number	Raw units sold, last 14 days
`units_sold_28d`	Sold 28d	number	Raw units sold, last 28 days (trend window)
`units_sold_30d`	Sold 30d	number	Raw units sold, last 30 days
`units_sold_90d`	Sold 90d	number	Raw units sold, last 90 days
`units_sold_180d`	Sold 180d	number	Raw units sold, last 180 days
`units_sold_365d`	Units 365d	number	Raw units sold, last 365 days
`sales_history_days`	History (days)	number	Days of sales history backing the rates — windows shrink and weights renormalize when shorter than 180

Demand rates & blend weights

Field	Label	Type	Description
`daily_sales_28d`	Rate 28d	number	Units/day over the last 28 days
`daily_sales_30d`	Rate 30d	number	Units/day over the last 30 days
`daily_sales_90d`	Rate 90d	number	Units/day over the last 90 days
`daily_sales_180d`	Rate 180d	number	Units/day over the last 180 days
`w30` / `w90` / `w180`	—	number	The actual blend weights applied to the 30/90/180-day rates (API only). Renormalized when history is shorter — the visible proof of how the weighted rate was mixed
`weighted_daily_demand`	Sales/day (weighted)	number	Blend of the window rates; recent windows weighted higher
`deseasonalized_daily_demand`	Sales/day (season removed)	number	Weighted rate with the seasonal swing taken out — comparable across months

Seasonality & coverage window

Field	Label	Type	Description
`seasonal_multiplier`	Season factor (order window)	number	Season factor of the period a purchase placed today would cover
`seasonal_source`	Seasonal basis	text	Where the factor comes from: measured from own sales, manual override, or profile
`coverage_window_start`	Window from	date	Start of the coverage window: today + lead time (an order placed now arrives here)
`coverage_window_end`	Window to	date	End of that window: arrival + target stock days
`coverage_window_factor`	Season factor (order window)	number	Season factor averaged over the coverage window — the factor that actually multiplies into planned demand

Planned demand & its factors

Field	Label	Type	Description
`forecast_daily_demand`	Planned demand/day	number	The rate procurement plans with: weighted rate × season factor of the coverage window × lifecycle × manual factor
`lifecycle_multiplier`	Lifecycle factor	number	Demand factor from the lifecycle stage (launch boosts, declining damps)
`manual_demand_multiplier`	Manual factor	number	Manual factor from the product master
`manual_target_quantity`	Manual target	number	Manual forecast from the product master — used when there is no sales history
`demand_status`	Demand status	text	`READY` / `LOW_HISTORY` / `NO_SALES_HISTORY` / `MANUAL_FORECAST` / `INSUFFICIENT_DATA` — how the rate was derived. Zero sales during a stockout still reads as zero demand; the status makes that visible instead of hiding it
`demand_confidence`	Demand confidence	text	`high` / `medium` / `low` — how much history backs the rate

Family trend (joined in)

Field	Label	Type	Description
`trend_label`	Trend	status	Family trend classification (see Family Trend)
`momentum_pct`	Momentum %	number	Family 28-day rate vs. 90-day rate, seasonally adjusted
`trend_confidence`	Trend confidence	text	Confidence of the trend classification

All columns are read-only. The view also carries tenant_id / workspace_id for tenant isolation — filtered automatically, never selected.

Query it

{
  "method": "tools/call",
  "params": {
    "name": "data_query",
    "arguments": {
      "view_slug": "v_product_demand",
      "filters": { "demand_status": "READY" },
      "select_fields": ["sku", "product_name", "forecast_daily_demand", "days_of_stock", "stock_on_hand"],
      "sort_by": "days_of_stock",
      "sort_desc": false,
      "limit": 25
    }
  }
}

Getting Started

Resources

Sales & Commerce

Procurement

Marketing & Outreach

Governance

What it is

How it gets data

Fields

Identity & stock

Raw sales windows

Demand rates & blend weights

Seasonality & coverage window

Planned demand & its factors

Family trend (joined in)

Query it

​What it is

​How it gets data

​Fields

​Identity & stock

​Raw sales windows

​Demand rates & blend weights

​Seasonality & coverage window

​Planned demand & its factors

​Family trend (joined in)

​Query it

What it is

How it gets data

Fields

Identity & stock

Raw sales windows

Demand rates & blend weights

Seasonality & coverage window

Planned demand & its factors

Family trend (joined in)

Query it