Price List Updater for Microsoft Excel

The Price List Updater add-in for Microsoft Excel will quickly and easily update your price list. It took less than a minute to update 10,000 new prices among 100,000 prices! The Price List Update generates a report showing which prices were updated, the old and new prices, the amount and % of price change. The following is a sample report: The line in yellow above represents a new product that was not in the old or main price list. Some users will first run the above report, sort on price change, and then use this list to update prices that should go up. For those that are lower, they do not update, leaving the old prices to maximize profit. The price Analysis report insures that you know what prices changed and by how much. Although we use the word "prices", prices can selling price, cost (the price you bought something for), or any value you wish to update from one list to another. Once you select the option you want, you are prompted for the the old and new prices and for the columns containing their identification or product numbers. Data is loaded based on identification numbers or product numbers. The Price List Updater is very menu driven. The Price List Updater can do the following: Update price or cost Between large lists extremely quickly Generate a report on what prices are updated - and do so before you load the data so you can correct mistakes On this report identify which new prices are not found in the destination file Show the price change and percent change on any price that is updated Color code and Mark (column entry) any new prices that are not loaded Color code and mark the old prices that are updated