Magento EXPORT configurable products

Magento EXPORT configurable products

August 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento EXPORT configurable products

Exporting Configurable Products in Magento: A Step-by-Step Guide

Configurable products are a powerful feature in Magento that allows you to offer multiple variations of a single product. However, when it comes to exporting configurable products for bulk updates or integration with other systems, the process can be complex and confusing.

Understanding the Requirements

To export configurable products from Magento, you need to include two additional columns in your CSV file: associated and configurable_attributes. These columns contain critical information about the product variations that must be preserved during the import process.

The associated column stores the SKUs or IDs of the simple products linked to the configurable product. The configurable_attributes column is a JSON-encoded string that defines the attributes for each variation.

Creating and Populating the Columns

Unfortunately, Magento does not automatically include these columns in standard exports, even for configurable products. This means you cannot simply select “All” or “Products” when creating an export profile.

To create and populate these columns, you’ll need to use the Advanced Dataflow profiles feature in Magento. Here’s a step-by-step guide:

  1. Create a New Import/Export Profile

    Go to System > Dataflow > Manage Profiles and click on “Add new profile”.

  2. Set the Export Method

    Choose “CSV” as the export method for your profile.

  3. Select the Entities

    Select “Catalog Product” as the entity you want to export.

  4. Configure the Column Mapping

    Under the “Column Mapping” section, click on “Add column mapping”.

  5. Add the Required Columns

    For the first mapping:

    • Column name: associated
    • Source entity attribute code: sku (if using SKUs) or entity_id (if using IDs)

    For each configurable attribute:

    • Click on “Add column mapping” again
    • Column name: Use the format "attribute_code" for each variation’s attribute, e.g., "color"
    • Source entity attribute code: The actual attribute code of your configuration
  6. Save and Export

    Once you’ve added all required columns, save the profile. Then click on “Export” to download the CSV file.

Populating the JSON-encoded String

The configurable_attributes column requires a specific format. It must be a JSON-encoded string containing an array of objects, where each object represents a variation and its attributes.

Here’s how you can populate this column for a simple configurable product with two attributes (color and size):

[
  {
    "attribute_id": 14,
    "label": "Color",
    "value_index": 9
  },
  {
    "attribute_id": 15,
    "label": "Size",
    "value_index": 36
  }
]

In this example, attribute_id is the ID of the attribute in your Magento store. You can find these IDs by looking at each attribute’s settings.

Conclusion

Exporting configurable products from Magento requires a bit more manual configuration than standard product exports. By following the steps outlined above and understanding how to populate the required columns, you should be able to successfully export and import your configurable products.

Remember, if you’re working with large datasets or facing complex integration challenges, consider reaching out to professional Magento development services like Laravel Company for expert guidance and custom solutions.

Catalog Configuration Import/Export JavaScript

Our network