The WordPress Users & WooCommerce Customers Import Export plugin allows you to export WooCommerce users/customers into a CSV or XML file using advanced filter options. This article explains how to filter user exports based on registration date, user role, activity, purchase data, and other user attributes.
Steps to Export Users
- Navigate to WebToffee Import Export (Pro) → Export.
- Select the post type as User / Customer.
- Choose Advanced export as the export method to avail filter options.
- In Step 3 – Filter Data, configure the required filters.
- In Step 4 – Map and Reorder Export Columns, map the required fields.
- Configure Advanced Options, Batch Export, or Scheduling if required, and complete the export.
Refer to Export WooCommerce Users to learn more about the overall export process.
1. Filter User Export by Registration Date
Follow the steps below to export users registered after or before a specific date.
- Select User / Customer as the post type.
- Choose the Advanced Export method.
- In Step 3 – Filter Data, expand the filter section.
- Under the element Registered at, choose a condition such as Greater than or Less than.
- Select the required date.
For example, to export users registered after March 1, 2025, choose Greater than and set the date as 2025-03-01.
- Proceed to mapping and complete the export.
Only users who registered within the specified date condition will be included in the exported file.
2. Filter User Export by User Role
You can filter user exports based on specific WooCommerce or WordPress roles.
- Select User / Customer as the post type.
- Choose Advanced Export.
- In Step 3 – Filter Data, expand the filter section.
- Under the element Role, select one or more user roles such as Customer, Subscriber, etc.
For example, to export only customers, select only Customer from the Role field. This will exclude administrators, shop managers, and other roles.
- Continue to Step 4 to map and export the file.
Only users matching the selected role(s) will be exported.
3. Filter User Export by Last Active Date
You can export users based on their activity.
- Select User / Customer as the post type.
- Choose Advanced Export.
- In Step 3 – Filter Data, select Last active as the element.
- Choose a condition, such as Greater than, and select a date.
To export users who were active after August 1, 2022, choose Greater than and set the date accordingly.
- Proceed to mapping and complete the export.
Only users who were active after the specified date will be exported.
4. Filter User Export by Purchase Data
Filter by Total Spent or AOV
- Under Filter Data, select Total spent or AOV as the element.
- Choose a condition such as Greater than.
- Enter the required amount.
For example, if you want to export high-value customers who have spent more than $500, select:- Element: Total spent
- Condition: Greater than
- Value: 500
- Proceed to mapping and export the file.
This will export only customers whose total purchase value exceeds the specified amount.
Using Multiple Filters Together
You can combine multiple filters to refine user exports further. For example:
- Role = Customer
- Registered at > 01-01-2024
- Total spent > 500
Only users matching all applied filters will be included in the exported file.
