What changed in this supplier's price list?
Most of the work on a new price list is lining it up with your current catalog. Match the supplier's columns once and every later list arrives as its changes.
Why comparing lists by hand is slow
Suppliers rename columns, change layouts and drop items without saying so.
Match columns once per supplier
Pick which columns hold the item number, name, cost, price and unit.
See new, dropped and repriced items
Every cost or price that moved shows old next to new. Unchanged rows stay out of the way.
- Example
- +5.3%CB-1200-HDGCarriage bolt 1/2-13 x 12 in, hot-dip galvanized, box of 10Cost
$118.00$124.50Price$189.00$199.00 - DroppedHX-0410-SSHex cap screw 7/16-14 x 1-1/2 in, stainlessLeaves the storeCost$15.10Price$24.60
1,988unchanged since 2 Oct
A bad sheet changes nothing
A list with no item number column, or the same item number twice, is refused with the rows named. Your catalog stays as it was.