Inventory adjustments

Every inventory quantity change Shopify recorded — how many units moved and how many separate adjustments moved them, by product, quantity state, reason, app and staff member. Requires the read_reports scope; empty on stores that have not granted it.

15 fields — 13 dimensions, 2 metrics. Date clauses (SINCE, UNTIL, DURING) use day.

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_adjustment_history
  SHOW inventory_adjustment_change
  GROUP BY day
  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
inventory_adjustment_change	number	metric	Net units added or removed by the adjustments in the group. Signed: negative means stock left. Zero is meaningful — it means adjustments cancelled each other out, which is exactly what an inventory snapshot cannot show.
inventory_adjustment_count	number	metric	How many separate adjustment events occurred in the group, regardless of how many units each moved.
day	date	dimension	The day the adjustments were recorded.
product_variant_sku	string	dimension	SKU of the adjusted variant.
product_variant_title	string	dimension	Title of the adjusted variant.
product_variant_id	string	dimension	Shopify id of the adjusted variant.
inventory_item_id	string	dimension	Shopify inventory item id behind the adjusted variant.
inventory_state	string	dimension	Which quantity state moved — available, on hand, committed, damaged and so on. ⚠️ One adjustment records BOTH an available and an on-hand row, so totals taken without filtering this dimension count the same movement twice.
inventory_change_reason	string	dimension	Why the quantity changed — correction, restock, damaged, purchase and so on.
inventory_app_name	string	dimension	Which app made the change, when an app made it.
staff_member_name	string	dimension	Which staff member made the change. Empty for changes made through an API rather than the admin — that is a real answer, not missing data.
reference_document_uri	string	dimension	What the change refers to, such as the order that consumed the stock.
reference_document_type	string	dimension	What KIND of document the change refers to — a separate column from the URI.
inventory_location_name	string	dimension	Which location the stock moved at.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.