Changing a users plan in admin

Hi,

Is it possible to change the plan a user has purchased in the backend? A user purchased a plan which he wasn't entitled to and I want to add him to the the correct subscription without having to cancel his subscription, refund his money and get him to re subscribe.



I do not want subscribers to have the option of upgrading plans themselves, however need the ability to upgrade a member to Full Membership once they have served their 5 years as a restricted member. Can this be done, or better still, can it be automated once their subscription has reached the 5 year criteria? (Perhaps based on conditionals?)

Many thanks,
Tony

There's no means of easily changing the users subscription plan when it comes to recurring subscriptions. If it's a single payment you can just edit the subscription within CBSubs > Subscriptions by clicking the number under the Id column and changing it there.

For recurring subscriptions that's not an option as the recurring payment is tied to the basket and not the plan so the entire basket chain in the database would need to be modified, which just isn't realistic as it'd be incredibly easy to break it. For recurring subscriptions the best option is for the user to cancel and subscribe to the correct plan. If you really want to try diving into the database to correct it you'll need to modify the relevant data in the below tables.

_cbsubs_payment_baskets
_cbsubs_payments
_cbsubs_payment_items
_cbsubs_payment_totalizers
_cbsubs_subscriptions

Specifically columns associated with the basket and subscription like plan_id, description, and item_name.

Hi Krileon,

That was all I needed to do!
eWAY doesn't allow for recurring repayments, so it was just the membership plan I wanted to change. Now it has been changed, will the renewal notice sent in 12 months time be for the new plan or old one?

That's for the prompt response.

Now it has been changed, will the renewal notice sent in 12 months time be for the new plan or old one?

Emails are tied to the subscription so it should send for the new plan since you changed the subscription.