📦
Upload your files to get started
Upload the Variant Report from Stocky (Best Sellers is optional). Set your Lead Time and Coverage Days to calculate restock quantities.
This calculator tells you how much of each product you need to reorder, based on your current stock, how fast it's selling, and how long your supplier takes to deliver. It reads data directly from your Stocky reports — no manual data entry needed.
Export from Stocky: Reports → Stock on hand → Export (or SKU/Variants report, as long as it includes the columns below).
| Column name | What it's used for |
|---|---|
Product | Product name |
SKU | Unique variant identifier (size/color) |
Tags | Used for the Tags filter |
Price | Shown in the report table |
Available | Current stock on hand |
Sales/Day | This is the ADS (Average Daily Sales) used directly in the restock formula |
Sales | Optional — enables the Total Sales filter if present |
Only needed if you want to subtract Incoming/Ordered stock from the restock calculation. Export from Stocky: Reports → Best sellers → Export.
| Column name | What it's used for |
|---|---|
SKU | Used to match rows with the Variant Report |
Ordered | Incoming stock already on order from a supplier |
If you skip this file, Incoming is treated as 0 for every product — which is fine if you don't currently have open purchase orders.
If any column in either file has "Grade" in its name (e.g. an ABC analysis grade), a Grade filter appears automatically in the sidebar. If no such column exists, the filter stays hidden.
| Term | Meaning | Where it comes from |
|---|---|---|
| ADS | Average Daily Sales | Sales/Day column, Variant Report |
| Lead Time | Days your supplier takes to deliver new stock | You enter this manually in the sidebar |
| Coverage Days | How many days of stock you want on hand after restocking | You enter this manually in the sidebar |
| Current Stock | What you have right now | Available column, Variant Report |
| Incoming | Stock already ordered, not yet received | Ordered column, Best Sellers (optional) |
If the result is negative (you already have enough stock), it's shown as 0 — no restock needed.
| Status | Meaning |
|---|---|
| Out of Stock | Zero units currently available |
| Critical | Less than 7 days of stock left at current sales pace |
| Low Stock | Between 7 and 14 days of stock left |
| Restock Soon | Between 15 and 29 days of stock left |
| OK | 30+ days of stock left — no action needed yet |
| No Sales | No sales recorded, so days-left can't be calculated |
The Restock Needed column always shows the formula's result and never changes. If you want to order a different quantity than the formula suggests (e.g. rounding up to a case size, or a supplier minimum), type your own number into the Actual Restock column next to it. A small note underneath shows how far your number is from the formula's suggestion. Your manual numbers are included when you export to CSV, Excel, or PDF.