Mass Change of Subscription End Date

All our membership plans except for one (Lifetime) expiry on the same date (30th April). Due to changes in our accounting systems we want to bring the membership expiry date back to 31st December.  Is there an easy way to do this apart from running an SQL query?
 

Unfortunately, you would have to do it via SQL query. We do not support batch change to subscriptions at the moment. However, something I can support for in the future

Regards,

Tuan

Hi Than,
I thought that might be the answer, no worries. I don't think those would be an 'everyday' requirement of EB users.
Kind regards
David

Yes. But it could still be useful in some cases

I think if you are going to provide this feature, maybe include the possibility for admins to Cancel subscriptions also. Currently they can manually renew..... Just a thought 
 

For a recurring subscription, admin should be able to cancel it already. He needs to click on a subscription record, and on edit screen, if it is a valid recurring subscription and not cancelled yet, he will be a button to allow cancelling subscription

For one time subscription, we do not have Cancel Subscription, so guess you will have to change subscription status to Expired manually yourself

Regards,

Tuan

Here is some comments and SQL code that Tuan has very kindly given me to as a workaround:  Thanks Tuan !!!!
NOTE OF CAUTION! Before running this code, make sure you have a backup of your Site and or Events Booking. Manual changes to the data base could bring your site down or corrupt it...So please be careful
Fields you need to update
- to_date is the field you need to update
- plan_subscription_to_date should be updated to the same date, too

General, one user can have multiple subscription records of the same plan. In that case, plan_subscription_to_date keeps the end date of the whole subscription (basically, it equals to to_date of the last renewal record)

Hope you get the idea. Run a SQL command attached in zip file.

Replace jos_ with actual table prefix on your site database 
Replace dates in to_date and plan_subscription_to_date with the date you want the membership to expire
Replace category_id with IDs of any  categories (plan categories) you wish to change

As an alternative to running your own SQL code there is a Joomla Module from Regular Labs that might be easier to use if you are not familiar with running SQL code. It is called DB replacer  regularlabs.com/dbreplacer  
NOTE: The free version only allows max of 50 records to be changed, so you may have to run it multiple times to correct all your subscription records


 

Thanks David for sharing it back to forum.