Ask a small business owner how much stock they have and you will often get an estimate rather than a number. That is not carelessness. Stock is constantly moving: deliveries arrive, sales happen, items are returned, damaged or given away, and each movement is an opportunity for the record and reality to drift apart.
Below are seven common problems, why they happen and what to do about each one.
1. The system and the shelf disagree
Why it happens: sales are billed but returns are not recorded, deliveries are put away before being entered, damaged items are thrown out without an adjustment, or the same product exists twice under slightly different names.
What helps:
- Record every stock movement, not just sales. Deliveries, returns, damage and samples all count.
- Bill from the same system that holds stock, so each sale reduces the right item automatically.
- Merge duplicate products and agree a naming convention for new ones.
- Use cycle counts: count a small section of stock every week instead of everything once a year. Errors are found sooner, and counting never becomes a dreaded event.
2. Running out of best sellers
Why it happens: reordering depends on someone noticing that a shelf looks empty. By then, the supplier's lead time means several days or weeks without the product.
What helps: set a reorder point for your important products. A simple way to start is:
Reorder point = average daily sales × supplier lead time in days + a safety buffer
If you sell about four units a day, your supplier takes seven days to deliver and you want a safety buffer of ten units, reorder when stock falls to 38. Review the numbers every few months, because sales patterns and lead times change. A system that shows current stock clearly, or alerts you at the reorder point, makes this much easier to follow.
3. Money stuck in stock that does not sell
Why it happens: buying is based on instinct, supplier offers or minimum order quantities rather than sales history. Slow items sit at the back of the storeroom and are forgotten.
What helps:
- Review a report of products with no sales in the last 60 or 90 days, at least monthly.
- Decide what to do with each one: bundle it, discount it, return it to the supplier if possible, or stop reordering it.
- Before placing a large order, check how quickly the product sold last time.
Freeing cash from slow stock is one of the quickest ways a small business can improve its cash flow.
4. Overselling across channels
Why it happens: the same stock is sold in a shop, on a website and perhaps on a marketplace, and each channel keeps its own count. The last unit gets sold twice.
What helps: there are two broad approaches. Either keep a single source of truth for stock and connect each channel to it through integrations, or allocate a fixed quantity to each channel and rebalance regularly. The first is more efficient. The second is simpler to start with. Our article on API integrations for ecommerce explains how connected stock works.
5. Not knowing which products make money
Why it happens: sales figures are visible but cost prices are not recorded consistently, so margin is a guess. A product can be a best seller and still make very little.
What helps: record cost price alongside selling price for every product, and update it when supplier prices change. Even a basic product and sales report then shows which items contribute most to profit, not just to revenue.
6. Billing and stock live in separate tools
Why it happens: many small businesses start with a standalone billing app for GST invoices and track stock separately in a spreadsheet. The two never quite match.
What helps: bring billing and stock into one place, so each invoice updates stock as it is created. This removes a whole category of errors and saves the time spent reconciling the two. It is the core reason we built vStoreOS, which keeps product records, stock levels, GST billing and sales reports in one workspace.
7. Everything depends on one person
Why it happens: the owner or a long serving employee knows where things are, what is on order and which supplier is reliable. That knowledge is not written down anywhere.
What helps: move that knowledge into the system. Supplier details, reorder points, product locations and purchase orders should all be recorded where others can find them. It protects the business and makes it possible to delegate.
Choosing tools for inventory
For a very small range, a well structured spreadsheet can work for a while. Once you have hundreds of products, more than one person handling stock or more than one sales channel, dedicated software usually pays for itself in time and accuracy. When you compare options, look for:
- Stock that updates automatically when you bill.
- Simple ways to record deliveries, returns and adjustments.
- Reports on stock levels, slow movers and sales by product.
- Access from the devices your team actually uses.
- A way to export your data if you change systems later.
If you are unsure whether you need a focused inventory and billing tool or something broader, our article What is an ERP system? explains the difference.
A simple monthly routine
- Count one or two sections of stock each week and correct differences.
- Review best sellers against their reorder points.
- Check products with no recent sales and decide what to do with them.
- Update cost prices from recent supplier bills.
- Look at sales by product to plan the next month's buying.
None of these steps takes long on its own. Done regularly, they turn inventory from a source of surprises into something you can plan around.
Common questions
-
How often should a small business count stock?
A full count at least once a year is common, but small weekly cycle counts of a few product groups catch errors much sooner and make the full count easier.
-
Is a spreadsheet good enough for inventory?
For a small range managed by one person, it can be. Once several people handle stock, you sell through more than one channel or billing is separate from stock, dedicated software is usually more accurate and saves time.
-
What is a reorder point?
It is the stock level at which you place a new order. A simple version is average daily sales multiplied by the supplier lead time in days, plus a safety buffer.