SleekView for WooCommerce Bulk Discounts: quantity tiers as tables
Read directly from the bulk-discount postmeta keys (typically _bulk_discount_* on each product) and join to wc_orders for usage history. Flatten tier arrays to rows, audit coverage, and bulk-update thresholds across the catalogue.
♾️ Lifetime License available
Bulk-discount tiers, finally as a real table
WooCommerce Bulk Discounts stores tier definitions per product in postmeta, typically as a serialised array under keys like _bulk_discount_tiers. The default product admin shows them in a stacked meta box (5 = 10%, 10 = 15%, 25 = 20%) which is fine for setup but tedious for catalogue-wide audit or update.
SleekView reads the postmeta arrays, flattens each tier into its own row, and joins back to the parent product. Filter to products missing tiered pricing, sort by maximum tier discount, or build a derived column showing average tier depth per category. Join wc_orders by line-item product to see which tiers actually hit on real orders versus which sit unused.
Inline tier edits route through WooCommerce's product CRUD where the plugin supports it, so price-cache invalidation and product-update hooks fire normally. Bulk-update tier ceilings across a category in one filtered pass, or copy a high-performing tier template to a new product line.
Workflow
Compose a tier-row workspace in four picks
Pick the product source
wp_posts filtered to product and optionally product_variation for per-variation tiers. SleekView auto-detects the bulk-discount postmeta key.
Flatten tiers to rows
_bulk_discount_tiers so Quantity, Discount, and Tier Order become real columns instead of nested fields.
Join usage data
wc_order_items on product id to add Last Hit and Hit Count. Useful for spotting tiers that never fire across last quarter's orders.
Save and bulk-edit
Sample columns
A typical bulk-tier audit view
_bulk_discount_tiers arrays so each tier is its own row joined to the product.
wp_postmeta (_bulk_discount_tiers on product) + wp_wc_orders + wp_wc_order_items
| Product | Tier qty | Discount | Tier order | Status | Last hit |
|---|---|---|---|---|---|
| Wholesale mug | 10 | 10% | 1 | Active | Apr 24 |
| Wholesale mug | 25 | 15% | 2 | Active | Apr 24 |
| Wholesale mug | 50 | 20% | 3 | Active | Mar 28 |
| Wholesale tote | 12 | 8% | 1 | Inactive | Never |
Comparison
Default Bulk Discounts admin vs SleekView
Default Bulk Discounts admin
- Tiers live as a nested meta box inside each product
- No catalogue-wide view of which products have tiers configured
- No usage data: which tier hit last week, which never hit
- Bulk-applying a tier template across a category needs per-product edits
- Auditing for inverted tiers (higher qty with lower discount) means opening each product
SleekView
- Each tier as its own row joined to the parent product
-
Join to
wc_order_itemsfor Last Hit and Hit Count columns - Filter products missing tiered pricing for the next coverage pass
- Inline-edit tier quantity and discount per row
- Bulk-apply tier templates across categories or product lines
Features
What SleekView gives you for WooCommerce Bulk Discounts
Tiers as rows
Flattens the _bulk_discount_tiers array so each tier is a real row with Quantity and Discount as columns. Inverted or duplicate tiers stand out immediately.
Usage join
Joins line items in wc_order_items by product id to show Last Hit and Hit Count. Spot tiers that never fire and either retire them or fix the threshold.
Template copy
Apply a proven tier set (10 = 10%, 25 = 15%, 50 = 20%) across an entire category in one bulk action. Each row writes through the product CRUD so caches invalidate.
Audience
Who uses SleekView for Bulk Discounts
Pricing managers
Catalogue-wide tier view with quantity, discount, and last-hit columns. Bulk-update ceilings before each quarterly pricing cycle without per-product edits.
Wholesale ops
Filter to wholesale-applicable products, ensure every SKU has at least a starter tier, and copy successful templates from hero products to long-tail SKUs.
Margin auditors
Cross-product audit of maximum tier discount per category. Filter for tier discount over 25 percent to verify against cost-of-goods before approving.
The bigger picture
Why bulk-pricing audits need flat-row tier views
Bulk pricing is the most common B2B and wholesale discount model on WooCommerce. The data model is simple: per-product tiers, each with a quantity threshold and a discount value. The default admin renders tiers as a stacked form in the product edit screen, which works for setting up a handful of products but breaks down at catalogue scale.
Pricing managers either accept that audits don't happen and live with inconsistent tier coverage, or build out custom dashboards in spreadsheets that lose the link to live data the moment they're exported. SleekView lets the same plugin's data behave like the table it conceptually is. Each tier is a row, with the parent product, the threshold, the discount, the tier order, and (where the plugin records it) the real-world hit history all visible at once.
The operational change is dramatic: pricing managers, wholesale ops, and margin auditors each get a workspace tuned to their job, and the catalogue stays consistent because audits become cheap enough to actually do. Same plugin, same hooks, just the workspace the data deserves.
Questions
Common questions about SleekView for WooCommerce Bulk Discounts
Most Bulk Discounts plugins store tiers per product in postmeta under a key like _bulk_discount_tiers as a serialised array of objects with quantity and discount fields. SleekView reads the array and flattens it so each tier is one row, making it behave like a normal table.
Yes when the plugin records applied-tier data on order line items. wc_order_items with the relevant order_itemmeta exposes which tier matched per line. SleekView aggregates that into Last Hit and Hit Count columns on the tier row, surfacing zombie tiers.
Yes. Variations are product_variation posts with their own postmeta. SleekView can tier variations individually (one row per variation per tier) or aggregate to the parent. Most workflows want per-variation since wholesale tends to vary by size or pack.
Yes. Filter tiers by category and Tier Order, select the Quantity or Discount column, and run a bulk transform. Each row writes back through the plugin's CRUD method so update hooks fire and price caches invalidate per row.
 Bulk Discounts is per-product and per-quantity. Cart-level discount plugins layer on top at checkout. SleekView gives each its own view (per-product tiers here, cart rules in the conditional-discounts view) and the resolution logic of each plugin runs unchanged.
 Yes if the plugin's tier object includes a role field. SleekView surfaces the role as a column so wholesale-only tiers are distinguishable. Filter the view to a single role for a per-segment audit.
 Yes. Any view exports to CSV with all visible columns including flattened tier data. Useful for sending a wholesale customer their current tier ceilings or for porting tier logic to a parallel store after migration.
 
Reading postmeta for the tier key is indexed by post_id and meta_key. Flattening happens after rows return so the cost is bounded by tier-meta-row count. Catalogues with thousands of products and tens of thousands of tiers load sub-second in the typical pricing-manager 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 checkoutBrowse more
- Woocommerce Allegro Pl
- Funnelkit Funnel Builder
- Woocommerce Conditional Shipping And Payments
- Woocommerce Snapchat Pixel
- Yith Woocommerce Deposits And Down Payments
- Wcfm Marketplace
- Woocommerce Dhl Express
- Woocommerce Prices By User Role
- Yith Woocommerce Product Slider
- Surecart
- Woocommerce Affirm
- Edd Points Rewards
- Edd Fes Frontend Submissions
- Woo Direct Checkout
- Woocommerce Grouped Products Pro