Inventory Management for Small Online Stores: Stop Overselling

Selling stock you do not have, and sitting on stock that does not sell, are two sides of the same problem. Inventory is the money tied up in your business, and managing it well is one of the biggest influences on profit and customer satisfaction. Here is how to get a handle on it.

What goes wrong without good inventory control

• Overselling. A customer pays for an item that is out of stock. You must apologise, delay or refund, and reviews suffer.
• Stock-outs on best sellers, which lose sales and push customers to competitors.
• Dead stock. Items that do not sell tie up cash and storage.
• Counting errors that make profit reports unreliable.
• Shrinkage, meaning loss through damage, theft or mistakes that no one notices.
• Wasted time searching, recounting and reconciling.

Start with a clean product list

Give every product and variation a unique SKU (stock keeping unit), a short code that identifies exactly what it is, such as TSHIRT-BLK-M.

• Use a consistent naming pattern.
• Create separate SKUs for each size, colour or option.
• Record cost price, selling price, supplier and weight.
• Add barcodes if you want to scan items in and out.

Consistent SKUs make everything else easier: counts, reports and integrations.

Count and record accurately

• Do a full stock take at the start, and cycle counts regularly. Counting a few product groups each week is easier than a huge annual count.
• Record every movement: goods received, sales, returns, damaged or lost items.
• Keep a single place for stock data. Multiple spreadsheets or whiteboards invite conflict.
• Organise your storage with labelled bins or shelves, so items are easy to find and count.

Know your reorder points

A reorder point is the stock level at which you place a new order, so you do not run out. Work it out as:

Reorder point = daily sales rate × supplier lead time + safety stock

If you sell 5 units a day, your supplier takes 10 days and you want a safety buffer of 15 units, reorder when stock hits 65. Review these numbers as sales patterns change, especially around seasons and promotions.

Separate fast and slow movers

A simple analysis shows where to focus.

• A items: the top sellers that deliver most of your revenue. Keep them well stocked and watch them closely.
• B items: the middle group.
• C items: slow sellers. Hold less, discount or discontinue.

Review the list regularly and decide what to clear out. Ending a slow product frees cash for stock that sells.

Plan for seasons and promotions

Predictable peaks, such as Black Friday, festive season and back-to-school, need advance planning.

• Look at last year's sales to forecast demand.
• Order early, allowing for supplier and courier delays.
• Do not run a promotion without confirming you have the stock.
• Plan returns handling for the weeks afterwards.

Sync stock across channels

If you sell on your own store, a marketplace and in a physical shop, each sale must reduce the same stock count, or you will oversell.

• Choose one system as the master record.
• Use integrations that update quantities automatically when an order arrives or stock is received.
• Add a small buffer on marketplace listings to protect against timing gaps.

See marketplaces vs your own online store and connecting your accounting software to your store and CRM.

Handle out-of-stock items well

• Mark them clearly as out of stock, and offer an email or WhatsApp alert for when they return.
• Keep the page live, rather than deleting it, so you keep its search ranking. See ecommerce SEO for online stores.
• Suggest alternatives.
• Consider allowing backorders only when you can give a reliable date.

Work with suppliers

• Agree clear lead times, minimum orders and payment terms.
• Have a backup supplier for critical lines.
• Ask about shipping and delivery reliability, and check goods on arrival against your order.
• Keep records of purchase prices, since costs change and affect margins; see ecommerce pricing, margins and VAT.

Know when to upgrade from spreadsheets

A spreadsheet is fine at the start. Signs that you need proper inventory software or a custom system:

• Stock levels are wrong often enough to cause overselling.
• Several people update the same file.
• You sell across multiple channels or locations.
• You need batch, serial number or expiry date tracking.
• You build products from components, or bundle items.
• Counting and reconciling eats hours each week.

See signs you have outgrown your spreadsheets. Options range from inventory apps connected to your store to custom systems tailored to unusual workflows. If you are weighing these, custom software vs off-the-shelf explains how to decide.

Metrics to watch

• Stock turnover: how many times you sell and replace your stock in a period.
• Days of stock on hand.
• Stock-out rate on key products.
• Dead stock value.
• Stock accuracy after counts.

These feed into the wider picture in ecommerce metrics that matter.

A simple routine

• Daily: check low-stock alerts and new orders against stock.
• Weekly: count a section of stock, and review best sellers.
• Monthly: review slow movers, reorder points and supplier performance.
• Quarterly: a fuller stock take and a review of your range.

Good inventory control is unglamorous, but it protects cash, keeps customers happy and makes growth manageable.