View Cart US $29.95

Quantity
Discounts

Money back
guarantee

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!  It is compatible with Microsoft Excel 2010-2021 and Office 365.

The Price List Updater 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 (analyze or update), 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 completely 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

Customers who viewed the Price List Updater also viewed:

• Productivity Suite - Contains all of our add-ins including the Compare List Assistant.  Save $$
• Address Assistant - Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
• CSV File Creator - Create CSV files the easy way, without Excel's warning messages.
• Data Cleaner - Eliminate tedious manual cleaning of data
• Duplicate Finder & Deleter - Quickly find and remove duplicates in one list or between two lists.
• Text File Importer - Import ASCII or text files with over a million lines!