An order guide is one list per supplier: what you buy from them, the unit you buy it in, the par level, and when the order has to be in. With it, anyone on the team can place the order, not only the person who has it in their head. Below is a free order guide for a café with five example suppliers and 23 items. No signup.

Download the order guide

Download the free café order guide (CSV) →

It opens in Google Sheets, Excel or Numbers. The suppliers, items and numbers in it are examples. Replace them with yours.

ColumnWhat goes in it
SupplierWho you order from. Sort or filter by this column to get one list per supplier
Order Days, Order ByThe days you order and the cut-off time
Delivery ArrivesWhen that order turns up
ContactThe rep's name and number, or the ordering website
Item, Order UnitWhat you buy, in the unit the supplier sells it in
Par LevelWhat you want on the shelf after the delivery
On HandWhat you count before ordering
Order QtyPar level minus on hand
Last PriceWhat you paid last time, so a price jump stands out

A CSV file cannot carry formulas, so add one and copy it down:

  • Order Qty (J2): =MAX(0,H2-I2)

How to fill it in

1. List your suppliers first. For each one, write the order days, the cut-off time and when the delivery arrives. This is the part that lives in someone's head today. A missed cut-off is an easy way to run out of something you had every chance to order.

2. Put each item under one supplier. If you buy oat milk from two places, pick the main one and note the other in the Notes column.

3. Use the supplier's unit. If the invoice says "case of 12", the order guide says "case of 12". The person ordering should not have to convert anything.

4. Set a par for each item. If you do not have pars yet, the café par sheet template has the formula and a worked example, and the free par level calculator does the sum for you.

5. Copy the last price from your latest invoice. You will update it now and then. Its job is to make you look twice when a case of cups costs more than it did last month.

How to use it on order day

  1. Filter the sheet to the supplier whose order is due.
  2. Count only those items. That is a few minutes, not a full stock count.
  3. Type the counts into On Hand. Order Qty fills in.
  4. Read the list back before you send it. Does anything look too high or too low for the week ahead?
  5. Send it the way that supplier takes orders: their website, a text, a phone call.

Keep a printed copy of each supplier's list where the order is placed. On the day the usual person is off, the order still goes in.

Where an order guide stops

The sheet holds the list. It does not know when a par has gone stale, it does not know a price changed until you retype it, and somebody still has to remember that Tuesday is the dairy order.

QuickStok keeps the same list for you. Photograph a supplier receipt and your items, pack sizes and prices are in; you check them and save. Set each supplier's order days and how long delivery takes. After a count, you get an order sheet grouped by supplier, with a suggested quantity and an estimated cost for each line, and you tick the lines you want. You can also get one email on order days with what to order from each supplier.

It will not place the order for you. It tells you what to order, and you send it or phone it in as you do now.

It is free for one café, and it does not expire. No credit card.

If the spreadsheet is doing the job, keep it. For the weekly count that feeds it, use the café count sheet template.

When the order arrives, check it in with the receiving log template.

Frequently asked questions

What is an order guide?

An order guide is one list per supplier: the items you buy from them, the unit you buy them in, the par level for each, and when the order has to be in. Anyone on the team can use it to place the order.

What is the difference between an order guide and a par sheet?

A par sheet sets how much of each item you want on the shelf. An order guide groups those items by supplier and adds the order days, the cut-off time and the contact, so the count turns into an order for one supplier at a time.

How should I organize an order guide?

By supplier first, then by item in the order the supplier lists them. Use the supplier’s own unit, such as "case of 12", so nobody has to convert when ordering.

Does the template send orders to my suppliers?

No. It is a spreadsheet. It works out the order quantity from your par and your count, and you send the order the way that supplier takes it: their website, a text or a phone call.