InventoryItems
Query and update information regarding different inventory items.
Table-Specific Information
Select
The connector uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operators are '=' and 'IN'. The connector processes other filters client-side within the connector.For example, the following queries are processed server-side:
SELECT * FROM InventoryItems WHERE Id = '123'
SELECT * FROM InventoryItems WHERE Id IN ('123', '456')
Update
You must specify the Id to update an inventory item. For example:
UPDATE InventoryItems SET Sku = 'lamo', Tracked = false WHERE Id = '123'
UPDATE InventoryItemsSET Cost = 45.95, CountryCodeOfOrigin = 'AU', CountryHarmonizedSystemCodes ='[{"harmonized_system_code":"701912","country_code":"CA"},{"harmonized_system_code":"701912","country_code":"US"}]', HarmonizedSystemCode = '701912', ProvinceCodeOfOrigin = 'NC', SKU = 'Test1', Tracked = FALSE WHERE Id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the fulfillment. | |
| Cost | Decimal | False |
The unit cost of the inventory item. | |
| CountryCodeOfOrigin | String | False |
The two-digit code for the country where the inventory item was made. | |
| CountryHarmonizedSystemCodes | String | False |
An array of country-specific Harmonized System (HS) codes for the item. | |
| HarmonizedSystemCode | String | False |
The general Harmonized System (HS) code for the inventory item. Used if a country-specific HS code is not available. | |
| ProvinceCodeOfOrigin | String | False |
The two-digit code for the province where the inventory item was made. Used only if the shipping provider for the inventory item is Canada Post. | |
| SKU | String | False |
The unique SKU (stock keeping unit) of the inventory item. | |
| Tracked | Bool | False |
Whether the inventory item is tracked. If true, then inventory quantity changes are tracked by Shopify. | |
| RequiresShipping | Bool | True |
Whether a customer needs to provide a shipping address when placing an order containing the inventory item. | |
| 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 last updated. |