InventoryAdjustmentGroupChanges
Lists sets of quantity changes that occurred within inventory events.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- InventoryAdjustmentGroupId supports the '=, IN' comparison operators.
- InventoryItemId supports the '=, IN' comparison operators.
- LocationId supports the '=, IN' comparison operators.
- Name supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM InventoryAdjustmentGroupChanges WHERE InventoryAdjustmentGroupId = 'Val1'
SELECT * FROM InventoryAdjustmentGroupChanges WHERE InventoryAdjustmentGroupId = 'Val1' AND InventoryItemId = 'Val1'
SELECT * FROM InventoryAdjustmentGroupChanges WHERE InventoryAdjustmentGroupId = 'Val1' AND LocationId = 'Val1'
SELECT * FROM InventoryAdjustmentGroupChanges WHERE InventoryAdjustmentGroupId = 'Val1' AND Name = 'Val1'
Columns
| Name | Type | References | Description |
| InventoryAdjustmentGroupId [KEY] | String | The globally unique identifier of the inventory adjustment group associated with this change. | |
| InventoryItemId [KEY] | String | The globally unique identifier of the inventory item whose quantity was adjusted. | |
| LocationId [KEY] | String | The globally unique identifier of the location where the adjustment occurred. | |
| Name [KEY] | String | The name of the inventory quantity type that was changed (for example, available, committed). | |
| Delta | Int | The amount by which the inventory quantity changed. Positive values increase the quantity and negative values decrease it. | |
| QuantityAfterChange | Int | The total inventory quantity for the specified type after the adjustment. | |
| LedgerDocumentUri | String | A URI linking to the document or resource (such as an order or transfer) that caused the inventory change. |