Thread

How do I re-assign users (in bulk) to another member group? Doing one-at-a-time isn’t an option.

There isn’t a stock way to mass switch their groups.  Though I think it would make a good feature request- perhaps it could be added as a dropdown option in the ‘View Member’ page- in addition to the current ‘delete’ option.

That said, it wouldn’t be difficult to do directly via mysql.  However, I’ll move this over to ‘How to’ if you are comfortable going that route.  You’d definitely want to make a backup of your exp_members table before going forward that way.  And how you’d approach it depends on the specifics.  For example, switching everyone in one member group to a different member group would be very easy- just a query in the db query form.  However, if you want to apply it to specific members, the query would be a bit more complex.

Who needs switching- a whole group, or a list of members?

Hey Robin.

A whole group needs to be switched.

😉  Well, that makes things easy.  But seriously- go make a good backup of your exp_members table before doing anything.  Without it, if something goes wrong, you’re in trouble.

Then you just need to switch the group ids around.  The basic query can be done in phpmyadmin, or in ‘Admin- Utilities- SQL Manager- DB Query form’.

UPDATE exp_members SET group_id=5 WHERE group_id=7

To things you have to be really sure about.  The current group id of the members you want to switch and the group_id you want to switch them to.  In the above example, the current id you want switched is the ‘7’ and the one you’re moving them to is the ‘5’.

Does the above make sense?  If you have any doubts, uncertainties, need help figuring out the id- anything?  Ask, and I’ll walk you through it.

Make sense?

Makes perfect sense. Thanks for the feedback/help.

Let me know how it goes- I’ll be keeping an eye out until I’m sure everything went ok.  Have to be careful with direct database manipulation.

Done…without a hitch. Thanks.

Glad that worked smoothly 😊.