Customer Loyalty
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
customers
data-hygiene
merge
Find and Merge Duplicate Customer Records
Identify customer records that likely represent the same person under different accounts, and merge only the confirmed duplicates I approve.
π Prompt
Find customer records that likely represent the same person. Match on: Same email address with minor variations (e.g. plus-addressing like name+1@domain, or a typo-corrected resend) Same phone number across different customer records Same shipping address and same name, but different email For each likely duplicate pair or group, show me: customer ID, name, email, order count, and total spend for each record, so I can see which one should become the primary record (usually the one with more order history). List every candidate pair β do not merge anything automatically. Duplicate order history is high-stakes to get wrong. For the specific pairs I confirm back to you as duplicates, merge the secondary record into the primary one, combining order history, tags, and marketing consent (use the most permissive consent state between the two, but never merge to a subscribed state if either record shows unsubscribed β thatβs a compliance requirement, not a preference).
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 →