Reference

Table InventoryItems

Description

No description available

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

API Source - Shopify
Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
Shopify
InventoryItems
Required Parameters
Inventory Item Id(s) - Comma separated Fill-in the parameter...
SSIS API Source - Read from table or endpoint

Read/write to InventoryItems table using API Destination

API Destination - Shopify
Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
Shopify
InventoryItems
Select
Required Parameters
Inventory Item Id(s) - Comma separated Fill-in the parameter...
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read an inventory item by ID

<p>Gets a specific inventory item by its unique <code>Id</code>. The Inventory Item ID can be found in the <code>ProductVariants</code> table.</p> 

select * from InventoryItems Where Id=43512280416356

Read multiple inventory items by IDs

<p>Gets multiple inventory items by supplying a comma-separated list of IDs in the <code>Ids</code> parameter within the <code>WITH</code> clause.</p> 

select * from InventoryItems WITH(Ids='43512280416356, 43512280449124')

Update an inventory item

<p>Updates an existing inventory item identified by its <code>Id</code>. You can modify attributes like <code>Cost</code>.</p> 

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:

Read an inventory item by ID

<p>Gets a specific inventory item by its unique <code>Id</code>. The Inventory Item ID can be found in the <code>ProductVariants</code> table.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryItems Where Id=43512280416356';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Read multiple inventory items by IDs

<p>Gets multiple inventory items by supplying a comma-separated list of IDs in the <code>Ids</code> parameter within the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryItems WITH(Ids=''43512280416356, 43512280449124'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Update an inventory item

<p>Updates an existing inventory item identified by its <code>Id</code>. You can modify attributes like <code>Cost</code>.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE InventoryItems
SET Cost=''25.55''
WHERE Id=43512280416356';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];