can 4000 product combinations choke prestashop?

[vrob]

I have two products with 4116 combinations. Everything was fine for about a week, then today, I started getting 500 server errors. The prestashop backend works as normal except that when I go to catalog>product>myproduct and click the "combinations" tab, it loads nothing. The other tabs work fine. So I can't go in and even delete the combinations cause the tab doesnt load any info at all.

Is 4000 too many product combinations for PS to work right?

Here's a screenshot: http://easycaptures.com/5555952666

Any ideas? Did I overload PS somehow?

[tmouse]

I think they most probably can. I have created product with over 9000 combinations (door with options) and arrived to same problem.

BUT, with quick hack i just disabled displaying combinations in admin panel (so they're never shown) and it works OK - i am able to modify combinations thru combinations generator. I didnt test this prpperly as i am just evaluating Prestashop.

It looks like it was not designed to handle heavlily configurable products - in case od door you can have numerous colors, finish types, additional modifications, etc which i think could add up to more than 50.000 different products.

so even with this hack, database will probably get swamped and non-performant. This I will test next (creating like 1000 products with 10.000 combinations each).

[Gekko]

I just made a product with 5280 possible combinations and I have similar problem. OR actually the front end works, but in the backend I get no list of attributes so that I can choose the default one :-(

All it says in backend after using the generator is:

"No combination yet."

Buu hoo :-(

Maybe I can dive into the database and set default combination instead?

[rocky]

I had a quick look at the database and it looks like it is the default_on column in ps_product_attribute that chooses the default attribute. You could perform the following query to get all the attributes for a particular product:

SELECT `id_product_attribute`, `id_product`, `default_on` FROM `ps_product_attribute` WHERE `id_product` = 1

Change the 1 at the end to the id of the product for which you want to change the default attribute. You can then find the attribute with default_on value 1 and change it to 0, then find the attribute you want to be default and change its default_on value to 1. It isn't easy, but it should work.