SleekView Charts for YITH Role Based Prices: chart sales by customer role
YITH Role Based Prices writes per role price postmeta to every product, like _ywrbp_role_
♾️ Lifetime License available
Read your wholesale and role based pricing as charts, not a price matrix
YITH Role Based Prices already has the data. Each product carries per role postmeta like _ywrbp_role_wholesale_regular_price, _ywrbp_role_wholesale_sale_price, _ywrbp_role_b2b_regular_price, and a rules option in wp_options. On the customer side, the WordPress role lives in wp_usermeta under wp_capabilities. When a wholesale customer checks out, WooCommerce stores the resolved price in woocommerce_order_itemmeta under _line_total and _line_subtotal, alongside the customer_id on wc_orders.
SleekView Charts reads those tables together and turns them into chart cards on a single dashboard. A Number card summing total_amount for orders placed by wholesale role customers in the current month, a Donut splitting revenue by role across customer, wholesale, b2b, and reseller, a Horizontal Bar of top wholesale customers by revenue, and an Area chart of daily revenue split by role. Each card is a saved query against the live tables.
This is not a replacement for the pricing engine. YITH still owns defining per role prices on each product, computing the right price for the right role on the catalog and cart, and handling the price rules from the YITH admin. SleekView Charts adds the reading layer the pricing rules screen does not provide: revenue by role, AOV per role, and top wholesale customers, scoped per role and embeddable on a frontend page.
Workflow
From _ywrbp_role meta to a dashboard in four steps
Point SleekView at WooCommerce and users
Switch the view to Charts
Add chart cards split by customer role
Save and share the dashboard
Sample dashboard
Charts you can build from YITH Role Based Prices data
Wholesale revenue this month
Sum(total_amount)
Revenue by customer role
Sum(total_amount)
group by customer_role
Top wholesale customers
Sum(total_amount)
group by customer_id
Daily revenue by role
Sum(total_amount)
group by date_created_gmt
Comparison
Default YITH pricing rules vs SleekView Charts
Default YITH pricing rules
- The YITH admin defines per role prices but never reports revenue by role
- wp_capabilities and per role price meta are not exposed as chartable dimensions
- No way to see retail versus wholesale revenue side by side on one screen
- No saved dashboards per role for wholesale account managers, finance, and the owner
- No frontend embed for wholesale account managers without the orders screen
SleekView Charts
- Configurable chart cards built directly from wc_orders joined with customer role from wp_usermeta
- Mix Number, Pie, Bar, Line, and Area cards on a single role based pricing dashboard
- Group by the role in wp_capabilities and reference the YITH _ywrbp_role price meta for product context
- Saved chart views scoped per role for wholesale, finance, and the owner
- Embed any saved chart view on a frontend page with role based access
Features
What SleekView Charts gives you for YITH WooCommerce Role Based Prices
Chart cards by customer role
Number, Pie, Bar, Line, and Area cards split by the WordPress role of the customer on each order, the same role YITH uses to pick the right price on the catalog and cart.
Complements role pricing
YITH still owns defining per role prices and applying the right one at runtime. SleekView Charts adds the reading layer that lets the team see which role tier is actually paying off.
Wholesale embed
Save a wholesale focused dashboard and embed it on a frontend page for wholesale account managers so they read totals and top customers without admin access.
Audience
Who builds role based pricing dashboards with SleekView
Wholesale leads
Track the wholesale revenue KPI and the top wholesale customers bar to know which accounts to prioritise and which to nudge, without paging through filtered order lists.
Finance teams
Read the revenue by role donut to know the mix between retail and wholesale, useful for cash flow planning and for reviewing whether wholesale terms still make sense at the current price split.
Store owners
Watch the daily revenue area chart with retail and wholesale series to confirm that adding a new role tier expanded revenue rather than just shifting it from one role to another.
The bigger picture
Role pricing is only useful when you can read the revenue split
YITH Role Based Prices stores plenty of data. Each product carries per role price postmeta and each customer carries a WordPress role in wp_capabilities. The YITH admin is great at defining the prices.
It does not report revenue back by role, top wholesale customers, or whether the wholesale tier expanded revenue or just cannibalised retail. SleekView Charts reads wc_orders together with wp_usermeta and turns it all into chart cards on one saved dashboard. The wholesale lead sees the wholesale revenue KPI and the top wholesale customers bar.
Finance sees the revenue by role donut to keep an eye on the mix. The owner sees a daily area chart with retail and wholesale series to confirm that role tiers actually lift the total. YITH keeps owning the price rules, the per role product fields, and the runtime price selection; SleekView Charts adds the reading layer that wholesale leads, finance, and the owner can share, scope per role, and embed on a frontend wholesale dashboard page without exposing every order.
Questions
Common questions about SleekView Charts for YITH WooCommerce Role Based Prices
No. YITH still owns defining per role prices on each product, the rule engine that decides which price to show, and the catalog and cart integration. SleekView Charts reads wc_orders and joins customer role from wp_usermeta, so the two plugins are complementary rather than a swap.
Yes. WordPress supports an arbitrary set of roles. YITH lets you define a different price per role. SleekView Charts groups orders by the wp_capabilities value of the customer at checkout, so the donut and area chart can have as many series as you have configured roles in the store.
Yes. SleekView Charts groups orders by the customer's current role by default. If you want the role at the time of the order, you can use a snapshot order meta_key like _customer_role that YITH or a small hook can write at checkout, and chart that instead.
Yes. The YITH _ywrbp_role_wholesale_regular_price and _ywrbp_role_wholesale_sale_price meta carry the rate per product. A card can compare the line_total against the retail price meta on the same product to surface the implied wholesale discount across the period.
WooCommerce handles tax based on the customer's address and role through its own engine. SleekView Charts reads total_amount which already includes or excludes tax depending on the store setting, so the wholesale revenue KPI matches whatever WooCommerce treated as the order total.
Guest checkouts default to the customer role and YITH applies the retail price. SleekView Charts groups those orders under customer in the role donut, so a guest dominated store still sees the retail share cleanly while the wholesale tier counts only logged in role customers.
Yes. If your store uses WooCommerce Memberships or Subscriptions to apply roles dynamically, the role still lives in wp_usermeta when the order is placed. SleekView Charts reads that role at order time, so dashboards stay accurate even when membership transitions change the price tier.
Yes. SleekView ships a frontend embed with role based access, so a wholesale account manager can land on a private page that shows the wholesale revenue KPI, the role donut, and the top wholesale customers without ever opening the orders screen or admin.
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 Multilingual Currency
- Yith Essential Kit
- Advanced Shipment Tracking For Woocommerce
- Yith Woocommerce Deposits And Down Payments
- Woocommerce Advanced Shipment Tracking
- Woo Product Reviews Pro
- Solid Affiliate
- Woocommerce Tax Toggle
- Woocommerce Composite Products
- Fkcart
- Woocommerce Sezzle
- Yith Woocommerce Product Bundles
- Woocommerce Pdf Invoices Packing Slips
- Advanced Coupons
- Woocommerce Purchase Order Gateway