Complete Guide How to Import Product Attributes & Variants in Odoo

Introduction to Product Attributes & Variants in Odoo

What are Product Attributes
Product attributes are characteristics used to define product variations, such as color, size, or material. 

What are Product Variants? 
Product variants are the actual combinations of attributes (e.g., a T-shirt in Grey, Size M). 

Why Attributes and Variants Matter for Product Management

• Simplifies catalogue management 
• Enables accurate inventory tracking 
• Supports efficient sales and purchasing processes 

Benefits of Using Product Variants in Odoo

• Simplified Product Management – Manage one product with multiple variations instead of separate entries. 
• Better Inventory Tracking – Variants allow tracking stock for each combination (e.g., Grey-M, Black-L). 
• Improved Sales and Purchasing Efficiency – Automatically generates all combinations, reducing manual entry errors. 

Understanding How Odoo Handles Product Variants

• Variant Creation Methods in Odoo – Odoo automatically generates product variants based on defined attributes and their values. 
• Attribute Configuration Basics – Before creating variants, attributes and their values must be configured correctly in the system. 

Preparing Data for Import

Required Fields for Product Attribute Import 

• Attribute  
• Display Type  
• Variant Creation  
• Values / Value  

Required Fields for Product Variant Import 

• Name  
• Product Type (Goods)  
• Track Inventory  
• Tracking (By Quantity)  
• Attributes  
• Attribute Values  

Best Practices for Data Preparation 

• Use consistent naming conventions  
• Ensure correct formatting  
• Validate data before import 

Step-by-Step: Importing Product Attributes in Odoo

Variants must be enabled before importing any attributes or product variants. 

Step 1: Enable Product Variants – How to Enable Variants in Odoo 19 

1. Navigate to Inventory 
2. Open the Settings section 
3. Locate the Variants option under Product CatLog 
4. Enable the checkbox 
5. Click Save 

Enabling variants activates the system’s variant engine and makes attribute configuration possible.

Step 2: Import Product Attributes & Values 

Before importing products, all attributes and their possible values must already exist in Odoo 19. 

Required Columns in Attribute Import File 

• Attribute 
• Display Type 
• Variant Creation 
• Values / Value

Example: 

Important Formatting Rules 

• • Values must be comma-separated 
  • No spaces after commas: 
  • Correct: Grey,Black 
  • Incorrect: Grey, Black 
  • Variant Creation should be set to Instantly 

Step – 3 Attribute Import Steps in Odoo 19 

1. Go to Products → Configuration → Attributes 

  2. Click Import

   3.  Upload the attribute file 

   4. Map fields correctly 

   5.  Click Test 

  6. Click Import 

After this, all attributes and their values will be available for product variant creation. 

Step-by-Step: Importing Product Variants in Odoo

Step 1: Import Products with Variants 

Once attributes are imported, products can be imported with their variants. 

Required Columns in Product Import File 

• Name 
• Product Type (Goods) 
• Track Inventory 
• Tracking (By Quantity) 
• Attributes 
• Attribute Values 

Step -2 Important Inventory Settings in Odoo 19 

• Odoo 19 product types: Goods, Combo, Service 
• For storable products: 
• Track Inventory = Enabled 

• Tracking = By Quantity 

Step – 3 Product Import Steps 

• Navigate to Products 
• Click Import 
• Upload the product file 
• Map fields: 
• Name → Name 
• Variant → Product Attributes 
• Pattern → Product Attribute Values 

• • Click Test 

• Click Import 
• Variants will automatically generate based on attribute combinations. 

Common Errors During Import and How to Fix Them

• Attribute Mapping Errors 
• Duplicate Variant Issues 
• Data Formatting Problems

Tips for Managing Large ProductCatalog’sin Odoo 

• Attribute mapping errors 
• Variants may not generate 
• Inventory tracking could be incorrect 
• Products may remain simple without variant combinations 

Skipping steps can break the import workflow and create manual rework 

Conclusion

To successfully import product attributes and variants in Odoo 19: 

Enable Variants → Import Attributes → Import Products → Verify Variants 

This structured approach ensures correct variant creation, proper inventory tracking, and a hassle-free import process. 

Need help with Odoo implementation or data migration? Contact Techvaria at info@techvaria.com or call +91 80415 01883 for expert guidance and a free consultation