1. Documentation /
  2. Tiered Pricing Table for WooCommerce

Tiered Pricing Table for WooCommerce

Installation

↑ Back to top
  • Navigate to Plugins > Add New.
  • Click the Upload Plugin button at the top of the screen.
  • Upload the ‘tier-pricing-table.zip’ file you’ve downloaded from WooCommerce.com
  • Click the Install Now button.
  • When the installation is com

More info at Using Plugins.

Overall logic and purpose

↑ Back to top

The plugin provides quantity-based (volume-based) discounts/custom pricing. It allows you to set different prices per different product quantity.

The plugin encourages users to make larger orders by offering discounted prices for large orders.

The plugin provides two types of pricing: fixed (different flat prices per specific amount of product) and percentage (percentage-based discounts based on the regular product price per particular amount of product).

Fixed

↑ Back to top

The fixed type of pricing allows you to define a different product price for specific amounts. Let’s say you sell your product for $100.00, but if users buy 10 pieces, you want to sell it at $90.00, and if users buy 50 pieces, the price should be $80.00 each.

The setup should look the following:

Percentage

↑ Back to top

The percentage type of pricing let you define a discount for specific amounts calculated from the regular product price. Let’s say you sell your product for $100.00, but if users buy 10 pieces, you want to offer a 10% discount, and if users buy 50 pieces, you offer a 20% discount.

In this case, the pricing should look the following:

How to set Tiered Pricing

↑ Back to top

Simple products

↑ Back to top

Tiered Pricing for the simple products is set up under the “general” tab on the product edit page:

Variable products

↑ Back to top

There are two places to set up the pricing rules for the variable product. The plugin adds the tab “Tiered Pricing”. Here you can add the pricing rules that will be applied to every variation in this variable product:

You can also specify different tiered pricing for a particular variation. You have the same interface to set up the prices on every variation.

The priority of particular variation rules is higher than rules filled in the “Tiered Pricing” tab. But variations without specific rules will inherit the rules from the tab.

That means if you have, for example, 10 different variations, and you need to have the exact tiered pricing in 9 of them. Only one is different. You can set up the general rules in the “Tiered Pricing” tab and specify the different ones in that particular variation:

For product Category

↑ Back to top

There can be cases when you need to have the same discounts for many products. For example, you offer a 10% off for 10+ pieces. Instead of filling the rules in every product, you can wrap the product in a product category and set the tiered pricing rule in bulk. 

The products in the category will inherit the rules.

The rules can be skipped in a particular product:

How to set role-based tiered pricing

↑ Back to top

Simple products

↑ Back to top

Role-based pricing is set under the “Tiered Pricing” tab on the edit product page:

Chose a role you want to set up different prices and click “Setup for role”:

In the opened box, you can set the regular price and sale price you want to offer for this role (wholesaler in exampled case). Do not fill the prices to leave it the same as the regular ones.


Here you can also set a role-specific minimum order quantity. Please note that if you have a global MOQ set, you must duplicate it for a role if you want to keep it the same. Otherwise, the default value will be used – 1.

The plugin allows you to set role-specific tiered pricing rules. The interface is the same as the regular tiered pricing rules – choose a type and fill the flat prices or percentage discounts for specific quantities. If you don’t fill any tiered pricing rules here, the plugin will not use the global tiered pricing rules. So, if you want to keep the same tiered pricing rules for the chosen role as for the rest users, you must duplicate them here.

You can have as many role-based pricing rules as you need.

Variable products

↑ Back to top

Role-based rules for the variable products are set pretty the same as for the simple products: In the “Tiered Pricing” tab on the edit product page, you can set the rules that will be applied to every variation in the variable product.

Of course, you can override and set variant-specific pricing for each product variation:

How to set a minimum order quantity

↑ Back to top

Simple products

↑ Back to top

Minimum order quantity defines the minimum product pieces users can buy. You can set it under the “Tiered Pricing” tab:

When you set a minimum, the plugin will restrict users from purchasing under the amount and show a notice if they try to buy a less amount:

The pricing table also reflects the minimum amount, and the first row shows the proper value:

Please note that the plugin considers items in the cart, and if your minimum order quantity is set to 10, but a user already has 5 pieces in the cart – the plugin will allow adding to the cart from 5 pieces as it sums it is 10 – which is minimum.

Variable products

↑ Back to top

Of course, you can set the minimum order quantity per product variation:

Tiered Pricing Displaying Settings

↑ Back to top

The plugin’s settings page can be found on WooCommerce -> Settings -> Tiered Pricing.

Here, you can configure how your store’s tiered pricing will look and feel.

Show tiered price table

↑ Back to top

