Set tier prices for product variants of configurable products in Magento

Magento Logo

So you want to set tier prices for product variants of configurable products in Magento. To achieve this you create a configurable product and associate your simple product variants based on your pre-defined attributes. At this point you start setting tier prices for your associated product variants, i.e. your simple products thinking that Magento will use these values on the frontend. Well, unfortunately in fact Magento by default only uses the tier prices set for the configurable product itself which obviously results in wrong prices in the frontend.

Surcharge to the rescue?

Ok, well let’s then use surcharges for product variants as basis for tier price calculations of product variants. Unfortunately, this also will not work since price calculations of tier prices for product variants only take the parent configurable product into consideration.

A concrete example

Let’s back up a little and have a look at the problem at hand with a concrete example. Imagine you want to sell t-shirts in different colors (green, blue, orange). For each color you want to set different base prices and in addition different tier prices. Have a look at the following table for clarification:

T-shirt1 item3 items12 items24 items
green10876
orange111098
blue1211109

Prices are in EUR, e.g. 3 orange t-shirts cost 10 EUR each, whereas 3 blue t-shirts cost 11 EUR each. Again, by default Magento will use the tier price set for the product configurable product, thus ignoring tier prices set for product variants.

Magento extensions to use tier prices of product variants

This shortcoming of Magento’s default tier price handling for configurable products lead to the development of a handful of helpful extensions. One of the first ones on the market was Simple Configurable Producs (SCP), followed by the more advanced Better Configurable Products (BCP). Simple Configurable Products officially is not supported for the latest Magento 1.9.x series anymore. In fact, according to Magento Connect official support ended with Magento 1.5, although various people reported success with Magento 1.8 too.

Thus, you might want to use Better Configurable Products instead which is officially supported for the latest Magento EE and CE editions. Nevertheless, in case you want to save a little Configurable Products use Simple Price is cheaper but does the job just as well. No, I’m not affiliated with Configurable Products use Simple Price in any way. But after spending some time testing various extensions capable of using tier prices of product variants instead of the parent’s configurable product I’ve opted for Configurable Products use Simple Price for its price and functionality. Compared to Better Configurable Products Configurable Products use Simple Price is pretty simple with regards to the feature list.

To round up, in case you are just searching for a quick way to set tier prices for product variants of configurable products in Magento Configurable Products use Simple Price offers a quick and cost effective solution.

Grouped Products as alternative

Grouped products can also be used as alternative to the above mentioned extensions to correctly calculate and display tier prices in Magento. Of course, only if your product setup matches the required configuration for grouped products. For grouped products, tier prices are correctly calculated based on the values of the underlying simple products.

You can find a lot of information on the web concerning this issue in case you want to continue your search for alternative solutions. Hopefully, some day setting tier prices for configurable products correctly will become an integral part of Magento so we are not dependent on additional extensions for this (core) functionality.

Comments

5 responses to “Set tier prices for product variants of configurable products in Magento”

  1. Julie Avatar
    Julie

    Thank you for your sharing!
    I have been using Pro Configurable Product Grid View for my Magento site and I really like tier price and color swatch funtions of this extension. Especially, it also support Simple product pricing
    http://bsscommerce.com/magento-pro-magento-configurable-product-grid-table-view.html

  2. stefan68 Avatar
    stefan68

    This is so helpful! I also recommend a magento Configurable Product Table Ordering extension that also support to set up advanced tier prices on a separated table.
    http://bsscommerce.com/magento-configurable-product-table-ordering.html

    1. Josh Avatar
      Josh

      hi @Stefan68,
      thanks for your suggestion, but I think the module you suggested is not suitable for this topic. I find another extension from BSS would be suitable https://www.magentocommerce.com/magento-connect/pro-configurable-grid-table-view-extension.html

  3. hagan Avatar
    hagan

    For guys who want to upgrade to Magento 2 and want an extension for Configurable Products on Magento 2 platform, here it is: Configurable Product Grid Table View for Magento 2:
    http://bsscommerce.com/magento-configurable-product-grid-table-view-for-magento-2.html

  4. Ole Avatar

    We also implemented am Magento 2 Module, which does exactly that.
    Feel free to take a look at https://commercemarketplace.adobe.com/customgento-module-configurable-tier-prices-m2.html.
    With this module, you can set up tier prices on the level of the children and then the module automatically applies the tier price for the total qty of all bought children.
    You can even configure if the highest, the lowest or the tier price based on the respective products should be charged.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.