Active subscribers shown in expired list

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

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

Regards,

Tuan

Thanks Tuan,

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

Best regards,

Francis

Great. Happy to hear that and thanks for the update Francis

Tuan