InventoryItemInventoryLevelQuantities
List quantities for inventory items at specific locations.
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
SELECT * FROM InventoryItemInventoryLevelQuantities WHERE InventoryLevelId = 'Val1'
SELECT * FROM InventoryItemInventoryLevelQuantities WHERE Name = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| InventoryLevelId | String | A globally-unique ID. | |
| InventoryLevelLocationId | String | A globally-unique ID. | |
| Name | String | The name that identifies the inventory quantity. | |
| Quantity | Int | The quantity for the quantity name. | |
| UpdatedAt | Datetime | When the quantity was last updated. |