$800M+ industrial distributor
One distributor. Five desks of manual work, rebuilt one by one.
Five teams each got a tool built around how they already work, all running on the distributor's own server. AI handles the messy inputs, and people still set every price.
Vendor price files
Every vendor's price changes, in every format, landed on the right part
The problem
Vendors send price updates as spreadsheets, portal exports and PDFs, each laid out differently. Before any cost could change, the pricing desk had to find the part behind every line, catch unit and pack differences, and decide which increases were normal.
The solution
A desk tool reads each vendor's file, matches every line to the catalog, converts units and pack sizes, and flags any change larger than the threshold the desk sets.
Customer sourcing requests
Requests full of loose descriptions, answered with the right part and cost
The problem
Customer requests arrive as lists of loose descriptions and mixed part numbers. Every line had to be identified, matched to a vendor and priced from current cost before the team could reply.
The solution
Drop a request in, and the tool pulls out part numbers and vendor codes, rates each match by confidence, pulls current cost from the ERP, flags codes that look wrong, and writes the questions to send back to the customer.
Utility blanket pricing
A major utility's blanket prices, kept current all year without one fragile workbook
The problem
A major utility customer's blanket price agreements update on a four-to-six-week cycle all year, driven by supplier calendars. One master workbook was the only current record of those prices.
The solution
The tool builds the vendor sheets and the utility's own template for each blanket, and sends only the lines that changed.
Expediting
Every project's dates in one place, instead of one spreadsheet per project
The problem
Each project was tracked by hand in its own Excel sheet, so nobody could see the whole picture across the team.
The solution
One shared tracker for every project's promised and last-confirmed dates, with a history of every change.
Project quotes
Quote requests split by vendor and sent from templates, instead of by hand
The problem
For each project, the team split the materials list by vendor and wrote and sent every request for quote by hand.
The solution
The tool splits each project's list by vendor and sends every request for quote from a template.