Skip to Content
Guerilla IT
    • Home
    • Projects
    • Philosophy
    • Workshops
      • Für Kunstschaffende
      • Kommende Termine
    • Blog
    • Werkzeuge
      • Odoo Table Pivoter
      • Odoo Multi Row Collapse
      • Odoo Variant Importer
  • ͏ +43 650 3450 399 contact@guerilla-it.com
  • English (US) Deutsch Español
  • Sign in
Guerilla IT
      • Home
      • Projects
      • Philosophy
      • Workshops
        • Für Kunstschaffende
        • Kommende Termine
      • Blog
      • Werkzeuge
        • Odoo Table Pivoter
        • Odoo Multi Row Collapse
        • Odoo Variant Importer
    • ͏ +43 650 3450 399 contact@guerilla-it.com
    • English (US) Deutsch Español
    • Sign in
    Odoo Product Variant Import Tool

    🚀 Odoo Product Variant Import Tool

    1 Master File
    2 Odoo Export

    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.

    Next Steps in Odoo:
    1. Go to Settings → Products → Attributes
    2. Import the import_1_attributes.csv file
    3. Go to Products → Products (Templates)
    4. Import the import_2_templates.csv file
    5. 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.

    How to Export from Odoo:
    1. Go to Products → Variants
    2. Select all relevant variants (use the filter if needed)
    3. Click Action → Export
    4. Check "Export with External ID"
    5. Select only these three fields:
      • id
      • product_tmpl_id/id
      • product_template_attribute_value_ids/product_attribute_value_id/id
    6. Export and upload below
    📤

    Click to upload or drag & drop

    Odoo variant export CSV (with id, product_tmpl_id/id, and attribute value IDs)

    Imprint

    Guerilla-IT Logo
    •  +43 650 3450 399
    • contact@guerilla-it.com
    Copyright 2025 © Felix Strobl
    English (US) | Deutsch | Español
    Powered by Odoo - Create a free website

    We use cookies to provide you a better user experience on this website. Cookie Policy

    Only essentials I agree