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
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
Map the SWPM tables
swpm_members_tbl, swpm_payments_tbl, and swpm_membership_tbl. Each becomes a navigable view with the columns Simple Membership already maintains.
Join on member_id
payment_amount from swpm_payments_tbl for lifetime spend; show last-payment date inline.
Save the workflow views
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
account_state and lifetime spend pulled from swpm_payments_tbl.
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_tbltoswpm_payments_tbl -
Filtering is limited to single-column dropdowns on
account_stateor level -
Bulk
account_statechanges 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_tblinline -
Filter on
account_state, level, and join date together -
Inline-edit
account_stateandmembership_levelin 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.
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
- Woocommerce Quotes Orders
- Currency Switcher
- Woocommerce Afterpay
- Woocommerce Frontend Manager
- Wcfm Vendor Verification
- Woocommerce Dpd Shipping
- Woocommerce Product Vendors Pro
- Woocommerce Product Table
- Yith Woocommerce Product Slider
- Woocommerce Cashfree
- Pretty Links
- Woo Direct Checkout
- Woocommerce Postnord
- Woocommerce Mondial Relay
- Woocommerce Checkout Addons