SleekView for WooCommerce Wholesale Prices: roles & wholesale prices as tables
Wholesale Prices saves per-role prices in product postmeta keyed by role slug. SleekView pivots each role into its own column alongside retail price, so catalog audits and margin analysis live on one screen instead of the per-product editor.
♾️ Lifetime License available
Retail and wholesale prices, finally side by side
WooCommerce Wholesale Prices stores per-role pricing as wp_postmeta rows keyed by the role slug — for example wholesale_customer_wholesale_price or distributor_wholesale_price. The default plugin UI shows those values inside the per-product editor, which is fine for setting one price but unworkable for auditing five hundred products across three wholesale roles.
SleekView pivots each role's price into its own column next to retail price and SKU on a flat catalog view. Computed columns derive discount percentage off retail per role, so margin checks happen by sorting a column rather than running an export. Filtering to rows where a specific role's price is null surfaces products missing wholesale coverage for that role — the single most common pre-launch audit before opening a wholesale store to a new customer segment.
The same view supports bulk inline updates through the plugin's price-update hooks, so price-history logs and audit trails continue to fire as expected. Variation-level wholesale prices on wp_postmeta keyed against variation post IDs join naturally onto the parent product row for granular review.
Workflow
Wholesale catalogs as a real ranked workspace
Pivot per-role meta keys
Compute discount columns
Filter missing-price rows
Save per-manager presets
Sample columns
A typical wholesale catalog view
wp_postmeta (wholesale price keys) + wp_users (wholesale roles)
| Product | SKU | Retail | Wholesale | Distributor | Status |
|---|---|---|---|---|---|
| Studio Desk | SD-100 | EUR 320 | EUR 240 | EUR 210 | Active |
| Office Chair | OC-220 | EUR 180 | EUR 130 | EUR 110 | Active |
| Acoustic Panel | AP-018 | EUR 90 | EUR 70 | — | Missing role |
| Lamp Pro | LP-008 | EUR 60 | — | — | No wholesale |
Comparison
Default Wholesale admin vs SleekView
Default Wholesale admin
- Wholesale prices live in the per-product editor — no flat catalog view
- Audits for missing per-role prices need code or exports
- Bulk wholesale price updates go one product at a time
- Margin and discount columns aren't built in
- Wholesale customers are tied to a role but no joined view
SleekView
- Pivot per-role wholesale prices from postmeta into columns
- Show retail, wholesale, and distributor prices side by side
- Calculate discount % per role inline
- Filter to products missing a wholesale price
- Save views per pricing manager
Features
What SleekView gives you for WooCommerce Wholesale Prices
Per-role columns
Each wholesale role gets its own price column pivoted from postmeta. Compare across roles in one ranked view instead of clicking through the per-product editor.
Missing-price audit
Filter to products that don't have a wholesale price set for a given role and bulk-set defaults inline. Catches gaps before a wholesale customer hits retail at checkout.
Margin and discount math
Computed columns show discount percentage off retail per role. Sort ascending to find products where wholesale margins are too thin before finance flags them.
Audience
Who uses SleekView for WooCommerce Wholesale Prices
Pricing managers
Catalog-wide wholesale audits with per-role pricing visible inline. Saved daily views surface missing-price rows before a partner segment goes live.
B2B account managers
Per-customer effective price for accurate quoting, scoped to the role each customer maps to. No editor round-trips during sales calls or RFP responses.
Finance
Discount and margin reports across the wholesale portfolio with computed columns sortable across thousands of SKUs. Catches drift before quarterly reviews.
The bigger picture
Why wholesale catalogs need a flat workspace
Wholesale pricing in WooCommerce sits in a structurally awkward place: it lives in postmeta keyed by role slug, which means the same product can have a retail price, a distributor price, a wholesale-customer price, and a reseller price scattered across four meta rows that the editor surfaces one at a time. The plugin works fine for adding a price; it works poorly for auditing a thousand-SKU catalog before a partner roll-out. Missing a single role price means that wholesale customer pays retail at checkout — usually the moment the customer notices, which is usually the moment trust is damaged.
A flat sortable view of every product with retail and per-role wholesale columns turns that audit from an export-driven Excel exercise into a daily filter. Margins drift the same way: when costs rise but wholesale tiers are not updated, the discount percentage off retail goes from healthy to bleeding without any UI surfacing the slippage. A computed discount column sorted ascending shows the bleeding row at the top before finance asks about it.
Questions
Common questions about SleekView for WooCommerce Wholesale Prices
Yes. Premium's extra meta keys for per-category discounts, minimum order quantity, and product visibility per role are exposed as additional columns. The agent samples meta keys on first connection and offers the discoverable ones for mapping into typed columns.
 Yes. SleekView writes through the plugin's price-update API on inline edits where supported, so price-history logs and audit hooks fire as expected. Bulk-edit across a filtered view is capability-gated to pricing managers and rolls back cleanly on validation errors.
 Yes. Variation-level wholesale prices stored as postmeta against the variation post ID are pivoted alongside parent product prices. A product with three variations renders as a parent row plus three variation rows, each with its own role columns, so granular review works without separate screens.
 Yes. Queries are paginated and indexed; catalogs with tens of thousands of products run smoothly. Meta-key joins are batched against indexed meta_key values, so even five-role pivots on a twenty-thousand-product catalog render quickly.
 Yes. Views are gated by capability and savable per role, so each pricing manager sees only their region or brand. The saved view also remembers which role columns are visible, so a regional manager need not see roles outside their territory.
 Yes. Wholesale prices live on products in postmeta regardless of HPOS, so the catalog views are unaffected. Order-side data is read from whichever table HPOS is configured to use (wp_wc_orders or wp_posts), and wholesale-customer order history joins cleanly.
 If the plugin logs price history to a custom table or postmeta history key, SleekView exposes that as a separate view per product. Sorting by change count surfaces volatile pricing — useful before quarterly margin reviews or partner renegotiations.
 Filter the view to rows where retail price is set but visibility flags suggest wholesale-only is intended, or where wholesale-only meta keys exist but retail visibility is still active. The mismatch is hard to find in the editor and trivial to find in a sorted view.
 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 checkout