1. Use Odoo's product variant and attribute features to capture unique specifications for custom advertising materials.

2. Implement dynamic Bill of Materials (BoM) to adjust raw materials based on selected attributes.

3. Allow sales order customization to accommodate diverse client requirements without creating individual products.

4. Leverage Odoo's costing methods to accurately track manufacturing costs for each product variant.

5. Utilize production planning in Odoo's manufacturing module, aligning with incoming sales orders.

6. Take advantage of reporting and analytics tools to gain insights into costs, order volumes, and product variations.

7. Integrate the manufacturing module with other Odoo modules for a seamless end-to-end process.

8. Ensure comprehensive employee training to maximize system utilization.

9. Regularly review and refine processes based on feedback and evolving business requirements.

10. Stay updated on new Odoo features for potential enhancements to your manufacturing workflow.

If need more information about Odoo 17 visit at Ledger Labs Blog they have Explained it very well!

Hi Amjith

This depends, of course, on the exact requirements. We have a customer where we create products based on the sales order, but the volume is not as large as in your question.

An alternative approach would be to 'group' products with similar specifications and create different BOMs (bills of materials) for the specific customer order. This way, the number of products is more limited, and you can group them by either manufacturing or reporting requirements.

Finally, if multiple BOMs are still too complex, and again, depending on the specific needs, you could move some elements to description field(s) on a manufacturing order. You loose even more info for selection, reporting, ..., but gain in simplicity.