AI & Automation · Industrial Distribution · Custom Build · 2026

Teaching a Machine to Read a Quote Request Like an Estimator Does

A pipe, valve and fitting distributor

The challenge

Customers sent requests for quote as spreadsheets and emails, every one in a different layout, using their own abbreviations for the same parts. Each line had to be matched by hand against a catalogue of nearly twelve thousand items spanning dozens of product categories — work that needs real domain knowledge of material specifications and schedule-to-wall-thickness conversions, and that only a handful of people could do.

Where we came in

The tempting framing is a parser: teach software the formats and it will read them. That fails on contact, because the variation is not in the layout but in the language. We treated it as a matching problem instead — represent the catalogue by meaning rather than by string, and let the system propose candidates for a human to confirm.

What we did

  • Ran a discovery and architecture phase before writing production code, delivered as a written report rather than a verbal readout
  • Built a data engineering and embedding pipeline that represents the product catalogue by meaning rather than exact text
  • Developed a parsing and matching engine with a web interface for reviewing and confirming proposed matches
  • Stood up a dedicated evaluation phase so accuracy is measured against a held-out set rather than asserted
  • Delivered in numbered phases with a demo closing each one

Where it landed

  • Inbound quote requests are parsed and matched against the catalogue rather than transcribed line by line
  • Matching accuracy is measured against a validation set, so changes to the engine can be judged rather than guessed at
  • Delivered through discovery, data engineering, matching, and evaluation phases to handoff

Technologies

  • Retrieval-Augmented Matching
  • Vector Embeddings
  • Large Language Models
  • Python
  • JWT Authentication

Delivered and closed out in our project management system. Outcomes describe the resulting state — we have not published a measured before-and-after for this engagement.

Back to all projects