By Summer Henderson on Wednesday, 05 June 2019
Posted in General Issues
Replies 2
Likes 0
Views 768
Votes 0
We would like to export a list of members and member email addresses who have expired subscriptions into a CSV file so we can email them membership renewal reminders. Is this possible and how can I do it?

FYI - We do not have the latest version of Payplans installed yet (we are running 3.7.1) as we are waiting until after the busy season to do this upgrade.
Hey there,

I am really sorry for the delay of this reply as it is a public holidays for us here.

I think Payplans 3.x doesn't have this feature but we did implement this in Payplans 4 (you can refer at my attached screenshot below), you should consider to upgrade it.

By the way, you can try execute this following SQL from your database and see if it showing the correct result for those user subscription already expired.

Remember replace jos_ to your table prefix.

SELECT `a`.`id`, `a`.`username`, `a`.`email` from `jos_users` as a
inner join `jos_payplans_subscription` as s
on s.user_id = a.id
AND s.status in (1603)
group by a.id
·
Wednesday, 05 June 2019 09:34
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post