Skip to main content
Magento 2
Magento 2 Product Import Template – Additional Attributes Column Hack

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 1Attribute 2 Value1Attribute 3 Value1
Attribute 1 Value 2Attribute 2 Value2Attribute 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 an 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.

View The Google Drive Sheet Document Here

To make your copy of my sheet go to File and click Make A Copy.  You will need your own Google account to do this.

MAGENTO 2 PRODUCT IMPORT TEMPLATE – ADDITIONAL ATTRIBUTES COLUMN HACK - Make a copy

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.

MAGENTO 2 PRODUCT IMPORT TEMPLATE – ADDITIONAL ATTRIBUTES COLUMN HACK - Paste Special
By Michael Cristancho

I'm a Digital Commerce and Experience evangelist who enjoys engaging in thought-provoking conversation and mutual exploration. I am a strong believer that learning never ends, and each day brings another opportunity to grow as an individual and professional.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

3 Comments

  • Amazing post !! that is really helpful content. For more helpful content see webetutorial dot com

    Reply

  • Sorry but this is NOT a good solution and as a developer, no, it's not "easy". When you make a task in 1 second and then you have to make 10 additional steps and consume 1 minute per custom attribute because some genius at Magento development team thought that merging a variable amount of attribute columns in just one was a good idea, it's not "easy". It's a waste of additional time that you didn't have to do with earlier versions of Magento. What you're proposing is not easier than opening the data file in Excel and splitting the additional attributes column in several columns using "," as a separator, doing what you have to do with all those attributes and merging them again before uploading the CSV to Magento import. This was a stupid and useless idea. If something was working as it was, why do they have to change it for worse? Magento 2 is very disappointing even for developers because it's a lot more time consuming.

    Reply

    • Sorry you feel that way. This was designed for non technical folks. I agree that developers are better served loading it up and concatenating else where. M2s upload it much different than M1.

      Reply

[class^="wpforms-"]
[class^="wpforms-"]