I was able to export the custom filterable product attributes into individual columns in CSV file using BSSCommerce export extension. Now I have a large amount of data need to update.I have searched around the forum and found different answers. I would like to confirm the definite answer if Magento 2 (i'm using 2.2.6) default import allow us to import custom product attributes through csv with individual columns(using custom attribute names), or everything need to go under "additional_attributes" column?
For example: Can I import it like below:
SKU | custom-attr1 | custom-attr2 | custom-attr3
shirt | blue | xl | men
or does it has to be like:
SKU | additional_attributes
shirt | custom-attr1=blue,custom-attr2=xl,custom-attr3=men
some related questions i found, but can't find the definitely answer for import.
custom attributes in separate coloumn while export? – Magento 2.0.8
Best Answer
You can use Magento default Import Export available at (System > Data Transfer > Import/Export).
Yes you need to specify all inside "additional_attributes" like "gift_wrapping_available=Use config,must_ship_freight=0,narendra=i am test entry on 24 march,narendra_attribute_2=Test1,ship_separately=0".
You can also import using individual column also like add a new column in exported CSV "narendra":"testing" and it should reflect in corresponding attribute value. But in this case you can delete that attribute from additional_attributes
For better understanding you can export CSV containing all products from (System > Data Transfer > Export) section and perform import using same CSV from (System > Data Transfer > Import) on selecting appropriate option in "Import Behaviour".
Let me know if you face any issue in this.
Thanks.