A useful supplier comparison makes its assumptions visible. Unit price alone can hide pack-size differences, freight, minimum orders and non-comparable terms. Start with a repeatable worksheet before building a purchasing application.
Minimum fields
Record supplier, quote date, item identifier, specification, pack size, quantity ordered, currency, unit or pack price, shipping charge, minimum order, lead time and quote expiry. Keep tax treatment explicit. Unspecified costs should remain unknown until confirmed.
A worked example
These numbers are fictional. Supplier A offers a pack of 12 items for $48, plus $20 shipping. Supplier B offers individual items at $4.50 with $5 shipping. For an order of 24 items, A totals $116 and B totals $113 before any applicable taxes or other charges. The lower advertised item price does not produce the lower order total in this example.
Normalize before ranking
- Confirm the specifications describe equivalent items.
- Convert pack prices to an item price without losing the pack-order constraint.
- Calculate how many whole packs the requested quantity requires.
- Add known order-level charges once.
- Flag missing costs, incompatible currencies and expired quotes.
Do not hide a quality or delivery tradeoff
A lower total is not automatically the best offer. Show delivery dates, return terms and specification differences alongside the arithmetic. Where information is missing, use a review status rather than a misleading winner badge. Keep the source quote linked to each comparison.
Test whether automation is worth paying for
Take three recent, anonymized quotations from one buyer and recreate the comparison they actually made. Record the fields that required interpretation. Ask whether the same vendors and formats recur. A one-off clean spreadsheet is weak evidence for subscription demand; repeated manual normalization may support a scoped service.
Read the supplier-price comparison opportunity and counterevidence. Compare other service-first automation ideas.