Reference

Endpoint Update Inventory Item

Name

put_inventory_item

Description

No description available

Related Tables

InventoryItems

Parameters

Parameter Required Options
Name: Id

Label: Inventory Item Id

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_I8 bigint
Sku DT_WSTR nvarchar(255) 255
Cost DT_WSTR nvarchar(255) 255
Tracked DT_BOOL bit
RequiresShipping DT_BOOL bit
CountryCodeOfOrigin DT_WSTR nvarchar(50) 50
ProvinceCodeOfOrigin DT_WSTR nvarchar(50) 50
CountryHarmonizedSystemCodes DT_WSTR nvarchar(4000) 4000
HarmonizedSystemCode DT_I8 bigint
CreatedAt DT_DBTIMESTAMP datetime
UpdatedAt DT_DBTIMESTAMP datetime
If the column you are looking for is missing, consider customizing Shopify Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Sku DT_WSTR nvarchar(255) 255
Cost DT_WSTR nvarchar(255) 255
Tracked DT_BOOL bit
RequiresShipping DT_BOOL bit
CountryCodeOfOrigin DT_WSTR nvarchar(50) 50
ProvinceCodeOfOrigin DT_WSTR nvarchar(50) 50
CountryHarmonizedSystemCodes DT_WSTR nvarchar(4000) 4000
HarmonizedSystemCode DT_I8 bigint
Id DT_I8 bigint
Required columns that you need to supply are bolded.

Examples

SSIS

Use Shopify Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the InventoryItems table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update inventory item:

API Destination - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
InventoryItems
Update
Optional Parameters
Inventory Item Id
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update an existing inventory item cost and other attributes 

UPDATE InventoryItems
SET Cost='25.55'
WHERE Id=43512280416356

put_inventory_item endpoint belongs to InventoryItems table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source 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 [LS_TO_SHOPIFY_IN_GATEWAY];

put_inventory_item endpoint belongs to InventoryItems table(s), and can therefore be used via those table(s).