Odoo Split Product Case - Inventory Manager

Key Features:

• Bundle and Case Setup:- Admins can enter the number of units in a case and the total price, allowing for precise pricing strategies. This setup facilitates the automatic calculation of bundle and single-item pricing based on the master case price.
• Linked Product Mapping:- Product bundles and single products can be marked and linked to their parent case. This ensures accurate inventory tracking and real-time adjustments based on customer orders.
• Real-Time Inventory Adjustments:- Inventory levels adjust dynamically as bundles or single units are ordered. When a bundle of 6 is ordered, the system converts a master case into smaller bundles, maintaining efficient stock levels.
• Customizable Product Filters:- Admins can use added filters in the product list to easily sort and track different configurations of cases, bundles, and single units.
• Automatic Cost Calculation:- The app calculates the cost of smaller bundles or single units automatically from the master case price, streamlining pricing and sales operations.
• Seamless Sales Operations:- As various quantities are sold, the inventory updates reflect accurate stock levels for cases, bundles, and individual units, ensuring precise inventory management.

Example:

Here's how the app can help:

1. Inventory Setup:- The admin enters the received inventory: 10 cases with 24 bottles each. The app calculates the total initial stock as 10 cases.

2. Pricing Configuration:- The admin sets the total price for a master case at $240, meaning each bottle costs $10. The app then automatically calculates the price for a bundle of 6 bottles at $60.

3. Product Offering:- Customers visiting the online store can choose to buy:

• A full case of 24 bottles for $240
• A bundle of 6 bottles for $60
• A single bottle for $10

4. Dynamic Inventory Management:-  

• If a customer orders a bundle of 6, the system automatically deducts one master case from the inventory and adds 4 bundles of 6 (since 24/6 = 4).
• If a customer orders a single bottle, the app decreases one master case from the inventory and adds 24 single bottles to the stock.

5. Sales Example:- 

• A customer buys 1 master case, 1 bundle of 6, and 1 single bottle:
• Inventory decreases by 1 case, leaving 7 cases. (2 master cases opened to create a bundle of 6 and single bottle product)
• Bundles of 6 are shown as 3 remaining (4 initially, minus 1 sold).
• Single bottles are shown as 23 remaining (24 initially, minus 1 sold).

Benefits:

• Simplified Product Management
• Automatic Cost Adjustments  
• Real-Time Inventory Tracking  
• Enhanced Order Confirmation Process 
• Improved Sales Order History Tracking  
• Streamlined User Experience 

Steps:

• Go to Website -> eCommerce -> Products. Create products, enable the case box, and enter the value for units in the case.
• Create another product, enable the bundle case, and enter the value for units. 
• Navigate to the case bundle tab and select case map products.
• Create a product, and next enable the single case. Go to the case bundle tab and select case map product.
• After confirming the order, the on-hand and forecast values are automatically adjusted according to the case map product.