Inventory Management for Small Shops and Online Sellers in Africa

Inventory management for small business means knowing what you have, what you have sold and what you must reorder before you run out. You do not need expensive software. Stock control for a small shop starts with a notebook or you can track stock with a spreadsheet. A notebook or spreadsheet, a regular counting habit and a few simple rules will protect your cash, which is often locked up in stock. This guide explains stock control for a small shop or online seller in plain steps: how to record stock, how to set a reorder point, how to use FIFO for items that expire, how to handle dead stock and shrinkage, how to do stock taking and when it is time to move to software.

Why stock control matters for small sellers

For many small sellers, stock is the biggest cost and the biggest risk. Too little stock means lost sales and unhappy customers. Too much means money stuck on shelves, items that expire or go out of fashion, and no cash to buy what customers actually want. Good stock control also helps you spot theft, mistakes and damage early, and it makes your pricing more accurate because you know the true cost of what you hold. If you are still setting prices, read our guide on how to price your products for profit alongside this one.

Step 1: List every product and give it a code

Start with a full list of what you sell. For each item write a short name, a simple code (for example BAG-BLK-M for a medium black bag), the supplier and the unit you count in: pieces, packs, cartons, kilograms or litres. Use the same names in your records, your catalogue and your chats with customers. If you sell variations (size, colour), treat each variation as its own line, because each one sells at a different speed.

Step 2: Track stock with a spreadsheet

You can track stock with a spreadsheet on your phone or computer, or on paper if you prefer. Here is a simple layout, described in words so you can copy it. Make one sheet for products and one for movements.

Products sheet, one row per item

• Item code and name.
• Supplier.
• Cost per unit (update it when your supplier price changes).
• Selling price.
• Opening stock.
• Total received (add up from the movements sheet).
• Total sold.
• Current stock (opening plus received minus sold, minus damaged).
• Reorder point.
• Status: OK, reorder soon or out.

Movements sheet, one row per event

• Date.
• Item code.
• Type: received, sold, returned, damaged, given as sample.
• Quantity.
• Reference: invoice number, order number or customer name.

Record each movement the same day. A short daily habit is much easier than a long weekend of catching up. If you sell through chats, add the order to the sheet when payment is confirmed so you never sell the same item twice. Our guide on selling on WhatsApp and Instagram in Nigeria shows how to keep orders organised.

Step 3: Set a reorder point

A reorder point is the stock level at which you place a new order. A simple way to calculate it:

Reorder point = average daily sales x supplier lead time in days + safety stock.

Here is an illustrative example with made-up numbers. You sell about 4 units a day of an item. Your supplier needs about 5 days to deliver. Your lead-time demand is 4 x 5 = 20 units. You add a safety buffer of 10 units in case of delays or a busy week. Your reorder point is 30 units. When the count reaches 30, you reorder. Review these numbers every month, because sales speed changes with season, price and promotions. If you are unsure about average sales, use the last four weeks of your movements sheet.

How much to order each time depends on your cash, your supplier's minimum order and how fast the item sells. Do not buy so much that your money disappears into slow items. A smaller, more frequent order is often safer for a small business, as long as transport costs stay reasonable.

Step 4: Use FIFO and watch expiry dates

FIFO means first in, first out: sell the oldest stock first. It matters most for food, drinks, cosmetics, medicines and anything with an expiry or best-before date, but it also helps with items that fade, rust or go out of fashion. Practical habits:

• When new stock arrives, place it behind or beneath older stock.
• Write the date received or the expiry date on the carton with a marker.
• Check expiry dates weekly and move near-expiry items to the front.
• Never sell expired products. Some categories are regulated, so confirm the rules with the relevant agency.
• Plan promotions for items that are close to their end date, at a price that still covers your cost where possible.

Step 5: Do regular stock taking

Stock taking is a physical count that checks whether your records match what is on the shelf. For a small shop, count fast-moving items weekly and everything monthly. Choose a quiet time, count each item twice, and write the count next to the record. Where numbers differ, find out why before you adjust. Common reasons are unrecorded sales, wrong item codes, damaged goods thrown away without a note, items given away and theft.

A good habit is a spot check: pick five random items at the end of each day and compare shelf to sheet. If you have helpers, rotate who counts so mistakes and shortcuts come to light without accusations.

Handle dead stock and slow movers

Dead stock is stock that has not sold for a long time and is unlikely to sell at full price. Find it by sorting your sheet by the date of the last sale. Items with no sales in several months deserve attention. Options include:

• Bundle them with a popular item.
• Discount them clearly for a short period.
• Sell in bulk to another trader.
• Return to the supplier if they allow it.
• Donate or write off items that cannot be sold, and note the loss in your records.

Then learn from it: why did it not sell? Wrong price, poor photos, wrong season or no demand? Before reordering a similar product, test with a smaller order. If you sell as a producer, you may also like our article on how to scale a factory beyond the local market with distributors, which discusses demand and planning at a larger level.

Reduce shrinkage

Shrinkage is the stock you lose through damage, theft, errors and spoilage. You cannot remove it fully, but you can reduce it.

• Store goods off the floor and away from water and sunlight.
• Keep high-value items in a locked or visible place.
• Limit who can take stock, and note every sample or gift.
• Check deliveries against the invoice before the driver leaves, and record any shortage or damage the same day.
• Pack parcels carefully so items arrive undamaged.

When to move from a spreadsheet to software

A spreadsheet is enough for most sellers with a modest number of products. Consider stock software when you have several hundred items, sell through more than one channel, have staff entering sales, or lose time to counting errors. Look for tools that work on a phone, handle your local currency, show low-stock alerts and let you export your data. Try a free or trial version first, and keep your spreadsheet as a backup until you trust the new system. If your business is also becoming more formal, see our guide on registering a business in Nigeria.

Frequently asked questions

How often should I count my stock? Count fast sellers weekly, do spot checks daily if you can, and count everything monthly. Count again after busy periods.

What is a reorder point? It is the stock level at which you place a new order, so that you do not run out before the delivery arrives.

What is the difference between FIFO and LIFO? FIFO sells the oldest items first. LIFO sells the newest first. For items that expire or go out of fashion, FIFO is usually the safer habit.

How do I avoid dead stock? Start with small test orders, watch sales speed, reorder only what sells and clear slow items early.

Can I use Excel or Google Sheets? Yes. Either works. Pick the one you can open on your phone and back up regularly. Comilmart's team publishes this guide and names these tools only as common examples.

Do I need to count if I only sell online? Yes. Online sellers who oversell items they do not have face cancellations and angry customers.

Getting started

This week, list your products, count everything once and set up the two sheets above. Calculate a reorder point for your top five sellers. When your stock is under control and you can promise availability with confidence, register on Comilmart to reach more buyers across Africa; there are no listing fees to get started.