Magento 2 Import Products With additional attributes

Download open office
save the file editing the filter settings

Make sure to select UTF8

Next put in a BAR “|” as the separator in the attributes section.

Then when importing you need to change the separator to the BAR “|”

That should work! The next issues you will have is if there are attributes on the spread sheet that are not in admin it will error then look up those line numbers and add the missing attributes to admin.

I hope that helps someone!

Leave a Reply

Your email address will not be published. Required fields are marked *