My new and returning customer numbers don’t add up

This merchant did what careful owners do: added up the report and found it did not match. The mismatch has an ordinary explanation, and a second effect hides behind it.

Why the totals differ

A reply in the thread gives the definitions. A customer counts as new for the first order they place in your store, and as returning for the second order and every order after it. That means one customer can appear in both groups in the same month: a person who places a first order early in the month and a second order later in it is new and returning in the same report. The reply adds that the returning figure may count orders from returning customers and not unique people. It is a community answer, so check the definitions against Shopify’s Customers reports page, linked below.

So 191 new plus 45 returning can be more than 225 customers. The extra is not a missing record. It is the same people counted under both labels. Products sold is a third count again, 302 here, and it need not match the number of customers either.

Duplicate profiles are not the cause of this gap. Reading the thread, there is no sign that they are.

The second distortion: one person, two profiles

Shopify’s customer reports work on profiles. If a shopper’s first order is on one profile and the next is on another, the report counts a new customer twice and never sees a returning one.

Our demo store shows what that does to a list built from those counts: 905 look like they stopped ordering → 842 really stopped ordering; 63 still buying under another profile Demo store (Northsail Supply). The gap between the first two figures is customers who still buy, under a newer profile, yet look like they stopped. A win-back discount sent to them goes to someone who never left.

What it costs

A repeat purchase rate that is too low sends you to fix a retention problem you may not have. A win-back list that includes active buyers costs margin on discounts nobody needed. Both come from counting profiles when you meant to count people.

Counting people does not always raise the rate. If both profiles of a split customer already had repeat orders, merging them lowers it. The guide on how duplicates distort repeat purchase rate works through both cases.

How to check your own store

1. Pick one window, for example the last 12 months, and write down which formula you use. Shopify’s reports define their own terms, so check the definition before comparing a report with your sums.
2. Export orders with the customer ID, email, phone and shipping address.
3. Count by profile, then group profiles that clearly match and count by person. Keep profiles that share only an address apart.
4. Report both numbers as a range. The truth for your store sits between the cautious count and the wider one.

Deciding when a customer has stopped buying is a separate question, and a fixed number of days rarely fits. The guide on when a customer has stopped buying uses each customer’s own gap between orders, which is also MergeGuard’s default.

What MergeGuard does

MergeGuard for Shopify does not change Shopify’s report. It builds ready-made lists that count people. The Win-back group has Stopped ordering, Ordering less often, Buys on more than one profile and Ordered once, never came back. By default, each customer is judged against their own usual gap between orders, or you can set 90, 180 or 365 days instead, and orders from all their profiles count together.

Win-back lists come with Scale and Enterprise. On the other plans you see the counts. Sync a list to Klaviyo or export it as a CSV. MergeGuard never messages your customers, and a sync never changes anyone’s consent. Before you send a win-back offer to a list, read who should not get a win-back discount.