Inventory adjustments table

The inventory adjustments table contains a historical record for each inventory item that is tracked by Shopify. Inventory items are an upcoming part of the Shopify API. For now, you can think of them as product variants.

This table has one row per inventory adjustment. Data in this table is available from April 1, 2017 UTC.

Columns

Anchor link to section titled "Columns"
Column Data type Description
inventory_adjustment_id numeric ID of the inventory adjustment. This column is the primary key for this table.
api_client_id numeric ID of the API client from which the adjustment was made. This column is a foreign key reference to the ID of the API client in the API clients table.
inventory_item_id numeric ID of the inventory item. This column is a foreign key reference to the inventory_item_id column in inventory items table.
product_id numeric ID of the product. This column is a foreign key reference to the product_id column in products table.
product_variant_id numeric ID of the product variant associated with the inventory item. This column is a foreign key reference to the product_variant_id column in product variants table.
user_id numeric ID of the staff member who changed the inventory. Not all changes have a staff member associated with them. This column is a foreign key reference to the user_id column in the users table.
shop_id numeric ID of the store. This column is a foreign key reference to the shop_id column in the shops table.
quantity_after_adjustment numeric Inventory quantity after an adjustment in inventory.
quantity_delta numeric Number of the items that were increased or decreased by the adjustment. Negative numbers indicate a decrease in inventory.
reason varchar Reason that the inventory adjustment was made. Valid values are:
  • initial_adjustment — The inventory item was created.
  • transfer_received — An increase in inventory caused by an inventory transfer from a supplier.
  • purchase — A decrease in inventory caused by a sale of the item.
  • order_cancellation — An increase in inventory caused by canceling an order from within an app only.
  • restock — An increase in inventory caused by restocking the item from within the Shopify admin only. Items can be restocked as part of canceling or refunding an order.
  • manual_addition — An increase in inventory that was made manually.
  • manual_removal — A decrease in inventory that was made manually.
created_at timestamp Date (ISO 8601) and time (UTC) when the inventory adjustment was made. For example, 2016-02-05 00:00:00.
Anchor link to section titled "Related information"