Follow the guide below to import products with variants into Odoo. The video was recorded on an older Odoo version, but the approach still holds (as of Q2 2023).
Download: Product variants import template (XLSX)
Video walkthrough
The full import of products, variants and values is shown step by step in a video: Products and Product Variants - IMPORT TUTORIAL. Ask your consultant for the video if you need it.
Excel template
Use the Excel template TEMPLATE - PRODUCT & PRODUCT VARIANTS as your starting point. Fill in the fields you need for products, variants and their values. The template follows the same column layout as the video, so you can get your import file ready quickly.
Import without variants
Do not need attributes or variants? A simpler import will do. There is a separate article with a product import template without variants.
Need a hand with your import?
Stuck importing products or variants? Book an Odoo scan or get in touch - we will take a look with you.