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

  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
🚀

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 →