Advanced Inventory: Variants, SKUs and Stock Alerts

The five settings most shops skip

Adding products and ringing up sales is the easy half. The half that changes decisions is the handful of fields people click past during setup because the product saves fine without them.

Each of the settings below answers a question you would otherwise guess at: what is actually profitable, when to reorder, what is about to expire, and where the missing stock went. None takes more than an afternoon.

---

1. Variants, and when not to use them

If you sell a shirt in three colours and four sizes, you do not want twelve unrelated entries in your inventory. You want one product with twelve variants — so stock is tracked per combination, but sales roll up to the product when you want the bigger picture.

Enable the variants toggle when adding the product, then assign a unique SKU to every variant. That last part is what lets a scanner distinguish Small Blue from Large Red at the counter; without it, staff search by name and pick the wrong one under pressure.

The mistake in the other direction is using variants for things that are not variants. Two different brands of rice are not variants of "rice". The test is whether the combined figure across all of them would ever be useful to you. If yes, variants. If it would be meaningless, they are separate products and forcing them together makes your reports worse, not better.

---

2. Reorder points, calculated rather than guessed

Most systems have one low-stock alert for the whole shop. That number is wrong for almost everything in it.

Set them per product, and calculate rather than guess:

daily sales × supplier lead time in days + buffer

A product that sells 10 a day from a supplier who takes 3 days needs the alert at around 35, not at 5. An expensive appliance that sells twice a month from a supplier who delivers next week needs it at 1. Using the same threshold for both means you run out of the first and over-order the second — the two failure modes people usually think of as opposites, caused by the same setting.

Two adjustments worth making once you have the basic number:

• Raise the buffer on anything you cannot substitute. Running out of a specific prescription line is worse than running out of one brand of biscuits, because the customer cannot be sold something else.
• Raise it seasonally, in advance. A December threshold set in December is already too late; the lead time has not shrunk just because demand grew.

This is the shallow end of demand forecasting — worth reading if reorder timing is your main pain.

---

3. Cost price, and the ranking it changes

The cost price field is the most-skipped and most consequential.

With it entered, two numbers become available that are otherwise unobtainable:

• Gross margin per product. Revenue ranks your products one way; profit ranks them another, and the two lists disagree more often than owners expect. The high-volume item everyone knows as the best seller is frequently near the bottom on margin, which matters the moment you are deciding what to promote or what shelf space to give.
• Stock value on hand. The naira total sitting on your shelves right now. Your insurer asks for it. Your accountant asks for it. If you ever seek financing, that is asked for too, and "roughly" is not an answer.

Enter it at intake, when the invoice is in front of you. Reconstructing cost prices later from memory produces margins that are confidently wrong, which is worse than not having them.

---

4. Categories that answer a question

Do not stop at "Clothes" and "Food". Those group your products but tell you nothing when you read a report.

More useful shapes:

• By supplier — "Vendor XYZ". Turns reordering into one filtered list instead of a scan through everything.
• By season — "Christmas 2026". Makes it obvious in February what is still sitting there.
• By status — "Clearance". Lets you see what discounting is costing you as a single figure.
• By margin band — "High margin", "Low margin". Makes the promotion decision visible at a glance.

The test for any category is whether a report filtered to it would change something you do. If not, it is a label, not a category.

---

5. Batch and expiry, for anyone selling perishables

If you sell food, drugs, cosmetics or anything with a date on it, expiry tracking is the difference between a discount and a write-off.

Set the alert window against how fast the item moves, not against a default. The arithmetic: stock on hand ÷ units sold per week gives the weeks of cover you need. Forty units of something selling five a week needs eight weeks' warning to clear at a modest discount. Thirty days' notice on that item is an announcement that you have already lost the money.

The habit that makes it work is picking up flagged items weekly and doing something — a bundle, a shelf-front move, a small markdown — rather than letting the flag sit until it is a write-off with an alert attached.

---

6. Stock adjustments, with a reason attached

When physical stock does not match the system, the temptation is to correct the number and move on. Do not delete and re-add the item; use a stock adjustment and write the reason.

Two things this buys you:

1. An honest financial record. Written-off stock is a cost. Silently editing the count hides that cost inside your margin, where it distorts every product it touches.
2. A pattern you can act on. One "2 units — water damage" is an accident. The same reason appearing monthly is a leaking roof, and the log is the only thing that would ever have told you.

The reasons worth distinguishing are damage, theft, expiry, supplier shortfall, and counting error — because each has a different fix, and lumping them into a single "adjustment" bucket means none of them get one. This is the same reasoning behind audit logs for theft prevention.

---

What to do first

If you set up nothing else this week:

1. Cost price on your top 20 items by sales volume. One afternoon, and it makes margin real.
2. Reorder points on the same 20, calculated from lead time rather than guessed.
3. Reasons on stock adjustments, from today forward. Costs nothing; the log is worthless without it.

Variants, categories and expiry windows can follow once those three are habitual. A half-configured system used every day is worth considerably more than a fully configured one nobody maintains.