Update Stock List Price Ex

In this example, we will update List Price ex GST.

Note: You cannot update kitting or packaging stock prices using this method.

To begin, go to Stock > Create Stock List on the ribbon and run a filtered list of the stock requiring updating. Choose the Stock List – Export report, then save the file.

Note: As there can be rounding issues if updating List Price Inc, it is best to always update List Price Ex.

In all cases, keep the Stock Code column and remove all other columns except the List Price Ex GST column (this may be named differently depending on your setups. Make your changes to the pricing, then save the file.

On the ribbon go to Tools > Import Data and select Import destination: Stock.

Click Next. Select the Source File name and open the saved spreadsheet. Map the Source Field Name to the Destination Field Name. In the below example it is RRP Price.

Click Next, then Load data to grid from source. Click Synchronise, (this step is important as it ensures everything is ok to bring in to Jim2.) Test Data, then Next

Select Import data and you're done.