We have a Bundle Product with 2 options:
- Laptop Bag (3 Child Products)
- Laptop (2 Child Products)
Each Child Product is a separate Simple Product with its own quantity in Magento:
The quantity of each Child Product will be updated automatically once a Channel order is placed and imported to Magento. Its quantity will be reduced by the Default QTY value (which is the number of each Child Product included in one Variation).
By default, a Bundle Product is listed as a Multi-Variational one on the Channel.
For eBay: If the Ignore Variations option is enabled, a Bundle Product will be listed as a Simple Product on the Channel.
Basic Calculations
Using this Bundle Product as an example, we will figure out how to calculate Item Quantity available on Channels with different Selling Policy settings.
The buyer can purchase a certain number of variations of a Bundle Product. Each variation is a combination of two Child Products (in our case, one is taken from the Laptop option, the other – from the Laptop Bag option). Thus, our Bundle Product has 6 available variations:
- Laptop Gold + Black Laptop Bag
- Laptop Gold + Gray Laptop Bag
- Laptop Gold + Purple Laptop Bag
- Laptop Gray + Black Laptop Bag
- Laptop Gray + Gray Laptop Bag
- Laptop Gray + Purple Laptop Bag
The quantity of a Bundle Product is calculated as the sum of quantities of all available Variations.
To figure out how the quantity is calculated for each variation, let’s take a look at one of the variations as an example – Laptop Gray + Black Laptop Bag.
The quantity of the variation will be taken from the Child Product with the smallest quantity value. In our case, it is Black Laptop Bag with the quantity value of 10.
Calculations based on Selling Policy Settings
Now let’s see how particular Selling Policy settings affect the quantity calculation of our Bundle Product.
What you need to know about basic quantity settings in Selling Policy:
- Quantity – allows you to select Magento source for a product quantity that will be displayed on the Channel.
- Quantity Percentage – allows you to set a percentage of Magento Product quantity that will be submitted to the Channel.
- Conditional Quantity – allows you to set minimum and maximum product quantity values that will be displayed on the Channel.
Important! In case the quantity value of Variations is equal to a decimal number, for example, 3.75, M2E Pro will submit the quantity available on the Channel with the value 3 in order to prevent oversells.
If Magento Inventory Management feature is configured, M2E Pro will operate product Salable Quantity when submitting product data to Channel. Find out more details in this video or in this article.
Case 1. 100% of Product Quantity
In Selling Policy, it is set to use 100% of Product Quantity. Select this value if you want to list the entire Magento product quantity on the Channel.
We need to sum up the quantities of all Variations:
10 + 11 + 11 + 10 + 11 + 12 = 65
The item will be listed on the Channel with 65 available pieces.
Case 2. 50% of Product Quantity
In Selling Policy, it is set to use 50% of Product Quantity.
Firstly, you need to calculate the quantity of each Variation based on QTY Percentage.
To do that, multiply product quantity of each Variation by QTY Percentage. For example:
11 (product quantity) x 50 % (QTY Percentage) = 5.5 ~ 5
Now let’s calculate the sum of quantities of all Variations: 5 + 5 + 5 + 5 + 5 + 6 = 31
The item will be listed on the Channel with 31 available pieces.
Case 3. 100% of Magento Attribute Value
In Selling Policy, it is set to use 100% of Magento Attribute value.
After the Channel Order is imported, Magento will reduce the quantity in the default Product QTY Attribute. The quantity specified in your custom Magento Attribute value will not change and will still be submitted to the Channel. You need to make sure to update the quantity accordingly.
The Magento Attribute of Child Products contains such values:
- Laptop Gold - 15, Laptop Gray - 20
- Black Laptop Bag - 12, Gray Laptop Bag - 13, Purple Laptop Bag - 14
In our case, Magento Attribute is “QTY”, but you can select any other appropriate custom Attribute.
The quantity of each variation will be taken from the Child Product with the smallest Magento Attribute value.
Now let’s calculate the sum of quantities of all Variations:
12 + 13 + 14 +12 + 13 + 14 = 78
The item will be listed on the Channel with 78 available pieces.
For eBay: In case the Ignore Variations option is enabled, the QTY listed on the Channel will be taken from the Magento Attribute value of the Parent Product.
Case 4. Conditional Quantity Enabled
In Selling Policy, it is set to use 100% of Product Quantity with the enabled Conditional Quantity option.
Before you set Min and Max QTY to Be Listed values, mind that they affect the quantity of each Variation individually.
Now you need to calculate the quantity of each Variation based on QTY Percentage. To do that, multiply product quantity of each Variation by QTY Percentage. For example:
10 (product quantity) x 100% (QTY Percentage) = 10
The quantity of each Variation is greater than the Max QTY to Be Listed value.
Therefore, the quantity value for each Variation will be taken from the Max QTY to Be Listed value. The right calculations are as follows:
5+5+5+5+5 = 30, where 5 is the Max QTY to Be Listed value
The item will be listed on the Channel with 30 available pieces.
For the item to be submitted, the quantity of at least one of the Variations has to be equal or more than the value set in the Min QTY to Be Listed field.
If the quantity of all Variations is less than the specified Min QTY to Be Listed value, the item will not be listed on the Channel.
Case 5. Custom Value
In Selling Policy, the QTY is set to use a Custom Value.
In this field, you have to enter your own quantity value based on which QTY calculation will be carried out.
The specified Custom Value will be applied to the quantity of each Variation individually.
We need to calculate the sum of quantities of all Variations:
7+7+7+7+7+7 = 42, where 7 is the Custom Value
The item will be listed on the Channel with 42 available pieces.
After the Channel Order is imported, Magento will reduce the quantity in the default Product QTY Attribute. The quantity specified in your custom value will not change and will still be submitted to the Channel. You need to make sure to update the quantity accordingly.
Case 6. 60% of Magento Attribute Value + Conditional Quantity
In Selling Policy, it is set to use 60% of Magento Attribute value with enabled Conditional Quantity.
The Magento Attribute of Child Products contains such values:
- Laptop Gold - 15, Laptop Gray - 20
- Black Laptop Bag - 12, Gray Laptop Bag - 13, Purple Laptop Bag - 14
In our case, Magento Attribute is “QTY”, but you can select any other appropriate custom Attribute.
As you already know, the quantity of each variation will be taken from the Child Product with the smallest Magento Attribute value.
Now you need to calculate the quantity of each Variation based on QTY Percentage. To do that, multiply product quantity of each Variation by QTY Percentage. For example:
12 (Magento Attribute value) x 60% (QTY Percentage) = 7.2 ~ 7
The quantity of each Variation is not greater than the Max QTY to Be Listed value. The right calculations are as follows:
7+7+8+7+7+8 = 44
The item will be listed on the Channel with 44 available pieces.
For eBay: In case the Ignore Variations option is enabled, the QTY listed on the Channel will be taken from the Magento Attribute value of the Parent Product multiplied by QTY Percentage.
Case 7. Ignore Variations option Enabled (for eBay only)
In Selling Policy, it is set to use 100% of Product Quantity with the enabled Ignore Variations option.
If you enable the Ignore Variations option, a Bundle Product will be listed as a Simple Product on eBay.
To calculate the available QTY of such a product, you need to sum up the quantity of all Child Products in each Option:
Laptop: 11 + 25 = 36
Laptop Bag: 10 + 11 + 12 = 33
The quantity of the smaller Option will be submitted to the Channel as Product QTY.
Thus, the item will be listed on the Channel with 33 available pieces but without variations.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article