[Resolved] Bulk Delete Users with ‘Activation required’ account status

To delete all member records from the ‘swpm_members_tbl’ database table in one step, you can run a query with the following condition:

account_state = activation_required

You can use PHPMyAdmin or any other database management tool to browse the table and execute this query. Always ensure you take a backup before performing any delete operations.

Unfortunately this doesn’t delete the related WordPress users. It would be helpful to have a bulk operation to delete “Activation Required” or a command via wp-cli.

A temporary solution is to add the following code as a mu-plugin which will set the items per page on the membership members page to 200 versus 50.

function custom_swpm_members_items_per_page( $perpage ) {
    return 200; // Change 200 to whatever number you prefer.
}
add_filter( 'swpm_members_menu_items_per_page', 'custom_swpm_members_items_per_page' );