On Monday morning, the greengrocer sends this week’s price list: a PDF, sometimes just a photo. The chef skims it, places the order, and the sheet ends up in a folder. Ten days later the invoice arrives — and nobody checks that the prices invoiced are the ones on the list. Yet the supplier price list is a basic tool in any professional kitchen. Kept properly, it is how you order, compare, negotiate and check. Kept badly, it is just one more list of prices.

Supplier price list vs order guide

Two documents tend to go by similar names.

The supplier price list sets out the prices a supplier offers for a given period: the week for fruit, vegetables and fish, the month or year for dry goods and drinks. On fresh produce these prices follow the market, so a price is only valid until the next list. French kitchens call it the mercuriale.

The order guide is yours: the list of products your site actually buys, each with its supplier, pack size and reference price. Some kitchens call it a market list or an order sheet. It is the backbone of ordering, recipe costing and invoice checking.

List price, negotiated price, invoiced price

Three prices circulate for the same product. Do not confuse them.

PriceWhat it isWho sets itValid
List priceThe price the supplier offers for the periodThe supplierUntil the next price list
Negotiated priceThe price agreed with youYou and the supplierFor the length of the agreement
Invoiced priceThe price actually charged on the invoiceThe supplier, at invoicing—

All three should match. Their gaps are where supplier invoice errors and the small increases that erode margins hide.

A restaurant order guide template: the columns that matter

Here is a simple template to copy into a spreadsheet. The figures are examples.

Product (your own name)Supplier and codePack sizeUnit pricePrice per kg or LValidPrevious priceChange
Unsalted butter 82%Supplier A, code 1234Case 10 × 1 kg92.00 per case9.203–30 Nov89.50+2.8%
Double creamSupplier B, code 5678Pack 6 × 1 L27.60 per pack4.603–9 Nov27.600%
CourgettesSupplier C5 kg box2.10 per kg2.103–9 Nov1.85+13.5%

Four columns make the difference:

  • Your own product name. One name per product, whatever the supplier. “BUTTER UNSLTD 10X1KG” and “Unsalted butter block 1 kg” are the same product: they belong on the same row.
  • Price per kilo or per litre. The only column that lets you compare two suppliers or two pack sizes. For conversions and preparation losses, see our method for comparing supplier prices per kilo and per usable kilo.
  • Validity. On fresh produce, a price without a date means nothing.
  • Previous price and change. They show an increase when it lands, not three months later.

Depending on your needs, add an alternative supplier and its price, the category, the origin or the season.

How to keep supplier prices accurate

  1. Start from what you actually buy. Not the supplier’s whole catalogue, but your invoices from the last few months. Begin with the products that weigh most by value.
  2. Update at the pace of the market. Every week for fresh produce, at every price change for dry goods and drinks.
  3. Keep the history. Do not overwrite the old price: history is what reveals a trend, and it is what you will bring to the next negotiation.
  4. Check the list against the invoice. The price on the list is not always the price invoiced. This check extends three-way matching of order, delivery note and invoice.
  5. Compare across suppliers and sites. Per kilo, at equal quality. In a group, the same product bought at different prices from one site to the next always deserves an explanation.
  6. Allow for seasonality. An increase on an out-of-season vegetable does not call for the same response as one on stable dry goods. Compare with the same month last year.

When a gap persists and the market does not explain it, it is time to open the discussion: see our method to push back on a supplier price increase.

Where the spreadsheet stops working

A spreadsheet works for one site and a handful of suppliers. Beyond that, it soon shows its limits, as we explained in why Excel is no longer enough:

  • Re-keying. Every price list received as a PDF has to be copied in, every week, for every supplier.
  • Changing descriptions. The supplier renames a product or changes its pack size, and the row no longer matches.
  • The listed price, not the price paid. The spreadsheet holds what the supplier offers; what it invoices sits in another folder.
  • Multiple sites. One order guide per site, versions that drift apart, no consolidated view.

An order guide built from your invoices

With the Eqolux purchase catalogue, you no longer type up your order guide: it builds itself from what you actually pay.

  • Every product you buy, referenced automatically. Products extracted from your invoices and delivery notes join the catalogue with no data entry or import project, with clean descriptions, harmonised units and consistent categories.
  • Price history, product by product. Every price paid is dated and linked to its supplier, and can be compared per kilo or per litre across suppliers and sites.
  • Complete product records. Tags, origin, seasonality, linked documents: everything you know about a product, in one place.
  • All of your purchasing. Products and services, food and non-food: if you paid for it, it is in the catalogue.

The catalogue then works everywhere else: to order from all your suppliers in one catalogue, at your negotiated prices; to be alerted when a price paid moves away from its history or the negotiated price; to value stock at the last price actually paid.

Key takeaways

  • The supplier price list gives the price offered for a period; your order guide sets your products, suppliers and reference prices.
  • List price, negotiated price and invoiced price should match: their gaps are what you need to watch.
  • The columns that matter: your own product name, price per kilo or litre, validity, previous price.
  • A useful order guide is updated at the pace of the market, keeps its history and is checked against the invoice.

Want an order guide that stays up to date without re-keying? Explore the Eqolux purchase catalogue or book a demo on your own invoices.