I still want this. I'm having a particular issue now one year later, where rebills are starting. During a rebill, neither of the key user dates are updated:
mm_status_updated: not changed
mm_expiration_date: not changed
So on 3/25/16 I have a member "Doug" with "mm_status = 1 (active)", "mm_status_updated = 3/25/2015" and "mm_expiration_date=0000" and "mm_next_rebill_date (visible only on dashboard) = 3/25/17".
The next rebill date that appears in the dashboard isn't actually stored in the database, as far as I can tell; it's either pulled from MM payment servers or else inferred with some complicated database synthesis around transactions and orders. I can't easily export it.
So now when I export my members, this seems to be the easiest thing to do:
define next_renewal_due = mm_expiration_date
if (mm_expiration_date is blank or 0000) AND (mm_status = 1 or 9 )
next_renewal_due = mm_status_date
while next_renewal_due < today()
next_renewal_due += mm_rebill_interval
Absolutely need this. For our small newspaper we have a few thousand subscribers I need to import into MemberMouse. They are on an excel sheet. I need to see at a glance when their expiration dates are and whether they are signing up for automatic payment or if they need to manually resubscribe. I'm not seeing any of this information currently.
We are trying to send renewals out via MailChimp as some of the others have mentioned. It is so difficult to get the right data out.
Please include the ability to export the 'Start Date' for members.
Thank you for this suggestion! This feature request or some aspect of the functionality suggested is currently being reviewed for possible inclusion in a future update. If there is additional information, this post will be updated to reflect it.
Can you keep me in touch with the update?
Rest assured, I, or someone from my team, will surely update this post to let everyone know any and all developments on this. :)
Though you cannot currently see all expiration dates in the Manage Members area, you may find the export option as a valuable tool for this. When you Export a list of members, you can see all expiration dates, for both bundles and memberships.
You can read more about the fields available through the export process here: http://support.membermouse.com/support/solutions/articles/9000020319-exporting-members