E-commerce11 min read

Inventory Management for a Small Online Store: Johannesburg (2026)

Mohamed Bah·Fondateur, Kolonell
August 14, 2026
Share:
Inventory Management for a Small Online Store: Johannesburg (2026)

Inventory Management for a Small Online Store: Johannesburg (2026)

E-commerce

The verdict in three sentences

A stockout costs you twice: the lost sale and the acquisition budget already spent to bring that customer to an "out of stock" page, who then leaves for a competitor. Overstock is the opposite mistake: it freezes your cash and depreciates 2 to 3% per month through carrying, obsolescence and breakage. A small online seller does not need an ERP: a calculated safety stock and a connected store module are enough to cut stockouts by 30 to 50% in 2026.

The real cost of both mistakes

You only manage well what you quantify. A stockout is not just a missed sale: it is also the wasted acquisition cost (ads, social, SEO) that drove a customer to an "unavailable" page. Overstock looks free because the goods are "there", but it locks up cash that could have funded other lines.

Cost itemStockoutOverstock
Immediate saleLost (100%)Deferred
Customer acquisition costWasted (~2,000-5,000 FCFA)Recovered
LoyaltyCustomer lost in ~30% of casesNeutral
CashFreedLocked
Monthly carrying02-3% of value/month

The three tools compared (2026 order of magnitude)

CriterionExcel/Sheets spreadsheetIntegrated store moduleDedicated stock app
Setup cost0 FCFAIncluded in the store1,500,000-4,000,000 FCFA
Stock updateManualAutomatic on each saleAutomatic + multi-channel
Low-threshold alertNoYesYes + forecast
Error riskHighLowVery low
Time/week4-6 h30-60 min15-30 min
Stockout reductionLow30-50%40-60%

For most small stores, the module integrated into the store offers the best benefit/cost ratio: stock decrements automatically on each paid order and the reorder alert fires on its own.

Calculating your safety stock

Simple 2026 rule: safety stock = average daily sales × supplier lead time × safety coefficient (1.3 to 1.5). If you sell 4 units/day of an item and your supplier delivers in 7 days, safety stock is about 4 × 7 × 1.4 = 39 units. Below that, you trigger the order.

Need a professional website?

Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.

RotationSales/dayLead timeSafety stock
Fast85 days56 units
Medium47 days39 units
Slow110 days14 units

Mini case study

Oumar, who runs an online sneaker store, tracked stock on a spreadsheet updated in the evening. Result: about 12 stockouts/month on his best-sellers, each costing a sale of about 35,000 FCFA plus 3,000 FCFA of wasted acquisition, i.e. 456,000 FCFA/month in lost revenue. Switching to an integrated module with threshold alerts, he cut stockouts to 5/month and recovered nearly 300,000 FCFA/month. Since the module was included in his store rebuild, payback came in under two months.

FAQ

At how many SKUs does a spreadsheet become unmanageable? Beyond 40 to 50 active SKUs, a manually updated spreadsheet generates too many errors and delays. Displayed stock no longer matches reality, which causes sales of items you don't have.

How much does overstock really cost? Count 2 to 3% per month of the locked value across carrying, breakage and obsolescence. Overstock of 2,000,000 FCFA therefore costs you 40,000 to 60,000 FCFA per month without showing up in your direct expenses.

Does the stock module handle variants (size, colour)? Yes, a good store manages stock at the variant level, not just the product. It is essential for fashion and footwear, where one size can be out while the model still shows as available.

Can stock be connected to several channels (site + social)? A dedicated app allows it by syncing a single stock. For a single-channel seller, the integrated module is more than enough and costs far less.

Let's talk about your project. We build inventory management with threshold alerts and per-variant tracking straight into your store. WhatsApp +221 77 596 93 33.

Tags:#inventory management#inventory#stockout#overstock#online store#johannesburg#cash flow#replenishment
Share:

Mohamed Bah

Fondateur, Kolonell

Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.