Update Product and Variant Prices by a Percentage

SmithCart > How To
You can use the following SQL Scripts to increase your Product and Variant pricing by 10%:
 
Increase Product Prices by Percent:
Update Smith_Products
set UnitCost = UnitCost + (UnitCost*.1)
 
Increase Variant Prices by Percent:
Update Smith_ProductVariant
set PriceAdjustment = PriceAdjustment + (PriceAdjustment*.1)
 
 
To increase the Prices by a different percentage all you need to do if change the ".1" in the script. So for example if you want to increase Product Prices by 20% the script would look like the following:
 
Update Smith_Products
set UnitCost = UnitCost + (UnitCost*.2)
 
 
To decrease Prices for Products and/or Variants by a percentage the following scripts can be used:
 
Decrease Product Prices by Percent:
Update Smith_Products
set UnitCost = UnitCost - (UnitCost*.1)
 
 
Decrease Variant Prices by Percent:
Update Smith_ProductVariant
set PriceAdjustment = PriceAdjustment - (PriceAdjustment*.1)