Table InventoryItems
Description
No description available
Parameters
Parameter | Label | Required | Options | Description | Help | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no parameters |
Supported Operations
Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.Method | Supported | Reference EndPoint |
---|---|---|
SELECT | get_inventory_items | |
INSERT | ||
UPDATE | put_inventory_item | |
UPSERT | ||
DELETE | ||
LOOKUP | get_inventory_items |
Examples
SSIS
Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:
Read from InventoryItems table using API Source

Read/write to InventoryItems table using API Destination

ODBC application
Use these SQL queries in your ODBC application data source:
Get inventory item by id
You can find Inventory Item Id in ProductVariants table. ProductVariant has One-to-One mapping with InventoryItems table
select * from InventoryItems Where Id=43512280416356
Get inventory item by id
You can find Inventory Item Id in ProductVariants table. ProductVariant has One-to-One mapping with InventoryItems table
select * from InventoryItems Where Id=43512280416356
Get inventory items by multiple Ids
Query multiple InventoryItems by Ids (Comma separated list). You can find Inventory Item Id in ProductVariants table. ProductVariant has One-to-One mapping with InventoryItems table
select * from InventoryItems WITH(Ids='43512280416356, 43512280449124')
Update an existing inventory item cost and other attributes
UPDATE InventoryItems
SET Cost='25.55'
WHERE Id=43512280416356
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get inventory item by id
You can find Inventory Item Id in ProductVariants table. ProductVariant has One-to-One mapping with InventoryItems table
DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryItems Where Id=43512280416356';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_SHOPIFY_IN_DATA_GATEWAY];
Get inventory item by id
You can find Inventory Item Id in ProductVariants table. ProductVariant has One-to-One mapping with InventoryItems table
DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryItems Where Id=43512280416356';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_SHOPIFY_IN_DATA_GATEWAY];
Get inventory items by multiple Ids
Query multiple InventoryItems by Ids (Comma separated list). You can find Inventory Item Id in ProductVariants table. ProductVariant has One-to-One mapping with InventoryItems table
DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryItems WITH(Ids=''43512280416356, 43512280449124'')';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_SHOPIFY_IN_DATA_GATEWAY];
Update an existing inventory item cost and other attributes
DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE InventoryItems
SET Cost=''25.55''
WHERE Id=43512280416356';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_SHOPIFY_IN_DATA_GATEWAY];