Parts Catalog Price Matching

What it is

Python scripts that enrich a distributor's master parts catalog with pricing by fuzzy-matching seven historical price books and a vendor price file against it. Every master item gets a best match per source with a confidence flag, and a later pass applies exact item-ID matches from a supplier file and rebuilds a 'no price' sheet by category in versioned workbooks.

The problem

Thousands of catalog items had no usable price because pricing lived in mismatched spreadsheets.

How it works

1. Normalizes descriptions and extracts numeric tokens such as sizes and thread counts to avoid false matches
2. Reverse matching from master to source with three rapidfuzz scorers combined and a confidence tier per match
3. Per-source match workbooks plus one enriched master, with an audit script to check the output
4. Versioned follow-up pass applies exact item-ID matches from a supplier price file and regenerates the unpriced-by-category sheet

Stack

Disciplines

For your business

Catalog and price-list reconciliation that merges messy supplier spreadsheets into one priced master with confidence scoring.