...
- Run a price book run for all products
- Add quantity on hand to the price book run log
- Filter the price book run log to only show products where the list price has changed
- Export the price book run to Excel and add a column with a formula being (newvalue/oldvalue) * 100 as the percentage change is sell price. Then sort the excel data by the new column.
- Review the large positive and large negative changes on the spreadsheet
- For product where you do not want the data to change to match the price book. Go to the product and in the catalogue update tab, set ignore changes to sell prices and ignore changes to cost prices to be true
Click on the link provided on how to create a price book run Creating a price book run
Repeat the above procedure until you get a price book run which only includes acceptable sell price changes, then post that price book run.
...