Presta 1.7 combination module recomendation

[Alien(PL)]

I'm looking for a module that help us create and manage big amount of combinations.

The issue is that presta is overloaded when it has to generate and process at backend all the combinaiton

Here are the types of attributes we use for each product
Type of finish: 3-4 options
Color: 10-16 options
Direction: 2 options

I'm looking for a module that helps us create and manage a big amount of combinations.

Here are the types of attributes we use for each product
Type of finish: 3-4 options
Color: 10-16 options
Direction: 2 options
Sliding system: 2 options
Width: 6 options
Lock: 5-7 options
Ventts: 3-4 options
Frame: 3-4 options

Presta require php_value memory_limit up to 7400 which is insane

The server that runs It has 1 core 2.5 GHz, 4GB of ram however the provider guarantee 2 GB, ramdisk 256 MB

I will be grateful for any solution for this issue

Sliding system: 2 options
Width: 6 options
Lock: 5-7 options
Ventts: 3-4 options
Frame: 3-4 options

 

Presta require php_value memory_limit up to 7400 which is insane

Server that runs It has 1 core 2.5 Ghz, 4GB of ram however the provider guarantee 2 gb, ramdisk 256 mb

I will be gratefull for any soltuion for this issue

Edited July 6, 2020 by Alien(PL) (see edit history)

[Maria Kvasnytska]

Hi, you can try Store Manager software - https://addons.prestashop.com/en/third-party-data-integrations-crm-erp/2937-store-manager-for-prestashop.html, it has a Combinations Generator tool that allows quick creation of product variations, Mass Combination Changer and Update Wizard if you need to make changes to existing combinations. In addition, there is a possibility of export/import. There are different types of connection to a PrestaShop store, some of them will not overload the server (as there's a possibility working with local db) and the software can handle this amount of products.

[musicmaster]

It is a known weakness of Prestashop that it cannot handle too much attribute combinations. Prestashop stores a weight and price for each possible combination and when you have many thousands of possible combinations (as in your longest list) then the system cannot handle this.

Just a math example with your last list with the lowest values: it will create 2x6x5x3x3 = 540 combinations. That will need 540x5(the number of attributes)=2700 entries in the ps_product_attribute_combination table.

One thing that could help is combining attributes. 

[Alien(PL)]

4 minutes ago, musicmaster said:

One thing that could help is combining attributes. 

Can you elaborate on that?

[musicmaster]

Suppose you have Vents with values A, B and C

And you have Frame with X, Y and Z.

Then you might consider a combined "Vents-and-Frame" attribute with AX, AY,AZ,BX, etc.

That will still deliver 540 combinations. Only now they have 4 attributes so you get less entries in the ps_product_attribute_combination table