importing configurable products in Magento from CSV

importing configurable products in Magento from CSV

July 4, 2026 · Illustrated author avatarBy Stefan Bogdanescu
importing configurable products in Magento from CSV

Importing Configurable Products in Magento from CSV: A Comprehensive Guide

As a senior developer working with e-commerce platforms like Magento, I often encounter challenges faced by fellow developers during the import of products, especially when dealing with configurable items. In this blog post, we will explore the intricacies of importing configurable products in Magento 1.7.0.2 from CSV files and address some common issues you might face.

Understanding Configurable Products in Magento

Before diving into the import process, it’s crucial to understand what makes a product “configurable” in Magento. A configurable product is essentially a combination of simple products that share the same attributes but have different variations, such as size or color. These products are created by grouping one or more simple products together.

The CSV File Structure for Configurable Products

The provided CSV file contains essential information about the simple and configurable products to be imported into Magento. Let’s break down the structure:

    sku,_store,_attribute_set,_type,_category,_root_category,_product_websites,price,special_price,special_from_date,special_to_date,image,media_gallery,news_from_date,news_to_date,url_key,url_path,minimal_price,visibility,custom_design,custom_layout_update,page_layout,options_container,required_options,has_options,image_label,small_image_label,thumbnail_label,created_at,updated_at,enable_googlecheckout,gift_message_available,is_imported,country_of_manufacture,msrp_enabled,msrp_display_actual_price_type,msrp,qty,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,notify_stock_qty,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,_links_related_sku,_links_related_position,_links_crosssell_sku,_links_crosssell_position,_links_upsell_sku,_links_upsell_position,_links_associated_product_sku,_links_associated_product_position,tier_price,lists

As you can see, the CSV file contains columns for both simple and configurable product attributes. The key columns in this context are:

  • SKU: Unique identifier for the product.
  • _type: Specifies whether the product is “simple” or “configurable”.
  • msrp_enabled: Indicates if a Manufacturer’s Suggested Retail Price (MSRP) should be enabled for the configurable product.

Common Issues and Solutions

1. Inconsistent Product Types and Missing SKUs

One of the most frequent errors occurs when Magento encounters invalid or unsupported product types during import, as in your case:

Product Type is invalid or not supported in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

This error typically arises due to:

  • Incorrect product types specified in the CSV file.
  • Missing or invalid SKUs for associated simple products.

To resolve this issue:

  • Ensure that all simple products associated with a configurable item have unique and valid SKUs.
  • Cross-verify your CSV file against the existing Magento catalog to identify any missing or inconsistent product types.

2. Access Denied Error in Magmi

When using tools like Magmi for bulk imports, you might encounter access denied errors:

SQLSTATE[28000] [1045] Access denied for user '<>'@'localhost' (using password: YES)

This error usually stems from incorrect database credentials or insufficient privileges for the user account running Magmi. To troubleshoot this problem:

  • Double-check your Magento database connection details in the Magmi settings.
  • Ensure that the MySQL user has the necessary permissions to execute queries on the Magento database.

3. Incorrect File Path Configuration in Magmi

In some cases, you might encounter file path-related errors when attempting to import using Magmi:

C:wampwwwmagentoarimport/myfile.csv not found

This issue often arises because of a misconfigured file path setting in the Magmi options. The expected file path format should resemble this example:

C:\wamp\www\magento\var\import\myfile.csv

To address this concern effectively:

  • Verify that you have specified the correct import directory within your Magento installation.
  • Check if the file path mentioned in the Magmi settings matches the actual location of your CSV file.

Best Practices for Configurable Product Import

1. Leverage the right tools for the job

While the built-in Magento import functionality works well for small-scale imports, third-party tools like Magmi offer superior flexibility and performance for bulk operations. Make sure to choose a tool that aligns with your specific project requirements.

2. Maintain CSV file consistency

To minimize errors during the import process, ensure that:

  • Your CSV files contain consistent column headers.
  • The data types within each column match their intended Magento attribute formats (e.g., dates in Y-m-d format).
  • There are no leading/trailing spaces or special characters in your CSV data.

3. Validate your input and expect the unexpected

Always verify that your CSV files are error-free before initiating an import operation. Tools like Laravel Company’s Custom CSV Validator can help you catch issues early on in your development cycle.

Conclusion

While importing configurable products into Magento might seem daunting at first, adhering to best practices and leveraging the right tools can significantly streamline this process. By understanding the structure of your CSV files, identifying potential pitfalls, and validating your inputs thoroughly, you can ensure a smooth import experience without compromising your product quality.

Remember, the key lies in meticulous preparation—from data validation to tool selection—and consistent attention to detail throughout the entire import pipeline. With these insights, I hope this guide empowers you to tackle configurable product imports with confidence and efficiency for your Magento projects.

Happy coding!

Magento 1 Checkout Catalog Themes

Our network