SleekView for WooCommerce Prices by User Role: per-role catalogue audit
Read directly from product postmeta where Prices by User Role stores per-role values (typically _alg_wc_price_by_user_role_* keys) and join to wp_users by role. Edit role prices in bulk, audit missing overrides, and gate views per team.
♾️ Lifetime License available
Role-priced catalogues, finally in one screen
Prices by User Role stores per-role price overrides on each product's postmeta row, typically under keys like _alg_wc_price_by_user_role_{role_slug} alongside a regular-price counterpart. The default product admin shows base price plus a Prices by User Role meta box hidden behind a click. With dozens of roles and hundreds of products, an audit means opening each product or exporting a CSV that loses formula context.
SleekView reads wp_posts filtered to post_type=product and joins the per-role postmeta keys as first-class columns. Filter to products missing a wholesale price, sort by reseller percent-diff, or build a parallel wp_users view grouped by role to see who actually qualifies for which price. Saved views are scoped per capability so the pricing manager edits, customer service reads.
Inline edits route through WooCommerce's product CRUD where the plugin supports it, so price-cache invalidation, search indexers, and update hooks fire normally. Bulk-shift a category's wholesale price by five percent across a hundred products and each row triggers the same logic as a manual edit, just two hundred times faster.
Workflow
Compose a role-priced catalogue view in four picks
Pick the product source
wp_posts filtered to post_type=product. Variations land as a child option if you need per-variation edits.
Surface role columns
Add audit columns
Save and gate
Sample columns
A typical per-role catalogue view
postmeta rows so each role becomes a column next to _regular_price.
wp_posts (post_type=product) + wp_postmeta (per-role keys) + wp_users
| Product | Retail | Wholesale | Reseller | Subscriber | Updated |
|---|---|---|---|---|---|
| Notebook | $32.00 | $22.00 | $20.00 | $30.00 | Apr 24 |
| Pen set | $18.00 | $13.00 | $16.00 | $17.00 | Apr 24 |
| Mug | $14.00 | $13.00 | $14.00 | $14.00 | Apr 23 |
| Sticker pack | $8.00 | $5.00 | $4.50 | $8.00 | Apr 23 |
Comparison
Default Prices by User Role admin vs SleekView
Default Prices by User Role admin
- Per-role price overrides live behind a meta box, one product at a time
- No catalogue-wide audit across roles
- Bulk edits require CSV import/export with manual mapping
- Roles with no override silently fall back to base price, hidden from view
- No cross-check that wholesale is actually below reseller
SleekView
-
Each role's
postmetakey becomes a real column - Filter for products missing a wholesale price
- Inline-edit role prices with WooCommerce CRUD-routed writes
- Derived percent-diff columns flag inconsistent pricing
- Save catalogue views per role and per capability
Features
What SleekView gives you for WooCommerce Prices by User Role
Missing-override filter
Find every product without a wholesale or reseller price set with a single filter on postmeta NULL. Plug the gaps in bulk before the next price-list sync.
Cross-role audit
Percent-diff columns surface inverted pricing (reseller higher than wholesale) and discounts that are too small. Runs as SQL expressions, no custom code.
Inline catalogue edits
Edit wholesale, reseller, subscriber prices inline. Each save routes through WooCommerce's product CRUD so price caches invalidate and update hooks fire.
Audience
Who uses SleekView for Prices by User Role
Pricing managers
Catalogue-wide view with every role's price as a column. Sort by category, filter by missing overrides, bulk-update before each quarterly price-list cycle.
Account managers
Parallel view of wp_users grouped by role. Spot subscribers still on default pricing who should be on wholesale, then bulk-reassign role.
Margin auditors
Percent-diff and absolute-diff columns flag products with insufficient wholesale margin. Pull the report quarterly and feed corrections back into bulk edits.
The bigger picture
Why role-based catalogues need joined tabular views
A WooCommerce store that prices per role (wholesale, reseller, subscriber, member) is doing customer segmentation through pricing, which is one of the highest-leverage operational decisions a store makes. The plugin handles the data model correctly: per-role overrides on the product's postmeta, resolved at runtime against the logged-in user's role. The challenge is auditing and updating that data at scale.
The default WooCommerce admin is single-product oriented and the plugin's per-product meta box is invisible until you click into a product. So pricing teams end up exporting CSVs, editing in spreadsheets, importing back, and accepting that update hooks never fire because the workflow is too painful otherwise. SleekView changes the shape of the workspace, not the data model.
Same postmeta keys, same hooks, same WooCommerce price-resolution logic. What changes is that a pricing manager sees the whole catalogue's per-role pricing in one screen, sortable, filterable, editable in place. Audits become a saved view that runs in seconds instead of a quarterly project.
Margin discipline becomes possible without burning a person on spreadsheet janitoring.
Questions
Common questions about SleekView for WooCommerce Prices by User Role
Prices by User Role from Algoritmika uses keys prefixed _alg_wc_price_by_user_role_ followed by the role slug, plus matching _regular_ and _sale_ variants. SleekView's column picker enumerates meta keys present on product posts, so the prefix is auto-detected without manual config.
Yes. Variations are product_variation posts with their own postmeta. SleekView can flatten variations into the parent table or expose them as a child table per parent, depending on whether the workflow needs variation-level edits or parent-level summaries.
Each role can have its own regular and sale prices. SleekView shows them as separate columns (e.g. Wholesale regular and Wholesale sale) so a pricing manager can run a per-role sale without touching the global sale schedule. The price WooCommerce ultimately renders depends on resolution logic in the plugin and SleekView leaves that untouched.
Yes. Filter products by category or role-current-price range, select the role's price column, run a bulk transform (e.g. multiply by 0.92). Each row writes back through the product CRUD so update hooks fire and caches invalidate per row.
HPOS affects wc_orders, not product storage. Products still live in wp_posts with postmeta regardless of HPOS state, so role pricing is unaffected. SleekView reads both schemas correctly.
Yes. A parallel view of wp_users joined with wp_usermeta on the role meta key shows every customer's current role. Combine with order-history aggregates to spot users who should be promoted to wholesale based on spend.
Some Prices by User Role builds expose cart-level adjustments via separate options. Those are option-stored, not postmeta-stored, and SleekView surfaces them in a separate options-audit view if needed. The product catalogue view stays focused on per-product per-role pricing.
Each role column adds one indexed join to wp_postmeta. Twenty roles is fine on most stores but it makes the table wide. The recommended pattern is one view per pricing-tier group (B2B view with wholesale plus reseller plus distributor; B2C view with subscriber plus member). Splits keep load times fast and screens readable.
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 Zip Pay
- Woocommerce Bulk Stock Management
- Woocommerce Show Single Variations
- Woocommerce Cheque Payment Pro
- Woocommerce Multi Currency Switcher
- Woocommerce Conditional Shipping And Payments
- Affiliate Aliexpress
- Woocommerce Shipping Discount
- Sprout Invoices
- Flexible Shipping
- Woocommerce Eparcel
- Woocommerce Order Status Control
- Woocommerce Stock Sync
- Woocommerce Wholesale Gateway
- Bigcommerce Bridge