✨ 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 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

SleekView table view for Paid Member Subscriptions

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

1

Map the PMS tables

Point SleekView at the plans, members-to-plans, and payments tables PMS maintains. Each becomes a navigable view with the columns the plugin already writes.
2

Join on user ID

Build a member-centric view joining members to plans and payments on the WordPress user ID. Aggregate amounts for lifetime spend; show last-payment date and expiry inline.
3

Save the operational views

Build saved views for active by plan, expired-but-still-listed accounts, the cohort joined this month, and the failed-payments dunning queue. Gate by role for finance, admin, support.
4

Edit through the PMS API

Status and plan changes route through PMS' API where supported so member-level hooks fire. Direct DB writes stay available for bulk migrations and one-off cleanups.

Sample columns

A typical Paid Member Subscriptions roster

Members joined to plan, last payment, and expiry in one view.
Source: 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.

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