Environment: Odoo 16, Enterprise, on .SH

Problem?

I'm trying to import on my Odoo MRP module some Bills of Materials (BOM for acronym lovers)

My issue is that I have some product variants, and the components depend on the variant, for example, I have Cases that comes in black, blue, red. The base component is the same for all three color variants, but I apply a specific colorant depending on the variant.

So far I've tried to create the boom manually applying on variants and then exporting it to get the format from Odoo, but, for the apply on variant I get a field on each line that is, Color: Red, the next line: Color: Blue and so on. But when I try to import the exact same file I get the error that the values does no correspond to the database.

Then I exported the product ID's from the Variants menu so I get de product.product ID, put that product.product on the Excel file but it's not recognized.

I have a solution that is to create a fully independent BoM for each variant but i kinda fell that it's not appropiate or not taking full advantage of Odoo capabilities of simplifying things and keeping just one BoM with the variant diferentiation.

SO! my issue is that I want to import my BoM in Odoo applying product variants. Do you think that this is possible?