Stock Analysis Report
The stock analysis report shows what sells, what sits and how long your stock lasts: one row per item and warehouse, best sellers first. Everything is in units. The report shows no amounts of money and no order data. It works with Simple stock and with Full WMS.
Where to Find It
Click the chart icon Stock analysis at the top of the stock list (Warehouse > Stock), of the stock history or of the write-offs report. You need the permission View stock. The export also needs Export stock history.
The Views
All: every item and warehouse that shipped in the last 364 days or holds stock.
Best sellers: items that shipped in the last 30 days.
Dead stock: items with stock on hand and nothing shipped in the last 364 days.
Overstock: more on hand than the order-up-to level of the item, or, without such a level, more than 180 days of cover.
Never sold: nothing shipped in the last 364 days.
With more than one warehouse you can show one warehouse or all of them.
The Columns
SKU and name: click the SKU to open the stock item.
Warehouse: the warehouse of the row.
ABC: the velocity class of the item. A sells fastest, C slowest.
30 days, 90 days and 364 days: the units shipped in that period.
On hand and Available: the stock of this moment.
Days of cover: how many days the available units last at the pace of the last 30 days. Example: 35 available and 120 shipped in 30 days is 4 per day, so almost 9 days. A dash means nothing shipped in the last 30 days.
Flags: the pills Dead stock, Overstock and Never sold.
As of: when the shipped units were last worked out. That happens once a night. On hand and available are live.
Export
Export CSV downloads all rows of the view you are looking at, with the same warehouse filter. The file has the columns sku, name, warehouse_code, abc_class, units_30d, units_90d, units_364d, on_hand, available, days_of_cover, dead_stock, overstock, never_sold and computed_at. Refresh reloads the report.
Good to Know
The shipped units are one night old; the stock figures are live.
Warehouses you have no access to are left out.
In the views for dead stock, overstock and never sold, the list can show "Nothing found so far. QrX is still checking the rest of your items." for a moment while it loads the rest.
The report tells you what to look at. To be warned when an item runs low, see the article "Low Stock Alerts".
When to Contact Our Support Team
Contact QrX support when the column As of is more than two days old, or when shipped units do not match what you shipped in that period.