Unable to Add Products Manually in Configurable Product

[rudik99]

Steps to reproduce

1. Install Magento 2.0.3
2. Migrate or create a Configurable Product with 300 variations, save.
3. Go back into that product, press the "add products manually"

Expected result

1. With products with smaller variation sets the functionality works
2. I have increased the LimitRequestLine to work around 414 (Request-URI Too Large) error (per issue 414 (Request-URI Too Large) when using "add products manually" #3495)
3. I have not been able determine the size limit yet.

Actual result

1. Error Message Pops: Attention Something went wrong.
2. No browser messages in console.
3. Error in Apache Logs:

[Thu Mar 31 18:34:14.139835 2016] [proxy_fcgi:warn] [pid 4968] [client 60.225.85.XXX:37893] AH02536: couldn't encode envvar 'QUERY_STRING' in 16384 bytes, referer: http://EXAMPLE/admin/catalog/product/edit/id/3/key/81f78988e9908f8d89115a62f01eacdd8611886ce257a56bd9ec6c22d83930e6/

[Thu Mar 31 18:34:14.139840 2016] [proxy_fcgi:warn] [pid 4968] [client 60.225.85.XXX:37893] AH02536: couldn't encode envvar 'REQUEST_URI' in 16384 bytes, referer: http://EXAMPLE/admin/catalog/product/edit/id/3/key/81f78988e9908f8d89115a62f01eacdd8611886ce257a56bd9ec6c22d83930e6/

Environment

1. PHP 7.0.4 run as FPM not MOD_PHP (unable to test with 7.0.2 or 7.0.3 to see if it is a PHP error)
2. Apache 2.4.18
3. MYSQL 5.6

[joebusby]

I have not been able to add products manually when there are many configured products since since the first version. It's mentioned in thread #3228 and it might relate to this problem.

[rudik99]

Any short term work arounds?

[joebusby]

With the right php settings, I have been able to add up to about 400 configured products (for one configurable product) going through the "Edit Configurations" process as long as I don't add any images to the products. You then need to put the images in manually, one by one. If you add images during the "Edit Configurations" process, I can only get about 125 products in or it bombs. The "Add products manually" feature has been useless for me, but I have managed to get about 2100 products in using the above method with a lot of "clicks" to add the images. You will get good at using filters.

Related to #3154

[rudik99]

@joebusby be great if you could share your PHP tweaks ?

[joebusby]

I have:

max_input_vars -> 5000
max_execution_time = 600
memory_limit = 2048M

but I think the max_input_vars is the most important
You can try:

error_reporting = off

All in php.ini

I am using this on

Debian 8 up to date
MySQL version 5.6.28
OpenVZ 6 cores
PHP 5.6.17-0+deb8u1

so it may not be the same as your php 7.0.4

[joebusby]

I have been having better luck with chrome than firefox on windows 10 for adding many configurable products

With chrome you may be able to avoid hitting the "wait" dialog by using:

"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --disable-hang-monitor

in the windows shortcut properties

[rudik99]

Is this something that will get fixed in 2.1 release?

[piotrekkaminski]

@choukalos performance use case

[piotrekkaminski]

@rkhoury82 can you provide more info on your specific use case? what type of products? what is the maximum number of products you would like to use etc?

[rudik99]

For example, I run multiple apparel store's (swimwear)
We offer all products in all colours and sizes (some might be stocked and some are made to order)

So configurable product:

10-15 Sizes (from Attributes)
20-30 Colours (from Attributes)

So 300-400 combinations (Simple Product), need the simple product to manage stock / inventory

[PieterCappelle]

Same problem still exists in 2.1. In my case problem was fixed updating max_input_vars to 5000 in PHP7.