✨ 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 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

SleekView table view for WooCommerce Wholesale Prices

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

1

Pivot per-role meta keys

Map each wholesale role meta key — wholesale_customer, distributor, reseller — into its own typed currency column drawn from wp_postmeta. Retail and wholesale prices land side by side per product.
2

Compute discount columns

Add computed columns for discount percentage off retail per role. Sort descending to find the deepest wholesale discounts; sort ascending to find products where wholesale margins are too thin.
3

Filter missing-price rows

Filter the view to products where a specific role's price is null. Bulk-set defaults inline through the plugin's price-update hooks, so price-history logging and audit trails continue to fire as expected.
4

Save per-manager presets

Pricing managers save views scoped to their region or brand through capability-gated filters. Finance saves a margin-and-discount view across the wholesale portfolio. Both ride the same catalog table.

Sample columns

A typical wholesale catalog view

One row per product with retail and per-role wholesale prices.
Source: 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.

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