How to Do a Weekly Stock Count for Your Small Business in Nigeria
A practical guide to doing a weekly stock count for your small business in Nigeria, from setting up a simple stock list to counting fast, finding losses, and ordering at the right time.
Every Nigerian small business owner has had this moment: a customer asks for a product you are sure you have, you search the shelf, the store room, and the back of the shop, and it is not there. Or the opposite happens — you order more of a product, only to find ten cartons already sitting in a corner you forgot about. Both problems have the same cause: you do not know exactly what you have in stock.
A weekly stock count fixes that. It is a simple habit — once a week, you count what you have, compare it with what your records say you should have, and act on the difference. It takes one to two hours, it costs nothing, and it can save you tens of thousands of naira every month in lost sales, over-ordering, theft, and dead stock.
This guide shows you how to set up a stock count that works for a small Nigerian business, whether you sell clothes in Balogun Market, provisions in a shop in Surulere, phones in Ikeja Computer Village, or beauty products from your home in Lekki.
Why a Weekly Stock Count Matters
Stock is money sitting on your shelves. Every carton, every dress, every bottle is cash you have already spent, waiting to be turned back into cash through a sale. If you do not know what you have, you cannot manage that money.
A weekly count stops you from running out of your best sellers. When you know you have only three units of your fastest-selling cream left, you can order more before the shelf is empty. Without a count, you discover the shortage only when a customer asks for it and leaves to buy from your competitor. In a busy market, that lost sale rarely comes back.
It also stops you from tying up money in slow stock. Many shops in Nigeria have shelves full of products that have not sold in months — a colour nobody wants, a size that does not move, a brand customers have stopped asking for. A weekly count shows you which items are not moving, so you can discount them, bundle them, or stop ordering them, and use the money for products that sell.
It protects you from loss. Stock disappears in small ways: a staff member gives a discount without recording it, a customer takes an item without paying, goods are damaged in the store room, or a supplier delivers short. A weekly count catches these losses while they are still small. If you count only once a year, a small daily loss becomes a huge surprise at the end of the year.
Finally, it makes ordering simple. When you know exactly what you have and how fast it sells, you can order the right quantity at the right time. You stop guessing, you stop panic-buying at high prices, and you stop running out of stock during your busiest days.
Set Up Your Stock List Before You Count Anything
You cannot count properly without a list. Before your first weekly count, build a simple stock list for everything you sell. It does not need expensive software; a notebook or a spreadsheet on your phone is enough to start.
List every product with its name, size or variant, and the price you sell it at. Be specific. "Ankara fabric" is not a useful entry, because you may stock ten different designs at different prices. "Ankara fabric, blue floral, 6 yards, ₦12,000" is a useful entry. The same applies to clothes — list the size and colour — and to food items — list the weight and brand.
Give each product a simple code if you have many similar items. A code like "CREAM-01" for your best-selling body cream and "CREAM-02" for the second one makes counting faster and avoids confusion between products that look alike. Write the code on the shelf or on a small label, so anyone counting can find the right item.
Record your starting quantity for each product. This is the number you have on the day you start your stock list. From that day on, every sale reduces the number, and every new delivery increases it. Your stock list is a living record, not a document you write once and forget.
Keep your stock list in one place, and keep it safe. If you use a notebook, keep it in the shop, not at home. If you use a spreadsheet or a free stock app on your phone, back it up regularly. A stock list that is lost or out of date is worse than no list at all, because it gives you false confidence.
If you have a lot of products, start with your top 30 best sellers. Count those every week without fail. Add the rest gradually over the next month. A perfect system you never use is useless; a simple system you use every week is powerful.
The Weekly Count: A Step-by-Step Routine
Choose a fixed day and time for your count, and stick to it. Early Saturday morning before the shop opens, or Sunday evening after closing, works well for many Nigerian businesses, because the shop is quiet and the week's sales are complete. A count done at the same time every week is easier to compare from week to week.
Step one: stop all sales and movements during the count. Do not sell, pack, or move goods while you are counting, or your numbers will be wrong. If you must serve a customer during the count, finish the count for that section first, or note the sale separately and adjust afterwards.
Step two: count one section at a time. Start with one shelf, one rack, or one category, finish it completely, then move to the next. Count the physical items you can see and touch — not what your records say, not what you remember ordering, but what is actually there. Count out loud or use a tally, and write the number down immediately.
Step three: have a second person check the count if you can. The counter counts, the checker writes it down, and for high-value items, the checker counts again. This sounds slow, but it catches mistakes that would otherwise send you ordering the wrong quantity. If you work alone, count each high-value item twice.
Step four: check the store room and the back of the shop, not just the display shelves. Many businesses forget the goods in the store room, under the counter, or in a carton that was never opened. Count every location where stock is kept, including goods you have set aside for a customer or goods waiting to be returned to a supplier.
Step five: note damaged, expired, or unsellable items separately. A torn dress, a cream with a broken seal, or a food item past its expiry date is not sellable stock. Write it down in a separate column so you know its value and can decide whether to discount it, return it, or write it off.
Step six: compare your physical count with your records immediately, while the count is fresh. For each product, your record says you should have a certain number. Your count says you actually have a number. If they match, all is well. If they do not, investigate before you move on — the reason is usually fresh in your mind.
What the Numbers Are Telling You
A stock count is not just about finding missing items. The numbers tell you how your business is really performing, and what to do next.
First, look at what is selling fast. If you started the week with 20 units of a product and you have 2 left, that product sold 18 units in a week. That is a best seller. Make sure you always have enough of it, order it early, and consider whether you should stock a similar product to go with it. Running out of a best seller is the most expensive mistake in retail.
Second, look at what is not selling. If a product has sat at the same number for three weeks, it is dead stock. Do something about it: reduce the price, bundle it with a fast seller, move it to a better position in the shop, or advertise it on WhatsApp. If it still does not sell after a month, stop ordering it. Every naira tied up in dead stock is a naira that cannot buy a product customers want.
Third, look at the difference between your records and your count. A small difference — one or two units — may be a counting error or a damaged item. A large or repeated difference is a warning sign. It could mean theft, unrecorded sales, supplier short delivery, or a recording mistake. Investigate it the same week, while the evidence is still fresh, and change the process that allowed it to happen.
Fourth, work out your weekly sales value. Multiply the number of units sold by the selling price for your main products. This tells you which products bring in the most money, not just the most units. A product that sells 5 units at ₦20,000 brings in more money than a product that sells 20 units at ₦2,000, and it deserves more of your attention and shelf space.
Write a short weekly note for yourself: your best sellers, your slow sellers, any shortages, and any losses. Keep these notes together. After a month, you will see patterns — which products sell at month end when salaries are paid, which slow down during rainy weeks, which peak before festive seasons — and you can plan your ordering around them.
How to Order at the Right Time
The point of a weekly count is to make ordering easy and accurate. Two simple ideas will help you order at the right time, every time.
The first is a reorder level for each product. This is the number at which you place a new order. Work it out like this: how many units do you sell in a week, and how long does it take your supplier to deliver? If you sell 10 units a week and your supplier takes one week to deliver, your reorder level is 10 units, plus a small safety buffer of 3 to 5 units. When your count shows you have reached that level, order immediately. Do not wait until you have 2 units left.
The second is an order quantity. Do not order a random amount. Order enough to cover the time until your next delivery, plus a buffer, but not so much that your money sits in stock for months. If you sell 10 units a week and your supplier delivers weekly, ordering 15 units gives you a week of stock plus a buffer. Ordering 100 units ties up your cash for ten weeks and risks the product going out of fashion.
Keep a small list of your suppliers with their phone numbers, prices, and delivery times. When your count shows you need to reorder, call the supplier the same day. Do not wait until Monday if you counted on Saturday — a two-day delay can mean an empty shelf during your busiest days.
For products you buy from the open market, such as Balogun or Mile 12, plan your market trip around your count. Go with a written list from your count, buy only what is on the list, and check the goods before you pay. A written list stops impulse buying, and checking the goods at the market stops you from paying for damaged or short-delivered items.
Reduce Theft and Loss Without Accusing Anyone
Stock loss is a sensitive topic, but ignoring it costs real money. The best approach is a system that makes loss hard and easy to spot, rather than suspicion and accusations.
Give one person responsibility for stock on each shift, and record who received goods and who sold them. Use a simple sales book where every sale is written down with the product, quantity, and amount, and compare it with the stock count at the end of the week. When sales are recorded properly, a missing item stands out quickly.
Keep high-value items where you can see them, and keep the store room locked when it is not in use. Count high-value items — phones, jewellery, expensive fabrics — every week without exception, even if you skip a count for low-value items one week. Limit who has the key to the store room, and change the arrangement if stock keeps disappearing.
When you find a loss, investigate calmly and fix the process first. Was the item sold without a receipt? Was a delivery counted wrongly? Was a damaged item thrown away without being recorded? Most losses come from a weak process, not from dishonesty, and fixing the process stops the loss from happening again. If the same loss repeats after you have fixed the process, then you have a people problem to deal with directly.
Simple Tools That Make Counting Easier
You do not need expensive software to count stock well, but a few simple tools make the job faster and more accurate.
A notebook with columns for product, opening stock, sales, deliveries, and closing stock is enough for a small shop with fewer than 50 products. Write in it every day, not just on count day, and the weekly count becomes a quick check rather than a full investigation.
A spreadsheet on your phone, such as Google Sheets, works well for a growing business. You can set up formulas that calculate your expected stock automatically, share the sheet with a staff member, and keep a backup in the cloud. It is free, and you already have it on your phone.
A free stock app can help if you have more than 50 products or several staff. Look for one that lets you scan barcodes with your phone camera, record sales, and show a simple report of what is selling. Do not pay for a complex system until your simple system is working well every week.
Whatever tool you use, the rule is the same: record every sale and every delivery on the day it happens. A stock record updated daily makes the weekly count take an hour. A stock record updated once a month makes the count take a whole day, and the numbers will still be wrong.
Frequently Asked Questions
How long should a weekly stock count take?
For a small shop with fewer than 50 products, one to two hours is normal. A larger shop with several hundred products may take half a day. The time drops sharply once your stock list is organised and you count the same way every week.
What if my count does not match my records?
First, recount the product. Most differences are counting mistakes. If the difference remains, check your sales book and your delivery notes for that week. If you still cannot explain it, record the loss, note the date and amount, and watch that product closely for the next two weeks to see if the pattern repeats.
Should I count stock every week or every month?
Weekly is best for a small business, because it catches problems while they are small and keeps your ordering accurate. Monthly counts let a small daily loss grow for four weeks before you notice it. If weekly feels too much, count your fast sellers and high-value items weekly, and count everything else every two weeks.
What to Do Next
- Build your stock list this week, starting with your top 30 best sellers, with the name, variant, price, and opening quantity for each one.
- Pick a fixed day and time for your count, count one section at a time, and compare your physical count with your records on the same day.
- Set a reorder level for each best seller, order as soon as you reach it, and keep a short weekly note of your best sellers, slow sellers, and any losses.
Get weekly tech insights
Join our newsletter for practical guides on web dev, AI tools, and digital marketing — sent every Monday.
No spam. Unsubscribe anytime.