How to control stock in a small shop: reorder points, counts, shrink

What are the steps to control stock in a small shop?

Stock control is a weekly loop rather than a one-off project. The eight steps below work for a single gift shop, a convenience store or a franchisee with several units. Each step needs a simple record: a spreadsheet, a form or a routine everyone follows.

• 1. Know your numbers: weeks of cover, sell-through and stock turn for every line.
• 2. Rank lines with ABC analysis so your time goes where the sales are.
• 3. Receive properly: check at the door, count by the unit you sell, claim the same day.
• 4. Keep the stockroom: a labelled home for every line, first expiry first out for dated goods.
• 5. Count small parts of the shop every week with blind cycle counts.
• 6. Reorder at calculated reorder points with safety stock, and approve every order.
• 7. Plan buying with open-to-buy by month and department; clear slow stock on sell-through.
• 8. Measure shrink by cause and act fairly on the biggest causes first.

Which stock numbers should a shop owner track?

Five numbers do most of the work. Weeks of cover is stock on hand divided by average weekly sales: how long today's stock lasts. Sell-through is units sold divided by units sold plus units on hand: the share of what you had that has gone, which is the key test for seasonal and fashion lines. Stock turn is yearly cost of goods sold divided by average stock at cost. GMROI, gross margin return on inventory investment, is gross margin divided by average stock at cost: what each unit of money held in stock earns. The stock-to-sales ratio is stock at the start of a month divided by that month's sales, which buyers use to plan.

There is no universal target for any of them. Grocery runs short cover because deliveries are frequent and goods are fresh; gifts and fashion run longer. Set your own targets from your first eight weeks of figures and watch which way each number moves.

What is ABC analysis and why does it matter?

ABC analysis ranks your lines by share of sales value. A lines are the few that together make most of your sales, often taken as the first 80%. B lines make the next slice, and C lines the long tail. The idea draws on the observation credited to Vilfredo Pareto that a small share of causes often produces a large share of results.

The classes decide where effort goes. Count A lines weekly or fortnightly, hold more safety stock on them so they rarely run out, and review them every week. C lines get counted quarterly and have to earn their place. Before dropping a C line, check whether customers buy it together with an A line, such as wrapping paper with cards.

How do you calculate a reorder point and safety stock?

Lead time is the time from placing an order to the goods being on your shelf. The reorder point is the stock level at which you order: enough to cover expected sales during the lead time, plus safety stock. Safety stock covers weeks when sales run above average.

The standard formula, which assumes weekly sales vary around a steady average and a reliable lead time, is: safety stock = z x the standard deviation of weekly sales x the square root of (lead time + review period), where the review period is how often you order, in weeks. The z-value comes from the service level you choose, the chance of not running out while waiting: about 1.28 for 90%, 1.64 for 95% and 2.33 for 99%. Then reorder point = average weekly sales x lead time + safety stock, and the order brings stock back up to an order-up-to level of average weekly sales x (lead time + review period) + safety stock, rounded to the supplier's minimum and pack size.

Worked example: a reorder point for a best-selling candle

A gift shop sells a scented candle. Over the last eight weeks it sold 8, 10, 6, 12, 9, 7, 11 and 9: an average of 9 a week, with a standard deviation of 2. The supplier's lead time is two weeks, the shop orders weekly, and as a top seller the candle gets a 95% service level. There are 21 on hand and none on order. The minimum order is 12 and the candles come in packs of 6.

• If Christmas lifts average sales to 14 a week, the reorder point rises to 14 x 2 + 6 = 34.
• If the supplier's lead time doubles to four weeks, safety stock rises to 1.64 x 2 x square root of 5 = 7.3, so 8, and the reorder point to 9 x 4 + 8 = 44.

How should a shop count stock?

A full stock take counts everything at once; your accountant may need one at your year end. Its weakness is that a loss found once a year is too old to explain. Cycle counts fix that: count one area or group of lines before opening, in 20 to 40 minutes, so every line is counted over a few weeks and A lines most often.

Count blind, with sheets that show the item and location but not the expected quantity, because counters who can see the expected figure tend to find it. Count in the unit you sell. Book deliveries and transfers in before the count. Have a second person recount anything outside your tolerance, and investigate with paperwork before you adjust the system: deliveries, transfers, returns, damage, look-alike lines scanned as each other, units of measure and price changes. A loss in one store matched by a gain in another is usually an unbooked transfer, not a theft.

What causes retail shrinkage, and how do you reduce it fairly?

Shrink is the gap between the stock your records say you should have and what you actually have, plus losses you record along the way. The US National Retail Federation's National Retail Security Survey 2023 reported an average shrink rate of 1.6% of sales for fiscal 2022, about $112.1 billion, with internal and external theft making up nearly two-thirds. In the UK, the British Retail Consortium's Crime Survey 2025 put the cost of customer theft at £2.2 billion in 2023/24, with more than 20 million theft incidents. Those are large-retailer figures, but they show that theft is real and that a large share of loss comes from elsewhere.

Research led by Adrian Beck at the University of Leicester with the ECR Retail Loss group separates malicious losses (external theft, internal theft, supplier fraud) from non-malicious ones (process failures, administrative errors, damage and waste), and known losses from unknown ones that only show in counts. For a small shop, the practical order is: log every known loss the day it happens, measure count losses by cause, then fix receiving, transfers, scanning and date rotation first, because that is where the paperwork is.

Loss prevention must be fair to customers and staff. Treat everyone the same, with no profiling by appearance or any protected characteristic; never ask staff to chase, block or detain anyone; tell colleagues about checks before they start; and follow your local law on CCTV, searches and monitoring. The UK Information Commissioner's Office, for example, says video surveillance must be lawful, necessary and proportionate. Good service, tidy full shelves and clear sightlines from the till deter casual theft and make the shop better for honest customers.

What are the most common stock control mistakes?

• Signing for boxes, not units. A complete set of cartons can still be short inside. Count by the unit you sell before signing as complete.
• Claiming shortages days later. Most supplier terms have a short claim window. Claim the same day with photos.
• Counting with the expected figure in view, then adjusting straight away. Count blind, recount large gaps and investigate first.
• One big count a year and nothing else. Small weekly cycle counts explain losses while they are still fresh.
• Treating every line the same. Use ABC classes to set counting, safety stock and review.
• Ordering by eye. Use reorder points, a regular order day and an approval step.
• First markdowns that are too shallow and too late. Watch sell-through early and judge each cut after four weeks.
• Assuming shrink is theft. Measure it by cause; process and receiving errors are often bigger.
• Letting software order on its own. Demand suggestions and anomaly alerts help; a person approves every order.

How do open-to-buy and markdowns keep stock under control?

Open-to-buy is a stock budget by month and department: planned sales plus planned markdowns plus planned shrink plus the stock you want at month end, minus the stock you start the month with and anything already on order. When it is negative, you stop buying for that department until stock comes down. It is the simplest protection against buying because a rep's deal looked good.

Markdowns are the other half. Decide early on seasonal lines, make the first cut deep enough to move stock while customers still want it, and judge each step on sell-through after about four weeks. Before marking down, try moving the line to a better spot or a store where it sells, or agreeing a return or swap with the supplier. Donation and write-off come last, recorded and approved under a written policy. For dated food, rotate first expiry, first out and follow your local food authority's rules on use-by and best-before dates.

If you want the whole system in one place, The Stock, Shrinkage and Reorder System from Bodhih Training includes a stock workbook with these formulas, a reorder and open-to-buy calculator, receiving and count forms and a shrink action plan.