Dynamic Bundle Product Price

If you enable the Dynamic Price option while creating a Bundle Product in Magento, the item price will be calculated as a total of all Simple (Associated) Products that a customer purchases within a Bundle.

We have a Bundle Product with 2 options:

• Headphones

• Packaging

Each Associated Product has the following Product price values in Magento:

A buyer can purchase a certain number of variations of a Bundle Product. Each variation is a combination of two Associated Products (in our case, one is taken from the Headphones option, the other – from the Packaging option). Thus, our Bundle Product has 2 available variations:

• Headphones + Standard Packaging

• Headphones + Gift Packaging

The prices of these variations are taken as a basis for the final item price calculation. As our Bundle Product is listed as a Multi-Variational one, the channel’s item price will range depending on the selected variation. 

Using our Bundle Product as an example, we will figure out how to calculate Item Price displayed on Channels with different Magento Product and Selling Policy settings.

Calculations based on the selected Price Source

Apart from the selected Magento Price Type, the final price of a Bundle Product depends on one of the selected Price sources in Selling Policy:

• Product Price

• Special Price

• Magento Attribute

Product Price 

With the Product Price selected as a source, the prices for Bundle Product’s variations are calculated as the sums of the default Magento Price attribute values.

Let’s see how the Variation Price settings in Selling Policy affect the calculation of the Bundle Product’s price if you choose the Product Price as a source.

In Selling Policy, it is set to use a Product Price from Main Product.

To calculate the final price for each Bundle Product’s variation, we need to sum up the prices of Associated Products included in a variation:

Headphones + Standard Packaging: $350.00 + $12.00 = $362.00 

Headphones + Gift Packaging: $350.00 + $18.00 = $368.00

In case you choose to take the Product Price from Associated Products, this will not affect the final item price. It will be calculated as if you set to use a Product Price from Main Product:

Special Price

With the Special Price selected as a source, the prices for Bundle Product’s variations are calculated as the sums of the corresponding Special Price values and sent as regular prices to the Channel.

Our Main Bundle Product has a Special Price set to 50%:

Special Price values of Simple (Associated) Products included in a Bundle Product will be taken as a basis of item price calculation. In our case, these values are the following:

• Headphones

• Standard Packaging

• Gift Packaging

If the Special Price source is selected, but its value is not defined in Magento Product settings or its From/To dates have already expired, Product Price will be used instead.

 If you only enter the Special Price value, without specifying From/To dates, and save the Product, Magento will automatically fill in the From date field with the current date:

Therefore, since the To date is not specified, the Special Price will be active on the Channel as soon as the From date comes and further on (until you disable the Special Price or change the From/To dates).

Now let’s see how the Variation Price settings in Selling Policy affect the calculation of the Bundle Product’s price if you choose the Special Price as a source.

Case 1. Special Price taken from Main Product

In Selling Policy, it is set to use a Special Price from Main Product.

Let’s start with calculating the total price for each Bundle Product’s variation. To do it, we need to sum up the Product Price values of Associated Products included in this variation. 

Headphones + Standard Packaging: $315.00 + $7.00 = $322.00 

Headphones + Gift Packaging: $315.00 + $9.00 = $324.00

Now we will calculate the final price for each variation taking into account the Special Price percent value of the Main Bundle Product.

Laptop Gray + Black Laptop Bag: Total Price for this variation - Special Price percent value = $322.00 - 50% = $161.00

Laptop Gold + Purple Laptop Bag: $324.00 - 50% = $162.00

Case 2. Special Price taken from Associated Products

In Selling Policy, it is set to use a Special Price from Associated Products.

To calculate the final price for each Bundle Product’s variation, we need to sum up the Special Prices of Associated Products included in a variation.

Headphones + Standard Packaging: $315.00 + $7.00 = $322.00 

Headphones + Gift Packaging: $315.00 + $9.00 = $324.00

Magento Attribute

With the Magento Attribute selected as a price source, the prices for Bundle Product’s variations are calculated as the sums of the corresponding values of the assigned Magento Attribute.

