Can Magento import distinctive features of products through an Excel-file?

[SebastianJ65e2]

Hi!

So nice that there is such a forum in which one can ask questions about Magento (2).

This question is asked by me privately, although it is concerning my job.

Am currently working on a import of 2.000 articles into Magento 2  (our online shop). The articles were all formatted in an Excel-file: this was a lot of work as I had to adapt the information to the company. Amongst others I had to partly manually type in distinctive features of product groups into Excel cells: for instance is there a group of products which is differing in colours and measures. So for every single product of this group I typed in the colours red, blue, yellow etc. and the measures 1m x 3m, 2m x 1m, 1,5m x 2m etc.

Now I do know that those values will appear in "dropdown menues" in our online shop: per product group you will then be able to elige the colour, measures and so forth....

Colour is part of the attribute in Magento "attribute_colour" and measures "attribute_measure" etc. The IT-service that is doing the import of 2.000 articles is telling me that the features like "blue", "yellow", "1m x 3m", 1,5m x 2m" can only be imported into magento if e.g. in the attribute "attribute_colour" - "blue" , "yellow" etc. is typed in manually - else the values will not be imported. This is supposed to be a Magento issue...

I am really really wondering that for a mass import of 2000 articles I have to type into Magento about 4000 features additionally to the ones I already typed into Excel when preparing the import (double work). So in fact that would mean that for the 2000 articles I need to take the about 4000 features and check out all attributes like "colour", "measure" and many more and make sure that the features like "blue", "yellow", "1,5m x 2m" are typed into the appropriate attributes in magento.

Is this a joke? Is it not possible to import all those features directly with an Excel file into Magento? This is literally unbelievable for me and would take me a lot of time and nerves to do it manually!

Would be very nice to get an answer/solution to that.

Thank you in advance.

With kind regards,

Sebastian

[Bhanu Periwal]

Hi @SebastianJ65e2 

A general product import workflow in Magento 2 consists of the following steps:

• In Magento 2 admin, go to “System -> Import.”
• Select “Products” from “Entity Type”
• Select an import behavior option: Add/Update, Replace, or Delete.
• Select your CSV file.

Kindly refer below link for your reference:
https://docs.magento.com/user-guide/system/data-import.html

It may help you!
Problem Solved? Please click on 'Kudos' & Accept as Solution!

[Manish Mittal]

@SebastianJ65e2 

You are talking about product attributes and these are seems configurable products you have. To import using CSV you have to prepare CSV according to Magento 2 format.

To know Magento 2 format you can download sample CSV and then convert your CSV in the same format.

Yes you can import configurable products using csv, dont worry. Just follow below shared articles for more info:

https://docs.magento.com/user-guide/system/data-transfer-configurable-products.html

https://amasty.com/knowledge-base/magento-2-import-configurable-products.html

https://www.mageplaza.com/kb/3-steps-import-configurable-products-magento-2.html

[naheedmire215e]

Yes, you can easily import configurable products using a CSV file.
Keep in mind that while preparing CSV, use Magento 2 format.
Also, open the links shared by the members above, before starting.