Online shop inventory management: from counting by hand to stock you can trust

Online shop inventory is where most Instagram shops quietly lose money. Not to theft, to nobody knowing exactly how many of anything is left. That produces two expensive mistakes: selling what you do not have, and failing to reorder what is running out.

Tarmeh once counted how often that happened in a single month: three times she said in stock about something that had run out, twice a best-selling size got reordered late because nobody noticed in time. Both come from the same root, the number in her head no longer matched the number on the shelf.

Start by modelling variants properly

The biggest mistake is holding one stock number per product. Linen coat, 12 units means nothing when the customer wants a cream size 38 and you do not know how many of that exact combination are left.

• Every size and colour combination carries its own independent stock count, not a shared number.
• Variants can differ in price, a larger size or a special colour can cost more.
• Give each variant a unique code so packing does not go wrong.
• Keep a photo per colour, it removes half your inbound DM questions.

Automatic decrements: the core of online shop inventory

If you deduct stock manually, there is always a blind window between two updates where you are making a wrong promise. The only durable fix is having order placement decrement stock itself, not a person.

1. 1The customer places an order and the stock is reserved at that moment.
2. 2Once payment is confirmed, the reservation becomes a permanent decrement.
3. 3If the order is cancelled or never paid, the reservation is released back to sellable stock.
4. 4A recorded return adds the item back to inventory.

Thresholds: hear about it before you hit zero

The formula is weekly sales times weeks of lead time, plus a safety margin. If the goods are imported, be generous with that margin.

Cycle counts keep the system honest

Even the best system drifts from reality over time: an unlogged return, a gift pulled off the shelf, a damaged item set aside. The fix is not shutting the shop for an annual count, it is counting in cycles.

1. 1Split products into three tiers by value and sales speed.
2. 2Count best sellers and high-value items monthly.
3. 3Count the middle tier every quarter.
4. 4Count everything else once a year.
5. 5Note the reason for any discrepancy before you fix it, patterns show up there.

Dead stock is cash sitting on a shelf

• Each month, isolate products with no sales in 90 days.
• Total their value to see how much capital is tied up.
• Decide how to clear them: discount, bundle with best sellers, or a seasonal sale.
• Order fewer of that category next time.

Returns: stock that comes back but never reaches inventory

Returns are common in clothing and accessories: a size mismatch, a colour that looked different in photos, or plain second thoughts. The problem is the return path usually is not logged anywhere.

1. 1Give returns their own status instead of just cancelling the order.
2. 2When the item arrives in good condition, return it to stock right away.
3. 3If it is damaged, keep it separate, it is not sellable stock anymore.
4. 4Log the reason for the return, patterns show up after a handful of them.

That logged reason is the most valuable part. If half the returns on one product are about sizing, the problem is your size chart, not the customer.

Wire inventory to where selling happens

Accurate stock only pays off once it is connected to the place customers actually ask questions. When a DM reply is read straight from inventory, replies get faster and nobody promises stock that is not really there.

This is where inventory stops being its own island and becomes part of full online shop management, and where knowing your real profit per product finally becomes possible, because cost price and returns are already sitting next to every sale.

• Set a low-stock threshold for your best seller today.
• Run one cycle count on best sellers this week.
• Pull the dead stock list and decide how to clear it.
• Give returns their own status in your system.