For the Item to be listed on the Channel, Magento Attribute must contain a numeric value.

To enable automatic Currency conversion, make sure that the Price value is set to be taken from Magento Attribute with Price Catalog Input Type:

If you choose another Catalog Input Type, the relevant Magento Attribute value will not be automatically converted. 

Now let’s see how the Variation Price settings in Selling Policy affect the calculation of the Bundle Product’s price if you choose the Magento Attribute as a price source.

Case 1. Magento Attribute taken from Main Product

In Selling Policy, it is set to use a Magento Attribute value from Main Product. We have selected a Magento Attribute with the name of “Channel Price”.

Our Main Bundle Product has the selected Magento Attribute set to $123.00:

The price for the Bundle Product will be equal to the Magento Attribute value of the Main Product. Thus, the item is listed on the Channel with a price of $123.00.

Case 2. Magento Attribute taken from Associated Products

In Selling Policy, it is set to use a Magento Attribute value from Associated Products.

We have selected a Magento Attribute with the name of “Channel Price”.

Magento Attribute values of Simple (Associated) Products included in a Bundle Product will be taken as a basis of item price calculation. In our case, these values are the following:

• Headphones

• Standard Packaging

• Gift Packaging

To calculate the final price for each Bundle Product’s variation, we need to sum up the Magento Attribute values of Associated Products included in a variation.

Headphones + Standard Packaging: $341.00 + $10.00 = $351.00 

Headphones + Gift Packaging: $341.00 + $16.00 = $357.00

Calculations based on Price Change settings

Apart from the selected price source, the final price of a Bundle Product depends on Price Change settings in Selling Policy.

Let’s see how the Item Price will be calculated if we configure particular Price Change settings.

In Selling Policy, it is set to use a Product Price from Main Product. Price Change is set to Percentage Increase:

We need to calculate the final price for each Bundle Product’s variation taking into account two factors:

• The total Product Price of each variation (see the Product Price section of the article)

• Price Change settings

Headphones + Standard Packaging: Variation’s Product Price + Percentage Increase = $362.00 + 5.25% = $381.01

Headphones + Gift Packaging: $368.00 + 5.25% = $387.32

To show you how the Price Change settings affect the results of Item Price calculation, we have selected the Percentage Increase option. Mind that this is just an example and you are free to select any of the four Price Change options you want and set any preferred value for it:

Besides, instead of the Product Price source, you can choose the Special Price or Magento Attribute source – the price calculation process will stay the same.

VAT Rate Included

In Selling Policy, it is possible to indicate the VAT Rate – percent value that will be added to the final price of your Bundle Product.

Let’s see how the Item Price will be calculated if we add the VAT Rate value and configure particular Price Change settings.

In Selling Policy, it is set to use Product Price from Main Product. Price Change is set to Absolute Value Increase. VAT Rate is set to 19%. The Add VAT% on top of Price option is enabled.

Note that if you choose to take Product Price/Special Price/Magento Attribute from Associated Products, it will not affect the final item price. It will be calculated as if you select the Main Product as a price source.

The first step is to calculate the price for each Bundle Product’s variation taking into account two factors:

• The total Product Price of each variation (see the Product Price section of the article)

• Price Change settings

Headphones + Standard Packaging: Variation’s Product Price + Absolute Value Increase = $362.00 + 6 = $368.00

Headphones + Gift Packaging: $368.00 + 6 = $374.00

Then we need to calculate the VAT Rate value for each Bundle Product’s variation:

Headphones + Standard Packaging: Variation’s Product Price with Price Change settings applied x VAT Rate (%) = $368.00 x 19% = $69.92

Headphones + Gift Packaging: $374.00 x 19% = 71.06

The final price for each variation of our Bundle Product will be calculated according to the following formula:

(Product Price + Price Change) + VAT Rate value

Headphones + Standard Packaging: ($362.00 + 6) + $69.92 = $437.92

Headphones + Gift Packaging: ($368.00 + 6) + $71.06 = $445.06