This project required up to 90 possible combos with different main products and additional products. This solution allowed the client to enter their own personal skus per combo and the macro automatically retrieves the cost and selling price from their price list. It also contains conditional formatting to show which products went out of stock or which products’ pricing changed.
Key Features:
- Dynamic main product and add-on product selection
- Automatic combo configuration based on business rules
- Auto-retrieves costs from master price list using custom SKUs
- Calculates selling prices based on predefined markup rules
- Real-time price updates when source data changes