How to upload more than 36 values for an additional attribute by a CSV file

[jose_frontan]

Hi,

I am using Magento 2.2.3. I have several additional attributes for each product. I use CSV files for uploading my products. Some of my additional attributes have many values (sometimes more than 100). When I try to upload these attributes Magento is uploading only 36 values. It doesn't matter if I use Magento standard Import or other extension like Firebear. The limit is the same. I would like to know if somebody knows how to change this limit in Magento?

Many thanks in advance for your help

[Sunil Patel]

Hello @jose_frontan 

There is no limit from magento.

But it is limit from php

you need to increase below variable for php

php_value upload_max_filesize 10M
php_value max_input_nesting_level 128
php_value max_input_vars 7000 ( if you are using apache2 then add into htaccess it will work)

Hope it will help you.

if works then mark as a solution.

[jose_frontan]

Hello @Sunil Patel,

thanks for your aswer.

I have following values:

php_value upload_max_filesize 2G
php_value max_input_nesting_level 64
php_value max_input_vars 9999

max_input_nesting_level was changed to 128 but it does not work. Any other idea?

Thanks!

[Sunil Patel]

Hello @jose_frontan 

php_value max_input_vars

is that change? have you varify into by phpinfo ?

[jose_frontan]

Hello @Sunil Patel 

php_value max_input_vars is 9999. I keep this value because it is greater than 7000. I guess is better or I am wrong?

Yes, I´ve checked new values by phpinfo and shows:

max_inputs_vars 9999

max_input_nesting_level 128

upload_max_filesize 2G

Thanks for your answer.

[Sunil Patel]

Hello @jose_frontan 

i mis-understand your issue.

one thing possible  you can create column name as attribute code and pass it

let's example color, size

then column name color and that value

Hope it will help you.

[jose_frontan]

It´s not working.

I´m trying to give more information.

I have an EAV Attributes which 100 different values and several products have around 50 different values of this attribute.

By configuring through .csv file, where I´m including the 50 different values (column additional attributes), the product is created and only contents 36 values for this attribute. So I guess there is some limit for the configuration product when more than 36 values are assigned for this eav attribute.

I will appreciate any help.

Many thanks

[Sunil Patel]

Hello @jose_frontan 

is that value contain special char or something? is you csv is UTF-8 converted?

[jose_frontan · Accepted solution]

Hi,

Finally it is already resolved. I did the developer the tips you gave me and it is done. Many thanks

[Sunil Patel]

Hello @jose_frontan 

which solution help you, please mark that solution as a solution 

so it will help to other peoples.