PI Web Solution

Export WooCommerce customer list or export users with one click.
<ul>
<li>Download complete customer list </li>
<li>Download customer list by skipping rows from the top</li>
<li>Limit the number of customer list rows in the exported CSV</li>
<li>Modify the fields that you want in the generated CSV</li>
<li>You can save the fields needed in the CSV so you don’t have to do this again; from next time onwards, you can directly click download</li>
<li>Automate the whole customer list exporting process and receive the customer list in your inbox</li>
<li>Set the email ID on which you want to receive the email</li>
<li>Export customer user meta data</li>
</ul>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/_tREXIJk96Y?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&cc_load_policy=1&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h3>PRO Version</h3>
Here are the features of the PRO version of Export customer list:
<a href="https://www.piwebsolution.com/product/export-woocommerce-customer-list/" rel="nofollow ugc">Buy PRO version, Limited-period offer</a> | <a href="https://www.piwebsolution.com/user-documentation-export-customer-list-for-woocommerce/" rel="nofollow ugc">Documentation</a>
<ul>
<li>All the features of the FREE version</li>
<li>It allows you to download customers based on their registration dates</li>
<li>It allows you to give custom labels to the columns of the generated CSV</li>
<li>You can download users based on the registration date range</li>
<li>You can set frequency of the automated email, to be Hourly, Twice Daily, Daily, or Weekly</li>
<li>The list that you will receive will contain only the users registered during this time period</li>
<li>You can download Guest customer data in a separate CSV</li>
<li>You can filter out the guest customer list based on their order status</li>
<li>You can filter out the guest customer list based on their order placement date</li>
<li>Export users: You can download any other registered user data by selecting their role, so now you can download WooCommerce customer or normal WordPress user data as well</li>
<li>Download customer records based on the product they have purchased </li>
<li>You can make a condition for downloading the Product Customer List of only those customers who purchased product A and product B together in a single order</li>
<li>You can control the fields you want to download in the Product Customer List records</li>
<li>
You can restrict the Product Customer List by date of purchase or order status as well
</li>
<li>
This plugin can export custom data fields stored in: 
User meta data, stored in the xx_usermeta table 
Order meta data, stored in the xx_postmeta table 
For registered customers: The plugin first tries to search for the custom field in user meta data, and if it is not found there, then it searches order meta data to find the value 
For guest customers: It directly searches order meta data for the custom field data
</li>
<li>
You can receive registered customer, guest customer or both customer records in email attachments
</li>
</ul>
<h3>Privacy</h3>
If you choose to opt in from the plugin settings, or submit optional feedback during deactivation, this plugin may collect basic technical information, including:
<ul>
<li>Plugin version </li>
<li>WordPress version </li>
<li>WooCommerce version </li>
<li>Site URL</li>
<li>Deactivation reason (if submitted)</li>
</ul>
This data is used solely to improve plugin quality, compatibility, and features. No personal or user-specific data is collected without consent.

PiWeb Export Customers Users & Guest customer to CSV for WooCommerce

Works like champ!

Export WooCommerce customer list CSV, export WooCommerce guest customer list CSV, export WordPress users CSV, Product Customer List for WooCommerce

Hardik Patel

Akshay Kungiri

visualsbyridhi

