I was looking to do some research on which PMPro Customers start as the “Free Download” level, then later upgrade to PMPro Membership or the Little Help Here Package – so I wrote a plugin to easily reveal that data on the user profile screen. Sweet!
If your membership site is structured in tiered access levels, you’re probably curious to see an individual member’s “history” of membership. By default, you could search for a user in the Memberships > Orders admin screen in the WordPress dashboard. This plugin just makes it a little easier to isolate the member history for each unique user.
The data in this report/table is drawn from the ‘pmpro_membership_orders’ table in your WordPress site’s database and includes these order types:
- ‘success’ (the order for the user’s current level)
- ‘cancelled’ (the order for the previous level(s) held by that user)
- ‘refunded’ (orders you changed to “refunded” in the admin)
- ” (orders with no status which are “free” orders)
We’re omitting ‘pending’, ‘token’ and ‘review’ orders as these are order statuses that never were completed.
Comments (7)
Very cool and useful.
Kim, would this tell us the members that went from free in their first year to a paying member once the free membership expired?
Yes – it just pulls every “order” for that member. So if they signed up as “free” in Jan 2014 then purchased a paid level in Jan 2015 it would should you that on their Edit User Profile screen. It’s not a “report” that gives you dashboard view of all members who did this upgrade…but I’m working on that and will blog about it soon 😉
Kim, Shirley (our membership coordinator) told me that members that we put in manually (how we do free members) do not show the history???
Hi Kimberly. Does this work with the WooCommerce addon?
If you are using WooCommerce for checkout, no orders are created in Paid Memberships Pro. So this will not work for WooCommerce.
No problem. That’s what I suspected. 🙂