Update a product variant
Updates an existing product variant identified by its Id. You can modify attributes like Price, SKU, Weight, and Option1.
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