Unable to Add Products Manually in Configurable Product

[apiuser]

Feature request from rkhoury82, posted on GitHub Mar 31, 2016

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 #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/81f78988e9908f8d89115a62f01eacdd8611886ce257a56bd...

[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/81f78988e9908f8d89115a62f01eacdd8611886ce257a56bd...

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

[apiuser]

Comment from joebusby, posted on GitHub Apr 01, 2016

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.

[apiuser]

Comment from rkhoury82, posted on GitHub Apr 11, 2016

Any short term work arounds?

[apiuser]

Comment from joebusby, posted on GitHub Apr 12, 2016

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

[apiuser]

Comment from rkhoury82, posted on GitHub Apr 13, 2016

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

[apiuser]

Comment from joebusby, posted on GitHub Apr 13, 2016

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

[apiuser]

Comment from joebusby, posted on GitHub Apr 13, 2016

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

[apiuser]

Comment from rkhoury82, posted on GitHub May 30, 2016

Is this something that will get fixed in 2.1 release?

[apiuser]

Comment from piotrekkaminski, posted on GitHub Jun 09, 2016

@choukalos performance use case

[apiuser]

Comment from piotrekkaminski, posted on GitHub Jun 09, 2016

@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?

[apiuser]

Comment from rkhoury82, posted on GitHub Jun 10, 2016

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