How to calculate options and variants of the bundle?
To understand how to provide options for your customers, we've outlined the following logic to help you ensure that your bundle campaigns run smoothly while effectively managing pricing and inventory.
Sample
Consider the three products in the table below with their corresponding options and values. If a bundled product doesn't have a value for an option, it is marked with an (x).
Honey Bee Travel Notebook (P1)
Brown, Beige, Purple, Silver
A4, A5, B5
Dot, Grid, Lined
(x)
Soft Feather Travel Notebook (P2)
Purple
A4, A5, B5
(x)
Hardcover, Softcover
Moonflower Bullet Journal (P3)
Black, Beige, Pink
(x)
Dot
(x)
1. How bundled products are calculated?
All products added to the bundle are referred to as bundled products. Therefore:
Number of bundled products = Number of selected applicable products
From the sample, let's create two bundles to see how the calculations work.
Bundle 1: Select bundled products are P1 and P2 -> The number of bundled products is 2
Bundle 2: Select bundled products are P1, P2, and P3 -> The number of bundled products is 3
2. How options are calculated?
An option for the bundle is calculated when the options of the bundled product have more than one value selected (*). Therefore:
Number of options = Total number of calculated options from its bundled products
For Bundle 1:
Select the following options and values for P1, and we determine that there are 3 option values that meet condition (*), meaning P1 has 3 options.
Color
Brown, Beige
Yes
Has 2 values
Size
A4, A5, B5
Yes
Has 3 values
Paper type
Dot
Yes
Has 3 values
Select the following options and values for P2, and we determine that there are 2 option values that meet condition (*), meaning P2 has 2 options.
Color
Purple
No
Has 1 value
Size
A4, A5
Yes
Has 2 values
Cover material
Hardcover, Softcover
Yes
Has 2 values
Therefore, the number of options for Bundle 1 is calculated as:
Number of options = Calculated options of P1 + Calculated options of P2
Number of options = 2 + 3 = 5
For Bundle 2:
Select the following options and values for P1 (similar to Bundle 1), and we determine that there are 3 option values that meet condition (*), meaning P1 has 3 options.
Select the following options and values for P2 (similar to Bundle 1), and we determine that there are 2 option values that meet condition (*), meaning P2 has 2 options.
Select the following options and values for P3, and we determine that there are 2 option values that meet condition (*), meaning P3 has 1 option.
Color
Black, Beige, Pink
Yes
Has 3 values
Paper type
Dot
No
Has 1 value
Therefore, the number of options for Bundle 2 is calculated as:
Number of options = Calculated options of P1 + Calculated options of P2 + Calculated options of P3
Number of options = 2 + 3 + 1 = 6
3. How variants are calculated?
The number of values for each option is referred to as option values.
Variants of the bundle are calculated based on these option values for each bundled product. They are computed by:
Number of variants = Product of variants for each bundled product
From the selected sample, we get:
P1 has 2 x 3 x 3 = 12 variants
P2 has 1 x 2 x 2 = 4 variants
P3 has 3 x 1 = 3 variants
Therefore:
The number of variants for Bundle 1 is:
Number of variants = Variants of P1 × Variants of P2
Number of variants = 12 × 4 = 48
The number of variants for Bundle 2 is:
Number of variants = Variants of P1 × Variants of P2 × Variants of P3
Number of variants = 12 × 4 × 3 = 144
Last updated