Odoo’s native import functionality, accessible from the Products screen via the “Favorites” → “Import Records” option, is a surprisingly capable tool—especially if you're working with clean Excel or CSV files. This method works best when your product and variant structures are fairly typical. For importing product variants, your file should typically include:

• Product Template Name
• Attribute (like Size or Color)
• Attribute Value (such as Small or Red)
• Internal Reference, Barcode, Pricing details, etc.

As long as the CSV is well-structured, Odoo can automatically create the correct relationships between templates and their variants during import.

Hi,

You can use the following modules for importing the product and product variants.

* https://apps.odoo.com/apps/modules/18.0/product_import

* https://apps.odoo.com/apps/modules/18.0/product_variant_import

* https://apps.odoo.com/apps/modules/18.0/import_lots

Hope it helps