Free template
Free reorder point template
Free reorder point spreadsheet for Excel and Google Sheets.
One row per product. Type in what you sold, what you have and how long your supplier takes. The sheet works out the reorder point, how many days of stock you have left, how many days until you need to order, and how many units to buy, rounded to the case pack.
Download the free template (.xlsx)
Works in Excel, Google Sheets (File, Import, Upload) and Apple Numbers. No email required.
What's in the template
Reorder plan tab
SKU, Product, Supplier, Units sold (period), Days in period, On hand, On order, Lead time (days), Safety stock (days), Order should last (days), Case pack, Daily sales, Reorder point, Days of stock left, Order in (days), Suggested order qty, Status
White cells are inputs. Green cells are formulas, so don't type over them. Sample rows are included so you can see how it works. Delete them and add your own.
How to use it
- Pick a sales period, 28 days is a good default, and enter units sold for each SKU.
- Enter on hand and anything already on order but not received.
- Enter the supplier lead time in days, from placing the order to stock on the shelf.
- Choose safety days (7 is common) and how many days each order should last.
- Sort by 'Order in (days)', smallest first. Anything at 0 or below is due now.
The math
Order qty = daily sales × (lead time + days each order should last) − (on hand + on order)
Want to check one product quickly? Use the free reorder point calculator.
Skip the spreadsheet
Spreadsheets work until you have more products than time. SteadyShelf connects to your Shopify store, works out daily sales for every product, shows what to reorder and when for each supplier, and drafts the purchase order for you. $29/month flat, unlimited products and suppliers, 30-day free trial.
SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.
More free templates
- Purchase order template
- Inventory count sheet
- Supplier list template
- Safety stock template
- Inventory forecast template
All free inventory templates · Free purchase order generator
FAQ
Does this template work in Google Sheets?
Yes. In Google Sheets go to File, Import, Upload, and pick the .xlsx file. All formulas are standard ones that Sheets supports.
What lead time should I use?
The full time from placing the order to having stock ready to sell: supplier production, shipping, customs and receiving. If it varies, use a typical slow order, not the fastest one.
Let SteadyShelf do this math for every SKU
Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.
Get early access