SleekView for Wholesale Market: B2B catalog, tiered pricing & orders as tables
Wholesale Market layers B2B tiers, bulk-quantity rules, and wholesale orders onto WooCommerce; the data lives in postmeta keys per product and standard order rows. SleekView pivots it into a B2B catalog and orders workspace.
♾️ Lifetime License available
B2B catalog and orders without per-product clicks
Wholesale Market for WooCommerce adds tiered pricing, quantity rules, and wholesale-customer logic on top of WooCommerce. Each product gets postmeta keys for tier prices (typically named per role, like wm_wholesale_price, wm_tier_2_price) and quantity-rule keys (wm_min_qty, wm_max_qty). Orders write to the active WooCommerce order store with the wholesale customer's role attached to the user.
The default Products screen shows price, stock, SKU, and a fixed set of columns. Tier prices live in postmeta with no admin presence; auditing the catalog for missing tier prices or inconsistent margins means exporting product CSVs and crunching in a spreadsheet. The Orders screen treats wholesale orders identically to retail orders, with no role-aware filter or tier visibility.
SleekView pivots the Wholesale Market postmeta into columns on a products view: tier 1, tier 2, retail price, computed margin, min quantity, max quantity. Inline edits update postmeta with hooks intact so any caching layer the plugin uses still invalidates. A separate orders view filters to wholesale-role customers with tier and line-item aggregates surfaced.
Workflow
B2B catalog and orders on one screen
Pivot tier prices
wm_wholesale_price, wm_tier_2_price, etc.) as columns on the products view. Include min and max quantity keys for full B2B context.
Compute margin
Filter the catalog audit
Wholesale-only orders
wc_orders by the wholesale customer role via wp_usermeta. Add line counts and tier as columns so fulfilment and finance share B2B context.
Sample columns
A typical wholesale catalog view
wp_posts (products) with wp_postmeta tier-price keys for inline auditing.
wp_posts (product) + wp_postmeta (wm_* tier prices & quantity rules) + wp_wc_orders + wp_usermeta
| SKU | Product | Retail | Tier 1 | Tier 2 | Min qty | Stock |
|---|---|---|---|---|---|---|
| BR-COF-001 | House blend 500g | £12.00 | £9.00 | £7.20 | 12 | In stock |
| FS-PRT-A2 | Print A2 set | £24.00 | £18.00 | missing | 6 | Low |
| LL-LAMP-L | Pendant lamp L | £92.00 | £74.00 | £66.00 | 4 | In stock |
| HW-STA-NB | Notebook A5 | £6.50 | £5.00 | £4.00 | 24 | Out of stock |
Comparison
Default Wholesale Market admin vs SleekView
Default products + Wholesale Market
-
Tier prices live in
wp_postmetawith no admin columns on the Products screen - Auditing missing tier prices needs a CSV export plus spreadsheet work
- Computed margin (retail minus tier) isn't visible without custom code
- Wholesale orders aren't distinguishable from retail on the Orders screen
- Bulk-updating a tier across a category requires WP-CLI or import / export
SleekView
-
Tier-price columns sourced directly from
wm_*postmeta keys - Computed margin per tier as a virtual column
- Filter to products missing a tier price (catalog audit)
-
Wholesale-only orders view via role join to
wp_usermeta - Inline-edit tier prices and quantity rules with cache-aware writes
Features
What SleekView gives you for Wholesale Market for WooCommerce
Tier-price audit
Pivot every Wholesale Market tier (retail, tier 1, tier 2, tier 3) into columns on the products view. Filter to products missing a tier price or to products where tier 2 is higher than tier 1 (a classic configuration mistake).
Margin per tier
Compute margin as a virtual column: retail price minus tier 1 price, or tier 1 minus cost-of-goods (if cost is in postmeta). Sort by margin to find category-level pricing inconsistencies.
Wholesale-only orders
Filter wc_orders by customer role joined from wp_usermeta. Add line-item count and average line price as columns for B2B-specific reporting.
Audience
Who uses SleekView for Wholesale Market
Product / pricing
Catalog audit for tier consistency: every SKU's tier 1 / tier 2 / tier 3 visible inline. Bulk-edit price ladders without leaving the table.
B2B account management
Per-customer order history sortable by spend. Top accounts by quarter, dormant accounts (no orders in 60 days) for re-engagement campaigns.
Finance / merchandising
Margin per tier across the catalog. Spot products where the discount is too steep or the retail price is too low for the wholesale tier to make sense.
The bigger picture
Why B2B catalogs need tier-aware tables
B2B catalogs grow fast and break quietly. A new product gets a retail price set on launch and an intention to add tier prices "next week"; six months later tier 2 is still empty on hundreds of SKUs. A tier 2 price gets typed wrong and ends up higher than tier 1 by a transposition error; the wholesale customer sees a discount that's actually a premium.
These bugs aren't caught by the WooCommerce admin because Wholesale Market's tier prices live in postmeta and don't surface on the product list. The data is structured: every tier price is a separate postmeta key, every quantity rule is its own key, every wholesale order has a role-tagged customer. SleekView pivots those keys into columns, computes margin as a virtual column, and lets B2B teams audit consistency in one view.
Pricing managers fix tier inconsistencies in bulk. Account managers pull per-customer history sortable by spend. Finance splits revenue between retail and wholesale streams.
The catalog stops being something that needs a quarterly CSV cleanup and becomes a workspace that surfaces problems inline.
Questions
Common questions about SleekView for Wholesale Market for WooCommerce
Yes. Variable products store tier prices on each variation as postmeta on the product_variation post type. SleekView surfaces variations as either rolled-up summary columns or expandable rows under the parent product.
Yes. Filter to a category, multi-select, and bulk-set the tier-price postmeta key. Cache-clearing hooks fire per row so Wholesale Market's price cache (if used) invalidates correctly.
Yes. wm_min_qty and wm_max_qty (or whichever keys Wholesale Market uses in your version) surface as columns and are inline-editable. Build a saved view of products missing a minimum quantity for catalog cleanup.
Wholesale Market grants the wholesale customer a specific role (the identifier varies by version, e.g. wholesale_customer). SleekView filters wc_orders via a join to wp_usermeta on that role; the identifier is configurable per saved view.
Yes. SleekView writes via WordPress's standard postmeta API and fires the relevant updated_post_meta hooks so any cache layer (Wholesale Market's own, or WP super cache, or Redis) invalidates exactly as it would with a manual edit.
Yes. Aggregate wc_orders totals filtered by the wholesale role for the B2B revenue stream, and the complement (non-wholesale roles) for retail. Saved views per stream give a clean monthly split.
Yes. The order side reads from wc_orders under HPOS and shop_order posts otherwise. The product / tier-price side uses wp_posts + wp_postmeta regardless of HPOS.
Wholesale Market hides certain products from non-wholesale roles. SleekView's admin tables show every product to admins; visibility filters are surfaced as a column so admins can see which products the wholesale-only flag applies to.
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 Moneris
- Woocommerce Sequential Order Numbers Pro
- Wc Marketplace
- Yith Woocommerce Request A Quote
- Woocommerce Prices By User Role
- Paypal Payments
- Givewp
- Woocommerce Product Variations Swatches
- Presta Shop Bridge
- Woocommerce Affiliatewp Integration
- Curcy Multi Currency
- Woocommerce Product Recommendations
- Razorpay For Woocommerce
- Woocommerce Lottery
- Printful Integration