Reorder Level and Low Stock Alerts: How to Never Run Out of Stock
Learn how to set a reorder level for each product with the reorder point formula, Naira examples, safety stock tips and low stock alerts that keep shelves full.
By Ajinex Team · · 9 min read
In this article
A reorder level is the stock quantity at which you must place a new order so the goods arrive before you run out. Get it right and your shelves stay full without tying up all your cash in stock. Get it wrong and you either lose sales to the shop next door or you watch your money sit on a shelf as dead stock.
Most Nigerian shop owners manage this by eye: when the noodles look low, somebody goes to the market. That works for a one-counter shop with fifty products. It stops working at five hundred products, two branches, or a manager who does not notice until a customer asks.
This guide gives you the reorder point formula with worked examples in Naira and units, explains lead time and safety stock in Nigerian conditions, introduces ABC analysis in simple terms, and shows how low stock alerts in software do the watching for you.
The reorder point formula
The formula is short:
Reorder level = (average daily sales × lead time in days) + safety stock
In words: enough stock to cover the days you will wait for a delivery, plus a cushion for the days when sales are higher or the supplier is slower than usual.
- Average daily sales: units sold per day, taken from your sales report over the last 4 to 8 weeks.
- Lead time: days from the moment you decide to order until the goods are on your shelf and ready to sell.
- Safety stock: extra units held for the unexpected.
Worked example 1: noodles in a provision store
- Average sales: 12 cartons a day
- Lead time: 2 days (ordering from a distributor in the same city)
- Safety stock: 1 extra day of sales, 12 cartons
Reorder level = (12 × 2) + 12 = 36 cartons. When stock falls to 36, you order. At roughly ₦9,500 a carton, that is about ₦342,000 of stock on hand at the moment you reorder.
Worked example 2: paracetamol in a pharmacy
- Average sales: 5 packs a day
- Lead time: 7 days (wholesaler in Lagos, waybill to Kano)
- Safety stock: 3 days of sales, 15 packs
Reorder level = (5 × 7) + 15 = 50 packs. A pharmacy needs the cushion because running out of a basic medicine sends the customer, and often their family, to another chemist for good.
Worked example 3: a slow-moving item in a boutique
- Average sales: 1 handbag every 5 days (0.2 a day)
- Lead time: 14 days
- Safety stock: 1 unit
Reorder level = (0.2 × 14) + 1 = 3.8, so round up to 4 units. Slow items still need a level, just a low one.
How much to order
The reorder level tells you when to order, not how much. A simple rule is to order 2 to 4 weeks of average sales, adjusted for the supplier's minimum order and carton or bale discounts. More than that ties up cash; less means you pay transport every few days.
Lead time realities in Nigeria
Lead time is where most reorder calculations go wrong, because owners count the supplier's promise and not the full journey. Measure from "I decided to order" to "it is on my shelf".
| Supplier type | Typical lead time (roughly) | What adds days |
|---|---|---|
| Distributor or wholesaler in your own city (Lagos, Abuja, Port Harcourt, Kano) | Same day to 2 days | Traffic, supplier out of stock, waiting for cash to be free |
| Buying yourself at a major market (Balogun, Alaba, Trade Fair, Onitsha Main Market, Kantin Kwari, Ariaria) | 1 to 3 days | Your own availability, transport back, loading |
| Supplier in another city via waybill or transport company | 3 to 7 days | Public holidays, fuel scarcity, waybill delays, bad roads in the rainy season |
| Importer or manufacturer order | 2 to 8 weeks | Clearing, exchange rate changes, minimum order quantities |
Two practical points:
- Cash is part of lead time. If you order only when money is free, the days spent waiting to fund the order belong in the formula.
- Record actual lead times. Note the order date and arrival date for your top products. After a month you will know your real average and worst case rather than guessing.
For businesses with branches in different cities, lead times can differ a lot per branch, which is why reorder levels should be set per branch, not per product. Our guide on managing multiple shop branches covers that.
Safety stock for festive seasons and surprises
Safety stock is the cushion for weeks that do not look like the average. In Nigeria the predictable spikes are:
- Christmas and New Year (late November to early January): beverages, rice, oil, provisions, clothing, electronics, gifts.
- Sallah (Eid el-Fitr and Eid el-Kabir, dates move earlier each year): rams, rice, oil, spices, fabrics, especially in the North.
- Back to school (September and January): stationery, uniforms, bags, snacks.
- Easter and Valentine's Day: cakes, drinks, cosmetics, gifts.
A simple approach: 4 to 6 weeks before a known peak, raise the safety stock on your fast movers to cover 1 to 2 extra weeks of normal sales. Prices often rise just before these periods too, so buying early protects your margin as well as your shelf.
For a more careful calculation when you have the data:
Safety stock = (maximum daily sales × maximum lead time) - (average daily sales × average lead time)
Using the noodles example: if sales can reach 18 cartons a day in December and the supplier can take 4 days, safety stock = (18 × 4) - (12 × 2) = 72 - 24 = 48 cartons, and the festive reorder level becomes 24 + 48 = 72 cartons. After the season, bring it back down so cash is not stuck in stock through the quiet months of January and February.
ABC analysis in simple terms
You cannot watch 500 products equally closely, and you do not need to. ABC analysis sorts products by how much they matter to your sales.
- Run a sales report by product for the last three months, with the total sales value of each.
- Sort from highest to lowest value.
- Mark the products that together make up roughly the top 70% to 80% of sales value as A items. Typically this is only 15% to 20% of your products.
- The next 15% or so of value is your B items.
- Everything left, which is often half your product list but only 5% to 10% of value, is C items.
Then manage each group differently:
| Group | Share of products (roughly) | Share of sales value (roughly) | How to manage |
|---|---|---|---|
| A | 15% to 20% | 70% to 80% | Tight reorder levels, count weekly, never run out, negotiate best prices |
| B | 25% to 30% | 15% to 20% | Standard reorder levels, count monthly |
| C | 50% or more | 5% to 10% | Simple levels or order on request, count quarterly, candidates for dropping |
In a supermarket, A items are usually rice, oil, beverages, noodles, sugar and a handful of toiletries. In a pharmacy they are the common analgesics, antimalarials and antibiotics. These are the products where a low stock alert should be treated as urgent.
Dead stock: the other side of the problem
Reorder levels set too high, or products nobody asks for, create dead stock: goods that have not sold in roughly 90 days. It is cash you have already spent, sitting on a shelf, losing value as it ages, expires or goes out of fashion.
Run a report of products with no sales in the last 90 days and stock above zero. Then act:
- Discount it to clear it, even below cost if it is near expiry. Recovering ₦600 of a ₦800 item is better than ₦0.
- Bundle it with a fast mover.
- Move it to a branch where it does sell.
- Return it to the supplier if they will take it.
- Stop reordering it. Set the reorder level to zero or remove it from the order list.
For pharmacies, dead stock is also an expiry risk; our guide on pharmacy inventory management covers expiry tracking in more detail.
How low stock alerts work in software
By hand, all of this means a weekly count and a notebook of reorder levels. Software does the watching continuously:
- Every product has a reorder level field (sometimes called minimum stock or low stock threshold).
- Every sale, return, delivery and transfer updates the current stock for that product, per branch.
- Whenever current stock falls to or below the reorder level, the product appears on a low stock report or dashboard, and in some systems on a notification.
- The owner or manager uses that list to build the next market order instead of walking the shelves.
The alert appears the moment the thirty-sixth carton of noodles is sold, not three days later when someone notices a gap.
Setting reorder levels per product
- Start with your A items; set their levels first using the formula above.
- Work from a sales report, not memory. Owners tend to overestimate slow items and underestimate fast movers.
- Set levels per branch where you have more than one, because sales rates and lead times differ.
- Set B and C items to a simple rule such as one week of sales plus one unit, then refine the ones that cause problems.
- Review levels every quarter and before every festive season.
- Give a new product a provisional level and correct it after a month of sales data.
In Ajinex, each product carries a reorder level per branch, stock updates with every sale and transfer, including offline sales from the desktop app once they sync, and the low stock report shows what to order across all branches from the owner's dashboard. Stock counts and movement history let you check that the system's figure matches the shelf. See the Stock management software for shops and warehouses in Nigeria page for the full list of stock reports, and read how to do stock taking in a shop for the counting side.
Frequently asked questions
What is the difference between reorder level and minimum stock?
In most software they mean the same thing: the quantity at which a product is flagged for reordering. Some systems also have a separate "minimum stock" (the lowest you ever want to hold, effectively your safety stock) and a "maximum stock" that caps the order. If your software has one field, treat it as the reorder level from this guide.
How often should I update reorder levels?
At least every quarter, and always before Christmas, Sallah and back-to-school. Also update a product's level whenever its supplier changes, because the lead time changes with it. To spot wrong levels, look at which products ran out last month (too low) and which have not sold in 90 days (too high, or drop the product).
Should safety stock be the same for every product?
No. Fast-moving, high-value and critical products (your A items and anything a customer will leave over, like basic medicines) deserve more safety stock. Slow, low-value C items need little or none. Safety stock costs money, so put it where a stock-out hurts most.
Can low stock alerts work across several branches?
Yes, if the software tracks stock and reorder levels per branch. Then a low stock report can show that Ikeja is low on a product Surulere has too much of, and the right action is a transfer, not a purchase. Alerts that only look at total stock across branches hide that problem.
Next step
If you want reorder levels and low stock alerts to run themselves across every product and every branch, start a 30-day free trial of Ajinex at [the sign-up page](/register/). It includes stock per branch, transfers, low stock reports, stock counts and the sales reports you need to calculate the levels in this guide. For the wider picture, see our inventory management software for Nigerian businesses page.
Ajinex Team
The people who build Ajinex, writing from what we learn supporting supermarkets, pharmacies, restaurants and wholesalers across Nigeria. Questions? Talk to us.