SleekView for UserPro Pro: profiles, memberships & social activity as tables
UserPro Pro stores extended profile fields in wp_usermeta and ships paid add-ons that add their own tables for memberships, badges, and notifications. SleekView joins them so each member shows profile completion, membership tier, and recent activity on one row.
♾️ Lifetime License available
Profiles, memberships, and add-on data side by side
UserPro Pro is the paid edition of UserPro by DeluxeThemes: front-end registration, customisable profile fields, badges, social connections, and a membership add-on. Most extended profile data writes into wp_usermeta with plugin-prefixed meta keys, while add-ons such as the Memberships and Notifications modules introduce their own tables for transactions, package assignments, and activity feeds.
The default UserPro admin lists users and lets you edit profile fields, but it does not consolidate the picture. Profile completion percentage, active membership tier, last login, badge count, and recent activity each live in separate places. Cohort filtering (active members with incomplete profiles, expired memberships with high badge counts) needs custom SQL or exports.
SleekView reads wp_usermeta by meta key and joins it with the add-on tables to produce a member-centric roster. Profile completion becomes a percentage column, membership tier and renewal date sit alongside, and recent activity counts render as sortable values. Bulk membership extensions and profile-field fixes happen inline through UserPro's API.
Workflow
UserPro profiles and memberships in one workspace
Map the data sources
wp_users, wp_usermeta for UserPro fields, and the membership add-on tables. Each becomes a navigable view with the columns already maintained.
Compose the joined roster
Save the workflow views
Edit through the UserPro API
Sample columns
A typical UserPro Pro members view
wp_usermeta and add-on tables.
wp_usermeta (userpro_* keys) + UserPro membership add-on tables
| Member | Tier | Profile | Last login | Badges | Status |
|---|---|---|---|---|---|
| alex@studio.co | Pro | 92% | May 14 | 7 | Active |
| ria@design.io | Annual | 78% | May 12 | 4 | Active |
| tom@hello.dev | Pro | 55% | Apr 24 | 2 | Past due |
| mia@brew.coop | Free | 31% | Mar 02 | 0 | Cancelled |
Comparison
Default UserPro Pro admin vs SleekView
Default UserPro Pro admin
- Profile completion percentage is not visible alongside the user list
- Membership tier and renewal sit in a separate add-on screen
- Badge counts and activity feeds live behind their own tabs
- Cohort filtering across profile and membership data needs SQL
- Bulk membership extensions for campaigns go one user at a time
SleekView
-
Roster joining
wp_usermetaand the membership add-on tables - Profile-completion percentage as a sortable column
- Tier, renewal date, and last login visible inline
- Inline tier changes via the UserPro API
- Save views per role for support, admin, finance
Features
What SleekView gives you for UserPro Pro
Joined member roster
Pull profile fields from wp_usermeta and combine with the UserPro Pro membership tables. One row per member with tier, profile completion, badge count, and recent activity.
Profile-completion cohorts
Sort by profile-completion percentage to find members who registered but never finished onboarding. Combine with last-login date to scope re-engagement campaigns.
Renewal-risk sort
Sort by next-renewal date from the membership add-on table to surface accounts due in the next 7 days. Combine with last-payment status to find subscribers at risk of involuntary churn.
Audience
Who uses SleekView for UserPro Pro
Finance ops
Renewal-risk roster joined to lifetime spend from the UserPro Pro payments table. Filter by date range for monthly close; export the dunning queue as CSV.
Membership admins
Bulk tier changes for campaign comps. Cohort filtering by profile completion to scope re-engagement sequences; member-status fixes inline.
Support
Per-member profile, badges, and tier visible during chat. Inline tier changes for comping access without leaving the view.
The bigger picture
Why UserPro ops needs joined data
UserPro Pro covers a lot of surface (registration, custom profile fields, badges, social, memberships) and each piece writes to its own slice of the database. The configuration UIs handle that breadth, but the operational UIs are thinner. Profile completion sits in usermeta, tier sits in the membership table, last login sits in a usermeta key, and badges sit in the notifications add-on.
Answering a real ops question (who registered but never completed their profile, who is past due but high-value, who has badges but no recent logins) typically means screen-jumping and CSV exports. SleekView reads each slice and joins them on user_id so the cross-cutting picture is one saved view. The dunning queue is a filter, the re-engagement list is a sort, the profile-cleanup pass is an inline bulk update.
The default admin keeps doing what it does well, and SleekView handles the row-level ops layer the default admin was never designed for.
Questions
Common questions about SleekView for UserPro Pro
Yes. The Memberships, Notifications, and Social Connect add-ons all introduce their own tables or meta keys. SleekView reads them as standard SQL sources and joins them on user_id to the core wp_users roster.
UserPro stores extended profile data in wp_usermeta with plugin-prefixed meta keys. SleekView surfaces each meta key as a sortable, filterable column so any field configured in the profile builder becomes first-class in the view.
Yes when SleekView routes profile and tier changes through the UserPro API. Registered hooks (capability sync, notification emails, social syncing) fire as expected. Direct writes stay available for bulk migrations and skip hooks by design.
Yes. Badge assignments and activity events from the Notifications add-on render as joined columns or as separate saved views. Useful for spotting power users or members who never engaged.
Legacy meta keys remain in wp_usermeta after a field is removed from the profile builder. SleekView lists them so cleanup is one filter and a bulk delete, instead of a manual SQL trawl.
Yes. Save view sets per WordPress capability so finance sees amounts, support sees profile and last-login context, admins see everything. Each role loads only the data it needs.
Yes. UserPro hooks into the standard WordPress personal-data exporter and erasers, and SleekView can additionally export any view as CSV directly from the workspace.
Yes. Queries are paginated and use the indexed user_id columns UserPro maintains on its tables. Sites with tens of thousands of members run smoothly because joins use the existing indexes.
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 Gift Cards Pro
- Woocommerce Snapchat Pixel
- Woocommerce Affirm
- Woocommerce Allegro Pl
- Wp Ecommerce
- Woocommerce Tnt Shipping
- Edd Conditional Emails
- Woocommerce Shipping Royal Mail
- Wholesale Market
- Woocommerce Frontend Manager
- Alibaba Dropshipping
- Yith Woocommerce Points And Rewards
- Dokan
- Woocommerce Waitlist
- Wp Invoice