Supplier price list updates
Upload the supplier's new price list as it arrives. Proceny matches it to your catalog, turns every price into a cost per unit, and shows only the changes that need a decision — before anything reaches your ERP.
- NW-60014Big increaseTHHN 14 AWG, per ft0.1100 → 0.1380+25.5%
- NW-10220Pack size changedPushbutton, box of 10 → 1295.00 → 92.00−3.2%
- NW-30001Price basis changedTerminal block, per 100 → each0.6200 → 0.6500+4.8%
- NW-30101Possible matchPSU QUINT4 24V 10A— → 318.00New
How it works
- 1
Upload the file
Excel, CSV or PDF, as the supplier sends it — or forwarded to your inbox address. - 2
Confirm the columns once
The header and columns are detected. Next time the same layout is re-used; if a column moved, the import stops and says which. - 3
Match to your catalog
By supplier SKU, manufacturer part number, GTIN and links you confirmed before. Near misses are suggestions, never silent links. - 4
Normalise
Prices per 100 or 1,000, packs, boxes and feet or metres become one cost per unit, then your ERP's unit. - 5
Review the exceptions
Increases and decreases beyond your thresholds, new and discontinued items, pack or unit changes, uncertain matches. - 6
Export
A CSV or XLSX in your ERP's import format, with the approved rows only.
The cases that break a spreadsheet update
A lookup on the item code finds most rows. These are the ones that go wrong quietly, and what Proceny does with each.
- The supplier changed its item code
- Matches by manufacturer part number or GTIN as well. A link you confirm is remembered for next month.
- Codes damaged by Excel (1.23E+05, lost leading zeros)
- Flagged as damaged instead of matched to the wrong item.
- Prices per 100 or per 1,000
- Read from a price-unit column, the header (“Price/100”) or the cell (“12.50 / 100 pcs”) and divided out. A basis stated twice, differently, is held. How per-100 pricing works
- Pack size changed (box of 10 → 12)
- Compared per unit, and flagged as a pack change — a flat box price can hide an increase or a decrease.
- A box, carton or roll without a stated quantity
- The cost per unit stays unknown and the row is held for you. Pack contents are never guessed.
- Different units (feet vs metres, each vs box)
- Converted exactly when both are measurable; otherwise held as not comparable.
- List prices with your discount
- A discount column and a per-supplier list multiplier are applied before comparing.
- Items missing from the new list
- Listed as dropped since the last completed list; items marked discontinued are shown as such.
- Two catalog products could match
- Held as “several possible products”. Proceny never picks one for you.
- Prices in another currency
- Flagged. Never converted with a rate you did not enter.
Step by step, with small examples: How to compare supplier price lists · Supplier part number, MPN or GTIN · Check a supplier price increase.
Before anything reaches your ERP
Exceptions first
Exact matches with changes inside your thresholds can be approved in one click. Everything else waits in tabs: increases, decreases, new, discontinued, pack and unit changes.
Every value traced
Each row links to its sheet and cell, or to its highlighted line on the PDF page.
You run the import
Proceny does not connect to your ERP. It writes the file; you import it. Price history builds up per product and per supplier.
PDF price lists are read with each value tied to its line on the page; scanned PDFs and photos are read by OCR, and every row waits for your approval. Supplier price lists in PDF · How your files are handled
Try it with your own files.
Free plan · no credit card