Sometimes you need to update Unit Pricing, or Price Level pricing in bulk. You can do this using Bulk Update feature.

First, Export the product list. It is recommended you only keep the products you want to update and remove the rest from the exported list.

To Update Unit Pricing

Add a column to the file named Custom_UnitPrice_{unit} and set the price you want. You can set the price as -1 if you want to unset the overridden price.

Eg: If you have a unit called kg, to update it add a column called Custom_UnitPrice_kg. Make sure the unit name matches exactly.

To Update Base Price for Price Level

Add a column to the file named Custom_PriceLevelBase_{level} and set the price you want. You can set the price as -1 if you want to unset the overridden price.

Eg: If you have a Price Level called Wholesale, to update it add a column called Custom_PriceLevelBase_Wholesale. Make sure the price level name matches exactly.


After making the changes, Goto "Bulk Update Products" and upload the excel.