Automation
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
automation
customers
flow
Tag Frequent Repeat Buyers
Build a scheduled Flow that finds customers ordering unusually often in a short window and tags them for a loyalty or subscription-conversion outreach list.
đź“‹ Prompt
Build a Shopify Flow that identifies customers with an unusually frequent repeat-purchase pattern. Trigger: Scheduled time — recurring, every [FREQUENCY] (e.g. weekly). Actions: Get order data — query: orders created in the last [WINDOW_DAYS] days (e.g. 30), grouped by customer, up to 100 results. For each customer with [MIN_ORDER_COUNT] or more orders (e.g. 3) within that window → Add customer tags: “[FREQUENT_BUYER_TAG]” (e.g. “frequent-repeat-buyer”). Send internal email to [CS_OR_MARKETING_EMAIL] listing the customers newly tagged this run, so the team can consider reaching out about a subscription option. Before activating: Show me the exact query and grouping logic and confirm the window and order-count threshold. Confirm the tag name. After I confirm, create and turn on the Flow. Note: “Get order data” returns up to 100 orders per run, not per customer — for very high order volumes, tell me and I’ll narrow the time window or increase run frequency so the query doesn’t miss orders past the 100-result cap. This tags for internal targeting only; it doesn’t enroll anyone in an actual subscription product, which would need Shopify’s native Subscriptions setup separately.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions