WooCommerce stores allow users to sign up during checkout, but if they abandon the cart the account remains in the system.
So you might end up with thousands of abandoned customer accounts. This can make your store very slow.
You can use the WP Sheet Editor plugin, which is a plugin that helps you easily and quickly find and delete your non-paying customers.
Install WP Sheet Editor
You can skip this step if you have the plugin installed and activated.
Once you have the plugin installed, you can open it and you’ll see a spreadsheet containing all your WooCommerce customers and their complete profiles.
1. 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 option in the Select the rows that you want to update dropdown.
In this search tool, you need to take these steps:
- Tick the Enable advanced filters checkbox.
- Field key: Orders Count
- Operator: =
- Value: 0
- Click on Run search
2. Delete 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
This and more changes are easily done using the WP Sheet Editor plugin.