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.
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:
|
created_at | timestamp | Date (ISO 8601) and time (UTC) when the inventory adjustment was made. For example, 2016-02-05 00:00:00. |