How to find customers who stopped buying in WooCommerce

To find customers who stopped buying in WooCommerce, open WooCommerce › Customers, add the advanced filters Number of orders (more than 1) and Last active (before a cutoff date, such as six months ago), then sort by Total spend. The result is your list of past regulars who have gone quiet. Download it as a CSV to follow up.

The rest of this guide covers how to pick the cutoff, where the Customers report can mislead you, an exact SQL version for developers, and how to get the count by asking a question.

The free way: filter the Customers report

1. In WordPress admin, go to WooCommerce › Customers.
2. Click Advanced filters and add Number of orders. Set it to more than 1 (or more than 2 if you only care about solid regulars).
3. Add Last active and set it to before your cutoff date, for example 1 May 2026.
4. Make sure the filter match is set to All, so customers have to meet both conditions.
5. Sort by Total spend to put your most valuable lapsed customers at the top.
6. Click Download to export the list as a CSV. Large exports are emailed to you.

The summary under the table shows how many customers match, along with their average orders and average lifetime spend. That count is your lapsed-customer number for this definition.

What the useful columns tell you

How do you pick the right cutoff date?

A lapsed customer is someone who used to buy and has gone longer than usual without ordering. "Longer than usual" depends on what you sell.

Start from your own buying cycle. If your repeat customers typically reorder every 40 days, a customer who hasn't ordered in 120 days is probably gone, while one at 50 days is just a little late. The guide on how long customers take to order again shows how to measure that gap for your store.

Some rough starting points to adjust from:

• Consumables (coffee, pet food, skincare): two to three times your typical reorder gap.
• Seasonal products: compare with the same season last year rather than a fixed number of days.
• Occasional purchases (furniture, gifts): use a long window, often a year or more, and expect a lower repeat rate anyway.

Pick one definition and stick with it, so the number means the same thing every time you check it.

Where the Customers report can mislead you

• Last active isn't the same as last order. For registered customers, activity in their account can count as "active" even without a purchase. Treat Last active as a guide, and check a customer's order history before assuming they're still buying.
• Guests split if they change email. The report links guest orders by email address. A customer who used two email addresses shows up as two customers, and one of them may look lapsed when the person is still buying.
• Order statuses. Order counts come from WooCommerce Analytics, so orders with statuses listed under Analytics › Settings › Excluded statuses aren't counted. See excluded statuses.
• No date range. The Customers report shows lifetime figures. You can't ask it "how many customers who were active last year are lapsed now" without filtering by registration or last active dates yourself.

For developers: count lapsed customers in SQL

The Analytics table wc_order_stats has one row per order with a customer_id that links to wc_customer_lookup, and it's the same whether your store uses HPOS or posts storage. This counts customers with at least two orders and none since 1 May 2026:

SELECT COUNT(*) AS lapsed_customers
FROM (
  SELECT customer_id,
         COUNT(*) AS orders,
         MAX(date_created) AS last_order
  FROM wp_wc_order_stats
  WHERE parent_id = 0
    AND status IN ('wc-completed', 'wc-processing')
  GROUP BY customer_id
  HAVING orders >= 2
     AND last_order < '2026-05-01'
) lapsed;

parent_id = 0 leaves out refund rows. Adjust the status list to match the statuses your Analytics counts, and change wp_ if your table prefix differs. Unlike the Customers report, this uses the actual order date, not Last active.

The quick way: ask Askshelf

Askshelf adds Analytics › Askshelf to WordPress admin. Its lapsed customers lookup counts how many customers placed at least a given number of orders but none since a date. It returns a count only. It never reads names, emails or addresses, so the follow-up list still comes from the Customers report.

Asking the same question every month gives you a simple trend line for customer loss without building a report. More on the privacy side in is it safe to give AI your store data, and on what else it covers on customers, such as new vs returning counts and repeat purchase rate, in customer analytics with Askshelf.

What to do about lapsed customers

• Contact the highest spenders first. Sort the export by Total spend. A short, personal note to your top 20 lapsed regulars often matters more than a mass discount email.
• Look for a shared cause. If lapsed customers cluster in one country, around one product or after one month, something changed: shipping costs, a discontinued product, a price rise.
• Check what they bought. Customers who started with a product you no longer stock may have nothing to come back for. The guide on which products bring customers back covers this.
• Track the number over time. A rising lapsed count with flat new-customer numbers means your repeat purchase rate is slipping.

For the full picture of what WooCommerce can tell you about customers, see the WooCommerce customer analytics guide.