Bundles
We define bundles as products that contain a combination of multiple other products.
Example
- 1 Pack of Aspirin Complex -> individual product
- 3 Pack of Aspirin Complex -> bundle product
Typical bundle issues
- The Price of the bundle product should follow the price of the individual product. Example: If the 1 Pack Aspirin Complex is reduced in price by 10%, you need to make sure, that the 3 Pack Aspirin Complex is still more affordable
- Stock is usually not stored separately for bundles. Stock therefore needs to be considered virtually for bundles. Example: if you have 10 packs of Aspirin Complex left, you can only sell a maximum of 3 bundles of 3 Packs of Aspirin Complex
Bundle data feed
To better handle bundle products, we ask for bundle information in a separate data feed. The way we ask for the data means, that each bundle will have a bundle_id AND a product_id.
| Column | Data Types | Description |
|---|---|---|
| product_id | Text | Unique product identifier |
| bundle_id | Text | Unique bundle identifier |
| product_qty | Integer, Decimal | Product quantity in bundle |
This data feed enables specific bundle rules that wouldn't be possible without it.
Rule: Bundle Price = Product Prices x Value
This rule sets the bundle price at a multiple of the price of the individual products.
Example
Price of 1 pack of Aspirin Complex after optimization = 11.49 EUR
Value = 95%
Price of 3 pack of Aspirin Complex after optimization: Bundle price = 11.49 x 3 x 95% = 32.75 EUR
Rule: Bundle Price < Product Prices x Value
This rule sets a maximum bundle price at a multiple of the price of the individual products.
Example
Price of 1 pack of Aspirin Complex after optimization = 11.49 EUR
Value 95%
Price of 3 pack of Aspirin Complex after optimization: Bundle price < 32.75 EUR