Enabling this option will display the table on the product page. Prices stay dynamic even if you choose not to show the table.

Quantity displaying type

↑ Back to top

You have two options: ranges (set by default) and static quantities.

If you choose ranges, the table will automatically build ranges of quantities that apply per the pricing rule. For example, if you set 10% for 10 product pieces, it will show the following ranges:

1-9 pieces: the regular price, 10+: discounted price.

Static quantities will just follow your quantity breaks:

Please note that this will not restrict users from purchasing amounts between the breaks. For example, in this case, users will be able to buy five pieces at the regular product price. This option just adjusts the table look but not the discount logic.

Display 

This option controls the table displaying type. Besides the regular table showing, you can display the table in a little tooltip near the product price:

The table will show once users move the mouse over the question icon.

This option comes with several additional options:

  • Tooltip icon color
  • Tooltip icon size
  • Tooltip border options

Table title

↑ Back to top

Set the title for your pricing policy. It will show above the table. For example, “Buy more, save more!”:

Leave the field empty to not show any title.

Table position

↑ Back to top

You can move the table on the product page to the best place for you. There are seven different places available:

  • Above buy button  
  • Below buy button  
  • Above add to cart form
  • Below add to cart form
  • Above product title
  • Before product summary
  • After product summary

Active price background-color 

This option lets you choose a background color for a table row that is active at the moment:

  ‎   ‎

Quantity column text

↑ Back to top

This option allows you to customize the “Quantity” column title.

Price column text

↑ Back to top

This option allows you to customize the “Price” column title.

Show discount column for percentage table

↑ Back to top

You can enable or disable displaying the “discount” column for the percentage-based tiered pricing.

Please note that this column is available only for percentage-based tiered pricing rules.

If you set fixed (flat) pricing rules for your product, only the “quantity” and  “price” columns will show.

Discount column text

↑ Back to top

If the option above is active, you can customize the “Discount (%)” column title the same way as the “quantity” and “prices” columns.

You can disable the table heading by leaving those fields empty:

CSS class 

Here you can add a CSS class that the plugin will add to the pricing table. It’s helpful for advanced style customizations.

Prices Settings

Summarize all product variations during the calculation of tiered pricing for variable product

↑ Back to top

All tiered prices are set individually per product. When you have variable products, you can enable this option to consider every variation as the same product. For example, you sell a t-shirt with 3 variations: small, medium and large. You can have the same tiered pricing rules for all those variations. The plugin will summarize every size in the cart to calculate the end quantity and calculate the discount based on that. For example, you have a 10% discount for 10 pieces of a product. Users who add 5 small, 2 medium, and 3 large t-shirts will get 10% off on everything.

Enable price formatting on the catalog page, widgets, etc.

↑ Back to top

The option enables special price formatting on the catalog. 

Display tiered price as

↑ Back to top

If the option above is enabled, you have two options on how to display tiered pricing on the catalog:

  1. Price range 

The plugin will build a price range from the lowest price possible and the regular product price.

For example, if the regular product price is $18.00 and you set a 10% discount for 10 pieces, the catalog price range will look the following:

  1. Lowest Price with a prefix

The plugin will calculate the lowest price and show it in the catalog. For the exampled product, the price will look the following:

Lowest price prefix

↑ Back to top

You can specify a custom “From” prefix:

Price formatting for variable products

↑ Back to top

You can enable or disable price formatting for variable products. The plugin will show a minimum price or a price range. Consider every variation in the variable product.

Price caching for the variable product

↑ Back to top

Suppose the price formatting is enabled for the variable product. In that case, it could take a lot of performance to build a price range or find a minimum price as the plugin has to check tiered pricing for every variant of the variable product. It may cause performance issues on variable products with many variants.

If the option is enabled, the plugin will calculate a price string once and then cache and use the cached version until you modify the prices.

Price formatting on the product page

↑ Back to top

The formatted price string will default not appear on the product page. Enable it to format the price on the product page too.

Set a tiered price on a click

↑ Back to top

This feature makes the table clickable. When users click on a table row, the quantity will automatically set to the appropriate amount.

Show the total price on the product page.

↑ Back to top

Calculate and show the total price instead of the pricing string on the product page. This option cannot be enabled if the “Price formatting on product page” option is enabled. Those are interchangeable options.

Show tiered price in cart as a discount.

↑ Back to top

When users buy a product with a tiered pricing discount, the price in the cart will show as crossed out regular price near the discounted actual price:

Summary (Subtotals) block

↑ Back to top

The plugin is shipped with the summary block for the product page. The block is dynamic and instantly recalculates the totals once users change the quantity:

There is a bunch of options to adjust the block:

Enable/Disable

↑ Back to top

