change plan from 1 year to fixed date expiry
- Alison
- Topic Author
- Offline
- Platinum Member
Less
More
2 years 11 months ago #144156
by Alison
change plan from 1 year to fixed date expiry was created by Alison
Hi Guys
We have a plan which has always had a subscription length of 1 year from the time of purchase/renewal.
We now want to change this plan so that all memberships expire on 30th June each year so that everyone renews at the same time.
How can I achieve this change with a current plan with many members.
I have attached the current set up for your reference
Thanks
Alison
We have a plan which has always had a subscription length of 1 year from the time of purchase/renewal.
We now want to change this plan so that all memberships expire on 30th June each year so that everyone renews at the same time.
How can I achieve this change with a current plan with many members.
I have attached the current set up for your reference
Thanks
Alison
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
2 years 11 months ago #144160
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic change plan from 1 year to fixed date expiry
I guess you would have to run an SQL command to your database
Maybe should only update subscription end date of active subscribers only ?
UPDATE #__osmembership_subscribers SET to_date = "2021-06-30" WHERE published = 1 AND YEAR('to_date') = 2021
(Replace #__osmembership_subscribers with the actual table on your site, depends on table prefix)
Regards,
Tuan
Maybe should only update subscription end date of active subscribers only ?
UPDATE #__osmembership_subscribers SET to_date = "2021-06-30" WHERE published = 1 AND YEAR('to_date') = 2021
(Replace #__osmembership_subscribers with the actual table on your site, depends on table prefix)
Regards,
Tuan
The following user(s) said Thank You: Alison
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2024 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.