Try the demo — no signup
Menu
Products
BOM Health CheckCheck a single export for data quality issuesBOM CompareCompare revised BOMs and material exportsMaterial DeltaEstimate the cost impact of revision changesPrice DeltaTrack price movement, quote exposure, and approved alternate pricingQuote CompareValidate supplier quotes against your BOMPrice List CheckFreeCompare two price lists instantlyMaterial Export CleanerFreeFlag spreadsheet junk before handoffDuplicate Part FinderFreeFind repeated part numbers before handoff
Solutions
PrefabricationVDC / BIMProcurementMechanical & FPDistributionNew
Pricing
Resources
Sample reportsBuyer packetSecuritySupport
Log inTry the demo — no signup

Distributor price updates

How to compare manufacturer price lists

When a new manufacturer price list arrives, the hard part is not opening the spreadsheet. The hard part is knowing exactly which SKUs changed, which items disappeared, and which active quotes or buying assumptions may now be exposed.

Who this helps: For distributor inside sales, branch managers, pricing teams, purchasing, and manufacturer/distributor operations.

Compare the old list to the new list

Use the last approved price list as the baseline and the new manufacturer file as the current list. Map the SKU or item number column and the unit price column on both files.

  • Old catalog vs new catalog.
  • Baseline cost list vs updated cost list.
  • Last quarter's price file vs this quarter's update.

Look for four outcomes first

A clean price-list review starts with increases, decreases, new SKUs, and discontinued items. Those are the changes most likely to affect active quotes, counter sales, purchase orders, and branch margin.

  • Price increases that may require quote updates.
  • Price decreases that may update cost records.
  • New SKUs that did not exist in the previous list.
  • Discontinued or removed SKUs that may need substitution review.

Do not convert units or currency silently

If the old file says each and the new file says box, or one source is USD and another is CAD, flag the row for review. Price movement is only useful when the comparison basis is clear.

Checklist

Price list comparison checklist

  1. 1Map SKU or part number on both files.
  2. 2Map unit price on both files.
  3. 3Preserve SKU formatting and leading zeros.
  4. 4Sort by largest percentage increase first.
  5. 5Review new and discontinued SKUs separately.
  6. 6Flag unit, pack-size, or currency differences before trusting totals.

Watchouts

Common mistakes

Using row position

Manufacturer price files often add, remove, or reorder rows. Match by SKU, not spreadsheet row number.

Ignoring removed items

A missing SKU may mean discontinued, renamed, or not included in the current file. It needs review.

Only looking at averages

Average increase hides the handful of items that can blow up active quotes.

Free browser-local workflow

Run the free tool

Use Price List Check to test the workflow on your own material file. Raw files are not stored by default.

Run the free tool