Display the block or not

Summary block title

↑ Back to top

Set a title above the summary block:

Summary block type

↑ Back to top

There are two display types available:

  1. Table (set by default):
  1. Inline

You can adjust the “Total” and “Each” labels for the inline option.

Summary block position

↑ Back to top

You can move the block in the same places as the pricing table:

  • Above buy button  
  • Below buy button  
  • Above add to cart form
  • Below add to cart form
  • Above product title
  • Before product summary
  • After product summary

Import / Export format

↑ Back to top

The plugin provides 4 additional columns to import and export:

  • Tiered pricing type

The value must be either “fixed” or “percentage.” Represent the type of tiered pricing for a product:

  • Tiered pricing minimum product quantity

Must be an integer value (1 or greater). Represent the MOQ of tiered pricing for a product:

  • Fixed Tiered Prices

A string with rules with fixed pricing rules. Quantity and actual price are separated with “:” and rules are separated with “,”.

For example, for the rules on the screenshot below, the import string must be the following: 

“10:50,20:40,40:33” – where $50.00 at 10pcs, $40.00 at 20pcs, $33.00 at 40+pcs:

  • Percentage Tiered Prices

A string with rules with percentage pricing rules. Quantity and actual discount are separated with “:” and rules are separated with “,”.

For example, for the rules on the screenshot below, the import string must be the following: 

“10:20,15:22,20:25” – where 20% discount at 10pcs, 22% discount at 15pcs, 25% discount at 20+pcs:

Export

↑ Back to top

Export via WooCommerce standard tool 

Read about how the WooCommerce export tool works here: https://woocommerce.com/document/product-csv-importer-exporter/#export.

The plugin provides 4 additional columns to export.

  • Tiered pricing type
  • Tiered pricing minimum product quantity
  • Fixed Tiered Prices
  • Percentage Tiered Prices

Read about its format in the format section.

Import

↑ Back to top

Import via WooCommerce import tool

↑ Back to top

Read about how the WooCommerce export tool works here: https://woocommerce.com/document/product-csv-importer-exporter/#import.

The plugin accepts 4 columns to be imported.:

  • Tiered pricing type
  • Tiered pricing minimum product quantity
  • Fixed Tiered Prices
  • Percentage Tiered Prices

Read about its format in the format section.

For example, your CSV file could look like the following:

Please note that empty columns will erase the appropriate data.

Import via WP All Import

↑ Back to top

Please note that this is a 3rd-party plugin, and WooCommerce or our team does not handle it.

Read more about WP All Import here: https://www.wpallimport.com/

If you face any issues with the general import process, please contact them directly.

The Tiered Pricing Table plugin provides the same 4 additional fields to import + with this plugin, you can import role-based tiered pricing rules.

In the step #3, when you match the data to appropriate fields, you have additional metabox with Tiered Pricing data to match:

Role-based rules are imported in the same way. Click to checkbox near a role name you want to import rules for and match the CSV column to the fields:

WPML

↑ Back to top

The plugin is fully compatible and every sting used can be translated via WPML.

“tier-pricing-table” domain provides 140 strings to translate:

Developers section

↑ Back to top

REST API

↑ Back to top

The plugin extends the WooCommerce REST API and provides 4 additional fields for 2 object types: product and product_variation.

Below is an example of getting the “product/{id}” endpoint:

Can I override the plugin’s files?

↑ Back to top

Yes, all the plugin templates are displayed on the frontend – fixed pricing table, percentage table, summary block, etc., can be overridden in your theme or your plugin. Here is a little guide on how to make that happen: https://u2code.com/how-to-override-our-plugins-templates/

How to enable Tiered Pricing for the manual (admin-made) orders

↑ Back to top

By default, orders created by admins are not considered tiered pricing rules. This has been done because of the possibility of incompatibility with 3rd-party plugins, in particular product addons plugins that modify the product price.

However, you can force enable tiered pricing for manual orders if you need it, and you don’t use a 3rd-party plugin that can break calculations:

add_filter(‘tier_pricing_table/addons/manual_orders_active’, ‘__return_true’);

How to disable minimum quantity checking from Tiered Pricing Table

↑ Back to top

Using a min/max plugin can conflict with the built-in minimum order quantity functionality from Tiered Pricing. Below you can find a filter that will disable this feature in the plugin and let you min/max plugin do the job:

add_filter('tier_pricing_table/addons/min_quantity_active', '__return_false');

Please note that you still need to put a minimum quantity value in the tiered pricing field to reflect the table displayed.

WooCommerce

The most customizable eCommerce platform for building your online business.

  • 30-day money-back guarantee
  • Support teams across the world
  • Safe and secure online payment