How to import configurable products and associate simple products by csv

How to import configurable products and associate simple products by csv

September 27, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to import configurable products and associate simple products by csv

Importing Configurable Products and Associating Simple Products via CSV

If you’re facing challenges while importing configurable products and associating their simple children using CSV files in Magento, you’ve come to the right place. In this post, I’ll guide you through a step-by-step process that ensures both parent and child products are imported correctly.

Prerequisites

Before proceeding, make sure your Magento instance is up-to-date and running on version 2.4 or later for optimal performance and security. Additionally, ensure that the necessary extensions (like Advanced Pricing or Inventory Management) are installed if you plan to work with complex product configurations.

Step-by-Step Guide

Step 1: Prepare Your CSV File

Create a new CSV file named configurable_products.csv in your Magento root directory. The columns should include:

  • sku
  • attribute_set_code
  • product_type_id
  • name
  • description
  • short_description
  • price
  • tax_class_id
  • visibility
  • status
  • weight
  • category_ids (separated by commas)
  • image (path to the product image)

For simple products, create a separate CSV file called simple_products.csv:

  • sku
  • attribute_set_code
  • product_type_id
  • name
  • description
  • short_description
  • price
  • tax_class_id
  • visibility
  • status
  • weight
  • category_ids (separated by commas)
  • image (path to the product image)

Step 2: Import Configurable Products

Navigate to your Magento admin panel > Catalog > Import/Export > Import. Click on ‘Choose File’ and select your configurable_products.csv. Choose “Products” as the Entity Type and click ‘Continue’. Follow the on-screen instructions, ensuring you map the appropriate columns.

Step 3: Prepare Super Attribute CSV

Create a new file called super_attributes.csv for configuration options:

  • attribute_code
  • product_sku
  • option_label

Populate this with your configurable product’s option data. For example:

color
P01
Red

Step 4: Import Super Attributes

In the same import/export section, choose “Super Attribute” as the Entity Type and upload your super_attributes.csv. Map the columns correctly during the import process.

Step 5: Prepare Simple Products CSV

For each configuration option (like color or size), create a separate CSV file with simple product data. The main difference is that you’ll include the configurable product’s SKU in the parent_sku column for each of these files:

  • sku
  • attribute_set_code
  • product_type_id
  • name
  • …
  • parent_sku

Step 6: Import Simple Products

Import each simple product CSV file using the same process as before, ensuring you map the parent_sku column to the correct field in your Magento installation.

Best Practices

  1. Always backup your database and files before performing mass imports.
  2. Use SKUs that are unique across all products for easy identification during import.
  3. Check your configuration settings to ensure tax rates and product visibility match your requirements.
  4. If your catalog is large, consider breaking the process into smaller chunks or using Magento’s data migration tool for smoother performance.

Conclusion

Importing configurable products with associated simple products in Magento requires careful preparation of CSV files and proper mapping during each import step. By following this guide, you’ll have a solid foundation for managing complex product configurations in your e-commerce store.

Remember to test the process in a staging environment first before applying it to your live site. For more detailed information on Magento’s import/export capabilities, visit https://documentation.magento.com/2.4/user_guide/system/data-export.html.

Catalog Performance Security Extensions

Our network