Price List Updater

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 for 100,000 products.

The Price List Updater generates a report showing which prices were updated, the old and new prices, and the amount and percentage 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 first run this report, sort on price change, and then use the list to update prices that should go up — leaving the lower ones alone to maximize profit. The price analysis report ensures that you know what prices changed and by how much.

Although we use the word “prices”, prices can be 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 (analyze or update), you are prompted for 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 completely menu-driven.

The Price List Updater can do the following: