How do I update the cost prices on my items to match the cost prices from my SIM suppliers?

We've recently added the option for our US SIM Suppliers to include cost prices in the product data that they send us. Any newly imported products from this point onwards will include cost price data from the supplier. Existing items won't be affected, unless you choose to update them.

We always recommend checking and amending cost prices at the Goods In stage of receiving stock, but if any of your items currently have a $0 cost price, this is a great way to update those items with a more realistic cost price.

If you need to update the cost prices on existing items from SIM, you can do this using a combination of two of our wizards – the Revalue Stock Wizard and the Supplier Information Wizard. You'll need to use both wizards to complete the process.

Revalue Stock (Cost Prices) 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 (if you have multiple stores, you'll need to do this for each one), then choose how you want to add items to the wizard.

4) Add the items to your wizard – in this case, we'd recommend using Search and Select Items. You can then filter the results to only show items with a $0 cost price:

Use the Select All button in the top left to select them all, then click on Create Wizard.

5) 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.

6) Before you commit the wizard, click on the Generate File button near the bottom – this will download an Excel spreadsheet of all the items in this wizard (we'll need this later on).

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

Supplier Information Wizard

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

2) On the Wizards page, choose Supplier Wizards, then Supplier Information Wizard:

3) You'll see there are several options for adding items to the Wizard in order to work with them – in this case, you want to choose Import List of Codes:

4) Next, find the file that we downloaded from the Revalue Stock Wizard earlier (step 6), and open it in Excel. Highlight all of the columns apart from the Item Lookup Code column – make sure you highlight the whole column, not just the cells with data in them. Delete those columns by right-clicking on what you've selected and choosing Delete from the menu that appears.

Your file should now look something like this:

5) Delete the top row, just as you deleted the other columns in step 4.

Your file should now be just a list of codes in column A, a bit like this:

Save the file somewhere sensible and close it.

6) Back on the Supplier Information Wizard page, upload the file you just edited either by dragging it onto the green box, or clicking on the green box and selecting the file.