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:
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.
For eBay: If you enable the Ignore Variations option in Selling Policy, a Bundle Product will be listed not as a Multi-Variational but as a Simple one. In this case, the Variation with the lowest price and the Option with the lowest quantity will be submitted to eBay.
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:
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:
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:
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
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.
The VAT rate sent by M2E Pro is perceived as a proper VAT rate only by eBay. Click here to learn more.
Amazon and Walmart consider the VAT rate sent by M2E Pro in a different way – as an additional price increase.
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.
Using the Add VAT% on top of Price option in eBay Selling Policy, you can either:
- add the VAT rate on top of the Item Price (choose “Yes”);
- include the VAT rate in the Item Price (choose “No”).
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
Instead of the Product Price source, you are free to choose the Special Price or Magento Attribute source – the price calculation process will stay the same.
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: