To begin, go to Stock > Create Stock List on the ribbon and run a filtered list of the stock requiring updating. Right click in the grid and select Export Procurement Data.
In all cases, keep the Stock Code column and remove all other columns except those columns you wish to change.. Make your changes to the pricing, then save the file.
On the ribbon go to Tools > Import Data and select Import destination: StockLocation Procurement.
Click Next. Select the Source File name and open the saved spreadsheet. Map the Source Field Name to the Destination Field Name if not already done.
Click Next, then Load data to grid from source.
When you load the data you will receive a warning that there are errors. Please ignore this warning.
Click Synchronise, (this step is important as it ensures everything is ok to bring in to Jim2.) You will receive a pop up advising that the data test was successful.
Click Test Data, then Next.
Select Import data and you're done.
Further information
Consignment Stock for Customers
Kitting v Packaging v Manufacturing
Backfill Stock Sold in Advance
Buy and Sell in Different Measures
Change a Serial Number on a Stock Record
Export a Stock Report to Spreadsheet
Generate Backdated Stock on Hand Report
Move Stock from Depleting to Asset
Stop Users From Giving Discounts
Update Existing Vendor Pricing
Update Lead Time on Vendor Tab