Customer Loyalty
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
flow
vip
tiers
Flag VIP Customers Eligible for Tier Downgrade at Renewal
Build a Flow that tags VIP customers who will fall below their tier's spend threshold at the next qualification reset, before the tier changes.
📋 Prompt
Build a Shopify Flow automation that gives VIP customers a heads-up before losing tier status, rather than silently downgrading them. Trigger: Scheduled, runs [DAYS_BEFORE_RESET] days before the [RESET_PERIOD]-month tier qualification window resets Conditions: Customer has tag [TIER_TAG] (any current VIP tier tag) Customer’s amount spent within the current qualification window < $[TIER_MIN_SPEND_THRESHOLD] (the threshold for their current tag) Actions: Add tag [DOWNGRADE_RISK_TAG] Send a Shopify Messaging email letting them know their tier renews on [RESET_DATE], showing how much more they need to spend by then to maintain [TIER_NAME] status, and highlighting [RELEVANT_PRODUCT_OR_OFFER] as a way to close the gap Build this workflow, and separately create a report showing everyone currently tagged [DOWNGRADE_RISK_TAG] so my team can see the at-risk-of-downgrade list at any time, not just when the Flow triggers. Tell me explicitly if tracking a rolling qualification window (rather than all-time spend) requires a workaround, since Flow’s native spend condition may only support all-time totals.
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
🚀
Joy Loyalty
Sidekick can tag customers and issue discount codes, but Shopify has no native points ledger. Joy runs the points, tiers, and redemption side.
Install Joy Loyalty — Free →