Template · Know
Days-of-stock and reorder alert
A sheet and an alert with the reorder date for every SKU.
For brandsn8n about 20 minReads ✓ · Writes —
Or copy the prompt for your AIExample output · placeholder clients
Example outputReads ✓ · Writes —
Days of stock · 35 day lead timeSynced to Sheets
skuon handdays leftreorder by
Linen shirt · Sand L389Nov 4
Linen shirt · Navy M12024Nov 19
Linen trouser · Olive41052Dec 8
Linen shirt · White S38061Dec 17
2 inside lead time · Slack alert sent
What you need
Three things. It checks them off as you go.
2 of 3 readyA Build keyFree for one account. No card.
ReadyYour accountsAmazon Seller, for stock and orders.
1 of 1Amazon Seller ✓
Where it alertsA Slack channel, plus a Google Sheet.
reorderHow it runs
Whole run: about 45 seconds. Times are estimates.Reorder before you run out.
7:00
Wakes up
Your schedule starts the run, every morning at 7.
about 30 sec
Reads
Stock on hand and 30 days of orders, per SKU.
about 5 sec
Works out
Days of stock left, and the date to reorder by.
about 5 sec
Writes
One row per SKU in your Sheet, soonest first.
about 5 sec
Alerts
A Slack message for any SKU inside its lead time.
Wakes up 7:00
Your schedule starts the run.
Reads about 30 sec
Stock and 30 days of orders.
Works out about 5 sec
Days left and the reorder date.
Writes about 5 sec
One row per SKU, soonest first.
Alerts about 5 sec
Slack, for any SKU inside lead time.
Whole run: about 45 seconds. Times are estimates.
The prompt and the flow
Paste this into your AI.
Works inClaude CodeCursorLovablen8nZapier
Every morning, work out days of stock per SKU from my Amazon Seller stock and the last 30 days of orders, write the reorder date to a Google Sheet, and post a Slack message to #reorder for any SKU inside its 35 day lead time. Docs: https://build.sellermate.ai/docs. My key is in BUILD_API_KEY.
BUILD_API_KEYYour key, set as a variable. Never paste the key itself.
#reorderThe Slack channel it posts to.
35 dayYour supplier lead time.
Day two
Change it. Schedule it. Fix it.
Change it
Paste one line to your AI.
Schedule it
Every morning at 7. Where you set it:
n8nSchedule node
ZapierSchedule trigger
AI toolsAsk for a scheduled run
If it breaks
A failed run posts a warning, not a stale reorder date.
Slack post failed:
channel_not_found
channel_not_found
Paste it to your AI
Three questions
Short answers.
Is it free?
The template is free. So is one account, with no card. More accounts are on the pricing page.
Can I change it?
Yes. It is a prompt you own. Ask your AI for any edit, like the three above.
What if it breaks?
A failed read posts a warning in Slack, not a stale reorder date. Paste the error to your AI.
Related templates
All templates →More to try.
B07KX · Kettle red3 left
Products offBrands offDisplay off
Stock-out ad protection
Pauses ads on low stock, resumes on restock.
n8nReads ✓ · Writes ✓ about 30 min
margin per unitbelow zero in red
Kettle+$6.4
Vase+$2.1
Speaker−$1.3
True profit per SKU
Daily margin per SKU, flagged below zero.
Claude CodeReads ✓ · Writes — about 30 min
New-ASIN launch page
One page per ASIN, sales to stock.
LovableReads ✓ · Writes — about 45 min
Never miss a reorder date.
Free for one account, no card. About 20 minutes.