✨ 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 Simple Membership Pro: members & payments as tables

Simple Membership Pro keeps members in swpm_members_tbl and payments in swpm_payments_tbl. SleekView reads both and joins them so renewals, expirations, and account-status fixes happen in a single view.

♾️ Lifetime License available

SleekView table view for Simple Membership Pro

Members and payments in one workspace

Simple Membership Pro stores its operational data in two custom tables: swpm_members_tbl holds one row per member with account_state (active, inactive, expired, pending), membership_level, subscription_starts, last_accessed_date, and the SWPM user ID, while swpm_payments_tbl records every IPN with txn_id, payment_amount, gateway, and status. Membership levels themselves live in swpm_membership_tbl with the level name and access-control rules.

The default Simple Membership admin gives Members, Payments, and Membership Levels separate screens, with filtering limited to single-column dropdowns. There is no joined view showing a member alongside their payment history, no aggregate lifetime-spend column, and bulk operations on account_state happen one row at a time. The free-vs-Pro split also means some reporting screens require the Pro add-on while the underlying tables remain identical, so reading from the database is the most reliable path.

SleekView reads both tables directly, joins them on member_id, and aggregates payments per member so a single row shows level, account state, lifetime spend, last payment date, and last-access timestamp. Status edits route through Simple Membership's SwpmMembers API where available, with direct table writes available for bulk migrations.

Workflow

Simple Membership tables joined into one workspace

1

Map the SWPM tables

Point SleekView at swpm_members_tbl, swpm_payments_tbl, and swpm_membership_tbl. Each becomes a navigable view with the columns Simple Membership already maintains.
2

Join on member_id

Build a member-centric view joining members to their payments. Aggregate payment_amount from swpm_payments_tbl for lifetime spend; show last-payment date inline.
3

Save the workflow views

Save the active-by-level view, the expired-with-recent-access cohort, the pending-no-payment cleanup queue, and the dunning view. Gate each by role so finance, support, and admin see only their columns.
4

Edit through SwpmMembers

account_state and level edits route through the SwpmMembers API class so registered hooks fire. Direct DB writes stay available for bulk cleanup.

Sample columns

A typical Simple Membership Pro members view

Members joined to payments with account_state and lifetime spend pulled from swpm_payments_tbl.
Source: wp_swpm_members_tbl + wp_swpm_payments_tbl
Member Level Account state Lifetime spend Last payment Joined
alex@studio.co Pro Active $180 Apr 24 Jan 12
ria@design.io Annual Active £120 Mar 14 Mar 14
tom@hello.dev Pro Expired $60 Feb 11 Feb 11
mia@brew.coop Trial Inactive €0 (none) Apr 02

Comparison

Default Simple Membership Pro admin vs SleekView

Default Simple Membership Pro admin

  • Members, payments, and levels live on three separate admin screens
  • No joined view linking swpm_members_tbl to swpm_payments_tbl
  • Filtering is limited to single-column dropdowns on account_state or level
  • Bulk account_state changes happen one row at a time
  • Lifetime spend and last-payment date aren't first-class columns

SleekView

  • Joined member + payment views via member_id
  • Lifetime spend aggregated from swpm_payments_tbl inline
  • Filter on account_state, level, and join date together
  • Inline-edit account_state and membership_level in bulk
  • Save views per role for support, finance, and admin

Features

What SleekView gives you for Simple Membership Pro

Joined members and payments

One row per member joining swpm_members_tbl to swpm_payments_tbl on member_id, with lifetime spend, last payment date, and gateway visible inline.

Multi-column filters

Combine filters on account_state, membership_level, and subscription_starts at once, then save the combination as the dunning queue or win-back cohort view.

Bulk state edits

Flip account_state from active to expired across many rows at once, routed through SwpmMembers where available so registered hooks fire.

Audience

Who uses SleekView for Simple Membership Pro

Finance ops

Payment audit table joined to members, sortable by payment_amount and gateway. Filter by month for monthly close, export as CSV for reconciliation.

Membership admins

Active vs expired members in one view with inline account_state fixes. Find pending accounts that never paid and clear them in bulk.

Support

Per-member payment history during a chat without leaving the row. last_accessed_date, lifetime spend, and current level all visible at once.

The bigger picture

Why Simple Membership stores need joined tables

Simple Membership is popular because it does its core job well with a light footprint, but its admin treats members and payments as two unrelated concerns. Operationally every retention question, every dunning workflow, and every cohort analysis needs both tables read together. Did this member's last IPN come in.

Is their account state still active despite a missed payment. How much have they paid since signup. Simple Membership stores the data to answer all of those, but reaching it from the default admin means jumping between Members and Payments screens and reconciling by email.

SleekView's joined view collapses the two tables into one workspace where the row-level question is one filter away. For finance teams running monthly close and support handling chat queries the consolidation removes the cross-screen reconciliation that otherwise eats the day. Stores running both PayPal and Stripe see both gateways in one view filtered by gateway, which is the kind of question the default admin cannot answer without an export.

Questions

Common questions about SleekView for Simple Membership Pro

No. The default Members, Payments, and Membership Levels screens stay in place. SleekView adds a joined workspace on top, so existing workflows keep working while ops gets row-level cross-table views.

 

Yes. SleekView reads swpm_members_tbl and swpm_payments_tbl directly, and both exist in the free Simple Membership plugin. The Pro add-on adds extras like ad-hoc reports, but the underlying tables SleekView reads are the same in both.

 

Yes. State changes route through the SwpmMembers API class where supported, so any registered hooks fire on the update. Direct DB writes are available for bulk migrations where you do not want hooks to re-trigger.

 

Yes. swpm_payments_tbl stores both Stripe and PayPal IPN records with a gateway column, so SleekView filters on gateway just like any other column. You can build a gateway-split dunning view if needed.

 

Yes. SleekView queries are paginated and use Simple Membership's indexed columns (member_id, account_state, email_address). The join is on the indexed member_id column so larger member bases stay fast.

 

Yes. Any view exports to CSV or JSON, including joined member-plus-payment views. Build a saved view for last month's payments by level and export it as a monthly revenue report.

 

Rules are stored as level metadata in swpm_membership_tbl and the category-protection options table. SleekView surfaces them as a filterable view per level so admins can audit which categories each level unlocks.

 

Yes. Each saved view ties to a capability or role so finance sees gateway and amount columns, support sees contact and last-access columns, and admin sees everything. Each role only loads the columns it has access to.

 

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