Reference

Endpoint Update a Product Variant

Name

put_product_variant

Description

Updates an existing product variant. [API reference]

Related Tables

ProductVariants

Parameters

Parameter	Required	Options
Name: Id Label: Product Variant Id The ID of the product variant to be updated.	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
Id	`DT_I8`	`bigint`
ProductId	`DT_I8`	`bigint`
Title	`DT_WSTR`	`nvarchar(100)`	100
Sku	`DT_WSTR`	`nvarchar(500)`	500
Price	`DT_WSTR`	`nvarchar(100)`	100
CompareAtPrice	`DT_WSTR`	`nvarchar(100)`	100
Position	`DT_I4`	`int`
Option1	`DT_WSTR`	`nvarchar(500)`	500
Option2	`DT_WSTR`	`nvarchar(500)`	500
Option3	`DT_WSTR`	`nvarchar(500)`	500
CreatedAt	`DT_DBTIMESTAMP`	`datetime`
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`
Taxable	`DT_BOOL`	`bit`
InventoryItemId	`DT_I8`	`bigint`
InventoryQuantity	`DT_I4`	`int`
OldInventoryQuantity	`DT_I4`	`int`
InventoryPolicy	`DT_WSTR`	`nvarchar(50)`	50
InventoryManagement	`DT_WSTR`	`nvarchar(100)`	100
FulfillmentService	`DT_WSTR`	`nvarchar(100)`	100
Barcode	`DT_WSTR`	`nvarchar(500)`	500
Grams	`DT_I4`	`int`
ImageId	`DT_WSTR`	`nvarchar(500)`	500
Weight	`DT_R8`	`float`
WeightUnit	`DT_WSTR`	`nvarchar(50)`	50
RequiresShipping	`DT_BOOL`	`bit`
AdminGraphqlApiId	`DT_WSTR`	`nvarchar(500)`	500
PresentmentPrices	`DT_WSTR`	`nvarchar(4000)`	4000

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

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
Id	`DT_I8`	`bigint`
ProductId	`DT_I8`	`bigint`
Title	`DT_WSTR`	`nvarchar(500)`	500
Price	`DT_WSTR`	`nvarchar(100)`	100
Sku	`DT_WSTR`	`nvarchar(500)`	500
Position	`DT_I4`	`int`
InventoryPolicy	`DT_WSTR`	`nvarchar(50)`	50
CompareAtPrice	`DT_WSTR`	`nvarchar(100)`	100
FulfillmentService	`DT_WSTR`	`nvarchar(100)`	100
InventoryManagement	`DT_WSTR`	`nvarchar(100)`	100
Option1	`DT_WSTR`	`nvarchar(500)`	500
Option2	`DT_WSTR`	`nvarchar(500)`	500
Option3	`DT_WSTR`	`nvarchar(500)`	500
Taxable	`DT_BOOL`	`bit`
Barcode	`DT_WSTR`	`nvarchar(500)`	500
Grams	`DT_I4`	`int`
ImageId	`DT_WSTR`	`nvarchar(500)`	500
Weight	`DT_R8`	`float`
WeightUnit	`DT_WSTR`	`nvarchar(50)`	50
InventoryItemId	`DT_I8`	`bigint`
InventoryQuantity	`DT_I4`	`int`
OldInventoryQuantity	`DT_I4`	`int`
RequiresShipping	`DT_BOOL`	`bit`
AdminGraphqlApiId	`DT_WSTR`	`nvarchar(500)`	500

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 ProductVariants table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update a product variant:

API Destination - Shopify

Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.

Shopify

ProductVariants

Update

There are no parameters to configure.

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update a product variant

<p>Updates an existing product variant identified by its <code>Id</code>. You can modify attributes like <code>Price</code>, <code>SKU</code>, <code>Weight</code>, and <code>Option1</code>.</p>

Update ProductVariants 
SET  
	 Option1='Chocolate' 
	,Option2='Large'
	,SKU='ICE-CHO-SML'
	,Price=90.45
	,CompareAtPrice=100.45
	,Position=2
	,Weight=10.5
	,WeightUnit='lb'
	,ImageId=31900013854820  --use available images from Products table
Where Id=42564507992164

put_product_variant endpoint belongs to ProductVariants 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 a product variant

<p>Updates an existing product variant identified by its <code>Id</code>. You can modify attributes like <code>Price</code>, <code>SKU</code>, <code>Weight</code>, and <code>Option1</code>.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'Update ProductVariants 
SET  
	 Option1=''Chocolate'' 
	,Option2=''Large''
	,SKU=''ICE-CHO-SML''
	,Price=90.45
	,CompareAtPrice=100.45
	,Position=2
	,Weight=10.5
	,WeightUnit=''lb''
	,ImageId=31900013854820  --use available images from Products table
Where Id=42564507992164';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

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