How to email users with expired memberships

Please have a look at this document. www.ramtinworld.com/expired.jpg

All the expired memberships still have Active as status.

So I am not sure how I can filter by expired when the status is active?

I appreciate your help.

ramtinworld wrote: Hi,

We have set an expiry date as end of June to all our membership packages.

How exactly did you do this and when?

As per your previous instructions we used SQL actions and we set this up when we went live with the module.

You have probably setup a "Grace period before real expiration" in Plans -> Plan -> Pricing tab for that plan, so it stays active for the grace period before the real expiration.

Also the auto-expiration method chosen in global settings of cbsubs should be triggered for the real expiry to happen. By default that happens automatically. But if you set it to cron job and don't setup a cron job, it won't happen.

sorry I think I kind of understand your response, but I am confused as well.

Our memberships will expired end of each June (end of fiscal year in Australia) and it really doesn't matter when the members sign up.

So since there is no way to make this happen under the standard plan section, your team suggested that we use SQL actions to force expiry end of June each year.

Is there a way to fix this really now?

And I dont really understand this section of your response:

Also the auto-expiration method chosen in global settings of cbsubs should be triggered for the real expiry to happen. By default that happens automatically. But if you set it to cron job and don't setup a cron job, it won't happen.

In CBSubs 1.1.2 the solution to change the physical calendar expiration date from December 31st is indeed to use SQL modifications.

CBSubs 1.2 has a clean implementation for this, so you can upgrade and use it.

What Beat said is to check you plan to see if it includes a 'Grace period before real expiration:' value in the plan pricing tab setting.