Product custom attribute import with CSV Magento 2.2
- Upload from the default
CSV
generated by Magento
Yes you need to fill all your custom attributes into the single column named additional_attributes_code
.
Just simply put all your custom attribute in following way into the column with name additional_attributes_code
into your imported CSV
file.
custom_attribute_code_1="Value_1",custom_attribute_code_2="Value_2",custom_attribute_code_3="Value_3",custom_attribute_code_4="Value_4"
After this simply upload your CSV
file.
- Upload with some changes into the
CSV
generated from the Magento
You also can create different columns with the attribute_code
of your custom attributes & fill the data into it & upload the file. It will works with it as well.
Note: First upload a single product manually & download the csv file from your admin & do corrections into it only & use only that file for uploading/Updating the products.
I will recommend the First one because as of you will have more no. of attributes & more no of attribute sets you need to insert more no of columns into your CSV file so better would be upload it into a single column it will reduce your time for this data entry stuff as of you are using CSV upload for that intention only.
Hope This will help!
Thank You!
I have made one more test case and tried to upload with the name of attribute in csv. Instead of "additional_attributes" I have directly added name of a column and tried to upload value of a custom attribute and it worked.
So both ways are working. we can specify under "additional_attributes" as well as we can directly give attribute name to upload value of custom attributes.