Customer Loyalty πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick loyalty tiers segmentation

Reconcile Loyalty Tier Tags Against Actual Customer Spend

Reconcile your existing customers against tier thresholds: segment everyone who qualifies but was never tagged, plus anyone tagged who no longer qualifies, with counts.

πŸ“‹ Prompt
Run in Sidekick
My loyalty tier tags at [STORE_NAME] were applied by an automation that only fires on new orders, so customers who crossed a threshold before it existed were never tagged. Do a one-time reconciliation of my existing customer base against the real thresholds β€” a point-in-time gap check, not a new automation.

My tiers, thresholds and tags are: [TIER_1_NAME] at [TIER_1_THRESHOLD] tagged [TIER_1_TAG]; [TIER_2_NAME] at [TIER_2_THRESHOLD] tagged [TIER_2_TAG]; [TIER_3_NAME] at [TIER_3_THRESHOLD] tagged [TIER_3_TAG].


  
    For each tier, create a customer segment named β€œ[TIER_NAME] missing tag” of customers whose amount spent over [QUALIFICATION_WINDOW] meets that tier’s threshold but who do not carry the matching tier tag. These are the customers currently under-recognized.
  
  
    Create one more segment named [OVER_TAGGED_SEGMENT_NAME] of customers who carry a tier tag but whose spend no longer meets that tier’s threshold.
  
  
    Report back a reconciliation table: tier, threshold, how many customers currently carry the tag, how many qualify but are missing it, and how many carry it without qualifying. Give me the total number of customers affected across all tiers.
  
  
    If any filter above cannot be expressed in a segment β€” scoping spend to [QUALIFICATION_WINDOW] rather than all-time spend, or excluding customers who already carry a given tag β€” tell me explicitly which one and give me the closest workable filter, instead of silently approximating it.
  


Do not add, remove, or change any tag on any customer record β€” I will apply the corrections myself from these segments using a bulk action, once I have reviewed the counts. Flag any tier where the missing-tag count is above [ALERT_THRESHOLD] customers, since that suggests the tagging automation was off or misconfigured for a period rather than just missing historical backfill.

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 →