SleekView for MemberPress Corporate Pro: parent accounts & sub-seats as tables
MemberPress Corporate Accounts links parent accounts to sub-members through mepr_corporate_account_users. SleekView reads the link table and joins to mepr_members so seat usage, renewal status, and add-remove ops live in one workspace.
♾️ Lifetime License available
Corporate accounts without per-seat clicks
MemberPress Corporate Accounts (the add-on covering team and B2B seats) stores its relationship data in mepr_corporate_account_users, a link table connecting a parent member (the corporate buyer) to one or more sub-members (the seats). The parent's purchase still writes into mepr_transactions and mepr_subscriptions with a corporate_account_id reference, while each sub-member exists as a normal row in mepr_members tied to the parent via the link table.
The default MemberPress admin shows the parent account as a single transaction or subscription and lists sub-members under that parent's detail page. Asking which corporate accounts are using all their seats (so the parent should be upsold to a larger plan), which have unused seats, or which sub-members were last active corporate-wide requires drilling per parent or running custom queries against the link table.
SleekView reads mepr_corporate_account_users and joins it to mepr_members and mepr_subscriptions so a single corporate-account view shows the parent, total seats, seats used, last sub-member activity, and parent subscription state. Drilling shows each seat as its own row joined back to the parent. Inline edits to seat assignments route through the Corporate Accounts API where supported, with direct table writes for bulk migrations.
Workflow
Corporate Pro link table joined into one workspace
Map the link table
mepr_corporate_account_users, mepr_members, and mepr_subscriptions. Each becomes a navigable view with the relationship intact.
Aggregate per parent
Save the B2B ops views
Edit through the Corporate Accounts API
Sample columns
A typical Corporate Pro parent accounts view
wp_mepr_corporate_account_users + wp_mepr_members + wp_mepr_subscriptions
| Parent | Plan | Seats used | Seat usage % | Last seat active | Subscription |
|---|---|---|---|---|---|
| alex@studio.co | Team 20 | 20/20 | 100% | Apr 24 | Active |
| ria@design.io | Team 10 | 8/10 | 80% | Apr 14 | Active |
| tom@hello.dev | Team 5 | 2/5 | 40% | Mar 02 | Past due |
| mia@brew.coop | Team 10 | 10/10 | Overflow | Apr 02 | Cancelled |
Comparison
Default Corporate Accounts admin vs SleekView
Default Corporate Accounts admin
- Parent accounts and sub-members require per-parent drill-down to see seat usage
- No first-class column for seat usage % or unused seats
-
mepr_corporate_account_userslink table isn't exposed as a navigable view - Activity recency across all sub-members under a parent isn't surfaced
- Bulk seat add or remove is per-parent only
SleekView
-
Parent view with seat usage % aggregated from
mepr_corporate_account_users - Last-seat-active timestamp across all sub-members per parent
- Filter parents at 100% usage for the upsell queue
- Filter sub-members by parent for per-account cohort views
- Inline seat assignments via the Corporate Accounts API
Features
What SleekView gives you for MemberPress Corporate Pro
Parents joined to seats
Each parent row joins to mepr_corporate_account_users for the seat list and aggregates seat count + activity across all sub-members on that account.
Upsell queue
Filter parents with seat usage at 100% or above for the upsell queue. Cross-reference with renewal date for the optimal upsell window.
Bulk seat operations
Add or remove seats inline through the Corporate Accounts API. Bulk-onboard a list of emails to a parent account in one operation rather than per-seat drilling.
Audience
Who uses SleekView for MemberPress Corporate Pro
B2B account managers
Upsell queue of parents at 100% seat usage with renewal date inline. Sort by lifetime spend for prioritised outreach.
Customer success
Parents with low seat usage and recent activity are candidates for activation outreach. Filter to seats unused 30+ days for the de-risk queue.
Support
When a corporate buyer asks about their team's status, the parent row shows seat count, usage, activity recency, and subscription state. No drill-down needed for a status check.
The bigger picture
Why corporate-account ops needs joined link tables
B2B and team memberships live or die on seat usage. A parent account at 100% of seats is an upsell opportunity that disappears if it is not caught in the renewal window. A parent at 20% of seats with no activity is a churn risk; with low usage but recent activity it is an activation opportunity.
MemberPress Corporate Accounts stores the data to answer all of those questions through mepr_corporate_account_users, but the default admin makes each parent account a drill-down so the per-account question is not first-class. SleekView's joined view turns each parent into a row with seat usage percentage, last-seat-active timestamp, and parent subscription state inline. Account managers get the upsell queue, customer success gets the activation and at-risk lists, and support gets the corporate-wide status check during a ticket.
The data was always there in the link table. The joined workspace just makes it the default view that B2B account management actually needs.
Questions
Common questions about SleekView for MemberPress Corporate Pro
Via mepr_corporate_account_users, a link table with parent account_id and sub-member user_id. Parent purchases still write into mepr_transactions and mepr_subscriptions with a corporate_account_id reference.
Yes. Count mepr_corporate_account_users rows per parent account_id and divide by the plan's seat limit (stored in the corresponding membership's postmeta) for the usage percentage column.
Filter to seats-used equal to the plan's seat limit and subscription status active. That cohort is the upsell queue. Cross-reference with renewal date for the optimal upsell window.
Yes. Paste a list of emails into the SleekView bulk action and the Corporate Accounts API adds each as a sub-member to the selected parent, firing registered hooks on each addition.
Yes. Corporate accounts and Groups bundles are independent. The parent's purchase can include a bundle, and SleekView shows both the bundle's child memberships and the parent's seat usage in joined views.
Yes. Join each sub-member's mepr_members.last_accessed_date (or BuddyPress last-activity if installed) to the parent's seat list. Aggregate to the most recent per parent for the corporate-wide activity column.
Yes. SleekView paginates and uses indexed columns (account_id, user_id). Even installs with thousands of parent accounts and tens of thousands of seats stay fast.
Yes. Account managers see parent and renewal columns, customer success sees activity columns, support sees parent contact and seat list. Each saved view ties to a WordPress capability.
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 Eu Vat Assistant
- Woocommerce Order Status Control
- Woocommerce Freshbooks Sync
- Woocommerce Checkout Fees
- Woocommerce Cod Fee
- Woocommerce Bing Shopping
- Woocommerce Fortnox Integration
- Edd Conditional Emails
- Edd Stripe Marketplace
- Woocommerce Currency Converter
- Woocommerce Stock Manager Pro
- Woocommerce Loyalty Program
- Yith Woocommerce Product Bundles
- Mailchimp For Woocommerce
- Paystack Woocommerce