InventoryItemInventoryLevels
Shows per-location inventory level summaries for an inventory item.
Table-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- InventoryItemId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId = 'Val1'
Insert
The following columns can be used to create a new record:
InventoryItemId, LocationId
The following pseudo-columns can be used to create a new record:
Available, OnHand, StockAtLegacyLocation
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the inventory level. | |
| InventoryItemId | String | True |
The globally unique identifier of the inventory item associated with this level. | |
| LocationId | String | True |
The globally unique identifier of the location tied to the inventory level. | |
| CanDeactivate | Bool | True |
Indicates whether the inventory level can be deactivated for the associated item at this location. | |
| DeactivationAlert | String | True |
Explains the impact of deactivating the inventory level or the reason why it cannot be deactivated. | |
| CreatedAt | Datetime | True |
The date and time when the inventory level was created. | |
| UpdatedAt | Datetime | True |
The date and time when the inventory level was last updated. |
Pseudo-Columns
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description |
| Available | Int |
The starting available quantity of the inventory item when it is activated at the location. |
| OnHand | Int |
The starting on-hand quantity of the inventory item when it is activated at the location. |
| StockAtLegacyLocation | Bool |
Indicates whether activation is allowed at or away from a legacy fulfillment service location when SKU sharing is disabled. Enabling this option deactivates inventory at all other locations. |