Automate Supplier Quotations: A Distributor Scenario
A hypothetical scenario showing how to automate supplier quotations: parallel email requests and an automatic comparison of replies in a spreadsheet.
By Downway Team 3 min read
Anyone trying to automate supplier quotations usually faces the same picture: the buyer emails vendors one by one, waits for replies in mismatched formats, and spends hours building a comparison sheet. This is a hypothetical example, but a typical one, of an electrical-supplies distributor that fixed the problem without replacing its ERP.
The situation before automation
Our fictional distributor has two buyers and around 40 active suppliers. For fast-moving replenishment items, each buyer builds a list in Excel, pastes the items into email bodies and sends them to three to five suppliers.
Replies come back as plain text, PDFs, attached spreadsheets and even chat messages. The buyer retypes everything into a comparison. It takes most of a morning, and decisions are often made on incomplete quotes because someone never answered.
The solution they designed
- One request sheet. The buyer fills a template with internal code, description, quantity and reply deadline.
- Parallel sending. A script reads the sheet and, in one command, emails every supplier on the list with a personalized message and a reply template attached.
- Standard reply template. Suppliers fill in unit price, lead time, payment terms and validity without changing the structure.
- Automatic intake. Replies arrive in a dedicated mailbox. The automation reads the attachments, identifies the supplier and quote number from the subject, and writes values into a consolidated tab.
- Comparison. The sheet highlights the lowest price per item, calculates total cost per supplier and flags missing replies.
- Reminder. Near the deadline, anyone who has not answered gets an automatic nudge and the buyer sees the pending list.
What changes day to day
The buyer spends time on the decision rather than on typing. The comparison puts price, lead time and payment terms side by side, and the lowest unit price does not always win: a supplier 2% more expensive that delivers in two days may beat the cheapest one that takes ten.
In a case like this, the expected result is that building the comparison drops from hours to minutes. Real numbers depend on volume, the number of suppliers and how disciplined each one is about replying.
Lessons from the case
- standardizing the supplier's reply matters more than making the reader clever;
- replies outside the template need a review queue, not the trash bin;
- keep old quotations: they become price history for future negotiations;
- the final decision stays with the buyer, and automation only organizes the information;
- tell suppliers about the new process and give them a channel for questions.
How to apply this in your company
Start with one product category that has recurring suppliers and frequent quotes. Build the sheet template, test it with two or three friendly suppliers, and only then widen it. Once you connect the ERP to create the purchase order from the winning quote, a process automation project can cover that step.
Frequently asked questions
Do I need an e-procurement system to automate quotations?
Not to get started. A standard sheet, email and a reading script handle most of it in small and mid-size operations. Dedicated platforms make sense at high volume.
What if a supplier does not fill in the template?
Accept the reply in another format and send it to manual review, but encourage the standard by making clear that template replies are evaluated first.
Does the automation pick the winning supplier?
It can highlight the lowest price or lowest total cost, but the final choice weighs lead time, track record and relationship, and stays with the buyer.