Inventory

Inventory items with quantities across locations.

18 fields — 9 dimensions, 9 metrics. Date clauses (SINCE, UNTIL, DURING) use createdAt.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM inventory
  SHOW item_count
  GROUP BY sku
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
sku	string	dimension	Inventory item SKU.
barcode	string	dimension	Inventory item barcode.
product_title	string	dimension	Title of the product this item belongs to.
product_type	string	dimension	Type of the product this item belongs to.
variant_title	string	dimension	Title of the variant this item belongs to.
is_tracked	boolean	dimension	Label specifying whether the inventory item's inventory adjustments are tracked.
requires_shipping	boolean	dimension	Whether the item requires shipping.
item_count	number	metric	Number of inventory items (SKUs) in the group (document count — value_count on createdAt). Sums across stores.
cost	money	metric	Cost per item.
available_quantity	number	metric	Units available for sale across locations.
on_hand_quantity	number	metric	Units physically on hand across locations.
committed_quantity	number	metric	Units committed to orders across locations.
incoming_quantity	number	metric	Units incoming across locations.
unavailable_quantity	number	metric	Units unavailable across locations.
reserved_quantity	number	metric	Units reserved across locations.
location_name	string	dimension	Location holding the inventory.
location_available_quantity	number	metric	Units available at a specific location.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.