🚀 Odoo Product Variant Import Tool
Step 1: Upload Master File
Upload your master CSV file containing all products and variants. The tool will generate import_1_attributes.csv and import_2_templates.csv.
Click to upload or drag & drop
Master CSV file (with tmp_*, att{N}_*, var_*, prl_* columns)
Need a sample? Download the example master file to see the expected structure.
- Go to Settings → Products → Attributes
- Import the import_1_attributes.csv file
- Go to Products → Products (Templates)
- Import the import_2_templates.csv file
- After both imports complete, proceed to Step 2
Step 2: Upload Odoo Variant Export & Generate Files
After importing the files into Odoo, export the variants and upload the export file here. The tool will generate import_3_variants.csv and import_4_pricelist.csv.
- Go to Products → Variants
- Select all relevant variants (use the filter if needed)
- Click Action → Export
- Check "Export with External ID"
- Select only these three fields:
idproduct_tmpl_id/idproduct_template_attribute_value_ids/product_attribute_value_id/id
- Export and upload below
Click to upload or drag & drop
Odoo variant export CSV (with id, product_tmpl_id/id, and attribute value IDs)
🚀 Odoo Product Variant Import Tool
Step 1: Upload Master File
Upload your master CSV file containing all products and variants. The tool will generate import_1_attributes.csv and import_2_templates.csv.
Click to upload or drag & drop
Master CSV file (with tmp_*, att{N}_*, var_*, prl_* columns)
Need a sample? Download the example master file to see the expected structure.
- Go to Settings → Products → Attributes
- Import the import_1_attributes.csv file
- Go to Products → Products (Templates)
- Import the import_2_templates.csv file
- After both imports complete, proceed to Step 2
Step 2: Upload Odoo Variant Export & Generate Files
After importing the files into Odoo, export the variants and upload the export file here. The tool will generate import_3_variants.csv and import_4_pricelist.csv.
- Go to Products → Variants
- Select all relevant variants (use the filter if needed)
- Click Action → Export
- Check "Export with External ID"
- Select only these three fields:
idproduct_tmpl_id/idproduct_template_attribute_value_ids/product_attribute_value_id/id
- Export and upload below
Click to upload or drag & drop
Odoo variant export CSV (with id, product_tmpl_id/id, and attribute value IDs)