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.

Northwind Electrical Supply
October price list · northwind-2026-10.xlsx
Example
Rows
32
Matched
30
To review
10
  • NW-60014Big increase
    THHN 14 AWG, per ft
    0.1100 → 0.1380
    +25.5%
  • NW-10220Pack size changed
    Pushbutton, box of 10 → 12
    95.00 → 92.00
    −3.2%
  • NW-30001Price basis changed
    Terminal block, per 100 → each
    0.6200 → 0.6500
    +4.8%
  • NW-30101Possible match
    PSU QUINT4 24V 10A
    — → 318.00
    New
22 exact matches within your thresholds: approved.

How it works

  1. 1

    Upload the file

    Excel, CSV or PDF, as the supplier sends it — or forwarded to your inbox address.
  2. 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. 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. 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. 5

    Review the exceptions

    Increases and decreases beyond your thresholds, new and discontinued items, pack or unit changes, uncertain matches.
  6. 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