SleekView for Paid Member Subscriptions: members & payments as tables
Paid Member Subscriptions stores subscription plans, member assignments, and payments in its own custom tables. SleekView joins them so each member shows plan, status, last payment, and renewal on one row.
♾️ Lifetime License available
Subscriptions and payments in one workspace
Paid Member Subscriptions (Cozmoslabs) handles its own member-and-payment layer separately from wp_users. Subscription plans live in a plans table, member assignments in a members-to-plans table with status (active, expired, cancelled, pending), start and expiry timestamps, and the linked WordPress user, and payments in a payments table with gateway transaction IDs linking renewals to their parent subscriptions. WooCommerce-restricted products and Stripe recurring charges all flow through the same payments table.
The default Paid Member Subscriptions admin gives Members and Payments separate screens with their own filters. Joining a member to their last payment, current plan, and lifetime spend means jumping between screens and matching by user ID. The members screen shows status but doesn't show last-payment outcome, plan name, or expiry alongside it. Per-plan cohort retention, dunning queues for failed Stripe charges, and lifetime-spend rankings all sit somewhere between the default screens and the export tool.
SleekView reads the plugin's tables directly, joins members to plans and payments on the user ID, and produces a member-centric roster with plan name, status, last payment, lifetime spend, and expiry as columns. The dunning queue becomes a filter on payment status; the renewal-risk list becomes a sort on expiry.
Workflow
PMS members and payments in one workspace
Map the PMS tables
Join on user ID
Save the operational views
Edit through the PMS API
Sample columns
A typical Paid Member Subscriptions roster
PMS plans + members + payments tables
| Member | Plan | Status | Last payment | Expires | Joined |
|---|---|---|---|---|---|
| alex@studio.co | Pro | Active | Apr 24 | Jul 14 | Jan 12 |
| ria@design.io | Annual | Active | Mar 14 | Mar 14 | Mar 14 |
| tom@hello.dev | Pro | Pending | Mar 24 | Jun 24 | Mar 24 |
| mia@brew.coop | Trial | Cancelled | Apr 02 | Apr 16 | Apr 02 |
Comparison
Default Paid Member Subscriptions admin vs SleekView
Default Paid Member Subscriptions admin
- Members and payments live in separate admin screens
- Joining members to last payment requires manual user-ID matching
- Per-plan cohort retention isn't a saved view
- Lifetime-spend ranking sits in exports rather than the table
- Bulk status flips and plan changes go one row at a time
SleekView
- Joined member + plan + payment views
- Lifetime-spend and last-payment columns inline
- Filter by plan + status + expiry together
- Inline status and plan edits via the PMS API
- Save views per role for admin, support, finance
Features
What SleekView gives you for Paid Member Subscriptions
Joined member + payment views
Combine the PMS plans, members-to-plans, and payments tables into one row per member with plan name, status, last payment, lifetime spend, and expiry as proper columns.
Cohorts and retention
Sort by lifetime spend aggregated from the payments table, filter by plan plus join date for cohort views, and rank retention across signup months without exporting CSVs.
Stripe dunning queue
Filter the payments table to failed or refunded statuses for the dunning queue, with member email, plan, and lifetime spend visible inline so outreach can be prioritised by account value.
Audience
Who uses SleekView for Paid Member Subscriptions
Finance ops
Failed-payment dunning queue and LTV ranking joined from the payments table. Filter by date range for monthly close; export the dunning queue as CSV for outreach campaigns.
Membership admins
Active vs pending vs cancelled members with inline status fixes. Spot accounts in pending after a manual-payment plan that need approval before the expiry timer starts.
Support
Per-member payment history, current plan, and expiry visible during chat without screen-jumping. Inline plan changes for the cases where comping access or flipping cadence is warranted.
The bigger picture
Why PMS stores need joined tables
Paid Member Subscriptions sits in a sweet spot for sites that have outgrown the simplest membership plugins but don't need the breadth of MemberPress or Paid Memberships Pro. It does its core job well — plan capture, content restriction, recurring billing — and stays out of the way otherwise. The cost of that simplicity shows up on the operational side, where members and payments are two separate admin screens.
Every retention question, every dunning workflow, and every cohort analysis needs both tables read together. Did this member's last payment fail? Are they still listed as active despite that? How much have they paid since signup? When does their plan expire? PMS stores the data, but reaching it from the default admin means screen-jumping and exports. SleekView's joined view collapses that into one workspace where the row-level question is one filter away — finance running monthly close, support handling chat, and growth running cohort retention all benefit from the same simplification.
Questions
Common questions about SleekView for Paid Member Subscriptions
Yes. Both gateways write into the PMS payments table with the gateway identifier on each row. Filter by gateway for per-channel reconciliation, or scope the dunning queue to a single provider when one gateway is having an outage.
 PMS integrates with WooCommerce by restricting products to plans and recording payments through the same payments table. SleekView surfaces the linked Woo order ID as a column where present so support can drill from a member row to the order.
 Yes when SleekView uses PMS' API for status and plan changes. Registered hooks (renewal emails, capability sync, integration callbacks) fire as expected. Direct DB edits stay available for bulk cleanup and skip hooks by design.
 Yes. Sort the joined view by last-payment date and filter the payment status to failed. That's the dunning queue — members whose most recent charge didn't clear and need outreach before their plan lapses.
 Yes. Recurring renewals land in the payments table with a populated parent-subscription reference. Filter by that field to group renewals per subscription, or count renewals per member for retention analysis.
 Yes. Any SleekView view exports to CSV or JSON, including the joined member-plus-payment view. Build a saved view filtered to last month's payments by plan and export it as a monthly revenue report.
 Group Memberships link sub-members to a parent group via additional metadata. SleekView surfaces the relationship as a parent-group column on the member view so group admins can see all sub-members under one parent without per-account drilling.
 Yes. Queries hit the indexed user-ID column on the PMS tables with paginated reads. Sites with tens of thousands of PMS subscribers run smoothly because the joins use existing indexes rather than scanning postmeta.
 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 checkout