Best sellers, slow movers and dead stock
Stock that sells out loses orders; stock that sits ties up cash. How to read velocity, days of supply and sell-through, and decide what to reorder and what to clear.
Two stock problems at once
A store can have both problems at the same time: the best seller sold out on Thursday, and the shelf behind it holds 300 units of something that sells twice a week.
Each has a cost. A sold-out best seller loses orders you already paid to attract, through ads, search or a customer who came back. Slow stock holds cash and space that could be working on something else, and it gets harder to sell as its season passes. Both problems show up in the same few numbers.
Three numbers for every product
Velocity is units sold per day. Days of supply is current stock divided by velocity: how long the stock lasts at the current pace. Sell-through is units sold divided by units sold plus stock left, the share of available stock that sold in the period.
Illustrative example: in the last 30 days, Cedar Home sold 240 linen cushion covers, 8 a day, and has 40 left. That is 5 days of supply and a sell-through of 85.7%. In the same 30 days it sold 15 ceramic vases, 0.5 a day, with 300 still in stock. That is 600 days of supply and a sell-through of 4.8%. At a selling price of EGP 450, the vases on the shelf are EGP 135,000 of stock that, at this pace, will take well over a year to sell.
If the supplier needs 10 days to deliver cushion covers, 5 days of supply means the shelf will be empty before the next delivery arrives, even if the order goes out today. The vases need the opposite decision: stop reordering and find a way to move them.
What the Products report shows
On Products, the Sell-Through Rate tab lists every active product with Units Sold, Stock Left, Velocity (u/day), Days of Supply and Revenue. Velocity is measured over each product’s active window, from its first to its last sale in the period, so a product added mid-month is not diluted. Days of Supply reads OUT when stock is zero. The status column ranks products against the rest of your catalogue by velocity: the fastest fifth are Fast Sellers, the slowest fifth of those that sold are Slow Movers, and anything with no sales in the period is No Sales.
Stock vs Sales works at variant level, which matters for sizes and colours. It divides current stock by units sold in the period: under 0.5 is understocked, under 3 is balanced and 3 or more is overstocked. A jacket can be overstocked in XL and understocked in M at the same time. Revenue Concentration shows what share of revenue the top 20% of products bring, which tells you how much depends on a short list.
Inventory and days of supply
Inventory shows the current position: In Stock, Out of Stock, Low Stock Products with 5 or fewer units, and Out of Stock Products. Its Inventory Turnover table compares units sold with stock and labels each product Fast Moving, Normal, Slow Moving or Dead Stock. Dead Stock means no units sold in the selected dates, so use a long range, such as Last 90 days, before you call anything dead.
Days of Supply on the Sell-Through Rate tab is the figure to plan reorders with: current stock divided by average daily sales in the period. Set it beside your supplier’s lead time and the season ahead: two weeks of October sales may be the wrong amount for White Friday.
What to reorder and what to clear
Reorder first where days of supply is shorter than your supplier’s lead time plus a margin for delays, starting with Fast Sellers. For slow stock, the Bought Together tab on Products shows which products appear in the same orders; pairing a slow item with one it already sells alongside can be easier than discounting it alone. If a slow mover has no partners and no season coming, a price cut or a clearance bundle frees the cash for stock that sells.
Be careful with new products. A product added three weeks ago with a handful of sales is not dead stock yet. Check its first sale on the Sell-Through Rate tab, where hovering over Active Days shows the first and last sale dates.
A weekly stock check
Run it on the same day each week with the last 30 days selected, and keep the reorder list and the clearance list separate.
- Products, Sell-Through Rate tab: sort by Days of Supply and list every Fast Seller or Good product below your supplier’s lead time.
- Inventory: check Low Stock Products and Out of Stock Products against that list.
- Categories: compare with the previous period to see which product lines are growing, so you restock a line, not just one product.
- Products, Stock vs Sales tab: note the variants marked understocked or overstocked.
- Switch Inventory to Last 90 days and list Dead Stock and Slow Moving items for a clearance plan.