When to use this template
Use it before uploading your own file, or copy the headers into an export from Shopify, Etsy, Amazon, or your own spreadsheet.
Inventory CSV Template for Reorder Calculations
Use this inventory CSV template when you want reorder calculations from a spreadsheet export. Keep one row per SKU and include stock, sales velocity, lead time, optional incoming stock, MOQ, cost, and price.
Single-SKU calculator
How the calculation works
How to estimate average_daily_sales
If you know daily demand, enter it directly. If not, divide recent units sold by the number of days, such as last_30_days_sales / 30 or last_90_days_sales / 90.
How to estimate lead_time_days
Use the typical number of days from placing an order to receiving sellable stock. If suppliers vary, use a realistic average and add lead_time_variability_days.
How to handle optional fields
Optional fields can be blank. Leave unit_cost and selling_price blank if you do not want value or margin estimates. Leave incoming_stock blank when no purchase order is on the way.
Input fields explained
| Field | Why it matters |
|---|---|
| sku | Required product identifier. |
| product_name | Optional readable product name for the result table. |
| current_stock | Required units currently available. |
| average_daily_sales | Preferred demand rate input. |
| lead_time_days | Required supplier replenishment time. |
| lead_time_variability_days | Optional estimate of supplier delay variability. |
| desired_service_level | Optional buffer setting, commonly 0.90, 0.95, 0.98, or 0.99. |
| minimum_order_quantity | Optional supplier MOQ for reorder quantity rounding. |
| review_period_days | Optional replenishment cycle after lead time; defaults to 30 days. |
| incoming_stock | Optional units already ordered and expected to arrive. |
| unit_cost | Optional cost used for gross margin-at-risk estimates. |
| selling_price | Optional price used for revenue-at-risk estimates. |
| last_30_days_sales | Optional cumulative 30-day total used for average daily demand. |
| last_60_days_sales | Optional cumulative 60-day total used for demand variability. |
| last_90_days_sales | Optional cumulative 90-day total used for demand variability. |
Worked example
If last_30_days_sales is 120, average daily demand is 120 / 30 = 4 units/day. If supplier lead time is usually 18 days and can vary by 3 days, enter lead_time_days as 18 and lead_time_variability_days as 3.
Common mistakes
- Renaming required headers such as current_stock or lead_time_days.
- Putting currency symbols in numeric fields.
- Mixing units sold and revenue in the sales columns.
- Leaving both average_daily_sales and recent sales totals blank.
When not to rely on the result
A clean CSV format does not make the inputs correct. Review unusual sales periods, stockouts, supplier delays, and one-off bulk orders before using the results.
FAQ
Can I download a sample inventory CSV?
Yes. Use the sample CSV page or direct download link, then replace the sample rows with your own SKUs.
Which columns are required?
sku, current_stock, lead_time_days, and either average_daily_sales or recent sales totals are required for useful results.
Can optional fields be missing?
Yes. Optional fields can be blank, but revenue risk, margin, MOQ rounding, review period, and variability estimates may be less useful.