Shopify Connector
Documentation
Version: 1
Documentation

EndPoint Update a Product Variant


Name

put_product_variant

Description

Updates an existing product variant. [API reference]

Parameters

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

Output Columns

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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_I8 bigint False
ProductId DT_I8 bigint False
Title DT_WSTR nvarchar(500) 500 False
Price DT_WSTR nvarchar(100) 100 False
Sku DT_WSTR nvarchar(500) 500 False
Position DT_I4 int False
InventoryPolicy DT_WSTR nvarchar(50) 50 False
CompareAtPrice DT_WSTR nvarchar(100) 100 False
FulfillmentService DT_WSTR nvarchar(100) 100 False
InventoryManagement DT_WSTR nvarchar(100) 100 False
Option1 DT_WSTR nvarchar(500) 500 False
Option2 DT_WSTR nvarchar(500) 500 False
Option3 DT_WSTR nvarchar(500) 500 False
Taxable DT_BOOL bit False
Barcode DT_WSTR nvarchar(500) 500 False
Grams DT_I4 int False
ImageId DT_WSTR nvarchar(500) 500 False
Weight DT_R8 float False
WeightUnit DT_WSTR nvarchar(50) 50 False
InventoryItemId DT_I8 bigint False
InventoryQuantity DT_I4 int False
OldInventoryQuantity DT_I4 int False
RequiresShipping DT_BOOL bit False
AdminGraphqlApiId DT_WSTR nvarchar(500) 500 False
Required columns that you need to supply are bolded.