✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for Paid Membership Pro (Pro)

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

1

Map the PMPro tables

Point SleekView at wp_pmpro_memberships_users, wp_pmpro_membership_orders, and wp_pmpro_membership_levels. Each becomes a navigable view with the columns PMPro already maintains.
2

Join on user_id

Build a member-centric view joining members to orders. Aggregate order amounts for lifetime spend; count recent orders per member for activity context.
3

Save the workflow views

Build saved views for the dunning queue (failed orders), the lapse-in-7-days cohort, and the LTV leaderboard. Gate by role for finance, support, admin.
4

Edit through the PMPro API

Level and status writes go through the PMPro API so member-status and capability hooks fire. Direct DB writes stay available for bulk migrations.

Sample columns

A typical Paid Membership Pro members view

Members joined to level, status, lifetime spend, and last order from wp_pmpro_memberships_users and wp_pmpro_membership_orders.
Source: 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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