Add WooCommerce Bulk Discount Pricing to Your Product Tables
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.
Plugin 1: WooCommerce Dynamic Pricing
The 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.
However, 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:
- Use the free Advanced Custom Fields plugin to add a ‘Volume Discount’ custom field to the ‘Products’ post type.
- This field will now appear on the Add/Edit screen for each product. Add the discount details here.
- Finally, add the custom field as an extra column in your WooCommerce product table. Please see the instructions for adding a custom field column.
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.