How To Bulk Migrate Users Between Membership Plans?

I'm trying to consolidate the membership plans on my site. I currently have 3 separate membership plans, but want to combine them into a new, fourth plan. I can't seem to find a way to bulk-select everyone from a given plan and just move them to the new plan. Editing a single subscription does not give me the option to pick another subscription from their current group.

How can I move my users into a new, consolidated membership plan?

Hi Vince

The easiest way would be execute a SQL command via database using PHPMYADMIN. The command is:

UPDATE jos_osmembeship_subscribers SET plan_id = 200 WHERE plan_id = 100

- Replace jos_osmembeship_subscribers with actual table name (change jos_ to the right table prefix)
- Replace 200 with ID of the new plan
- Replace 100 with ID of the original plan

Please do that and let us know if you need more help

Tuan

Hi Tuan,

I presume you meant:

UPDATE jos_osmembeship_subscribers SET plan_id = 200 WHERE plan_id = 100

Correct?

Also, can I add multiple values separated by commas? Ex. 100, 150, 170

EDIT: Just tried it myself, yes the above is the validated; first number is "new plan" and second number is "current plan"

Yes, that's right. I corrected the typo

In case you want to update multiple plans, then the SQL would be changed to:

UPDATE jos_osmembeship_subscribers SET plan_id = 200 WHERE plan_id IN (100, 150, 170)

Regards,

Tuan

Thank you Tuan! This works, thanks for your help!

Great. Happy to hear that . Please continue using the extension. If you have any questions or need help, please don't hesitate to ask us

Regards,

Tuan