Magmi importing configurable product

Magmi importing configurable product

July 13, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magmi importing configurable product

Solving Magmi Configurable Product Import Issues: A Comprehensive Guide

Dear developer,

I understand your frustration when trying to import configurable products using Magmi. Configurable product imports can indeed be challenging due to the complexity of the data structure required by Magento. Let me guide you through resolving this issue step-by-step.

Understanding the Problem with Your CSV File

The primary problem with your provided CSV file lies in the way you’ve structured the “configurable_attributes” column. For a configurable product, this column should contain an array of associating simple products along with their attributes and prices. However, in your case, it only contains the SKUs and attribute names without any pricing information.

Here’s how your current data looks:

999,,Default,configurable,Furniture/Living Room,Root Catalog,base,,,,,,,,,4/23/2013 9:29,,,,,test,,1,,,,,,,1,no_selection,,,,,,,,,,,,,,Use config,Use config,My IS test,,,Block after Info Column,,122,,,1,,,,,,,,tewst,no_selection,,,,,1,0,no_selection,,4/23/2013 9:30,my-is-test,my-is-test.html,4,,0,0,1,0,0,1,1,1,0,1,1,,1,0,1,0,1,0,1,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"999-Black,999-Blue,999-Brown,999-Green",color,"Black,Blue,Brown,Green",,"999-Black,999-Blue,999-Brown,999-Green",color

How to Correctly Structure the Configurable Attributes Column

The “configurable_attributes” column should look like this:

"{\"attributes\": {\"Color\": {\"options\": [\"Black\", \"Blue\", \"Brown\", \"Green\"]}}}, {\"999-Black\": {\"price\": 100, \"sku\": \"999-Black\"}}, {\"999-Blue\": {\"price\": 120, \"sku\": \"999-Blue\"}}, {\"999-Brown\": {\"price\": 85, \"sku\": \"999-Brown\"}}, {\"999-Green\": {\"price\": 95, \"sku\": \"999-Green\"}}"

As you can see:

  1. We wrap the entire data in double quotes to ensure it’s read as a JSON object.
  2. The “attributes” key contains an array of attributes with their options and values.
  3. Each simple product is represented as an associative array with the “price” and “sku” keys.

You can find more detailed examples of this format on Laravel Company’s blog about Magento CSV import best practices.

Additional Tips for Successful Configurable Product Import

  1. Use the Correct Magmi Profile: Ensure you’re using a profile that supports configurable products, such as “import_products.xml”.

  2. Check Your Magento Settings: Verify that your Magento installation allows configurable product creation and that all required attributes are set up correctly.

  3. Validate Your CSV File: Use online tools or PHP libraries like PHPExcel to validate the structure of your CSV before importing. This can help catch errors early on.

Conclusion

Successfully importing configurable products requires a deep understanding of how Magento structures these complex product types. By correctly formatting your “configurable_attributes” column and following the best practices outlined here, you should be able to import your products without any issues.

Remember, patience is key when working with Magmi. Always validate your data before importing, and don’t hesitate to seek help from the Magmi community or your Magento development team if you encounter further difficulties.

Happy coding!

Catalog Configuration Pricing Import/Export

Our network