Inventory management is about having the right products in stock in the right quantities, so customers can buy what they are looking for without money being tied up in products that do not sell. For a webshop this means keeping track of stock on hand, sales, lead times and purchasing per product, and having fixed processes for when to order and how goods are received.
What to keep track of per product
Good inventory management starts with a few figures being correct for each product:
- Stock on hand, i.e. how many units are physically in the warehouse and available for sale.
- Incoming goods, i.e. how many units have been ordered from the supplier but not yet received.
- Sales per day or week, calculated without the days the product was out of stock. Read more in the guide on stockout days.
- Lead time from order to receipt, preferably measured and not just the supplier’s stated figure. See lead time.
- Cost price, minimum quantity and carton size at the supplier.
If one of these figures is missing, every calculation that follows becomes uncertain, no matter how good the formulas are.
Key figures in inventory management
There are many key figures, but these five cover most of what a webshop needs:
| Key figure | What it shows | Guide |
|---|---|---|
| Days of cover | How many days the stock lasts at the expected sales | Inventory turnover |
| Inventory turnover | How many times the stock is sold in a year | Inventory turnover |
| Stockout days | How many days popular products could not be bought | Stockout days |
| Overstock | Stock beyond what can be sold within a reasonable period | Overstock |
| Forecast accuracy | How close the forecast comes to actual sales | Forecast accuracy |
Days of cover is the most practical figure for day-to-day work. A product with 120 units in stock and expected sales of 4 units a day has 120 / 4 = 30 days of cover. If the lead time is 45 days, the product has already been ordered too late, unless there are goods on the way.
The processes behind inventory management
Figures are only one part of inventory management, because they have to be kept correct by a set of fixed routines:
- Reordering: each product has a reorder point, and when stock plus incoming goods falls below it, you order. The reorder point is based on sales during the lead time plus a safety stock.
- Order quantity: how much to order depends on the forecast, minimum quantity and carton size. See order quantity.
- Receiving: goods are counted on arrival and booked against the purchase order, so stock on hand and incoming goods are correct.
- Stock counts: all or part of the stock is counted regularly, so differences between the system and the shelf are found and corrected.
- Follow-up: overstock, dead stock and products with many stockout days are reviewed on a fixed schedule, for example once a month.
Inventory optimisation with ABC/XYZ
Inventory optimisation means not treating all products the same. An ABC/XYZ analysis splits the range by how much the products matter for revenue and how stable their sales are. A products with stable sales can be managed closely with a high service level, while C products with fluctuating sales can have a lower service level and be ordered less often. That frees money from the products that matter less without compromising on the products customers expect to be in stock.
What an inventory system should do
An inventory system or inventory management system for a webshop should at least be able to:
- fetch stock and sales automatically from the webshop,
- keep track of incoming goods per supplier and purchase order,
- calculate reorder point and safety stock from each product’s own sales and lead time,
- account for season and promotions in an inventory forecast,
- create purchase orders that can be sent to the supplier, and register receipts,
- show key figures such as overstock, stockout days and inventory turnover.
The term inventory management system is used for many different things, from a simple stock program that only counts units to large systems with picking, packing and bin locations. For most webshops the most important thing is that the system helps decide what to order and how much.
When the webshop’s stock count is not enough
Webshop platforms such as Shopify, WooCommerce and PrestaShop count stock down when a product is sold and up when you register a receipt. That is enough to show customers whether a product is in stock, but not to manage purchasing. The platform typically does not know how much is on the way, how long the lead time is, or how much the product will sell in the coming months. When the range grows to a few hundred products, or when several suppliers have long lead times, it is hard to order correctly from the stock count alone.
lesslater fetches sales and stock from PrestaShop, WooCommerce or Shopify and makes a purchase suggestion per product that accounts for season, stockout days, lead time, goods on the way and budget. The suggestions are rounded to minimum quantity and carton size and can be sent to the supplier as purchase orders. See more under purchasing.