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

  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 →