Weekly Sales - Concierca AI

What it is

Units sold per product and calendar week. Newest week first, strongest sellers within each week. One row per variant per week — the granular time series behind the aggregated demand rates, useful for spotting week-over-week movement that a 30/90-day average smooths away.

How it gets data

Computed view — derived automatically from Orders / Order Line Items and Products. Read-only; no ingest endpoint.

Fields

Field	Label	Type	Writable	Description
`week_start`	Week	date	read-only	Calendar-week start date
`sku`	SKU	text	read-only	Variant SKU
`product_name`	Product	text	read-only	Variant title
`product_family_label`	Family	text	read-only	Model family
`units`	Units	number	read-only	Units sold in that week
`orders`	Orders	number	read-only	Orders containing the variant in that week
`variant_id`	Variant ID	text	read-only	Source variant id — joins to `products.external_id`
`product_id`	—	text	API only	Internal product reference — joins to `products.id` (not a registered app column, but returned by queries)

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_sales_weekly",
      "filters": { "sku": "6304" },
      "select_fields": ["week_start", "units", "orders"],
      "sort_by": "week_start",
      "limit": 12
    }
  }
}

⌘I