✨ 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 WooCommerce Roles Pricing: role rules & user pricing as tables

Read directly from the postmeta keys where Roles Pricing stores per-role overrides (typically _role_based_price_*) and join to wp_users by role. Sort, filter, and inline-edit per-role prices across the whole catalogue from one screen.

♾️ Lifetime License available

SleekView table view for WooCommerce Roles Pricing

Per-role pricing without per-product clicks

WooCommerce Roles Pricing stores its per-role overrides in product postmeta rows keyed by role, alongside the standard _price, _regular_price, and _sale_price fields. The default WooCommerce product admin shows one price column, so to audit or update a per-role price you open each product, scroll to the Roles Pricing panel, edit, save, repeat. With a few hundred products that's a long afternoon.

SleekView reads wp_posts filtered to post_type=product, joins the Roles Pricing postmeta keys for each WordPress role, and exposes them as real columns next to base price. Filter by category, sort by role price, or build a percent-diff column to find the products where wholesale is barely below retail. Joining wp_users by role makes a parallel view: who currently has which role, how many of each, and what they pay.

Inline edits write back through WooCommerce's product CRUD where supported, so price-cache invalidations and product-update hooks still fire. Bulk-update fifty wholesale prices by ten percent in one filtered view, no per-product modal dance.

Workflow

Build a per-role price view in four picks

1

Pick the product source

wp_posts filtered to post_type=product (or product_variation for per-variation pricing). SleekView auto-detects which meta keys hold role overrides.
2

Add role columns

From the column picker, select the postmeta keys for each role. Wholesale, reseller, subscriber land next to _regular_price and _sale_price as first-class columns.
3

Build derived columns

Add a percent-diff column (e.g. wholesale vs retail) and a missing-override flag. These run as SQL expressions, no PHP needed.
4

Save and edit in bulk

Save the view for the pricing manager. Filter by category, bulk-update role prices, watch woocommerce_update_product fire row by row through the CRUD layer.

Sample columns

A typical per-role price audit view

Joins product postmeta rows where role-pricing values live. Each role becomes its own column.
Source: wp_posts (post_type=product) + wp_postmeta (role-keyed price keys) + wp_users
Product Retail Wholesale Reseller Subscriber Updated
T-shirt £24.00 £18.00 £16.00 £22.00 Apr 24
Hoodie £48.00 £36.00 £42.00 £45.00 Apr 24
Cap £18.00 £14.00 £12.00 £17.00 Apr 23
Tote £12.00 £11.00 £12.00 £12.00 Apr 23

Comparison

Default Roles Pricing admin vs SleekView

Default Roles Pricing admin

  • Per-role overrides live in postmeta with no catalogue-wide view
  • Updating a role's price means opening each product and scrolling to the Roles Pricing panel
  • No filter for products without a wholesale price set
  • No cross-role audit (e.g. wholesale higher than reseller by mistake)
  • Bulk operations require a custom CSV roundtrip

SleekView

  • Per-role overrides as real columns next to base price
  • Filter products missing a role override, sort by percent diff to retail
  • Inline-edit wholesale, reseller, subscriber prices in the same row
  • Bulk-update fifty role prices in one filtered view
  • Parallel view of wp_users grouped by role with role-price visibility

Features

What SleekView gives you for WooCommerce Roles Pricing

Roles as columns

Each WordPress role becomes a real column next to _regular_price. Spot empty cells (no override set) and inconsistent ordering (wholesale above reseller) at a glance.

Cross-role audit

Build a percent-diff column to find products where wholesale is barely below retail or where reseller exceeds wholesale. One filtered view replaces a spreadsheet pivot.

Inline edits with cache invalidation

Edit role prices inline. Updates route through WooCommerce's product CRUD so price caches invalidate and woocommerce_update_product hooks fire.

Audience

Who uses SleekView for Roles Pricing

Pricing managers

Catalogue-wide view of retail, wholesale, reseller, and subscriber prices side by side. Sort by category and bulk-update an entire range without opening each product.

Margin auditors

Percent-diff columns flag products where the wholesale discount is too small or where role prices are inverted. Pull the full audit before a price-list cycle.

Account managers

Parallel view of wp_users by role with counts per role and active-customer filters. Spot users still on the default role who should have been upgraded to wholesale.

The bigger picture

Why per-role pricing needs a tabular workspace

Pricing is one of the few operational decisions a WooCommerce store makes that touches every product. Roles Pricing solves the data-model side well: each role's override sits on the product's postmeta, indexed by role slug, with WooCommerce's price-resolution logic picking the right value at runtime. The operational side, though, is harder.

A pricing manager auditing margin wants every role's price visible at once, sortable, filterable, and editable in place. The default WooCommerce admin shows one product at a time. The Roles Pricing panel inside each product is fine for setting an override once but unworkable for catalogue-wide audits or quarterly price-list updates.

The result is that most pricing teams either bypass the admin entirely with CSV imports (which break the product-update hooks integrations rely on) or accept that audits never happen because the workflow is too slow. SleekView fixes that by making the same postmeta keys first-class columns in a tabular view. Same data, same hooks on edit, dramatically less click-through.

Pricing managers, margin auditors, and account managers each get the workspace shaped for their job.

Questions

Common questions about SleekView for WooCommerce Roles Pricing

Most Roles Pricing plugins store role overrides in keys like _role_based_price_{role_slug} or a serialised array under a single key. SleekView's column picker reads existing meta keys present in your data so whichever convention the plugin uses, the role columns surface automatically without manual mapping.

 

Yes. Filter on NULL for the role's postmeta key to find products with no override set. That's the typical workflow before a wholesale-pricelist sync: find the gaps, fill them in bulk, push the updated list to wholesale customers.

 

Yes. Updates route through WC_Product::set_meta_data() and save() so the woocommerce_update_product action fires, transient caches invalidate, and any integration listening for product updates (search indexers, CDN purgers) runs as usual.

 

Yes. Filter by category, select the wholesale column, run a bulk transform (e.g. multiply by 0.85). Each row writes back through the product CRUD so price-cache invalidation runs per row. The transform is logged so you can roll back if needed.

 

Yes. Variable products store role prices on each variation's postmeta row (variations are product_variation posts). SleekView either flattens variations into one row per variation or aggregates min/max per parent product, depending on the workflow.

 

They store data in different places. Roles Pricing on product postmeta, Dynamic Pricing in a rules table or option. SleekView shows them side by side as separate columns or separate views, so a finance lead can see both the role-level base and any cart-level discount rule applied.

 

Yes. Saved views are scoped to WordPress capabilities. A pricing manager can have full edit access to all role columns while a customer-service rep sees them read-only. Wholesale-only retailers don't get to see reseller pricing if their role doesn't allow it.

 

Queries hit indexed columns on wp_posts and wp_postmeta. Each role column adds one join to postmeta filtered on meta_key, which is indexed. Five role columns is fine. If you need fifteen role columns on one view, performance is still acceptable but consider splitting into focused views per pricing tier.

 

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