Supplier price-list comparison
A pack price can stay the same while each item gets more expensive. Match your SKUs and compare the cost of the actual unit you buy.
No signup or file uploads
1. Add your previous and updated lists
CSV / TSVProcessing stays in this browser. Use UTF-8 files with a header row, up to 10 MB, 20,000 data records and 150 columns per file.
Load two files, check each mapping and confirm the basis to produce a report.
How to use this tool
- Load the previous and updated price lists, or try the paired example.
- Map the SKU, pack price and units-per-pack columns for each file. Choose one unit per pack for per-item quotes.
- Confirm that currency, product specification and unit are comparable. Review cost changes and records that need attention.
- Download the complete comparison report. Table filters help you inspect results; they do not narrow the export.
A worked example
A case of tea at 72.00 for 12 items costs 6.00 per item. The updated case at 72.00 for 10 items costs 7.20: a 20% unit-cost increase, even though the case price did not change. Previous CSV · Updated CSV.
Know the limits
- SKUs match exactly, including spaces, case and leading zeros. We never choose an arbitrary row from a duplicate group.
- Currency is a label. No exchange-rate, tax, shipping, weight or measurement conversion is performed.
- Pack quantities are positive whole-number item counts. Numeric inputs use decimal points, without thousands separators or currency symbols.
- Added and removed mean membership in these files; they do not establish inventory or discontinuation. A percentage change from zero is undefined.
A few useful answers
Why compare unit costs instead of pack prices?
A pack containing fewer pieces can hide a price increase. Dividing pack price by item count makes the same underlying unit comparable.
Can I compare different currencies?
First convert both files to the same currency and basis using a rate you have chosen. This version performs no currency conversion.
What happens when an SKU is duplicated?
The group is held for review rather than matched arbitrarily. Check the source record numbers and resolve the ambiguity in your original files.
Why does a zero previous price have no percentage change?
A percentage change divides by the previous unit cost. That division is undefined at zero, so we report the absolute difference and explain the missing percentage.