The built-in import feature in Magento can often be frustrating due to its complexity and less than forgiving nature. In Magento 1, many extensions were created to aid in importing products quickly and easily. With the recent release of Magento 2, there are not many extensions to help with importing products. Documentation is also sparse when it comes to various methods of importing products. Importing simple type products in Magento 2 isn’t that difficult. You can export a simple product under: System -> Export and then look at the format. For configurable products (products that have ordering options like size, color, etc… where a number of simple products are attached to a main configurable product), the import process is much more complicated. You can export a configurable product with its associated simple products, but it may not be obvious what is required to have a successful import. Here are the steps needed to successfully import configurable products (with associated simple products) into Magento 2: Prerequisites Before you perform an import, the following items should be completed beforehand: Product attributes should already be created and defined properly. (Stores -> Attributes -> Products) The product attributes you plan to import should be assigned to an attribute set. (Stores -> Attributes -> Attribute…
Anyone that has worked on the backend of Magento 1 importing products knows that Magento 2 has rewritten the book on how you import in custom product attributes in the Product CSV file. Where Magento 1 used to allow a columnar approach where you could do 1 column for each piece of information (see below)
|Custom Product Attribute 1
|| Custom Product Attribute 2
||Custom Product Attribute 3
|Attribute 1 Value 1||Attribute 2 Value1||Attribute 3 Value1|
|Attribute 1 Value 2||Attribute 2 Value2||Attribute 3 Value2|
Magento 2 does not allow that individual column (per attribute) approach, but rather a single area called “additional_attributes” that is used for all your custom Magento 2 product attributes.
Now, if you have a web developer on staff this won’t be any issue because developers can write code to bring together your old format with the new format. However, if you are an owner operator or don’t have a web developer available it may be difficult or time consuming for you to match the new format of the Additional Attributes field.
I have created a template that does all the heavy lifting for you and all you have to do is update the Google Sheet with your own store’s information information.
If you want to view the file on Google Drive and make your own copy you can visit > Magento 2 Template for Additional Attributes – THEDIGITALPM.com
To make your own copy of my sheet go to File and click Make A Copy. You will need your own Google account to do this.
When you are done with that additional attributes field copy the row and PASTE SPECIAL into your Magento Product Import CSV. Sample Product CSV here.
Here is the file so you can see what it will look like once a few lines are filled out.
If you appreciate this (and other The Digital PM content) and would like to donate to show your appreciation, please click the Donate Button. Cheers!