Plugin for filtering, sorting, and exporting users.
This plugin allows you to filter, sort, and export users in CSV format. You can filter users by multiple parameters, such as date, role, meta key-value, and registration date.
<h3>Usage</h3>
Use the Users → All Users Filter screen to compose conditions. Choose a meta key, operator, type, value, and (optionally) group relation to build complex queries without code. Export matched users to CSV.
<h3>Admin UI → WP_Meta_Query Mapping</h3>
<ul>
<li>meta_key → <code>key</code></li>
<li>operator → <code>compare</code></li>
<li>Type → <code>type</code></li>
<li>meta_value → <code>value</code></li>
<li>Group relation (if available) → <code>relation: AND | OR</code></li>
</ul>
<h3>Meta keys used in tests (wp_usermeta.meta_key)</h3>
<ul>
<li><code>job_description</code> (string)</li>
<li><code>job_designation</code> (string; single value OR a pipe/comma-separated list)</li>
<li><code>age_in_years</code> (integer-like string)</li>
<li><code>joining_date</code> (stored as <code>YYYY-MM-DD</code> or full <code>YYYY-MM-DD HH:MM:SS</code>)</li>
<li><code>monthly_salary</code> (numeric, e.g., <code>9000</code>)</li>
</ul>
If your dataset stores dates in a different format (e.g., <code>DD/MM/YYYY</code>) or salaries with commas (e.g., <code>9,000</code>), see Edge Cases below.
<h3>Test Cases</h3>
The following UI test cases validate common scenarios and guardrails.
<h3>1) Single-condition functional tests</h3>
1A. Exact match on text 
Intent: Users with <code>job_description</code> exactly “Lorem ipsum test”. 
UI: 
– meta_key: <code>job_description</code> 
– operator: <code>=</code> 
– Type: <code>CHAR</code> 
– meta_value: <code>Lorem ipsum test</code> 
Expected: Exact match; typically case-insensitive under default collations; respects spaces.
1B. Case-sensitive regex match 
Intent: <code>job_description</code> starts with <code>Lorem</code> (case-sensitive). 
UI: 
– meta_key: <code>job_description</code> 
– operator: <code>REGEXP</code> 
– Type: <code>BINARY</code> 
– meta_value: <code>^Lorem</code> 
Expected: Matches only values beginning with uppercase <code>Lorem</code>.
1C. Negative regex 
Intent: <code>job_description</code> does NOT mention <code>ipsum</code> as a whole word. 
UI: 
– meta_key: <code>job_description</code> 
– operator: <code>NOT REGEXP</code> 
– Type: <code>CHAR</code> 
– meta_value: <code>(^|[^A-Za-z])ipsum([^A-Za-z]|$)</code> 
Expected: Excludes any row containing <code>ipsum</code> as a separate word.
<h3>2) Multi-value (roles) tests for `job_designation`</h3>
Assume values include: UI/UX Designer | QA Engineer | DevOps Engineer | Project Manager | Business Analyst | HR Manager | Data Analyst | Software Engineer | System Admin | Marketing Specialist
2A. Membership via IN 
Intent: QA Engineer OR DevOps Engineer. 
UI: 
– meta_key: <code>job_designation</code> 
– operator: <code>IN</code> 
– Type: <code>CHAR</code> 
– meta_value: <code>QA Engineer, DevOps Engineer</code> (comma-separated → parsed to array) Must Include at least one array 
Expected: Exact membership match.
2B. Pipe-separated field using REGEXP 
Intent: Field stores multiple roles separated by <code>|</code>; match Software Engineer or Data Analyst. 
UI: 
– meta_key: <code>job_designation</code> 
– operator: <code>REGEXP</code> 
– Type: <code>CHAR</code> 
– meta_value: <code>(^|\s*\|\s*)(Software Engineer|Data Analyst)(\s*\|\s*|$)</code> 
Expected: Token-aware match; avoids partials like “Engineer” inside longer tokens.
2C. Excluding a role with NOT REGEXP 
Intent: Exclude HR Manager. 
UI: 
– meta_key: <code>job_designation</code> 
– operator: <code>NOT REGEXP</code> 
– Type: <code>CHAR</code> 
– meta_value: <code>(^|\s*\|\s*)HR Manager(\s*\|\s*|$)</code> 
Expected: Excludes any token equal to HR Manager.
<h3>3) Numeric range tests for `age_in_years`</h3>
3A. Inclusive range (happy path) 
Intent: 18–45 inclusive. 
UI: 
– meta_key: <code>age_in_years</code> 
– operator: <code>BETWEEN</code> 
– Type: <code>NUMERIC</code> (or <code>UNSIGNED</code>) 
– meta_value: <code>18,45</code> 
Expected: Ages 18 through 45 inclusive.
<h3>4) Date tests for `joining_date` on Meta Filters</h3>
Reference cut-off date: 2023-08-25 (two years ago from baseline).
4A. On or before cut-off (joined ≥ 2 years ago) 
UI: 
– meta_key: <code>joining_date</code> 
– operator: <code><=</code> 
– Type: <code>DATE</code> 
– meta_value: <code>2023-08-25</code> 
Expected: On or before 2023-08-25. If stored as DATETIME, see 4A’.
4B’. DATETIME variant 
UI: 
– meta_key: <code>joining_date</code> 
– operator: <code><=</code> 
– Type: <code>DATETIME</code> 
– meta_value: <code>2023-08-25 23:59:59</code>
<h3>5) Salary tests for `monthly_salary` (business rule: exactly 9000)</h3>
5A. Exact numeric 
UI: 
– meta_key: <code>monthly_salary</code> 
– operator: <code>=</code> 
– Type: <code>NUMERIC</code> 
– meta_value: <code>9000</code>
5B. Degenerate range ⇒ equality 
UI: 
– operator: <code>BETWEEN</code> 
– Type: <code>NUMERIC</code> 
– meta_value: <code>9000,9000</code>
<h3>10) Extending scope for multiple users</h3>
Allow non-admins (specific user ID) to use the plugin by adding this to your theme’s functions.php:
<pre><code><?php
// Allow a specific user to access All Users Filter UI
function yr_theme_custom_allusfi_filter( $allowed ) {
 return ( 64901 === get_current_user_id() ) ? true : $allowed;
}
add_filter( 'allusfi_allowed_user_to_filter', 'yr_theme_custom_allusfi_filter' );
</code></pre>

All Users Filter

Filter, sort, and export WordPress users to CSV using powerful UI-driven meta queries (roles, dates, numeric ranges, regex, and more).

PiWeb Export Customers Users & Guest customer to CSV for WooCommerce vs All Users Filter