Reorder Reminders Timed to Each Wholesale Buyer's Own Cycle, Not a Flat 30 Days
- Level Advanced
- Setup1–3 hrs (estimated)
- Evidence Some evidence
- CostNot stated in source
- No-codeNo
What they did
A flat 30-day reorder reminder is wrong for wholesale buyers: a cafe that orders every 10 days hears too late, and a 60-day distributor gets nagged early. This n8n workflow for Shopify works out each buyer's usual cycle from the median gap between their last 10 orders, adds a few grace days, skips anyone with an order that hasn't shipped yet, and lets sales reps turn reminders off per account. Errors go to one 'email me' branch instead of failing silently.
How it went
n8n community post by the builder (Oct 21, 2026): median of last 10 order gaps plus grace days; fallback for buyers with fewer than 2 orders; unshipped hold-back; per-account do-not-disturb metafield; cursor paging past 250 buyers; note on a Shopify OAuth2 pagination bug. Free template with a video walkthrough
Worth knowing
- n8n community post by the builder (Oct 21, 2026): median of last 10 order gaps plus grace days; fallback for buyers with fewer than 2 orders; unshipped hold-back; per-account do-not-disturb metafield; cursor paging past 250 buyers; note on a Shopify OAuth2 pagination bug. Free template with a video walkthrough.
Prompt
Cleaned version rewritten from the source — not a direct quote.
Help me set up reorder reminders for my wholesale customers on [Shopify / my store]. For each buyer, work out how often they usually order from their last 10 orders (use the middle value so one rush order doesn't skew it), and remind them when they're [X] days past that. Don't remind anyone whose last order hasn't shipped yet, let me switch reminders off for specific accounts, and email me if anything breaks. Show me the first batch of reminders before any go out.
Recommended
Try it in Grok Bot
- Copy the prompt (button below).
- Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
- Connect the listed tools (Email) as connectors when Grok Bot asks.
- If the task repeats, ask: "Make this a daily routine."
Alternatives: the same prompt works in n8n, Claude, ChatGPT Agent, OpenClaw.
Set it up
Tools: Email · Stack: n8n + Shopify
- Read the original source for full context.
- Connect the tools your agent needs.
- Paste the prompt and replace [bracketed] placeholders.
- Run once manually and check the output before scheduling it.
Generic suggested steps, not from the source.
Evidence
n8n community post by the builder (Oct 21, 2026): median of last 10 order gaps plus grace days; fallback for buyers with fewer than 2 orders; unshipped hold-back; per-account do-not-disturb metafield; cursor paging past 250 buyers; note on a Shopify OAuth2 pagination bug. Free template with a video walkthrough
Source: Web · Verified by us: not yet · Report broken or outdated