If your system can do automatic product file price updates, for example if you are an Office Brands dealer, there is a procedure you need to follow to make best use of automatic price updates:
- Run a price book run for all product
- 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
Repeat the above procedure until you get a price book run which only includes acceptable sell price changes.
Then post that price book run. Your first price book run will normally be very large and should be posted on the server or on a workstation with lots of memory and processing power.
Finally contact Readysell and have our support team turn on automatic cost and sell updates for you. We would normally set this to run each day for you. You can set it to run once a week if you have a retail area and want to print price change labels only once a week, in order to reduce the time spent replacing labels.
You should not run price book runs on a regular basis. Once you have one good price book run posted you should turn on automatic overnight updates. Then you do not have to load a catalogue or price book run ever again!!!