SleekView for WooCommerce Trade Pricing: trade tiers & prices as tables
Trade Pricing stores tier-based prices and role overrides in postmeta on each product (keys like _price_trade, _price_wholesale, _price_distributor). SleekView pivots them into columns so margins per tier are visible across the catalogue at once.
♾️ Lifetime License available
Tier prices as a real spreadsheet
WooCommerce Trade Pricing (and the family of role-based-pricing plugins it shares a data shape with) stores each tier's price as a postmeta key on the product: _price_trade, _price_wholesale, _price_distributor, plus a base _regular_price and optional _sale_price. Variations carry their own per-variant copies of those keys.
The default Products screen shows one column per price, but only for the base price, and tier overrides stay buried in the product's pricing tab. Comparing margins across tiers means opening each product, or running raw SQL on postmeta. SleekView reads wp_postmeta directly and pivots each tier into its own column so the trade, wholesale, and distributor prices line up next to the base price.
Inline edits write back via update_post_meta, so any plugin hook that recomputes derived prices still runs. Bulk-update across a category, scope a view per role for the buyer team, and never open the price tab again.
Workflow
Catalogue-wide tier pricing in one screen
Pick products as the source
product post type (and product_variation if you sell variations). One row per SKU, plus a separate variation-level view.
Pivot the tier keys
_regular_price, _sale_price, _price_trade, _price_wholesale, and _price_distributor as named columns from postmeta.
Save buyer-team views
Edit inline or bulk
update_post_meta and plugin hooks fire normally.
Sample columns
Trade pricing across the catalogue
postmeta.
wp_posts (product) + wp_postmeta (_price_trade, _price_wholesale, _regular_price)
| Product | SKU | Regular | Trade | Wholesale | Status | Stock |
|---|---|---|---|---|---|---|
| Linen apron | APR-204 | £42.00 | £34.00 | £28.00 | Published | 84 |
| Steel kettle | KET-118 | £120.00 | £98.00 | £82.00 | Published | 32 |
| Walnut tray | TRY-061 | £68.00 | £54.00 | £45.00 | Draft | 0 |
| Glass jar | JAR-040 | £12.00 | £9.50 | £7.20 | Published | 412 |
Comparison
Default WooCommerce Trade Pricing admin vs SleekView
Default WooCommerce Trade Pricing admin
-
Tier prices live in
postmetawith no list-level columns - Margin comparison across tiers needs per-product clicks
- No bulk tier update across a category or brand
- Variation-level tier prices need opening each variation
- No saved view scoped to "products missing a trade price"
SleekView
- Tier-as-column pivot for trade, wholesale, and distributor prices
- Inline-edit tier prices with bulk update across a category
- Filter to products missing a tier override
- Per-variation tier pricing in a dedicated view
- Save buyer-team views with custom margin computations
Features
What SleekView gives you for WooCommerce Trade Pricing
Every tier as a column
Pivot _price_trade, _price_wholesale, and _price_distributor into named columns next to _regular_price. Spot missing overrides at a glance.
Bulk tier updates
Select a category or brand, set a new wholesale margin, write back via update_post_meta. The plugin's hooks for derived-price refresh still fire.
Variation drill-down
Switch to a variation-level view to see tier prices on every product_variation. Same column pivot, with parent SKU as a join column.
Audience
Who uses SleekView for WooCommerce Trade Pricing
Buyer team
Margin reviews across categories. Sort by wholesale-to-regular ratio, spot underpriced items, and bulk-update a category in one pass.
Sales managers
Trade-tier audits for B2B accounts. Filter to products missing a trade price and fix coverage before the next account onboard.
Pricing analysts
Cross-tier comparison and elasticity hypotheses. Export a snapshot, model the impact, and write the new prices back inline.
The bigger picture
Why tier pricing needs a flat view
B2B and trade stores live on tier coverage and margin discipline, not on individual product edits. A missing wholesale price on a fast-moving SKU costs more in lost margin than a hundred admin clicks would save, and the default Products screen makes that gap invisible: tier prices live in postmeta, surfaced only in the per-product pricing tab. The data is already there for every SKU (_price_trade, _price_wholesale, _price_distributor) and for every variation.
What's missing is the spreadsheet-style screen where a buyer can see them all in one row, spot the gaps, and fix them in bulk. SleekView's pivot turns the catalogue into that spreadsheet. A pricing analyst can sort by trade-to-regular ratio and find the underpriced SKUs in minutes.
A B2B sales manager can audit trade-tier coverage before onboarding a new account. A buyer team can run a quarterly margin pass across a category in a single saved view. The plugin already does the storage; SleekView just exposes it operationally.
Questions
Common questions about SleekView for WooCommerce Trade Pricing
The standard role-based-pricing keys: _price_trade, _price_wholesale, _price_distributor, plus the WooCommerce core keys _regular_price and _sale_price. The list is configurable per view if your build uses different keys.
Yes. Variations are product_variation posts with their own postmeta copies of each tier key. SleekView exposes a variation-level view with parent SKU as a join column so you can manage variant-level tier pricing in one screen.
Yes. Multi-select rows and apply a new price or a percentage adjustment. Writes go through update_post_meta so plugin hooks for cache invalidation and price-index refresh fire normally.
Trade Pricing meta lives on products, not orders. HPOS only affects order storage, so the product-side pivots are unchanged. Order-side tier-price recording (if your install logs the applied tier on each order) reads HPOS or legacy interchangeably.
Yes. Filter to rows where _price_trade is empty or zero. That's the coverage gap for the trade tier. Same filter pattern works for wholesale and distributor.
Yes. The Trade Pricing plugin and WooCommerce both invalidate product caches on the standard meta-update hooks. SleekView's CRUD writes trigger those hooks the same as a manual product save.
Yes. Scope views per role: buyers see all tiers, customer support sees only the regular price, B2B managers see trade and wholesale. Column-level role permissions per saved view.
If your build of Trade Pricing stores per-tier sale keys (_sale_price_trade, etc.), they pivot the same way. If sale logic is computed at runtime from a percentage, the percentage meta key pivots into a column too.
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
- Order Status Manager
- Mailchimp For Woocommerce
- Woocommerce Order Status Control
- Edd Software Bundles
- Woocommerce Quaderno
- Woocommerce Mercado Pago
- Paypal Payments
- Woocommerce Cheque Payment Pro
- Affiliate Aliexpress
- Woocommerce Payfast
- Fkcart
- Woocommerce Multistore
- Woocommerce Paypal Checkout
- Woocommerce Shipping Pickup Location
- Woocommerce Coingate