This process will explain how to bulk update List Ex price on stock. You can also bulk update kit pricing in this manner and it will not affect the pricing of the stock within the kit.
This example explains how to update List Ex on multiple stock codes.
1.Run a stock list filtered as required, then right-click and select Export Stock Header Data.
2.Save the resulting spreadsheet to your computer, then open in Excel.
3.Remove all columns except Stock Code and RRPrice, and delete any rows you don't want to update.
4.Make the required adjustments to the List Price Ex/RRPrice figure, then save your updated spreadsheet.
5.Import the spreadsheet via Tools > Import Data > Stock (Header only).
6.Mapping should be automatic at Step 3.
7.At Step 4, select Load data to grid from source. You will receive a warning that there are errors, which you can ignore. Click Synchronise.
8.Once the test is successful, click Next to complete the import at Step 5.
Further information
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
Report Showing all Vendors on Stock
Stop Users From Giving Discounts
Update Existing Vendor Pricing
Update Lead Time on Vendor Tab