Retail inventory management is controlling stock where a shop actually loses it: on the shelf, at the till and in each seasonal buy. Most out-of-stocks start inside the store: a worldwide review of 52 studies traced 72% of them to the shop's own ordering and shelf-filling. In a quarter, the goods were in the store but not on the shelf.
This guide follows the stock from the back room to the receipt, worked for an example shop in Egyptian pounds. The general system, its records and its tools, is in our guide to inventory management for small business.
What is retail inventory management?
It is stock control for a shop, where goods move from a delivery to the back room, the shelf and a customer. Each step can lose a sale or a unit. A warehouse ships cartons to a few customers; a shop sells single pieces to hundreds, through several cashiers, in front of the buyer.
| Step | What goes wrong | The record that catches it |
|---|---|---|
| Receiving | A short or wrong delivery is accepted | The purchase, checked against the delivery note before it is marked received |
| Back room to shelf | The goods are in the shop but not on the shelf | A morning check of best sellers against their stock figure |
| The till | A sale isn't rung up, or is rung up at the wrong price | Each cashier's own sign-in and register count |
| Returns | Money goes back without the goods | Returns limited by role, and the return ratio |
| Seasonal ranges | Too much is bought and left after the season | Sell-through, checked at the season's midpoint |
| Counts | The records drift away from the shelves | A count of one category at a time |
Why does the shelf matter more than the store room?
A product in the back room sells nothing, and shoppers who find a gap often buy elsewhere. When an item was missing, 21% to 43% of shoppers bought it at another store and 7% to 25% didn't buy it at all, depending on the category.
Those figures come from Gruen, Corsten and Bharadwaj's out-of-stock study of 2002, built from 52 studies in 29 countries. On average, 8.3% of the items a shop stocked were missing from the shelf when checked.
| Cause | Share of out-of-stocks | What it looks like in a shop |
|---|---|---|
| Store ordering and forecasting | 47% | The order went in late or too small, because the stock figure or the forecast was wrong |
| In the store, not on the shelf | 25% | Cartons in the back room while the shelf is bare |
| Upstream: supplier and distributor | 28% | The supplier was out, or the delivery came late or short |
The study covered fast-moving consumer goods, and it is old, but 72% of the causes it found sit inside the store, where the owner controls them. It blamed most ordering failures on wrong stock records and forecasts.
Find the gap: a best seller with stock but no sales
A fast seller that shows stock on record but sold nothing yesterday is usually not on the shelf, or not in the shop at all. Keep a list of your 20 best sellers and check it every morning.
- Open yesterday's sales by product and mark any best seller that sold nothing.
- Look up its stock figure. Stock on record with no sale means a walk to the shelf.
- Shelf empty and back room full: refill it. Neither: count it, because the stock may be lost.
Refill the shelf on a trigger, not when it is empty
Give each fast seller a shelf trigger: the quantity at which it gets topped up from the back room. The reorder point is a different number, for the whole shop's stock, and tells you when to buy from the supplier.
Shelf trigger = sales between two refills + display minimum
For example, a household goods shop in Giza sells 30 bottles of washing-up liquid a day and refills its shelves twice a day. Up to 30 ÷ 2 = 15 sell between refills, and it wants 6 on show, so its trigger is 15 + 6 = 21. These are illustrative figures, not a real shop's.
At each refill, a shelf at 21 or fewer gets filled to its 48, a top-up of 27 or more. The whole shop's reorder point comes from daily sales and the supplier's lead time: see how to avoid overstocking and stockouts.
How do you stop losses at the till?
Check five numbers at the end of every shift. Most till losses show in one of them, and ArmPOS records all five.
| Check | What it catches | Where ArmPOS shows it |
|---|---|---|
| Cash counted against the expected drawer | Cash sales not rung up, cash taken, wrong change | Close Register: expected, counted and the difference |
| Discounts given | Discounts to friends, or a discount typed on a whole sale | Discount Summary Report |
| Returns | Refunds paid without the goods coming back | The Sales Return list and the Return Ratio Report |
| Held sales still open | Goods handed over on a sale that was held and never finished | Draft Invoices Report, with each draft's age in days |
| Prices changed in the cart | A price typed down for someone | A cashier role without Change product details |
For example, a cashier at the Giza shop opens the register with a float of EGP 1,000. The shift takes EGP 18,450 in cash, refunds EGP 300 in cash and pays EGP 150 out for cleaning supplies. The drawer should hold 1,000 + 18,450 − 300 − 150 = EGP 19,000.
The cashier counts EGP 18,640, so the drawer is EGP 360 short. At a 25% gross margin, the shop needs EGP 1,440 of extra sales just to earn that back.
One short shift can be a counting mistake. The same cashier short every week is a pattern, and the causes and controls for each kind of loss are in inventory shrinkage.
How should a shop buy staples, seasonal ranges and new lines?
Buy each kind of range at its own pace. Staples are reordered all year, seasonal ranges are bought once before the season, and new lines are tried small and reordered only on proof.
| Range | For example | How to buy | When to act | What to watch |
|---|---|---|---|---|
| Staples | Cooking oil, soap, washing-up liquid | A reorder point and an order size for each product | When stock reaches the reorder point | Days a best seller was out |
| Seasonal | Ramadan lanterns, school bags, Christmas lights | One buy before the season, sized from past seasons | At the season's midpoint, and before it ends | Sell-through rate |
| New lines | A gadget or a style you haven't sold before | A small first order | After two to four weeks of sales | How much of the first order sold |
For staples, economic order quantity sets the order size. It assumes steady demand, so it doesn't fit a range that sells for six weeks and stops.
To see which ranges earn their shelf space, compare their GMROI by category: see inventory management KPIs.
How much to buy for a season you can't reorder
Buy one more unit while the chance that it sells beats a ratio built from three prices. The rule is the newsvendor model, as taught in MIT's supply chain course notes.
Buy the next unit while: chance it sells > overage ÷ (underage + overage)
- Underage is the profit lost on each customer you can't serve: price − cost.
- Overage is the loss on each unit left over: cost − what it fetches after the season.
For example, the Giza shop sold 260, 300 and 340 Ramadan lanterns in its last three seasons. Suppose its seasonal greeting cards sold the same numbers. The figures are illustrative, in Egyptian pounds.
| Line | Ramadan lanterns | Greeting cards |
|---|---|---|
| Cost | 120 | 30 |
| Price | 200 | 50 |
| Worth after the season | 90, cleared at a discount | 0 |
| Underage (price − cost) | 80 | 20 |
| Overage (cost − worth after) | 30 | 30 |
| Ratio: overage ÷ (underage + overage) | 30 ÷ 110 = 27% | 30 ÷ 50 = 60% |
| Average profit if you buy 260 | 20,800 | 5,200 |
| Average profit if you buy 300 | 22,533 | 5,333 |
| Average profit if you buy 340 | 22,800 | 4,800 |
| Best buy | 340 | 300 |
The averages treat each past season as equally likely. The 340th lantern sold in one season of three, a 33% chance: above 27%, so it is worth buying. The 340th card has the same 33% chance, below 60%, so the shop stops at 300.
The cheaper a leftover is to clear, the deeper you can buy. A dated product that is worthless after the season needs a far better chance before each extra unit pays.
Once the season starts, check what has sold at its midpoint, and mark down early if it lags: sell-through rate sets the line.
Which stock methods fit a shop?
Five methods recur in retail guides, and they answer different questions. Two decide which unit leaves the shelf first, one only decides what stock costs in the accounts, and two decide how much to order.
| Method | What it decides | Fits a shop when | Watch out |
|---|---|---|---|
| First in, first out (FIFO) | Older stock leaves first; also a way to cost stock | Always; a must for anything that ages | New deliveries go behind the old ones |
| First expired, first out (FEFO) | The earliest expiry date leaves first | Food, medicine and cosmetics | Each delivery needs a batch and expiry date |
| Last in, first out (LIFO) | Only what stock costs in the accounts | Not under IFRS: IAS 2 doesn't allow it | Selling new stock first lets old stock age on the shelf |
| Economic order quantity (EOQ) | How much of a staple to order | Steady sellers with a known cost per order | Seasonal ranges and new lines break it |
| Just in time (JIT) | Order only when stock is needed | A local supplier who delivers within a day or two | One late delivery empties the shelf |
Under IAS 2, interchangeable stock is costed by first in, first out or by weighted average cost. LIFO is not one of the formulas it allows.
What are the signs a shop's stock control is failing?
Each sign points to a cause with a first fix. Start with the one that costs you most.
| Sign | Likely cause | First fix |
|---|---|---|
| Best sellers run out every month | No reorder level, or a wrong stock figure | Set a stock alert on your 20 best sellers and count them |
| Customers ask for goods sitting in the back room | Shelves refilled only when empty | Shelf triggers and the morning gap check |
| A drawer is short more than once a week | Unrung sales, wrong change or theft | A register per cashier and the five-number check |
| Goods sit unsold for months | Buying by habit, not by what sold | A dead stock list each month, and smaller first orders |
| Counts never match the records | Damages, returns or deliveries not recorded, or stock kept on paper | Record each movement the day it happens, at the till where you can |
How to run retail inventory management in ArmPOS
ArmPOS is a point of sale with stock control that runs in the browser on a phone, tablet or computer. Many shops can do without an ERP system, which ties stock to finance and, for makers, production. These steps set a shop up, each with its Help center guide.
- Add products with a Stock Alert, and sizes and colours as variants with their own codes: Add your first products, Products with variants.
- Map the shop floor. Name each shelf as a location and fill in each product's Internal Location: Your warehouse and its locations.
- Or give the store room its own stock. Where your plan includes transfers, make the store room a second warehouse. Each refill is then a transfer, which moves once approved: Move stock between warehouses.
- Give every cashier their own sign-in and role. Leave Change product details off, so a price can't be changed in the cart: Roles and permissions.
- Open and close a register each shift. ArmPOS works out what the drawer should hold and shows the difference. An alert can reach your phone when a register closes: Open and close the register, Get alerts on your phone.
- Read the reports. Weekly: Discount Summary, Return Ratio, Draft Invoices and Top Selling Products (Sales reports). Monthly: Dead Stock and Stock Aging (Stock reports).
- Count one category at a time from a count sheet, and correct with an adjustment. Record breakages as damages: Count and adjust stock, Record damaged or spoiled stock.
If the internet drops while the POS is open, it keeps selling and sends the sales when the connection returns. The Starter plan is free, with no card needed, and the pricing page shows what each plan includes. Shops in Egypt can start from the local page.
Frequently asked questions
What is the difference between retail inventory management and inventory control?
Inventory control is the part that stops loss and errors: counts, till checks and who may change stock. Retail inventory management also covers buying, shelf refills and seasonal ranges.
What is the best inventory method for a retail store?
First in, first out on the shelf for everything, and earliest expiry first for dated goods. Then a reorder point for each staple and one sized buy for each seasonal range.
How often should a shop count its stock?
Count one category a week, and your best sellers more often. Count everything once a year for the accounts.
What is a normal out-of-stock rate for a shop?
The 2002 review put the worldwide average at 8.3% of items, and fast sellers and promoted items often above 10%. Measure your own on your 20 best sellers, every morning.
Start with tomorrow morning's gap check on your 20 best sellers. To have the till keep the stock figures as you sell, create a free ArmPOS account.
