Hi Andre Andersen,

You can achieve your process in Odoo via setup a correct Manufacturing Process as mentioned below to handling the conversion of 1-litre coffee bottles into 3-litre bags in Odoo, including partial manufacturing and wastage tracking via By-Products .

Step 1: Enable Required Settings in Odoo

1. Activate the Manufacturing Module
   • Go to Apps → Search for Manufacturing → Install if not already installed.
2. Enable Flexible Consumption (Partial Manufacturing)
   • Navigate to Manufacturing → Configuration → Settings.
   • Under Operations, enable:
     ✅ Consume Components in Manufacturing
     ✅ Allow Flexible Consumption (to allow partial production).
   • Save the settings.
3. Enable By-Products (For Wastage Tracking)
   • Still in Manufacturing Settings, enable:
     ✅ By-Products under "Operations".
   • Save the settings.
4. Enable Lot/Serial Tracking (If Needed for Expiry Tracking)
   • Go to Inventory → Configuration → Settings.
   • Enable Lots & Serial Numbers.
   • Save the settings.

​
Step 2: Create Products in Odoo

​1. Create the 1-Litre Coffee Bottle Product

• • Go to Inventory → Products → Create.
  • Name: 1-Litre Coffee Bottle.
  • Product Type: Storable Product.
  • Unit of Measure: Litres (or Bottles).
  • Tracking: Enable Lot & Serial Number Tracking (if needed).
  • Save the product.

​2. Create the 3-Litre Coffee Bag Product

• • Go to Inventory → Products → Create.
  • Name: 3-Litre Coffee Bag.
  • Product Type: Storable Product.
  • Unit of Measure: Litres (or Bags).
  • Save the product.

​3. Create a Product for Wastage Tracking (By-Product)

• • Go to Inventory → Products → Create.
  • Name: Wasted Coffee.
  • Product Type: Consumable (if not stored) or Storable Product (if tracked).
  • Storage Location: Set a designated scrap or waste location.
  • Save the product.
    
    

Step 3: Create a Bill of Materials (BoM)

1. Go to Manufacturing → Bill of Materials → Create.
2. Enter the following details:
   • Product: "3-Litre Coffee Bag".
   • BoM Type: "Manufacture this product".
   • Components:
     • Product: 1-Litre Coffee Bottle.
     • Quantity: 3 (for a standard process).
3. Add By-Products (Wastage Tracking):
   • Click "Add a line" under By-Products.
   • Product: "Wasted Coffee".
   • Quantity: 0.1L (for example, if 0.1L is lost per batch).
   • Location: Select the appropriate warehouse/storage location (e.g., "Scrap/Waste Bin").
4. Save the BoM.

Step 4: Process Manufacturing Order (Including Partial Manufacturing)

1. 1. Go to Manufacturing → Manufacturing Orders → Create.
   2. Select Product: "3-Litre Coffee Bag".
   3. Enter Quantity: Specify how many 3L bags you are creating.
   4. Click Check Availability to verify stock availability.

​Scenario 1: Full Manufacturing (3 Bottles Available)

• • If all 3 bottles are available, proceed normally:
  • • Click Confirm → Click Mark as Done.
    • Odoo will:
      ✅ Deduct 3 x 1L bottles.
      ✅ Add 1 x 3L bag.
      ✅ Log 0.1L Wasted Coffee (By-Product) in the designated storage.

​Scenario 2: Partial Manufacturing (Less Than 3 Bottles Available)

• • If only 2 bottles are available:
  • • Reduce the final product quantity proportionally (e.g., 2L bag).
    • Adjust component consumption accordingly.
    • Proceed with the order.

Step 5: Handle Stock Adjustments & Delivery

• Odoo automatically:
  ✅ Deducts used 1L bottles from stock.
  ✅ Adds 3L bags to stock.
  ✅ Logs Wasted Coffee (by-product).
• To ship products:
  • Go to Sales → Orders → Delivery Orders.
  • Select the 3-Litre Coffee Bag for dispatch.
  • Validate the delivery.

Step 6: Automate Stock Replenishment (Optional)

To automatically reorder 1L bottles when stock is low:

1. Go to Inventory → Products → Reordering Rules.
2. Select Product: 1-Litre Coffee Bottle.
3. Set Minimum & Maximum Stock Levels.
4. Odoo will auto-trigger purchase orders when stock drops below the threshold.

Conclusion

✅ Manufacturing Process:

• Convert 3 x 1L Coffee Bottles → 1 x 3L Coffee Bag.
• Use By-Products to track 0.1L wastage per batch.
• Allows Partial Manufacturing if raw material is insufficient.

✅ Inventory & Cost Management:

• Odoo automatically updates stock after conversion.
• Wasted Coffee is logged separately for cost & waste tracking.
• Reordering rules prevent stock-outs of 1L bottles.

This ensures a smooth, automated, and accurate manufacturing workflow! 🚀

Thanks & Regards,
Sunny Sheth (shethsunny555@gmail.com)