Expired or Upgraded?

I am confused, can you please explain how it works...

someone has a 1 year membership which expires. They decide to get a 3 year membership later. technically their 1 year membership IS expired, but I don't want them to show up on "expired" reports because it is misleading.

If they "upgraded" shouldn't it show as a U? even if it was expired?

I'm trying to get a report for client of members that EXPIRED (NO valid subscription) and it still brings up people who have expired but have gotten a different membership later, which is misleading and causes problems when they are included on an "expired" mailing.

Cheryl

When a subscription becomes expired it is marked expired. If a user has not expired and they upgrade to another plan it's marked upgraded. It will not mark as upgraded if they already expired before upgrading. There's no filter for displaying a list of users that have an expired plan, but no active plans. Only way I can think of to do that is maybe an advanced filter on a frontend userlist.

Ok thanks i understand, but it's not great, because if someone's plan expired and they started a new one they still show up when we search for expired subscriptions. Perhaps the system can check that somehow and change status to U or a new status like "REPLACED" or something?

I have a frontend user list using jx tools that displays a view, but again if they have an "x" in any of their subscription status it will show, even if they have an active as well.

I wish there were better reports available. Is there some kind of "view" that you are working on?

The filter is directly interpreting what you select. You selected for any plan to be expired and that's exactly the results you get. It's best to check by active and not expired as then you get all users with at least 1 active plan. We've plans to extend the filtering further at some point, but I've no idea when. I don't know if there will ever be a "expired, but has no active" subscription filter.

I understand why it's working that way, but how then can i accurately assess who has "expired" this way? The client wants to send emails to the "expired" members, but when they do it people get upset because they have renewed their membership.

I have (hopefully) solved this by creating a view in the database that joins the subscription records via userid, and checks if they have an active subscription OTHER than the expired subscription, then display the resulting view as a tools jx report for the client to view on the front end.

If anyone needs help with this I will be happy to share my SQL query to establish the view.

Thanks for the quick replies krileon.