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:
-
Create a New Import/Export Profile
Go to System > Dataflow > Manage Profiles and click on “Add new profile”.
-
Set the Export Method
Choose “CSV” as the export method for your profile.
-
Select the Entities
Select “Catalog Product” as the entity you want to export.
-
Configure the Column Mapping
Under the “Column Mapping” section, click on “Add column mapping”.
-
Add the Required Columns
For the first mapping:
- Column name:
associated - Source entity attribute code:
sku(if using SKUs) orentity_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
- Column name:
-
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.