How To Import Configurable Products To Magento 2

It is not a problem to import a single product to Magento 2, since you have all the necessary tools under System -> Export. But if you need to move Magento 2 configurable product data from the old site, it may take a lot of time and effort, since in this situation the import procedure is much more sophisticated. However, it is still possible to import a configurable product with its simple products to Magento 2, and below we shed light on what is necessary for a successful import. Note that the following article only briefly describes the process. For further information on how to import configurable products to Magento 2, read this guide: The Complete Guide to Magento 2 Configurable Products.

Magento 2 Configurable Product Import

Import Prerequisites

Before performing an import, you should pass the following preparations:

1. Create and define product attributes under Stores -> Attributes -> Products and assign them to an attribute set under Stores -> Attributes -> Attribute Set. Alternatively, you can use our Improved Import Export extension that allows creating new products attributes and values on the fly during the import process (if an attribute or a value doesn’t exist in the Magento 2 data base, it is created during the product import process).
2. Set up categories to import the configurable product to (Products -> Categories).
3. Note that neither simple nor configurable products should exist in the catalog before the importing procedure.

Import File

Next, it is necessary to prepare an import file. Unfortunately, Magento 2 supports CSV files only, but you can freely use Excel and XML files with our Magento 2 extension to import configurable products to your store.

As for the default requirements, a CSV file should use a comma as a separator for both fields and multiple values. Although the backend import interface allows you to change this parameter, it is not recommended to choose another separator, since it may cause issues.  As for other CSV file requirements, they are:

1. List simple products only before the configurable product.
2. The “attribute_set_code” field should match the Attribute Set (if you are not familiar with this parameter, it contains each product attribute).
3. In the “configurable_variations” field, create a pipe-separated set of sku/option combinations for each simple product. The field should be populated only for the configurable product. For the configurable T-shirt product: “sku=shirt-white,color=White|sku=shirt-black,color=Black”.
4. The “configurable_variation_labels” field is designed for correlating the Attribute code to the Label Name. The field should be populated only for the configurable product. For the configurable T-shirt product: “color=Color”.
5. As for the “additional_attributes” field, use it to list options for each simple product. Use comma separator for more than one attribute per simple product). For the White T-shirt: “color=White”; for the Black T-shirt: “color=Black”.

You can discover a CSV sample file with Magento 2 configurable product data here: Magento 2 Import/Export CSV/XML Samples.

Import Profile

Now that you know how to create an import file for a configurable product, go to System -> Import and click “Check Data”. The following procedure will validate the import file. If it has bad header options or an unsupported format, the procedure may go down.

If everything is OK, click the “Import” button. Once the import of your configurable product is complete, check whether everything was imported correctly: all associated simple products are available.

If there are no associated simple products, your import file likely had an unsupported format, so you should configure it more carefully. Alternatively, you can use the Improved Import Export Magento 2 extension by Firebear, since it supports mapping. Map all custom attributes to system ones and run import successfully.

For further information about the import process, follow this link: Magento 2 configurable product guide.

Store-View Specific Import

While talking about configurable product import, we should also draw your attention to how to import different product content for each store view.

In the case of the first Magento version, you can easily import different content for each store view simultaneously by placing each store data in a new line with an empty sku field. This approach doesn’t work for Magento 2.

In case of translations, you can import them separately, adding store_view_code with the appropriate value:

But you also deleted the default name from the database. Luckily, there is another solution.

Import all store views together in one import, the default one should be included as well. Note that SKU must be set for each store view:

You will update the existing products with different product content for each store view. It doesn’t work as an initial import. Add required attributes for an initial insert. For further information, follow this link: How to import product content differently for each store view (translations/multilingual)?

If you want to simplify import processes, check our extension as well:

Get Firebear Improved Import Export Magento 2 Extension

And if you need to get advanced functionality for configurable products (dynamic frontend updates, default options, matrix grid, etc), follow this link:

Get Firebear Improved Configurable Product Magento 2 Extension

Magento 2 Configurable Product Import & Export FAQ

Let’s take a look at іseveral other nuances of importing and exporting configurable products in Magento 2 which are also covered in The Complete Guide to Magento 2 Configurable Products.

Final Words

Magento 2 configurable product import is a user-friendly procedure if you rely on third-party tools, such as the Improved Import & Export extension. With the help of our module, you can freely transfer configurable proiducts to your e-commerce website to different store views via various file formats and sources. It is even possible to import third-party data, replacing unsupported attributes with the ones used in Magento. Follow the link abelow and contact our support to get more information on the Magento 2 import of configurable products:

Get Firebear Improved Import Export Magento 2 Extension