InventoryItems
Query and update information regarding different inventory items.
Table-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operators are '=' and 'IN'. The driver processes other filters client-side within the driver.
For example, the following queries are processed server side:
SELECT * FROM InventoryItems
SELECT * FROM InventoryItems WHERE Id='123'
SELECT * FROM InventoryItems WHERE Id IN ('123','456')
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false; the Shopify APIs require Id in the search criteria, and any other search criteria will cause an error.
Update
You must specify the Id to update an inventory item. For example:
UPDATE InventoryItems Set Sku='lamo', 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 | Boolean | False |
Whether the inventory item is tracked. If true, then inventory quantity changes are tracked by Shopify. | |
| RequiresShipping | Boolean | 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. |