combinations too many?

[butlerov]

Hi.Some of my products have 19pic + 6pic + 8pic +14pic + 8pic atributes. presta combination generator cant hadle that, on product page is seems normal but in BO i cant edit anymore in that product, its just dont load.How handel this?Increase more timeout or some module can do this?save buttons spinning and combination tab dont load.Thanks. ps v.1.6.1.2 

Edited February 16, 2017 by butlerov (see edit history)

[musicmaster]

That is some 100,000 combinations. And each of them gets several entries in the database. It takes a lot of time and memory to load that. 

 

Are you sure your frontend really works? Or is javascript crashing and do you get a html only experience?

 

Prestashop just isn't the best system for so many combinations. It gives you the possibility to assign each combination its own price, weight, etc and that takes a lot of space in the database. There is one module that can handle this - by using a different method of storing. If I remember well it from Prest-changeo. You should ask them. 

 

The big question is what you want to do with those data. In some cases it might be better to build something customized.

[butlerov]

That is some 100,000 combinations. And each of them gets several entries in the database. It takes a lot of time and memory to load that. 

 

Are you sure your frontend really works? Or is javascript crashing and do you get a html only experience?

 

Prestashop just isn't the best system for so many combinations. It gives you the possibility to assign each combination its own price, weight, etc and that takes a lot of space in the database. There is one module that can handle this - by using a different method of storing. If I remember well it from Prest-changeo. You should ask them. 

 

The big question is what you want to do with those data. In some cases it might be better to build something customized.

 

looks work to me http://www.caprigoshop.ru/jardin/765-tumba-jardin-120-so-stoleshnicej-10420.html but slow in first artubytes will be +5 and in third +6 but combination in bo wont load, now its "only" 12936 combinations isnt it?

 

You mean Atributes wizard pro? and than you for answer

Edited February 16, 2017 by butlerov (see edit history)

[YopixelAE]

Hello,

I agree with musicmaster, Prestashop has probably not adopted the best system to handle many combinations.
If you want to skip the 500 error in back-office , either you :
- Process combinations in localhost (with no limit for max_execution_time)
- Or create combinations via ajax and send it (chunked) to the server DB

By the way, when refreshing the BO page, all combinations will not be displayed entirely.
Above all, your front-office will always be slow when you start to reach 500 combinations (because all combinations are fletched when page loads).

 

Solution is to use a module, like AWP or my module Product Configurator, or try to reduce the number of your attributes by creating products which yet include attributes and let customer switch between these products.
 

[butlerov]

Hello,

I agree with musicmaster, Prestashop has probably not adopted the best system to handle many combinations.

If you want to skip the 500 error in back-office , either you :

- Process combinations in localhost (with no limit for max_execution_time)

- Or create combinations via ajax and send it (chunked) to the server DB

By the way, when refreshing the BO page, all combinations will not be displayed entirely.

Above all, your front-office will always be slow when you start to reach 500 combinations (because all combinations are fletched when page loads).

 

Solution is to use a module, like AWP or my module Product Configurator, or try to reduce the number of your attributes by creating products which yet include attributes and let customer switch between these products.

 

Thank you for solutions.But what system can handle so much combinations?I dont know any, atleast among the free cms

[YopixelAE]

 

Thank you for solutions.But what system can handle so much combinations?I dont know any, atleast among the free cms

 

Magento is still ahead on this point. You should try 2-3 other solutions.

[musicmaster]

I am working for Prestools on a system that should make it easier to handle editing of such large numbers of combinations.Should be ready within a few days.

[butlerov]

I am working for Prestools on a system that should make it easier to handle editing of such large numbers of combinations.Should be ready within a few days.

Thanks will try your refreshed script since i got a sql drop after clicking edit that specific product. dont have much choice

PDO::query(): MySQL server has gone away in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
] PHP Warning:  PDO::query(): Error reading result set's header in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): MySQL server has gone away in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): Error reading result set's header in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): MySQL server has gone away in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): Error reading result set's header in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): MySQL server has gone away in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
PHP Warning:  PDO::query(): Error reading result set's header in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  Error while sending QUERY packet. PID=10629 in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): MySQL server has gone away in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132
PHP Warning:  PDO::query(): Error reading result set's header in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132
 PHP Warning:  PDO::query(): MySQL server has gone away in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  PDO::query(): Error reading result set's header in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  Error while sending QUERY packet. PID=10627 in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, referer: http://www.caprigoshop.ru/admin76310nx85y/index.php?controller=AdminProducts&id_category=19&id_product=765&updateproduct&token=a0035c880729eac83edd483fa8b039de
 PHP Warning:  Error while sending QUERY packet. PID=10632 in /var/www/domains/caprigoshop.ru/classes/db/DbPDO.php on line 132, re

Edited February 17, 2017 by butlerov (see edit history)

[musicmaster]

Please try the newly uploaded Prestools 1.16i version

Edited February 20, 2017 by musicmaster (see edit history)

[motonet]

Hi. I have a problem with combinations in the front office.

We are developing a new web site, and we are testing. Each of our procuts have a set of 6 + 6 + 2 combinations possibilities and 7 or 8 different colors

For example. Product---> select list (6 options) + select list (6 options) + select list (2 options) + 7 colors. 16 images per product 2 languages

We are running ver PS 1.6.1.13

VPS
Intel(R) Xeon(R) CPU E5-1650 v3 @ 3.50GHz (2 core(s)

Plesk Onyx v17.5.3_build1705170317.16 os_CentOS 7

SOCentOS Linux 7.4.1708 (Core)

RAM 3GB

The Front office goes extremely slow when we try to see one of the prodcuts.. extremely

https://www.screencast.com/t/5zW3dMTM

Is there a solution for this problem. It is impossible to sell something in this way!

. On the other side. We are testing musicmaster´s Prestools and it is fabulous, if we finally can use PS to our project, we surely are going to buy the full version. In example, to add images and legends and stock... and so on to combinatios is faster, much more faster than in BO. I think is a great tool for mass editing

 

Thanks
Saludos

 

Edited October 22, 2018 by motonet
more detail (see edit history)

[musicmaster]

You should check your page size in the front office to make sure that the problem is really the combinations. 

One solution is to take one of the attributes and turn it into a customization. It should be an attribute that doesn't influence the price, doesn't change the picture and isn't relevant for your stock. It involves a bit of work on the template but not that much.

[Manuel Vidal]

I am facing this very old design problem.

I have tried to manage 2.000 combinations for a single product (contact lens) and it is not possible. The limit is around 1.200 combinations (VPS with 2GBs RAM for Apache and 2 cores).

Prestashop generates one GET method call per each 50 combinations and it takes almost one second to generate every GET.

I do not understand the reason why the B.O. needs to read and show all combinations when you recover the product. It would be more reasonable to show only every 50 combinations.

Do you know any new solution to this old design problem?