The Sales velocity report shows how fast each item sells, how many days of stock you have left, and how many days the item was in stock or out of stock. Use it to spot best sellers that keep running out and to adjust alert levels and reorder quantities.
How to open the Sales velocity report
Go to Inventory and open the Menu.
Click Sales velocity.
Pick the date range of sales to look at, and set Forecasted time (days) (30 by default).
Optional: use Filters to narrow by warehouse, store, supplier, item tags, order tags or mover class, and Columns to show or hide columns.
Click Calculate. Click Export to download the results as a CSV file.
Days in stock and days out of stock
These two columns show how much of the date range the item was available to sell:
# Days In Stock: the days in the date range when the item had stock on hand (more than 0). If you stock the item in several locations, a day counts as in stock when any of them had stock.
# Days Out Of Stock: the days in the date range when the item had no stock. It is the number of days in the range minus # Days In Stock.
SKULabs works these out from the item's inventory history, so they show partial days with two decimals. When you filter by warehouse, only stock in those warehouses counts.
Example: with a 30-day range, an item that sold 60 units and shows 10 days out of stock sold those units in about 20 days. Its real demand is closer to 3 a day than 2 a day, so its alert level or reorder quantity may be too low.
Other Sales velocity columns
On Hand, Reserved, Free: stock in your own warehouses, units committed to open orders, and units available to sell (On Hand minus Reserved).
FBA and Inbound (FBA): units in Amazon FBA and third-party warehouses, and units on the way there.
Alert and Incoming: the low-stock alert level, and units on open purchase orders.
Sold and # Days Sold: units sold in the date range, and the number of days with at least one sale.
Velocity: average units sold per day. Standard is Sold divided by the days in the range. With optimistic forecasting, it is Sold divided by # Days Sold.
Projected: expected units sold over the forecast window (Velocity times Forecasted time).
Mover: ABC class by units sold. A is the top 20%, B the next 60%, C the bottom 20%.
FBA >= Projected: true when FBA units meet or exceed the Projected demand.
Days left: days of stock left before you sell out (Free divided by Velocity). It shows 9999 when the item is in stock but not selling.