Hi everyone,
We are building our DB and need to import about 10,000 lines of articles and variants.
As for now, each product variant is one record in Sage100
We extract the main products in xls and import these in Odoo with the attributes and values to create the variants.
So far everything is OK.
Now we need to complete the Variants with the "default code".
Here we have a problem as there is NO COMMON FIELD existing in the Product table AND the Variants table to export the "Product default code" while exporting the variants.
With this "Product default code," we can complete the "Variant default code"
This default code contains what also is called the SKU and is a unique value we need to make price updates etc. This default code also contains intelligence regarding our product assortment.

Product: Serafil 30/10 => SKU 300G191 (product default code)
Variant:  zwart => SKU 300G191.4000 (variant default code)
Variant:  wit  =>   SKU 300G191.2000 (variant default code)

Thank you for reflecting on the issue and providing us with some useful insights.
Marc from Belgium