How to move subscribers to another plan?

Hi Tuan,
I have several plans which subscribe users to the same Joomla ACL group. Those several plans were priced differently, depending whether a client had a required license from third party software or not.
But now this is changed as the third party license is no longer needed.
Therefore, I disabled the deprecated plans, but I now need to move the existing users of those plans to the one that is still active, otherwise, they can't renew when their subscription is expired.
I didn't find a function to do that, so I suppose that is currently not possible with Membership Pro.
Since this is very urgent, is there a way to do this manually?
Thank you beforehand!

I think you can go to Membership Pro -> Subscriptions, click on the subscription record to edit and change it the plan for the record from there

Have you tried to do that? Or if you want a fast solution, run an SQL command below to your database and it should be OK

UPDATE #__osmembership_subscribers SET plan_id = NEW_PLAN_ID WHERE plan_id = OLD_PLAN_ID

Of course #__ needs to be replaced with your table prefix and NEW_PLAN_ID and OLD_PLAN_ID needs to be replaced with the actual IDs of the plans

Regards,

Tuan