The difference between what you own and what you can sell
This is where most of the mistake starts. The number in your head is not the quantity you can sell. What you can sell is what you own, minus what you promised someone else, minus what is damaged, minus what is held for an existing order. Whoever sells from the first number sells twice without knowing it.
- Quantity on hand: everything in the storeroom or on the shelf, including what is reserved.
- Reserved quantity: what was promised to a customer and not yet delivered.
- Available quantity: on hand minus reserved minus damaged. This is the number you speak from.
A small example: you have six black pieces in size M. A customer agreed on two that have not been delivered, and one piece is damaged but was never recorded. The real available number is three, not six. If this calculation is not clear in the record you will sell those two pieces twice, and the customer will discover the error, not you.
Why does overselling happen? Five real causes
- Sales are recorded late, so the number stays stale for hours or a day, and you sell from a number that was never updated.
- The item exists in more than one place, in the shop, in front of you in a chat, and at the cashier, with no single shared number.
- Sizes and colors are merged into one line, so you think you have twenty pieces when you have twenty of one size only.
- No level warns you before it runs out, so you learn an item is gone the moment a customer asks for it.
- A hold is promised but not written, so you give it to one customer and leave it available for the next.
Four of the five causes are not technical, they are daily habits: recording later, promising without writing, not separating sizes. The first fix is behavioural before it is software.
Step 1: make the unit the smallest thing you sell
Do not record "blue shirt: 20". Record "blue shirt M", "blue shirt L", and "blue shirt XL" as separate units. The same rule applies to color, to any option with a different price, and to packaging sold in different sizes. The unit is not the product, it is the version the customer asks for by name.
The practical test: if the customer might say "I want another size" after you sell to them, that needs its own line. If the size or color changes the price the reason doubles, because you are wrong about the quantity and the money at once.
Watch out for sets and bundles. A two piece set consumes two pieces of its component stock. If you sell the piece separately and the set together, every set sale must deduct from each component, otherwise you reach a set you cannot assemble while thinking its parts are there.
Step 2: one shared number across every channel
If you sell from WhatsApp, from the cashier in the shop, and from an online page, every channel must see the same quantity. When you copy numbers by hand between places, the oldest copy does the selling, and it does not know what happened elsewhere.
- Choose one place as the source, and every other place reads from it instead of editing it.
- If manual copying is unavoidable today, give it one fixed time and write the last update time next to the number.
- Stop selling from the channel that cannot see the number, or give it a known, limited quantity that is not mixed with the rest.
A useful temporary fix: allocate an explicit quantity per channel. For example, hold four pieces for a live session or market stall and remove them from general availability first. Not full accuracy, but it prevents the surprise because the pieces were not sold twice.
Step 3: deduct at agreement, not at delivery
The moment the customer says "agreed" or "confirmed" is the moment to hold it, not the moment of shipping. If you wait until delivery another customer may buy that piece in between, and either way you promised two people one thing. Deduct at agreement right away, even if payment happens on delivery.
- Confirm the order in one written line: product, option, quantity, final price.
- Deduct the quantity from the right unit in the record in the same minute.
- Write that the order is "reserved", not "delivered", they mean different things.
- If the customer cancels, return the quantity with a recorded adjustment and a clear reason, not a silent increase of the number.
- If unconfirmed after two days, ask one question before keeping the hold.
Set a hold duration: a day, two days, or depending on the item. An open ended hold freezes stock nobody may buy, so the item looks available while it is held for a silent customer. Write the duration and return the quantity after it if no reply arrives.
Step 4: a reorder point for each fast item
The reorder point is the number at which quantity triggers an order, not the number at which you run out. The calculation is simple: how much you sell per day, multiplied by the days the supplier takes, plus a small margin for days you sell more than usual.
A hypothetical example: an item you sell three pieces of daily, and the supplier takes four days. You need twelve pieces to cover that period, so ordering starts at that number not after it, otherwise you reach zero before the shipment. Add a margin for two heavy days and it becomes fifteen or eighteen pieces.
You do not need this calculation for every item. Start with your fastest movers, ten or fewer, because they cause most of the apologies. A slow item does not need a reorder point, it needs a decision: should you keep buying it at all?
- Fast item: a written reorder point and a weekly check of the number.
- Medium item: a check every two weeks, and an order as it nears the end.
- Slow item: no reorder, but an offer to clear it before it piles up.
Step 5: record only three movements, and on time
Everything that happens to stock falls into three types: in from a supplier, out by sale, and an adjustment with a reason. There is no fourth type. If you keep to these three the number stays honest, and if you skip one it becomes an opinion rather than a fact.
- In: record the shipment when it arrives, not when its invoice is paid.
- Out: every sale deducts from its specific unit, not from a general line.
- Adjustment: damaged, lost, returned, or a counting error, with a written reason in one line.
- Review: compare the number with the physical count, and never fix a difference silently.
Returns deserve special attention, because a piece comes back to stock in two different states: a sound piece returns as an available unit, and a used or damaged piece does not return at all. Mixing the two ends with selling a piece that is not fit, which is worse than apologizing for a stockout.
A daily and weekly checklist
The lists below are short on purpose. A long list does not get done, and a short one done daily beats a complete system on paper.
- Every morning: review open orders and return held quantities whose period expired.
- After every sale: deduct immediately from the right unit and record the customer name with the order.
- Every evening: check that the number of recorded orders matches the orders actually closed.
- Every week: physically count the fastest movers and compare with the record.
- Every week: review reorder points and adjust them if the selling speed changed.
- Every month: a full count, and a list of items that did not move for a month.
Common mistakes and how to fix them
- Relying on memory: write the number where you can see it before answering any availability question.
- An exaggerated safety stock: holding a lot of everything freezes your capital. Keep a buffer for fast items only.
- Adjusting the number retroactively: "I will deduct at the end of the day" means every answer before then may be wrong.
- Not recording damage: the piece that broke is still in the record, so it shows as available and gets sold.
- A verbal hold: a promise with no writing disappears in two hours, and the piece is sold to someone else.
- Selling a bundle without deducting its parts: the parts show as available while you cannot assemble a set from them.
- One number for all branches: the deduction does not travel, so you think a piece is in the second branch when it sold yesterday.
- Ordering from the supplier at zero: ordering at zero means days with no sales for that item.
If this happens, do this
- If you discover a stockout after promising: tell the customer the same day, before payment or waiting. A late apology is worse than the stockout.
- If you have the same product in another color or size: offer it first with a photo, and leave the decision to them.
- If the item is coming from the supplier: give a specific date, not "soon", a date keeps the order alive.
- If the customer already paid: a full refund or an alternative with their agreement, not a long wait with no options.
- If the same item runs out twice: the problem is the reorder point, not luck. Raise the number.
- If the gap between record and count is large and repeated: find one cause, an entry error, an unrecorded sale, or unwritten damage.
- If you sell on a live stream: allocate a known quantity and remove it from general availability first.
- If the customer cancels after a hold: return the quantity the same minute, a frozen number blocks a real sale.
Ready messages for a stockout apology
A good apology carries three elements: quick acknowledgement of the situation, at least two options, and a date if there is one. An apology with no option leaves the customer to find a solution alone, and they usually find it at another store.
- Apology with an alternative: "The size you asked for is actually gone. I have the same color in a close size, and another color in the same size. Want photos?"
- Apology with a date: "The piece sold out hours before your order. The new shipment arrives on such a day, and I can hold one for you with no payment. Would you like that?"
- Apology with a refund: "Unfortunately the order cannot be completed, and that is my mistake. I am returning the full amount today, and if you want an available alternative I can prepare it right away."
- Apology after a delay: "I learned late that the item was gone, and I am sorry I did not tell you earlier. Here are your options now, and if none fit I will refund immediately."
Notice that each message gives a clear next step, and none promises something you do not have. Promising an unconfirmed date is the fastest way to turn one apology into a complaint.
Where a tool like FIHRIST helps
Everything above can be done with a notebook, a sheet, and one rule: deduct at agreement. That is the way we recommend starting, and it needs no system.
When channels and orders multiply, manual combining gets tiring. In FIHRIST, sizes, colors, and options are recorded as separate stock units, each with its own price and quantity, and every order deducts the quantity sold from the specific option. The order is linked to the customer and the product, an item can be identified with a QR code, and item movement can be compared across two periods to see what moves fast and what piles up. The interface works in Arabic and English.
No system prevents every human error. Someone who forgets to record will make mistakes in any tool, but keeping one number in one place removes the most common causes and makes the error appear the same day rather than when the customer arrives.
Frequently asked questions
What is the difference between quantity on hand and available quantity?
On hand is everything you actually own, including what is reserved. Available is on hand minus reserved minus damaged, and it is the number you can promise a customer. The gap between the two causes most double selling, because the seller reads the first number and promises it to the second customer.
When should I deduct stock, at order time or at delivery?
At agreement, meaning the moment the customer confirms the product, option, and quantity. Waiting until delivery leaves room for another customer to buy the piece in between. Deduct at confirmation, record the order as reserved, close it at delivery, and return the quantity with a recorded adjustment if the customer cancels.
How do I calculate a reorder point for a fast item?
Multiply your average daily sales by the days your supplier takes, then add a small margin for busy days. If you sell three pieces a day and the supplier takes four days, you need twelve pieces to cover the period, and ordering starts at that number or slightly before it. Review the number weekly and adjust it if selling speed changes.
What do I say to a customer whose item sold out after I promised it?
Say it the same day and offer at least two options: a close size or color, a hold from the next shipment with a specific date, or a full refund. Do not say "soon" without a date, and do not send an apology with no next step. Quick acknowledgement protects trust better than trying to cover the mistake.
Do I need a minimum level for every item in the store?
No. Start with your fastest movers only, ten or fewer, because they cause most of the apologies. A slow item is not helped by a minimum level but by a decision: keep buying it or clear it with an offer. Too many levels become a long list nobody reviews, and an unreviewed list is worse than none because it gives false confidence.