A weekly purchasing list from inventory should answer one practical question: what needs to be ordered now, after accounting for what is already available and what is already on its way? For cafés, shops and other small stock-holding businesses, this distinction prevents two common problems: ordering items that are already covered by incoming deliveries, and missing items that will run out before the next purchase can arrive.
The goal is not simply to make a list of low quantities. A useful list connects current stock, expected demand, supplier orders in progress and the timing of the next review. With a consistent weekly routine, purchasing becomes easier to explain, easier to check and more closely tied to what the business actually needs.
Start with a clear weekly purchasing routine
Choose a regular time each week to review stock and prepare orders. The exact day depends on how the business trades and when suppliers deliver, but consistency matters more than the day itself. A café might review before its main supplier cutoff; a shop may review after its busiest selling period. The aim is to leave enough time for orders to be placed, confirmed and received before important items are needed.
Before looking at individual products, decide the planning window. For many businesses, this is the period until the next expected delivery or the next purchasing review. Then gather the same information for every item under consideration:
- quantity currently on hand;
- the quantity needed during the planning window;
- any quantity already ordered from suppliers;
- the expected arrival timing of those orders;
- the quantity that should remain after expected use, where a buffer is appropriate.
This structure helps separate an inventory count from a purchasing decision. Stock on hand tells you what is physically available today. Incoming orders tell you what may become available later. The purchase list should reflect both, without treating an unreceived delivery as if it were already on the shelf.
Review current quantities by priority
Begin with the products that create the greatest operational risk if unavailable. For a café, that may include core ingredients, takeaway packaging, milk or cleaning supplies. For a shop, it may be regular-selling lines, essential consumables or products with longer replenishment times. Prioritising avoids spending all of the review on low-impact items while a critical product is approaching a shortage.
Group items into a practical order such as critical, important and routine. Critical items need an immediate decision because running out would interrupt sales or day-to-day work. Important items may need ordering this week but are less urgent. Routine items can be reviewed after urgent needs are covered.
Count what is actually usable
Use the quantity that can genuinely be used or sold. Check storage areas, shelves and any other locations where the item may be held. If products are damaged, reserved, expired or otherwise unavailable for normal use, do not let them create a misleading picture of available stock. The point is to establish a dependable starting quantity, not merely to repeat an old record.
For each priority item, compare the usable quantity with likely needs before the next replenishment opportunity. A simple question keeps the review focused: if no new stock arrived, would the current quantity cover the period ahead? If the answer is no, the item needs closer attention. If the answer is yes, it may still need ordering depending on incoming quantities, supplier timing and the amount you want to retain as a working buffer.
Turn the review into a quantity decision
A straightforward way to think about the order quantity is:
Amount to order = quantity needed for the planning period plus desired buffer, minus usable stock on hand, minus incoming quantity expected in time.
This is a planning aid rather than a fixed rule. A negative result does not mean that stock should be cancelled; it means the current stock and expected deliveries appear sufficient for the chosen period. A positive result highlights a quantity that may need to be purchased, subject to supplier availability and the business's normal buying approach.
For example, a business may need 30 units before the next delivery, want 10 units left as a buffer, have 18 usable units on hand and have 12 units due to arrive before they are needed. The calculation suggests 10 additional units: 30 plus 10, less 18, less 12. If the incoming order is due after the critical date, however, it should not be counted as coverage for that period.
Check purchase orders already in progress
The most important safeguard in inventory purchasing planning is to review open purchase orders before creating a new order. An item can look low on hand while being adequately covered by a delivery already in progress. Conversely, an order may exist but be due too late, contain a smaller quantity than expected or no longer reflect the business's needs.
For each relevant purchase order, check the supplier, products, quantities and expected delivery timing. Keep the status clear: an order that has been prepared is different from one that has been sent, and an order in transit is different from stock received. This makes it possible to see what is committed without overstating what is available.
When reviewing incoming stock, ask these questions:
- Which items are already ordered?
- How many units are expected for each item?
- When are they expected to arrive?
- Will they arrive before the stock is needed?
- Does the incoming quantity fully cover the anticipated shortfall or only part of it?
If a delivery is expected before the item becomes urgent, subtract that incoming quantity from the amount you intend to buy. If it is expected afterwards, keep the item on the weekly reorder list or consider whether a smaller bridging order is needed. This is why timing matters as much as quantity: two deliveries of the same size can lead to different purchasing decisions when their arrival dates differ.
A system that keeps stock, suppliers and purchasing together can make this review easier. Inventory & purchasing is designed to help small businesses keep quantities current, record movements and view stock, suppliers and purchasing in one place.
Build a supplier-ready buying list
Once stock on hand and incoming orders have been reviewed, convert the remaining needs into an order list that can be acted on. Avoid a vague note such as “buy coffee cups” or “order more cleaning products.” A supplier-ready list should make each decision understandable and reduce follow-up questions when the order is prepared.
For every item to order, include the product name, proposed quantity, supplier and the reason for the order where useful. You may also note the date the stock is needed, especially for time-sensitive products. Grouping items by supplier is practical because it shows what can be purchased together and makes it less likely that an item is missed during ordering.
- List the items with a positive quantity to order after stock and timely incoming orders are considered.
- Group those items by the supplier you normally use for each product.
- Check the proposed quantity against the supplier's usual product format and your available storage.
- Mark urgent items whose timing requires prompt confirmation.
- Record the purchase order once the order is placed, so it becomes visible as incoming rather than remaining only on a separate buying list.
Keep the distinction between a proposed order and a confirmed purchase order. The weekly list is a decision tool; the purchase order is the record of what has actually been requested. Moving information from one to the other promptly reduces the chance of duplicate ordering at the next review.
As purchasing activity grows, it is helpful to keep this workflow in the same place as quantity records. You can explore Inventory & purchasing to manage stock, warehouses, suppliers and purchasing while keeping movements traceable.
Record received quantities when deliveries arrive
The weekly plan remains reliable only when deliveries are recorded accurately. When goods arrive, compare what was delivered with what was ordered. Record the quantity actually received rather than assuming that every order arrived in full. If an item is short, substituted or missing, the next stock review needs to reflect the real outcome.
Receiving is also the moment to update quantities before the products are put away or used. This keeps stock on hand meaningful for everyone who relies on it. A recorded incoming quantity becomes available stock only after it is received; until then, it should remain an expected quantity rather than being counted as physically available.
Use a simple receiving checklist:
- verify the delivered products and quantities;
- record what was actually received;
- note any differences from the purchase order;
- put stock in the appropriate storage location;
- follow up on missing or incorrect items with the supplier when needed.
This final step closes the loop between planning and reality. It improves the next weekly purchasing list because the starting quantities and incoming-order information are more trustworthy.
Keep the list useful week after week
A strong weekly reorder list is not a one-time spreadsheet exercise. It is a repeatable habit: review usable stock, check open orders and arrival timing, calculate what remains uncovered, prepare orders by supplier and record what arrives. Over time, the routine reveals which products require closer attention, which suppliers need earlier ordering and where stock records need better discipline.
Do not aim for a perfectly complicated forecast. Aim for a clear decision based on the information available today. By separating stock on hand from stock on the way, your business can buy with greater confidence and avoid treating an expected delivery as a guarantee already sitting in storage.
Explore Inventory & purchasing to view stock, suppliers and purchasing in one place.