Endpoint

Update Inventory Item

Name

put_inventory_item

No description available

Parameter	Label	Required	Options	Description
Id	Inventory Item Id	NO

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I8`	`bigint`		`False`
Sku	`DT_WSTR`	`nvarchar(255)`	255	`False`
Cost	`DT_WSTR`	`nvarchar(255)`	255	`False`
Tracked	`DT_BOOL`	`bit`		`False`
RequiresShipping	`DT_BOOL`	`bit`		`False`
CountryCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
ProvinceCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
CountryHarmonizedSystemCodes	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
HarmonizedSystemCode	`DT_I8`	`bigint`		`False`
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`

If the column you are looking for is missing, consider customizing Shopify Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Sku	`DT_WSTR`	`nvarchar(255)`	255	`False`
Cost	`DT_WSTR`	`nvarchar(255)`	255	`False`
Tracked	`DT_BOOL`	`bit`		`False`
RequiresShipping	`DT_BOOL`	`bit`		`False`
CountryCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
ProvinceCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
CountryHarmonizedSystemCodes	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
HarmonizedSystemCode	`DT_I8`	`bigint`		`False`
Id	`DT_I8`	`bigint`		`False`

Required columns that you need to supply are bolded.

Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:

This Endpoint belongs to InventoryItems table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Shopify

InventoryItems

Update

Use these SQL queries in your ODBC application data source:

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).

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

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).