- Posts: 57
- Thank you received: 1
Change membership to calendar year
- Christina
-
Topic Author
- Offline
- Senior Member
-
Less
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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:
That should save you from having to do it manually
Regards,
Tuan
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
-
Less
More
- Posts: 57
- Thank you received: 1
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
Regards,
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.