Bulk deleting free members from database if custom registration fields are empty

[chrisdoyle]

I’ve searched the forum and every option in the plug in and couldn’t find an answer so I’m hoping someone can help me here.

I have close to 10,000 free members in my database. After installing eMember, I had added two new fields during registration, making it mandatory for all new members to complete these two fields in order to register. I had also asked older members to complete these two fields. The intention was to trim the database to only serious members, since there is a cost involved with such a large member list.

I now need to bulk delete all the members who have not updated these two fields in their profile, since these are not serious members and I do not wish to bear the cost of carrying these members on my list.

My estimate is that there are possibly 3000 plus members who need to be deleted and deleting them one by one is going to be time consuming.

I see two options (if anyone has a third option to suggest, I will greatly appreciate it):

1. Bulk delete all members for whom the two mandatory new fields have not been filled in (but I don’t see any option for this anywhere). If this is possible, this will be ideal

2. Use the admin view (not the public view) of the member list to select and bulk delete members for whom these two fields are empty (but in this case, the two fields don’t show up in the member list in admin view. I do not wish to make the list public for other members to browse, for privacy reasons)

So I need a solution that helps me to identify all members for whom the two new mandatory fields are incomplete and then delete them in bulk, either through the admin view of the members list or using a bulk admin function.

I am not looking for coding support or any such thing, just advice or guidance on how I can solve my problem.

Please, please can you help with this? I will greatly appreciate any suggestions on how this can be done. Many thanks and I look forward to your advice.

[wzp]

I am not looking for coding support or any such thing, just advice or guidance on how I can solve my problem.

Because this is a “one time event,” it makes more sense to write a “simple” PHP script to perform what you want. You can use this pseudo-code (this is NOT real PHP code) to:

LOOP through each member ID

    IF required registration field(s) are empty THEN

        DELETE member account

If you don’t understand what I just described, please show it to someone who knows PHP coding. Essentially, you’d be automating the manual process you described.

[chrisdoyle]

Thank you. I appreciate the guidance. I will ask someone who knows PHP coding to help me with this. Much appreciated.

[Author]

Posts