Why accurate stock numbers matter
Your stock count drives several decisions: what to reorder, what to promote, what to mark down, and whether you can honestly tell a customer that an item is available. When the count is wrong in one direction, you oversell and have to cancel or delay orders. When it is wrong the other way, you buy stock you already own, or hide products that could have sold.
Accurate counts also support your accounting. The value of stock on hand feeds into your bookkeeping basics and overall store finances, and a gap between records and shelves usually points to a problem worth finding.
Why counts drift
Stock numbers rarely become wrong all at once. Small errors build up from ordinary causes.
- Unrecorded events. Damaged goods, samples, gifts, items lost in storage, or goods taken for personal use are removed from the shelf but not from the records.
- Returns. An item comes back but is never re-added, or is added even though it cannot be resold.
- Delayed receiving. A delivery arrives but the quantities are entered late, or entered from the order rather than what actually showed up.
- Multiple places to sell. If you sell through your own site, online marketplaces and in-person events such as pop-up shops, a sale in one place may not reduce the number in another.
- Mistakes in data entry. Typos, wrong product variants and duplicated entries are common.
- Supplier shortfalls. A supplier ships less than ordered, and the difference goes unnoticed.
Seeing the causes helps you target the habits that matter most for your situation.
Give every item a clear identity
Tracking only works if each distinct item is identified the same way every time. Assign each product and each variant, such as size or color, its own stock code (often called a SKU). Keep the codes short, consistent and unique, and avoid reusing a code for something different later. The article on product variants explains how options and codes fit together.
Label shelves, bins or boxes with the same codes so that what you see on the shelf maps directly to your records.
Keep a simple record
You do not need advanced software on day one. A spreadsheet can serve a small catalog if you maintain it consistently. A basic record usually includes:
- Stock code and product name
- Quantity on hand
- Location, such as shelf or box
- Cost per unit
- Supplier and typical lead time
- Date and reason of each change
The last item is key. Rather than overwriting the number whenever it changes, keep a log of movements: received, sold, returned, damaged, adjusted. A log lets you trace where a discrepancy began. As you grow, inventory features in your store software, or dedicated tools, can reduce manual entry, though the habits below still apply.
Habits that keep counts accurate
Record changes at the time they happen. The longer you wait, the more likely you are to forget. Receive deliveries at the door, check them against the order, and update counts that day.
Handle returns on purpose. Set a routine for inspecting returned goods and deciding whether each can be resold, needs repair or must be written off. Return processing and stock records should be linked, so refunds and counts agree.
Log write-offs. Damaged, expired and lost goods should be removed with a reason noted. This shows how much leakage you really have and where it occurs.
Count regularly. Instead of one exhausting yearly count, count a small section often. Many sellers count fast-moving items more frequently and slow items less often. Compare the physical count to your records, investigate differences, then correct the record and note the cause.
Keep one source of truth. If you sell in several places, decide which record is the master and update it first. Where your tools can sync counts automatically, check occasionally that they do. Where they cannot, update manually after each sale and keep a small buffer. Selling beyond your own website makes this more pressing, and it is covered in the notes on sales channels.
Hold a small buffer on shared stock. If an item is available on several channels and you have only a few units, listing slightly fewer than you own reduces the chance of two sales for the last unit.
Separate goods that are not for sale. Keep damaged items, returns waiting for inspection and reserved stock apart from sellable goods so they are not counted by mistake.
Use the numbers
Accurate counts become useful when you act on them. Pair them with sales pace and supplier lead times to set a reorder point so you restock before you run out. Review which items are not moving, so that slow stock does not turn into dead stock. If you use a third-party logistics provider or a supplier who ships for you, ask how and how often they report stock, since your records have to match theirs.
Start with small, regular steps
You do not have to build a perfect system straight away. A tidy list of products with codes, a movement log and a short weekly count of your best sellers will catch most problems. Add tools and detail as order volume grows, and keep an eye on whether the effort of tracking is paying back in fewer errors and better buying decisions.