[SOLVED] Covid-19 Suspend membership renewal

  • Trevor Smith
  • Trevor Smith's Avatar Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
More
2 weeks 2 days ago #133059 by Trevor Smith
Covid-19 Suspend membership renewal was created by Trevor Smith
Hi

As our sports club has to shut down due to the virus it has been decided to suspend membership renewals untll 1st September. (They were due on 1st April)
I have changed the renewal date on the plans but is there an easy way to change the renewal date on the individual subscriptions?

The plans are annual and non-recurring.

Best regards
Trevor

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

  • Trevor Smith
  • Trevor Smith's Avatar Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
More
2 weeks 2 days ago #133062 by Trevor Smith
Replied by Trevor Smith on topic [SOLVED] Covid-19 Suspend membership renewal
I have solved the problem by running a SQL query:
UPDATE `jos_osmembership_subscribers` SET `to_date` = '2020-08-31 23:59:59' WHERE `jos_osmembership_subscribers`.`to_date` LIKE "2020-03-31%"

Stay safe
Trevor

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

More
2 weeks 1 day ago #133075 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic [SOLVED] Covid-19 Suspend membership renewal
Ah, Yes. That's the right solution for your use-case

Tuan

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