Table of Contents
Problem description #
Admins want to list or delete users who never verified their email.
Common symptoms:
- Large list of unverified signups and wish to clean them up.
- Admin cannot find unverified users in the plugin settings.
Typical causes:
- Unverified users are recorded by the plugin in a dedicated section but not auto-deleted by default.
Solution (step-by-step)
- Where to look: Go to WooCommerce → Email Verification → Unverified Users (this is the built-in list the plugin exposes). Check for entries there.
- Bulk deletion via plugin UI: If the plugin provides bulk actions in the Unverified Users tab, use that (select entries → bulk delete).
- If plugin lacks bulk delete and you have many entries: Request guidance from plugin author or use a SQL query (advanced), backup your DB first
Example (conceptual only, do not run without backup and adaptation to your DB schema):
DELETE FROM wp_users
WHERE ID IN (SELECT user_id FROM wp_customer_email_verification_unverified WHERE DATE(created_at) < ‘2025-01-01’);
- Note: table/column names may differ, ask plugin author for exact schema before running DB commands.
- Request auto-cleanup feature: If desired, ask plugin author to add automatic deletion after X days (feature request).
Prerequisites
- Admin access and database backups if using SQL.
Additional notes
- Always export a list before deletion in case you need to restore data.
