Calculate reorder points from sales history in Google Sheets

You only notice a best-seller is running low when it's already out of stock.

In short: Calculate reorder points from sales history in Google Sheets is a beginner e-commerce recipe that uses Google Sheets, ChatGPT. Estimated cost: Free. Status: tested on 2026-10-14.

Share on X

prompt.txt

Sheet layout: tab 'Sales' with daily units per SKU (column A date, one column per SKU). Tab 'Reorder' with one row per SKU: A SKU, B on hand, C supplier lead time (days), D safety stock (days).

In Reorder:
E (avg daily sales, last 28 days): =AVERAGE(OFFSET(Sales!B1,COUNTA(Sales!A:A)-28,0,28,1))  (change B for each SKU's column)
F (reorder point): =ROUNDUP(E2*(C2+D2),0)
G (status): =IF(B2<=F2,"REORDER NOW",IF(B2<=F2*1.25,"Watch","OK"))
H (days of stock left): =IFERROR(ROUND(B2/E2,1),"")

Optional AI step: paste the Reorder tab into ChatGPT with: 'Draft purchase-order emails for every REORDER NOW row, ordering enough for {N} days of sales, rounded up to case packs: {CASE_PACKS}.'

Setup steps

Create the Sales and Reorder tabs as described.
Paste in at least 28 days of daily sales.
Set lead time and safety-stock days per SKU.
Add conditional formatting so 'REORDER NOW' turns red, and check it weekly.

#ecommerce#inventory#google-sheets#wholesale

Costs are rough estimates based on published model/API pricing and will vary. Fill in placeholders like {THIS} yourself.

Calculate reorder points from sales history in Google Sheets

Setup steps

Related recipes