Change membership to calendar year

  • Christina
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 9 months ago #148161 by Christina
Change membership to calendar year was created by Christina
Hi

The committee behind the website I run has requested that we change the current membership system where they get 1 year from the date they sign up to having all subscriptions needing renewal on the 1st January.
We will also be giving a year free for 2022 due to covid.

What's the best way for me to achieve this? at present all I can think of is doing it manually for each member.

Thanks

Christina
 

Please Log in or Create an account to join the conversation.

More
3 years 9 months ago #148162 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Change membership to calendar year
Hi Christina

So change subscription end date of all subscriptions to a certain date? And subscription status to Active?

If so, you can run a SQL command:
Code:
UPDATE jos_osmembership_subscribers SET to_date = '2022-12-31 23:59:59', plan_subscription_to_date="2022-12-31 23:59:59", published=1, plan_subscription_status = 1

That should save you from having to do it manually

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Christina
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 9 months ago #148165 by Christina
Replied by Christina on topic Change membership to calendar year
Great, thanks Tuan.

Please Log in or Create an account to join the conversation.

More
3 years 9 months ago #148167 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Change membership to calendar year
You're welcome. If I can help with anything, please don't hesitate to ask

Regards,

Tuan

Please Log in or Create an account to join the conversation.