Supplier Price List Comparison

Compare an old and a new supplier price list to find price increases, decreases, new products and discontinued lines, with the percentage change for each.

Reviewed by Dany, RightSums team · Updated

Files are processed in memory and never stored.

procurement · Business · UK & US

Upload the current price list and the new one as Excel (.xlsx, .xls, .ods), CSV, PDF, Word or text. The tool reads the product code, description and price from each list and pairs products by SKU, or by a very close description match when there is no code. Each product is marked Increase, Decrease, Unchanged, New Product or Discontinued, with the old price, new price, difference and percentage change. You set an alert threshold, 10% by default, and any increase at or above it is flagged. The summary counts each type of change and gives the average increase across the products that went up. Files are processed on our server and not stored. Export the results to Excel or CSV, or copy the table.

Accepted inputs

  • Excel (.xlsx, .xls, .ods)
  • CSV
  • PDF
  • Word (.docx)
  • Text (.txt)

Outputs

  • Excel (.xlsx)
  • CSV
  • Copy to clipboard

How to use the Supplier Price List Comparison

  1. Upload the old price list and the new price list, and set the alert threshold if 10% does not suit you.
  2. The tool reads the code, description and price for every product in both lists.
  3. Products are paired by SKU or a close description match and marked Increase, Decrease, Unchanged, New Product or Discontinued.
  4. Review flagged increases and the summary counts, then export to Excel or CSV.

Frequently asked questions

How do I compare two supplier price lists?

Upload the old list and the new list. The tool pairs each product by its code or description and shows the old price, new price, difference and percentage change in one table, with new and discontinued products listed as well.

How is the percentage price change calculated?

It is the difference divided by the old price, times 100. A product that goes from £10.00 to £11.50 has risen by £1.50, which is (11.50 − 10.00) ÷ 10.00 × 100 = 15%. With the default 10% threshold, that increase would be flagged.

What is the alert threshold?

It is the percentage increase you want to be warned about. Any product whose price rises by that amount or more gets a warning mark, and the summary counts how many items are above it. The default is 10% and you can change it before running the comparison.

How are discontinued and new products found?

Any product in the old list with no match in the new list is marked Discontinued. Any product in the new list with no match in the old one is marked New Product. Matching uses the SKU first, then a close description match of at least 85% similarity.

Which file formats work best?

Excel and CSV files work best because the tool can read the column headings, such as Product Code, Description and Price. PDFs and Word files work when each product sits on its own line with its numbers. Each file can be up to 30MB.

Related tools

  • PO vs Invoice Checker

    Upload a purchase order and the supplier's invoice to see price variances, quantity differences, missing lines and items you never ordered.

  • Supplier Quote Comparison

    Upload 2 to 10 supplier quotes and see unit prices side by side, the cheapest supplier for each item, total costs, delivery charges and lead times.

  • Product Catalogue PDF to CSV

    Extract product codes, descriptions and prices from a supplier catalogue or price list PDF into a CSV or Excel file you can import.