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
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
- 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 →