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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions