InventoryItems
Returns a list of inventory items.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- 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
The following columns can be updated:
Tracked, HarmonizedSystemCode, CountryCodeOfOrigin, ProvinceCodeOfOrigin, UnitCostAmount, InventoryItemCountryHarmonizedSystemCodes (references 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. | |
| InventoryItemCountryHarmonizedSystemCodes | String | False |
List of country-specific harmonized system codes. |