I'm trying to figure out the best way to handle product/BoM variants in Odoo 11 Community.  Our company is a door manufacturer and we would have a base product and some attributes or variants.  For example: 3 Interlocking sliding door is the end product and a BoM for that door would have a film_type and glass_type at a minimum.  Using Odoo product variants would cause this to create over 40,000 products and that just doesn't seem right to me.  I've tried many combination from create variant to not creating variant, but I can't seem to get the attribute, or variant from the sale order line to the manufacturing order, BoM, or purchase order without explicitly creating a new product.I have starting creating my own module to add dropdown options to the sale order line that I can pass along to the different areas.  While this is starting to look promising, I really want to double check and make sure there isn't already a build in method that I'm just overlooking or using incorrectly before I devote time to implementing my module. 

Your thoughts on this matter would be greatly appreciated, or if perhaps anyone knows of a third-party app that is already available or perhaps similar to my needs, that would be great as well.