Product customization

[Kirill]

Hi All!

I've some task and I do not see a correct way to resolve it.

We have virtual product, some software bundle which include nine attribute groups.
Simple example with 2 attribute groups:

group1: attr1, attr2, attr3
group2: some_attr1, some_attr2

Not all options are valid. For example, attr2 can't be select with some_attr1
Hope it clear.

Okay, I have nine groups, some of them have more then ten attributes. So, use "Product combinations generator" is not an option. There are will be a huge number of products.

Now the questions to all-knowing "All":

Is there a way to create such product with complex attribute combinations?
May be it will be good feature request if now there are no ways?
If you will have such task, how you will resolve it?

Thank you!

[spott]

PrestaShop doesn't have right now "virtual" attribute support. You only option is generate hundreds products - even when main product it is virtual.
And this feature request can be good.

[Kirill]

I try "Product combinations generator".
Was generated about 40 000 combinations (in truth, we need about 80 000, I just drop some attributes for test).

To display this attributes, prestashop use SQL command:

SELECT pa.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`
       FROM `ps_product_attribute` pa
       LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
       LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
       LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
       LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
       LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
       WHERE pa.`id_product` = 25
       ORDER BY pa.`id_product_attribute`

On my DBMS server ;-) (Debian Etch on Duron 950MHz/512MB RAM) it take 4 hours!

So, generate combinations is not a way out.

I've found feature request about bundles: here
which can help with our problem, because our bundle( I've talk about it here previously and in my first post) have 6 products, and each have attributes.

How soon this feature will be added?

Without this feature, we can't use prestashop.

[Kirill]

anybody here ?

[Madrilene]

up for me too