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

SleekView table view for WooCommerce Bulk Discounts

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

1

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.
2

Flatten tiers to rows

The view config tells SleekView to flatten _bulk_discount_tiers so Quantity, Discount, and Tier Order become real columns instead of nested fields.
3

Join usage data

Left-join 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.
4

Save and bulk-edit

Save as Pricing Manager view. Bulk-update tier quantities or discounts across a category in one pass. Each row routes through the product CRUD so caches invalidate.

Sample columns

A typical bulk-tier audit view

Flattens _bulk_discount_tiers arrays so each tier is its own row joined to the product.
Source: 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_items for 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.

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