How to make an existing product child of another

[lindapowers]

Hi

This is the situation, I have several normal products created which now I would like to make as childs of a parent product.

Is there any option for this? Cause I can't find it.

Regards

VM 2.6.10

[lindapowers]

Ill ask the same question for vm3.

I cant believe no on asked this before. Is not very nice having to loose customer reviews and data for a product having to create it again just to be assigned as child.

Any nasty way to do this?

[balai]

I assume that you can do it directly in your database.
In the table 'virtuemart_products' there is a field named 'product_parent_id'
Just set the id of the parent product in that field.

Do note: I did not tested that, so please test

[lindapowers]

I assume that you can do it directly in your database.
In the table 'virtuemart_products' there is a field named 'product_parent_id'
Just set the id of the parent product in that field.

Do note: I did not tested that, so please test

Thanks! Ill test and see

[Milbo]

yes taht is the way to go. Yeh the idea to add it is of course there, but you can do it rough and it works maybe for 100 products, or you do it correctly and it takes 10 times the amount of time.

[lindapowers]

Thanks that worked for me,

Regards