magento2: IMPORT: additional_attributes are completely ignored in 2.2.3

Preconditions

In a Magento admin login, we should have custom attributes created.

Navigate to Store>products page: Click on new attribute button, and just add the name of the attribute eg: Cust_Att1. Without any other changes, save the attribute.
Navigate to Store>Attribute Set: Click on the default attribute set record, Drag and drop the color attribute and as well the above created Cust_Att1 attribute. Save the attribute set.

Steps to reproduce

Prepare a CSV file with below content to import it further.

sku,price,attribute_set_code,product_type,name,additional_attributes
913352,1,Default,simple,ImprotProd5,"cust_att1=ca_edited,color=Blue"
917252,1,Default,simple,ImprotProd6,cust_att1=ca_edited

Note- This above given file data matches according to the above pre condition example data.

Navigate to Admin login > System> Import page.
Select Entity type- product and import behaviour add/update
Select the checkbox - Fields enclosure.
Choose the above created file, click on check data and followed by import.
Navigate to Catalog>products and search with the SKU text - 913352, and open the product.
Check the product’s custom attribute value whether that is as per imported file content.

Expected result

Additional attributes should be included along with the other product data.

Actual result

Products get created, but misses to store with the additional attribute column data.

Note: We get to see this issue only when the checkbox Fields enclosure filed is checked while importing in the Import page.

About this issue

Original URL
State: open
Created 6 years ago
Reactions: 2
Comments: 40 (2 by maintainers)

Most upvoted comments

Anyone reading this, don’t tick the box “Fields enclosure” - leave that unchecked. In my tests, when checking that box, importing additional_attributes would not work

WinstonN on Nov 4, 2020

2.3.5-p1 imported 15k products, then realized no additional attributes… nice

magenx on May 11, 2020

This is still an issue on version 2.3.5 p1. is there a fix we can do directly on our installation or something??

aampudia on May 11, 2020

I can confirm the same issue occurs on 2.2.9. Is this something that is being addressed?

Thanks.

sergiuionescu on Sep 11, 2019

Still on 2.3.4. Just bumped into the issue today.

ioweb-gr on May 4, 2020

Same problem with version 2.4.3

If the “Field Enclosure” box is checked the import of attributes does not work.

No problem if the option is not checked

Nico2P on May 31, 2022

dont waste your time here just use full import module from
https://docs.met.tdintern.de/pacemaker/1.3/ce_installation.html

install
composer require techdivision/import-cli-simple

magenx on Jun 19, 2021

additional_attributes doesn’t work in magento 2.3.5-p1 but it works if I put all the custom attributes as columns, but not via “additional_attributes” field. Please check and provide some fix.

seak6adtn59v on Jun 2, 2020

still on 2.3.3 I got into this problem yesterday for the first time. So from my side this is a +1

jg-development on Dec 10, 2019

On 2.3 at the moment. If the attribute field is a dropdown or multi-select, the fields need to be manually added into the system before it will be recognised. Insane.

yep. i have hundreds of attributes for my store. tried importing them in sql, which works, but the import process for the csv still ignores them.

From memory, the attributes sit in two different tables, one has the value and an ID, and they other has an ID and some other ID. Does your sql insert take that into consideration?

I can recommend using https://github.com/bigbridge-nl/product-import. It took me a day to get the Magento import working, only to find out it didn’t do anything with the attributes… I converted the CSVs I had to XMLs, and within an hour I had all my data imported. Saves you a lot of hassle of inserting in the right tables…

mlaurense on Dec 5, 2019

FFS… Seriously, one and a half year later and still not working…

mlaurense on Nov 28, 2019

Same on 2.3.2

Pyronerd62 on Oct 9, 2019