InventoryItemInventoryLevels
Returns a list of the inventory item's quantities for each location that the inventory item can be stocked at.
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.
- InventoryItemId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM InventoryItemInventoryLevels
SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| InventoryItemId | String | A globally-unique ID. | |
| LocationId | String | A globally-unique ID. | |
| CanDeactivate | Bool | Whether the inventory items associated with the inventory level can be deactivated. | |
| DeactivationAlert | String | Describes either the impact of deactivating the inventory level, or why the inventory level can't be deactivated. | |
| CreatedAt | Datetime | The date and time when the inventory level was created. | |
| UpdatedAt | Datetime | The date and time when the inventory level was updated. |