InventoryItemInventoryLevelQuantities
Lists on-hand, committed, and available quantities by location for an inventory item.
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.
- InventoryLevelId supports the '=, IN' comparison operators.
- Name supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM InventoryItemInventoryLevelQuantities WHERE InventoryLevelId = 'Val1'
SELECT * FROM InventoryItemInventoryLevelQuantities WHERE Name = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The globally unique identifier of the inventory level quantity record. | |
| InventoryItemId | String | The globally unique identifier of the related inventory item. | |
| InventoryLevelId | String | The globally unique identifier of the inventory level associated with this quantity. | |
| InventoryLevelLocationId | String | The globally unique identifier of the location tied to the inventory level. | |
| Name | String | The label or name that identifies the specific type of inventory quantity (for example, available or reserved). | |
| Quantity | Int | The recorded quantity for the specified inventory type. | |
| UpdatedAt | Datetime | The date and time when the quantity was last updated. |