Quantity of Simple Product with Custom Options

Modified on Tue, 30 May 2023 at 11:25 AM

We have a Simple Product with Custom Options in Magento Inventory with 10 items In Stock.

The product has 3 options.

Using this product as an example, we will figure out how to calculate Item Quantity available on Channels with different Selling Policy settings.

By default, a Simple Product with Custom Options is listed as a Variational one on the Channel.

Note

For eBay: If the Ignore Variations option is enabled, a Simple Product with Custom Options will be listed as a Simple Product on the Channel.

The quantity of a Simple Product with Custom Options (if it is listed as a Variational one on the Channel) is calculated based on the quantity value of Parent Product and the number of options.

Note

For this type of Product, its QTY is specified in the Simple Product itself.

The first step is to calculate the available quantity of the Parent Product. Then you need to multiply that value by the number of Custom Options. As a result, you get the overall quantity of pieces that will be displayed on the Channel.

Tip

The Custom Options of a Single Product are based on variations of a single SKU. Since they make part of a Parent Product and are not separate products, you have to update their quantity manually.

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 the Parent Product or its options 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.

Note

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 Quantity (quantity of options included) on the Channel.

Begin with calculating the available quantity of the Parent Product based on QTY Percentage. In our case, this value is 10.

Tip

To calculate available QTY of the Parent Product, you have to multiply QTY percentage by 10.

For example, 100% x 10 (QTY percentage) = 10 (QTY available on the Channel)

Then let’s calculate the overall quantity of pieces that will be displayed on the Channel. For that, multiply the quantity of the Parent Product (10) by the number of options (3): 10 x 3 = 30 pieces.

The item will be listed on the Channel with 30 available pieces.

Case 2. 100% of Magento Attribute Value

In Selling Policy, it is set to use 100% of Magento Attribute value.

Note

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 value 4 is set in Magento Attribute (in our case, it is “QTY”, but you can select any other appropriate custom Attribute).

To calculate available QTY, you have to multiply Magento Attribute value (4) by the number of options (3): 4 x 3 = 12 pieces.

The item will be listed on the Channel with 12 available pieces.

Case 3. 30% of Product Quantity

In Selling Policy, it is set to use 30% of Product Quantity.

Tip

Pay attention to this case if you want to submit only a certain part of Product quantity to the Channel.

Begin with calculating the available quantity of the Parent Product based on QTY Percentage: 30% x 10 = 3

Then let’s calculate the overall quantity of pieces that will be displayed on the Channel. For that, multiply the quantity of the Parent Product (3) by the number of options (3): 3 x 3 = 9

The item will be listed on the Channel with 9 available pieces.

Case 4. Conditional Quantity Enabled

In Selling Policy, it is set to use 100% of Product Quantity with the enabled Conditional Quantity option.

Begin with calculating the available quantity of the Parent Product based on QTY Percentage: 10 x 100% = 10. But note that Max QTY to Be Listed is 8.

Then let’s calculate the overall quantity of pieces displayed on the Channel. For that, multiply the quantity (8 - as it is Maximum to Be Listed) by the number of options (3): 8 x 3 = 24

The item will be listed on the Channel with 24 available pieces.

M2E Pro checks the value of Min QTY to Be Listed field based on the Parent Product quantity. Once this field is set to the value equal or more than the Parent Product quantity, the item will be submitted to the Channel with the quantity multiplied by the number of options.

Note

If Magento Product quantity 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.

To calculate available QTY, you have to multiply your custom value (7) by the number of options (3): 7 x 3 = 21

The item will be listed on the Channel with 21 available pieces.

Note

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. 75% of Magento Attribute Value + Conditional Quantity

In Selling Policy, it is set to use 75% of Magento Attribute value with enabled Conditional Quantity.

The value 5 is set in Magento Attribute (in our case, it is “QTY”, but you can select any other appropriate custom Attribute).

Begin with calculating the available quantity of the Parent Product based on QTY Percentage: 75% (QTY Percentage) x 5 (Magento Attribute Value) = 3,75 ~ 3 (QTY available on the Channel)

Then let’s calculate the overall quantity of pieces displayed on the Channel. For that, multiply the quantity (3) by the number of options (3): 3 x 3 = 6

Since Max QTY to Be Listed is set to 5, and 6 > 5, the item will be listed on the Channel with 5 available pieces.

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.

Note

If you enable Ignore Variations, the number of options will not be taken into account when calculating the overall product quantity displayed on the Channel. In this case, a Simple Product with Custom Options will be listed as a Simple Product.

The available QTY is 10 (10 x 100% = 10). The item will be listed on the Channel with 10 available pieces.