How to compare quotes from multiple suppliers and close on the best overall deal

Six quotes came back for the same order. One in PDF, two in Excel, one a WhatsApp photo, the rest each thrown together its own way. Every supplier calls the product by a different name, uses a different unit, and lists the items out of order. By the end of the day you have to say which one is the better deal — and the hard part isn't the arithmetic. It's making sure you're comparing the same thing before you crown a winner.

Compare item by item, not document against document

The mistake that wrecks the comparison right from the start is looking at the total down at the bottom of each quote and closing with the lowest one. "Supplier A's quote came to $12k, B's came to $13k, I'll go with A." Except A may not have quoted three items, while B quoted everything. The numbers aren't comparable.

Real comparison means lining things up item by item. Every product in your order becomes a row, and on that row you put what each supplier charged for it. Supplier A's cable faces B's and C's cable, on the same line. That's the only way to see who's actually cheaper on what matters — and who didn't even quote it.

The tedious work is matching the lines up: confirming that one quote's "Flexible cable 2.5mm" is the same as another's "PP cable 2x2.5" before you put them side by side. That's where most errors are born, and it's exactly what you can automate once you extract the items from each quote.

The lowest-unit-price trap

With the lines lined up, the temptation is to paint the lowest price of each item green and add them up. It almost always goes wrong, because the quantities vary. The item you buy by the thousands weighs far more on the total than the item you buy by the dozen.

A simple example, two items and two suppliers:

Item	Qty	Supplier A (unit)	Supplier B (unit)
Cable (meter)	1,000	$2.40	$2.55
Breaker (piece)	10	$38.00	$30.00

By the lowest unit price, line by line: cable from A, breaker from B. Looks clever. Now add up the total cost of buying everything from one supplier:

• Supplier A: 1,000 × 2.40 + 10 × 38.00 = $2,780.00
• Supplier B: 1,000 × 2.55 + 10 × 30.00 = $2,850.00

The $8 you "save" on each breaker adds up to $80 — and it doesn't cover the $150 more that B charges on the cable, the high-volume item. Closing everything with A comes out cheaper and even avoids a second order. The high-volume item drives the total. Deciding by the unit-price column, without multiplying by quantity, leads you to the wrong choice.

The trap of comparing different things as if they were the same

There's a trap trickier than the price one, because it doesn't show up in the math. It's comparing two items with the same quick description as if they were the same product — when they're not.

Take a real case from an electrical purchase. One supplier quotes a PP cable, which is multipolar with a PVC sheath, cheaper. Another quotes a cable with HEPR insulation. At first glance they look like two "cables" and the reflex is to close with the cheaper one. But they're not the same product: a cable with PVC insulation operates up to about 70°C, while one with HEPR insulation is 1 kV class, runs at 90°C, and carries more current at the same cross-section. They're different specs — voltage class and operating temperature. If the project calls for the higher spec, the other one's lower price is worth nothing: it's a different product.

The lesson holds for any category. Before you put two items on the same line and let price decide, confirm they meet the same specification. The lowest unit price is only an advantage when both sides deliver the same thing.

What to look at beyond price

Even with everything lined up and the total cost correct, price is only one of the variables. What actually shifts the decision:

• Missing items. A supplier that quotes 40 of your 60 items forces you to buy the other 20 elsewhere — with freight and a minimum order all over again. Mark the gaps; don't treat an empty cell as zero.
• Freight. Spreading the order across six suppliers to save pennies creates six freight charges. The unit-price savings vanish into shipping.
• Lead time. The cheapest option that delivers in 30 days is no use if the job stops tomorrow.
• Payment terms. An extra thirty days to pay can be worth more than a small discount on price, depending on your cash flow.

There's no single right criterion for every case. An experienced buyer runs more than one — lowest total cost, fewer suppliers, maximum coverage — and compares the results before deciding.

The spreadsheet holds the numbers. The criterion makes the decision — and it has to hold for the same thing on both sides, or the comparison crowns the wrong winner.

How to put suppliers side by side

The method above is the same, with or without a tool. The difference is who does the grunt work of typing sixty items times six suppliers into a spreadsheet. With OrbitQuote, the path is direct: you upload the quotes as they came — PDF, Excel, WhatsApp photo, or crooked scan — it extracts the items with code, description, quantity, unit, and price, and puts the suppliers side by side in a table.

Each item becomes a row, each supplier a column, and the total cost arrives already summed per supplier — no typing. You review, choose what to buy from whom, and close by the criterion that makes sense. At the end, you export the result as PDF, Excel, or WhatsApp-ready text to send the order. And if you'd rather work in the spreadsheet, you can adjust the Excel and send it back to extract again, now with your changes.

Want to structure this first? See how to build a price comparison sheet and, for the bigger picture, how the procurement quotation process works or what procurement quotation is. To get started, the help center shows how to upload the files.

Frequently asked questions

Should I compare by the lowest price on each item?

Not directly. The lowest unit price on each line almost never gives the lowest total cost, because the quantities vary. Multiply price by quantity and sum per supplier before you decide.

Why compare item by item instead of document against document?

Because every supplier sends the items in a different order and with different descriptions. Comparing one whole document against another, you never know whether you're looking at the same product. Item by item, each line faces the same line from everyone else.

Can the cheapest product turn out not to be the same product?

Yes, and it's a common trap. One supplier may quote a simpler, cheaper item while another quotes a higher-spec one that handles more. The lower price is worth nothing if the product doesn't meet the specification you need.

Beyond price, what else goes into the comparison?

Missing items, freight, lead time, and payment terms. A supplier that quotes cheaper but is missing half the items, or delivers late, can end up more expensive across the whole order.

Can I compare suppliers without building a spreadsheet by hand?

You can. You upload the quotes as they came, OrbitQuote extracts the items and puts the suppliers side by side in a table, with the total cost already summed per supplier.