What did your supplier just do to your margin?
Upload the old list and the new one. You get every change, weighted by what you actually sell, and a suggested price per product that holds the margin you have today. Both files are read on this device.
- Free
- No signup
- Runs in your browser
Last list
The prices you are buying at today, with your own sell price if the file has one.
New list
What the supplier just sent.
Sales, optional
Units sold per product. Without it the averages treat a product you sell twice a year the same as your best seller.
Your file stays on this device. This tool runs entirely in your browser. Your file is never uploaded, stored, or sent anywhere. You can disconnect from the internet and it still works.
Add both lists to see the comparison.
How it works
- 1
Add both lists
Products are joined by code, then by barcode, then by name. A renumbered product is still found as long as the barcode survived.
- 2
Add what you sell
Optional, and it changes the answer more than anything else: a 40% rise on your best seller is not the same as one on a product you sell twice a year.
- 3
Decide what to reprice
Each product shows the margin you had, the margin you would keep, and the price that restores it, rounded to whatever ending you use.
What it does not do
- It compares two files. It does not know what your supplier will do next.
- A suggested price protects a margin. Whether the market will pay it is your call.
- It does not write anything back to your systems.
Questions
How are the two lists matched up?
By product code first, then barcode, then name with the words sorted so word order does not matter. A code or barcode match is certain and a name match is marked as a guess on the row. A key that appears twice in a file is never used, because pairing with one of two identical codes would be a coin toss that changes with row order.
What does the weighted figure mean?
The plain average treats every product equally, which flatters or panics for no reason when most of your turnover sits in a handful of lines. Give the tool a sales file and it compares what the whole basket costs at your volumes, before and after, so the figure moves with the money rather than with the number of products. It is shown beside the extra spend those same volumes produce, and the two always describe the same money. Without a sales file no weighted figure is shown at all, rather than an unweighted one wearing a weighted label.
How is the suggested price worked out?
By default it holds the gross margin each product has today: the new cost divided by one minus that margin. Margin is a share of the selling price, not a markup on cost, so 30% margin on a cost of 7 is 10 and not 9.10. You can set one target margin for everything instead, and round to .95, .99, .50, whole units or a cash rounding. Rounding never goes below the price that protects the margin.
Can I send the price change to my customers?
There is a separate download for that, listing only the products whose selling price moves, with the old and new price. Your buying cost and your margin are never in that file, which is the whole reason it is a separate download rather than the same one.
What if the supplier renumbered everything?
Barcodes usually survive a renumbering, so those products are still matched and marked as matched by barcode. Anything genuinely unmatched is reported as discontinued or new rather than being force-fitted to the nearest-looking row.
When this happens every quarter
Vender keeps supplier costs, your price lists and your customer-specific prices in one place, so a supplier increase is a review rather than a spreadsheet exercise.