InventoryItems
Returns a list of inventory items.
Select
The component uses the Shopify API to process WHERE clause conditions built with the following column and operator. The component processes other filters client-side within the component.
- Id supports the '=,IN' comparison operators.
- Sku supports the '=,!=' comparison operators.
- CreatedAt supports the '=,!=,<,>,>=,=<' comparison operators.
- UpdatedAt supports the '=,!=,<,>,>=,=<' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM InventoryItems
SELECT * FROM InventoryItems WHERE Id = 'Val1'
SELECT * FROM InventoryItems WHERE Sku = 'Val1'
SELECT * FROM InventoryItems WHERE CreatedAt = '2023-01-01 11:10:00'
SELECT * FROM InventoryItems WHERE UpdatedAt = '2023-01-01 11:10:00'
Update
Update statements are mapped to the 'inventoryItemUpdate' GraphQL mutation.
The following columns can be updated:
Id, Tracked, HarmonizedSystemCode, CountryCodeOfOrigin, ProvinceCodeOfOrigin, UnitCostAmount, InventoryItemCountryHarmonizedSystemCodes
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique ID. | |
LegacyResourceId | String | True |
The ID of the corresponding resource in the REST Admin API. | |
VariantId | String | True |
A globally-unique ID. | |
Sku | String | True |
Inventory item SKU. | |
Tracked | Bool | False |
Whether inventory levels are tracked for the item. | |
LocationsCount | Int | True |
The number of locations where this inventory item is stocked. | |
RequiresShipping | Bool | True |
Whether the inventory item requires shipping. | |
DuplicateSkuCount | Int | True |
The number of inventory items that share the same SKU with this item. | |
HarmonizedSystemCode | String | False |
The harmonized system code of the item. | |
InventoryHistoryUrl | String | True |
The URL that points to the inventory history for the item. | |
CountryCodeOfOrigin | String | False |
The ISO 3166-1 alpha-2 country code of where the item originated from. | |
ProvinceCodeOfOrigin | String | False |
The ISO 3166-2 alpha-2 province code of where the item originated from. | |
CreatedAt | Datetime | True |
The date and time when the inventory item was created. | |
UpdatedAt | Datetime | True |
The date and time when the inventory item was updated. | |
TrackedEditableLocked | Bool | True |
Whether the attribute is locked for editing. | |
TrackedEditableReason | String | True |
The reason the attribute is locked for editing. | |
UnitCostAmount | Decimal | False |
Decimal money amount. | |
UnitCostCurrencyCode | String | True |
Currency of the money. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
InventoryItemCountryHarmonizedSystemCodes | String |
List of country-specific harmonized system codes. |