Distribution and manufacturing

Quote requests matched to the price list

A customer sends a quote request as a PDF, and the sales coordinator re-types each line into Excel, finds the matching item in the catalog and looks up the approved price. When the customer's codes or units differ from the catalog, each of those lines becomes a search of its own.

Who it is forDistributors and small manufacturers with 10 to 150 staff
Who decidesThe sales coordinator
Where the work livesEmail inbox → catalog and price list → Excel quote draft
BuildTen business days
A desk with a printed multi-page quote request, a thick ring binder catalog lying open, a coil of cable and a small box of brackets beside it, and a printed price list sheet with a pencil resting on it.

Who does what

The hours go into lines that do not match on the first look.

Reading the request The agent reads the PDF and pulls out each line's code, description, quantity and unit.The agent
Matching to the catalog The agent matches each line by code, then by description, using the customer's past matches first.The agent
Pricing from the approved list The agent takes the price from the customer's approved price list and notes which list it used.The agent
Deciding uncertain lines The sales coordinator reviews flagged lines, picks the right item or substitute, and approves any price not on the list.The sales coordinator
Building the draft The agent fills the Excel quote template with matched lines and leaves flagged lines marked.The agent

What you get

An Excel quote draft with each requested line matched to a catalog item and its approved price, and uncertain matches flagged for review.

Draft for review

Quote request
A three-page PDF from a contractor with 42 lines of part codes, descriptions and quantities, some in boxes and some in each.
Draft
An Excel quote with 39 lines matched to catalog items and priced, and 3 lines flagged at the top.
Based on
The contractor's approved price list and the code matches saved from that contractor's earlier requests.
How sure it is Moderate
Why a person decides Two lines had no code match and only a close description, and one asked for feet of cable the catalog sells by the coil.

The rules it follows

It prices from each customer's approved list from the first day.

These are your company's own rules, written down and confirmed with your team during the build. It works on its own only within limits you set.

  • Each customer gets prices from their own approved price list, not the general list.
  • A line with no code match and only a close description goes to the sales coordinator.
  • Quantities are converted to catalog units only where a set conversion exists, such as each to box of 50.
  • Any substitute item or price off the list needs the sales coordinator's approval.

What it learns when your team adjusts its work

Useful from the first day, and it keeps getting better. The sales coordinator reviews its work.

The busywork it takes off the sales coordinator. It takes the re-typing and catalog lookups off the sales coordinator so the day goes to the lines that need a decision. That time goes back to the work only they can do.

What it starts out knowing

  • The catalog with item codes, descriptions and selling units
  • Each customer's approved price list
  • The Excel quote template the business already sends
  • Which lines go to the sales coordinator and which can be drafted

It works from these sources, shows which one an answer came from, and asks when the answer is not there.

Who reviews its work, and when review can stop

At first the sales coordinator reviews every draft before it goes out. Review stops for a routine type of request, such as repeat orders from one customer, once the agent's record on them is good and the business agrees.

Flagged matches, substitutes and any price outside the approved list keep going to the sales coordinator.

It no longer needs review once its record on them is good and you agree, one type of task at a time. New, unusual and high-stakes work stays with a person.

When your team adjusts its work

When the sales coordinator changes a match because a contractor's code HB-12 means the catalog's 12-inch hanger bracket, the change is saved as an exception for that contractor, and next time the agent matches HB-12 from that contractor to the bracket and notes the saved match on the line. The team decides which changes are kept.

It learns how your company does this job. It does not watch, rate or profile your employees. Your team decides what it learns. You can read everything it has learned and remove anything. Whoever runs it, your team or our engineers, makes sure on a regular cycle that what it learned stays inside the bounds you agreed.

From a request a business posted

A business that prepares quotes from a catalog, on a public project request.

The poster wanted customer quote requests read from one agreed format, starting with text-based PDFs. Each request's product codes, descriptions, quantities and units would be matched to a supplied catalog and an approved price list. Uncertain matches would go to a person, and the result would be an Excel quote draft.

Paraphrased from a public post, not quoted, and not a client engagement.

From first principles

Which catalog item and approved price does each line the customer asked for match?

Before we build anything, we take the work down to what has to be true. What is left over is habit. Habit gets deleted, not automated.

  1. What has to be true

    • Each requested line maps to one catalog item or gets flagged.
    • Each price comes from the approved price list for that customer.
    • Quantities are stated in the units the catalog sells.
  2. What is only habit

    Re-typing the request into a fresh spreadsheet before any matching starts is only habit. So is searching the catalog by eye for lines that match on the first try.

  3. What we delete before building anything

    We drop the re-typing step and the second copy of the request. The PDF is read once and the matching starts from there.

  4. What is left

    The agent. Reading each request, matching lines to the catalog and price list, converting units where the rule is clear, and building the Excel draft.

    A person. The sales coordinator decides every flagged match, any price outside the list and when the quote goes out.

The kind of work: Checking and matching. Checking and matching is the work of holding one record against another: a bank line against the books, a delivery ticket against an invoice, a payout against the sales behind it, a customer's request against the price list. People still do it by hand because the records never line up exactly, and someone has to decide what each mismatch means.

What the engagement needs

What we need from you, and how it runs.

The engagement needs read access to the inbox or folder where quote requests arrive, the current catalog and each customer's approved price list. It also needs the Excel quote template and a sample of past requests with the quotes that went out, from QuickBooks, Fishbowl or wherever they are kept.

How the engagement runs

  1. 01

    Fit test first

    We check the time this job takes, access to your systems and how you would review the result. If a ready-made tool is enough, we say so.

  2. 02

    Build in ten business days

    Senior engineers agree the rules with the sales coordinator, test on past cases and set approval limits and a way to switch it off.

  3. 03

    Ninety days of support, included

    Work with the agent in Slack, Teams or text messages. We fix problems and adjust it as unusual cases come up.

  4. 04

    Keep improving it, with your choice of operator

    You own the agent and keep its source, tests and guide either way. Your team runs it, or our engineers run it with a monthly report. Learning continues on your own servers, in your own cloud account or in our data center.

When we'd point you elsewhere

Sometimes a ready-made tool is enough.

The fit test checks this first. If one of these covers your case, we tell you, and you keep the map of the work.

  • Requests come from a few customers who always order from your own item codes. A lookup in a spreadsheet or the quoting feature in your inventory or accounting system is enough.
  • Customers can order from a fixed list online. A customer ordering portal with set price lists is enough.

Honest limits

What this page does not claim.

It starts with text-based PDFs; scanned or handwritten requests need a separate reading step and more review.

The situation is drawn from a public request a business posted, paraphrased, not a client engagement.

Show us the work

More use cases

More work of the same kind: checking and matching.