Stock tracking for a small shop, without a full stocktake
Running the business · Updated · 5 min read
Read this in: 中文 · Bahasa Melayu
Key takeaways
- You do not need a full stocktake to start. Begin with the products that sell most, and add the rest as they sell.
- Give every product a SKU or barcode so it is found the same way at the till, every time.
- Set a low-stock level per product based on how long a reorder takes to arrive, not a single number for everything.
- Receive deliveries against a purchase order, so stock goes up by what actually arrived.
- Count a small group of products each week instead of everything once a year, and look for what is not selling.
Most small shops know stock tracking would help and put it off, because the first step looks like closing for a day to count every item on every shelf. It does not have to start that way. This guide is for owners of retail shops, groceries, minimarkets, pharmacies and salons that sell products, who want stock counts they can trust without a stocktake weekend.
Why stock tracking pays for itself
Stock problems cost money in two directions. Run out of something and you lose the sale, and sometimes the customer. Overbuy something that does not move and your cash sits on a shelf. Both are invisible without records: an empty hook and a full shelf of slow sellers look like ordinary shop life. Tracking makes both visible early enough to act on.
Step 1: Start with the products that matter most
In almost every shop a fairly small group of products makes up a large share of sales. Start there. Add your best sellers to the POS with their current quantities on day one, and add everything else the first time it is sold. Within a couple of weeks the catalogue covers what actually moves, and what is still missing is, by definition, the stock that is not selling - which is useful information in itself.
Step 2: Give every product a code
A product found by scrolling a list is a product that will occasionally be rung up as the wrong item, which quietly corrupts both the stock count and the price. Give each product a SKU, and use the manufacturer's barcode where there is one. A USB or Bluetooth barcode scanner is inexpensive and types into the POS like a keyboard. For items without a barcode - loose goods, your own products - make a short internal code and keep it consistent.
Step 3: Let sales count stock down
Once a product has a quantity, each sale should reduce it automatically, and a refund should put it back - unless the returned item cannot be resold, in which case it should not. The rule that keeps the count honest is simple: stock only changes through a recorded event - a sale, a refund, a delivery received, or an adjustment with a reason such as "damaged" or "expired". Never overwrite a number because it looks wrong; record an adjustment, so there is a trail.
Step 4: Set low-stock levels that match reality
A low-stock alert is only useful if it fires with enough time to reorder. Set the level per product, from two questions: how many do you sell in a typical week, and how long does a delivery take to arrive? If you sell about ten a week and your supplier takes a week, a level around fifteen leaves a margin. A single threshold for every product will be too early for slow items and too late for fast ones.
Step 5: Order and receive through purchase orders
A purchase order is a record of what you asked a supplier for, at what price. When the delivery arrives, receive it against the order: count what came, and record the quantities that actually arrived. Stock goes up by what you received, not by what you ordered, and any shortfall is visible before you pay the invoice. Over time the same records tell you what each supplier charged last time and how reliable their deliveries are.
Step 6: Count a little, often
Instead of one annual stocktake, count a small group of products each week - one shelf, one category, or the ten highest-value items. This is called cycle counting. Compare the count with the system, record an adjustment for any difference, and note the reason if you know it. Products that are repeatedly short are telling you something: theft, breakage, or sales being rung up as the wrong item.
If you already keep a count in a spreadsheet, you may not need to re-enter it. Importing a stocktake sheet into the POS sets the starting quantities in one step.
Step 7: Look at what is not selling
Best-seller lists get all the attention, but the report that frees up cash is the opposite one: products that have not sold in 60 or 90 days. For each, decide whether to discount it, bundle it, return it to the supplier if you can, or simply stop reordering. Review it monthly.
Common mistakes
- Selling items under a generic "misc" button, so no product count ever changes.
- Adding deliveries by editing the quantity instead of receiving a purchase order.
- One low-stock level for every product.
- Counting everything once a year and nothing in between.
- Staff sharing one login, so an adjustment cannot be traced to a person.
Where FivePOS fits
FivePOS includes a product catalogue with SKU and barcode fields that works with USB and Bluetooth scanners; scanning with the phone camera is not built in. Sales count stock down, a refund can restock the items or leave them out if they cannot be resold, each product has its own low-stock threshold with a low-stock view, and adjustments are recorded as stock movements. Suppliers and purchase orders support receiving what actually arrived, and a supplier invoice or delivery order can be photographed, or an order sheet uploaded, to fill in the purchase order lines. Stocktake sheets can be imported. On the Professional plan, AI Insights gives a plain-language read on slow movers and what to reorder. See POS for retail shops and minimarkets, or start free.
Frequently asked questions
Do I need to do a full stocktake before using a POS for inventory?
No. Start with your best-selling products and their current quantities, and add other products the first time they sell. A full count can come later, or be replaced by counting a small group of products every week.
How do I set a low-stock level?
Base it on how many you sell in the time a delivery takes to arrive, plus a margin. A product that sells ten a week from a supplier who takes a week to deliver needs a level of more than ten, not the same level as a product that sells one a month.
What is cycle counting?
Counting a small group of products regularly - for example one shelf or category each week - instead of the whole shop once a year. It catches errors sooner and never requires closing the shop to count.