Inventory items

Inventory items with quantities across locations.

22 fields — 12 dimensions, 10 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_items
  SHOW variant_price
  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.
product_variant_id	string	dimension	Shopify's id for the variant this inventory item belongs to.
variant_price	money	metric	The variant's current selling price.
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.
store_id	string	dimension	The shop's raw identifier — what an export or the API reports. Same shops as Store, shown as ids.
store_domain	string	dimension	The shop's myshopify.com domain. Filter with WHERE store_domain = 'shop.myshopify.com'.