Add WooCommerce Bulk Discount Pricing to Your Product Tables

By Updated: August 7, 2019 4

WooCommerce quantity discount plugin product table

Lots of people ask us which WooCommerce bulk discount plugins work with our Product Table and Quick View plugins. Today we’ve been testing the official WooCommerce Dynamic Pricing plugin, plus the Dynamic Pricing and Discounts for WooCommerce plugin. We’re pleased to announce that they both work beautifully with WooCommerce Product Table and WooCommerce Quick View Pro.

Here are all the details of how you can use bulk discounts and dynamic pricing with your own product tables and quick view popups. You can also see a product table with WooCommerce Dynamic Pricing in action on our demo page.

WooCommerce Product Table
Add bulk discount pricing to your WooCommerce site

Plugin 1: WooCommerce Dynamic Pricing

WordPress dynamic pricing plugin

WooCommerce dynamic pricing pluginThe official WooCommerce Dynamic Pricing extension lets you create bulk discounts based on a minimum and maximum quantity for individual products, across your entire store, or for specific categories or even product variations. It’s an incredibly advanced bulk pricing plugin and you can use simple or advanced logic to create sophisticated pricing rules. It also comes with user role based pricing.

How it works with WooCommerce Product Table

If you’re using the Dynamic Pricing plugin, then customers can choose a quantity from the product table and click the Add to Cart button. When they click through to the cart and checkout, the correct quantity based pricing will be applied based on the quantity ordered.

If your product table page has a sidebar, then you can add the WooCommerce Cart widget. When people add products to the cart, the correct volume discount will be shown in the Cart widget. This reassures customers that the volume discounts are working.

See it in action on our Dynamic Pricing demo page!

If there’s no Cart widget on the page, then customers can see the discount when they click through to the cart and checkout.

The ‘Price’ column in the product table will always show the price for a single item. Please see below for some suggestions on how you can display available bulk discounts in the product table.

How it works with WooCommerce Quick View Pro

If you’re using Dynamic Pricing with WooCommerce Quick View Pro, then the correct discounted price will appear in the quick view lightbox.

Plugin 2: Dynamic Pricing and Discounts for WooCommerce

Dynamic Pricing and Discounts for WooCommerce comes with a free version, which includes:

  • Dynamic discounts for individual products and entire categories.
  • Discount rules based on weight, quantity, price, total units and number of items in cart.
  • Option to show the available discounts on the single product page, or in the add to cart column of the product table.
  • Set minimum and maximum quantity that the discount will apply to.
  • Role-based pricing – ability to set different discounts based on logged in user role (e.g. 10% discount for wholesale users).
  • Optional start and end/expiry date for discount rules.
  • Choose from flat, percentage or fixed price discounts.

The Pro version has the added bonus of being able to combine discount rules, so it’s a bit more flexible. But the free version is great and offers a surprising number of features.

Dynamic Pricing and Discounts for WooCommerce works nicely with WooCommerce Product Table. The products are listed in the table layout as usual. When you add a product to the cart, the correct discount is applied and this is clearly labelled in the cart.

Here are some examples from my testing, so you can see how it works:

Can I show the bulk discount prices in the product table?

If your product table includes a Price column then this will always show the price for 1 item. This applies whichever bulk discount or dynamic pricing plugin you use – the Price column never changes.

WooCommerce product table with quantity discountHowever, the Dynamic Pricing and Discounts for WooCommerce plugin has a neat feature where you can show the available discounts for each product in the add to cart column of the product table. Simply switch this on in the settings for the plugin. If you set it to appear before or after the add to cart button then it shows up in the product table.

Unfortunately this feature isn’t available in WooCommerce Dynamic Pricing. The only way to list the available discounts in the product table is to add an extra column with this information. This subtly encourages people to buy higher quantities, convincing them that they’re getting better value.

You can do this as follows:

  1. Use the free Advanced Custom Fields plugin to add a ‘Volume Discount’ custom field to the ‘Products’ post type.
  2. This field will now appear on the Add/Edit screen for each product. Add the discount details here.
  3. Finally, add the custom field as an extra column in your WooCommerce product table. Please see the instructions for adding a custom field column.

Wrapping up

As you can see, the WooCommerce Dynamic Pricing and Dynamic Pricing and Discounts for WooCommerce plugins work beautifully with the product table layout. They also work nicely with WooCommerce Quick View Pro if you want to show the discounted prices in a quick view lightbox.

If I had to recommend a bulk pricing WooCommerce plugin then I’d suggest Dynamic Pricing. This is the official plugin from woocommerce.com so you can be sure it will be maintained and supported for the long-term.

Use either plugin with WooCommerce Product Table and WooCommerce Quick View Pro, and get the benefits of a one-page order form, coupled with the extra incentives offered by a bulk discount plugin and dynamic pricing. This creates a powerful incentive to buy, helping to increase your sales.

WooCommerce Product Table
Add bulk discount pricing to your WooCommerce site

Katie Keith

An active member of the global WordPress community, Barn2 Co-Founder Katie loves collaborating with other plugin companies. Her articles have been published on high profile sites including WPTavern, Torque and IndieHackers. She oversees all plugin support and deals with 'Tier 2' support requests about how to use Barn2's plugins in advanced ways.

4 Comments

  1. Dan Nielsen
    November 22, 2018 Reply

    Need discount plugin (Woocommerce): Buy X amount items in category A and get fixed price of X amount items in category B. Only same amounts of fixed prices as bought in category A. We sell eyewear and a customer need “Lenses” and a “Frame”. If customer buy “Lenses” the get the “Frame” cheaper, then just buying the “Frame” without the “Lenses”.?

    • Katie Keith
      November 22, 2018 Reply

      Hi Dan, the Dynamic Pricing extension has the most complex logic that I have seen and allows you to create some pretty advanced rules. However, I'm not an expert in it and recommend that you reach out to WooCommerce.com support to ask them if it will let you do exactly what you have described.

  2. Jae Yang
    January 23, 2018 Reply

    Hi Katie.
    It would be so thankful if you can provide the table field name for WooCommerce Bulk Discount.
    Best Jae

    • Katie Keith
      January 23, 2018 Reply

      Unfortunately the Bulk Discount plugin doesn't include a field showing the discount that can automatically be shown in the product table. This is because the discounts are generated dynamically based on the main product price. For a suggested workaround, please see the 3rd paragraph of the 'Can I show the bulk discount prices in the product table?' section of this tutorial. Alternatively, if you switch to the Dynamic Pricing and Discounts for WooCommerce plugin, then you can automatically show the available discounts in the add to cart column.

Please share your thoughts...

Your email address will not be published.