InventoryItems
Returns a list of catalog items that have inventory tracked, along with their identifying information.
Table Specific Information
Select
The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Sku supports the = and IN comparisons.
- VariantId supports the = and IN comparisons.
- ProductId supports the = and IN comparisons.
The rest of the filter is executed client-side within the driver.
For example, the following query is processed server-side:
SELECT * FROM InventoryItems WHERE Sku = 'SKU-1'
Columns
| Name | Type | Description |
| Sku [KEY] | String | The SKU of the catalog item. |
| VariantId | Integer | The Id of the product variant. |
| ProductId | Integer | The Id of the product. |
| SkuId | Integer | A read-only reference to the SKU Id used by the Catalog V2 API. Null if this is the base variant. |