Shopify Connector
Documentation
Version: 1
Documentation

EndPoint Create a Product Variant


Name

post_product_variant

Description

Creates a new product variant. [API reference]

Parameters

Parameter Label Required Options Description
Id Product Id YES The ID of the product for which you like to create a new variant.

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
ProductId DT_WSTR nvarchar(1000) 1000 False
Required columns that you need to supply are bolded.