You can use the Revalue Stock (Cost Prices) Wizard to update cost prices in bulk. We would always recommend checking and adjusting cost prices at the Goods In stage, but if ever that stage of the process is missed, you can use this wizard to rectify it.

Creating a wizard

1) In the main menu in the Back Office, expand the Wizards & Imports heading, then click on Wizards.

2) Click on Store Wizards, then on the Create Wizard button on the Revalue Stock (Cost Prices) Wizard.

3) Select the correct store from the dropdown, then choose how you want to create the wizard from the options – if you missed the cost prices stage in Goods In, you can choose Items on Purchase Order or Transfer to find those specific items. Or you can use Search and Select to add the items to the wizard.

4) Your wizard will look something like this. You can alter the cost prices by clicking into the Cost Price column and typing in the new cost for each item, or you can use the Update using SIM button near the bottom to use the cost prices from SIM. Any changes you make will autosave, so it's a good idea to double check them.

5) If all of the prices in the wizard need to be changed in the same way, for example if a supplier has decided to increase all of their items by 5%, you can do that in bulk. Click on the Modify All option at the top of the Cost Price column to increase or decrease the cost prices of each item by a percentage of the current cost, the selling price or the MSRP:

6) Once you're happy with the changes you've made, click on Commit Wizard to process those changes.