WooCommerce Delete Non-Paying Customers in Bulk (Users Without Orders)

In this tutorial, you’ll learn how to delete non-paying customers in WooCommerce. This means we’ll delete WooCommerce users with no orders placed.

WooCommerce allows customers to create accounts during checkout if this option is enabled. Depending on how registration is configured, some customers may create an account without completing a purchase. And over time, your store can accumulate inactive customer accounts that have never placed an order.

These accounts take up database space, although they don’t necessarily slow down your store. If you have many unused accounts, you may want to identify and remove those that are no longer needed.

In this tutorial, we’ll show you how to find WooCommerce customers who have never placed an order and delete their accounts in bulk. You just need to follow these steps:

Step 1: Install WP Sheet Editor: Best way to delete users with no orders

This plugin helps you find and delete all those WooCommerce user accounts without orders. You can make advanced searches and apply bulk edits with a few clicks.

You can skip this step if you have the plugin installed and activated.

Once you install and activate the plugin you can open the Users spreadsheet by going to WP Sheet Editor > Edit Customers. You’ll see your WooCommerce customers and their complete profiles.

You can also use this same spreadsheet to add new customers or edit existing customer information directly.

Here you have the steps you need to follow to delete all customer accounts without orders.

Step 2. Find non-paying customers

The first step is to find your customers with no purchases.

For this, you need to open the “Bulk Edit” tool on the toolbar.

Once you’ve opened the bulk edit tool, you need to select the I want to search rows to update and edit all the search results option in the Select the rows that you want to update dropdown.

In this search tool, you need to select these values to find all WooCommerce customer accounts without orders:

• Tick the Enable advanced filters checkbox.
• Field key: Orders Count
• Operator: =
• Value: Enter 0, or leave the field empty
• Click on Run search.

Step 3. Delete WooCommerce non-paying customers

Now that your customers have been filtered, you need to set these values in the Bulk Edit tool to delete the non-paying customers.

• Select the rows that you want to update: I want to search rows to update
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Delete completely
• Click on Execute now

That’s how you can bulk remove all WooCommerce users with no orders placed with WP Sheet Editor for WooCommerce Orders.