SleekView for Paid Membership Pro (Pro): members, orders & levels as tables
Paid Membership Pro stores members in wp_pmpro_memberships_users and orders in wp_pmpro_membership_orders. SleekView joins them so each member shows level, status, lifetime spend, and last order on one row.
♾️ Lifetime License available
Members, orders and levels in one workspace
Paid Membership Pro stores its operational data in custom tables: wp_pmpro_memberships_users tracks the current and historical level assignment per user, wp_pmpro_membership_orders records each charge and refund with status, amount, and gateway info, and wp_pmpro_membership_levels defines the level catalogue. The Pro edition of this listing adds the official paid extensions (recurring billing, advanced gateway setup, reports add-ons) on top of the same data model.
The default PMPro admin gives each table its own screen: Members, Orders, Levels, Reports. Joining them means the Reports module or custom SQL. A simple ops question (show me members whose last order failed and whose level is still active) does not have a one-screen answer in the default admin.
SleekView reads all three custom tables directly and joins them on user_id so a single member-centric view shows status, level, lifetime spend, active subscription state, and last order outcome in one row. The dunning queue becomes a saved view; the LTV leaderboard becomes a sort.
Workflow
PMPro members, orders and levels in one workspace
Map the PMPro tables
wp_pmpro_memberships_users, wp_pmpro_membership_orders, and wp_pmpro_membership_levels. Each becomes a navigable view with the columns PMPro already maintains.
Join on user_id
Save the workflow views
Edit through the PMPro API
Sample columns
A typical Paid Membership Pro members view
wp_pmpro_memberships_users and wp_pmpro_membership_orders.
wp_pmpro_memberships_users + wp_pmpro_membership_orders + wp_pmpro_membership_levels
| Member | Level | Status | Lifetime spend | Last order | Joined |
|---|---|---|---|---|---|
| alex@studio.co | Pro | Active | €288 | May 14 | Jan 12 |
| ria@design.io | Annual | Active | €720 | Feb 03 | Feb 03 |
| tom@hello.dev | Pro | Past due | €144 | Apr 24 | Mar 12 |
| mia@brew.coop | Free | Cancelled | €0 | . | Apr 02 |
Comparison
Default Paid Membership Pro admin vs SleekView
Default Paid Membership Pro admin
- Members and Orders live in separate admin screens
- Cross-table joins (member + LTV + last order) need custom queries
- Dunning queue (failed orders) requires Reports navigation
- Bulk status updates are not first-class
- Per-level cohort views need exports
SleekView
- Joined member, level, and order views
- Lifetime-spend and last-order columns inline
- Filter failed orders for the dunning queue
- Inline level changes via the PMPro API
- Save views per role (admin, support, finance)
Features
What SleekView gives you for Paid Membership Pro (Pro)
Joined PMPro tables
Build a single view that joins wp_pmpro_memberships_users with wp_pmpro_membership_orders on user_id. One row per member with the relevant fields visible inline.
LTV and cohort sorting
Per-member lifetime spend aggregated from wp_pmpro_membership_orders, active level, and join date. Sort to find high-value or at-risk accounts; filter by level for cohort analysis.
Dunning queue
Filter wp_pmpro_membership_orders to failed or refunded statuses for the dunning queue, with member email, level, and lifetime spend visible inline so outreach can be prioritised by account value.
Audience
Who uses SleekView for Paid Membership Pro (Pro)
Finance ops
Failed-order dunning queue and LTV ranking in one view. Filter by date range for monthly close; export the dunning queue as CSV for outreach campaigns.
Membership admins
Active vs cancelled members with inline level edits. Bulk-update level state across cohorts for migrations, comp accounts, or scheduled status flips.
Support
Per-member order history visible during chat without jumping screens. Level state, last charge, and lifetime spend all on one row for full context.
The bigger picture
Why PMPro ops needs joined tables
Membership businesses live and die by retention, and retention questions are inherently cross-table. Did this member's last charge fail. Is their level still active despite the failed charge.
How much have they paid lifetime, and which level are they on. PMPro stores the data to answer all of those, but in three separate tables accessed through three separate admin screens. The Reports module covers the aggregate questions but not the row-level ones, so figuring out which specific members need outreach today still means jumping between screens or running SQL.
SleekView's joined view turns the cross-table question into a single screen: members joined to their orders, with lifetime spend and last-order status as columns. Ops can see, in one view, every member whose payment failed in the last week alongside their lifetime value and current level state, which is exactly the data needed to prioritise outreach. For finance teams running monthly close or support teams handling chat queries, that consolidation is the difference between hours of cross-screen reconciliation and a single saved view.
Questions
Common questions about SleekView for Paid Membership Pro (Pro)
Yes. Recurring orders are recorded in wp_pmpro_membership_orders with the gateway identifier and recurring flag on the row. Filter by recurring vs one-off to scope the dunning queue or the LTV leaderboard accordingly.
Yes. Level changes route through PMPro's API where supported so registered hooks (member-status emails, capability sync, gateway updates) fire on inline edits. Direct DB writes remain available for bulk migrations and skip hooks by design.
 
PMPro add-ons such as Approvals, Sponsored Members, and Multiple Memberships introduce additional tables or meta keys. SleekView reads them as standard SQL sources and joins them to the member roster on user_id.
Yes. wp_pmpro_memberships_users retains historical level rows with the status flag indicating current vs cancelled. SleekView surfaces history as a separate joined view so admins can trace level changes over time without SQL.
Yes. Queries are paginated and use the indexed columns PMPro maintains on its tables. Stores with hundreds of thousands of members run smoothly because joins happen on indexed user_id columns rather than scanning postmeta.
 Yes. Save views per WordPress capability so finance sees amounts and gateway data, support sees member contact and last activity, admins see everything.
 
Yes. Stripe, PayPal, Authorize.Net, and the other gateways PMPro supports all write into wp_pmpro_membership_orders with the gateway identifier on the row. Filter by gateway for per-channel reconciliation.
Yes. PMPro hooks into the standard WordPress personal-data exporter and erasers. SleekView can also export any view as CSV directly from the workspace for ad hoc requests.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Veeqo Wp
- Woocommerce Easyship
- Yith Woocommerce Product Add Ons
- Woocommerce Stock Manager
- Woocommerce Subscriptions
- Woocommerce Shipping Class Rates
- Woocommerce Eu Vat Assistant
- Mollie Payments
- Woocommerce Coinbase Commerce
- Woocommerce Bambora
- Wp Crowdfunding
- Woocommerce Product Addons Pro
- Woocommerce Trade Pricing
- Woocommerce Elavon
- Woocommerce Points And Rewards