How to extend registration deadline for entire subscription

I am using CBSubs to manage yearly dues for members of a professional organization. Due to the coronavirus outbreak, we are extending their subscription period by one year, so no dues will be collected based on the previous due date.

How can I most easily extend each active subscription by one year? The current due date is 8/31/2020 and I would like to make it 8/31/2021.

Thanks for your help.

We've no official functionality for mass modifying subscription dates like that. Assuming you're using non-recurring payments the easiest way to do this is to increment their subscription expiration date by 1 year directly in the database. The below query can accomplish doing this for you.


Replace TABLE_PREFIX with your actual database prefix. Replace PLAN_ID with the plan id you want this to be applied to. So for example I might have the following.


If your subscriptions are recurring subscriptions you've no choice but to first force all the recurring payments to be cancelled. If you're using Stripe you can actually pause payment collections for subscriptions, but you won't have this functionality for other gateways and this must be done from your Stripe dashboard. If you are using Stripe and paused the subscriptions you can use the above query to push their expiration date.