Active subscribers shown in expired list

  • Francis Bartucca
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 week ago #157191 by Francis Bartucca
Active subscribers shown in expired list was created by Francis Bartucca
Created a menu with Menu Item Type Membership Pro - Members List
Option - Subscription Status - Expired

When I bring up the Members List page on the Front End and sort by Subscription End Date I notice two subscribers at the bottom of the list (about 100 subscribers in list) that are active.

What is different about these two subscribers? These are the only two subscribers who, last year, had upgraded to a different plan while their current plan was active. When they upgraded, their active plan status was changed to expired and their new plan became their current active plan.

As of today, 2023-03-16, their plans show expire date of 2023-12-31. All other subscribers in the expired list show that their plans expired on 2022-12-31.


Frank Bartucca
Asheville Mushroom Club

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

More
1 year 1 week ago #157198 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Active subscribers shown in expired list
Hi Francis

That's unfortunately, how it is designed to work. When their subscription for other plan is expired, they are still being expired members for the plan and will still being displayed on that list

For your need, try to edit the menu item, set SQL Command parameter to below SQL code to see if it works
Code:
tbl.user_id NOT IN (SELECT user_id FROM #__osmembership_subscribers WHERE published = 1)

Regards,

Tuan

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

  • Francis Bartucca
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 week ago #157200 by Francis Bartucca
Replied by Francis Bartucca on topic Active subscribers shown in expired list
Thanks Tuan,

The SQL filter worked! Excluding records with published = 1 user_id was all that was needed.

Best regards,

Francis

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

More
1 year 1 week ago #157201 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Active subscribers shown in expired list
Great. Happy to hear that and thanks for the update Francis

Tuan

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