Change multi variant to generic child variant?

[websmith]

Joomla 3.6.4 VM 3.0.18.5

I was wondering if there is a way to change products with multi variants to generic child variants on the fly? Or would I have to do this one by one for each product?

[Studio 42]

Hi,
Im not sure at 100%, but it should be possible using Vm be Pro http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm.
You have a feature to remove selected customfield from all selected product and you can add the generic child variant.
The only problem you can have, is that you cannot set the parameters per product when adding the generic child variant.

[K&K media production]

it should be possible with phpmyadmin and a sql update query

something like

Code Select Expand

UPDATE `YOURPREFIX_virtuemart_product_customfields` SET `virtuemart_custom_id`="GENERIC CHILD VARIANT CUSTOM ID",`customfield_value`="NEW VALUE",`customfield_params`="NEW PARAMS" WHERE `virtuemart_custom_id` = "MULTI VARIANT CUSTOM ID";

[Studio 42]

Of course you can do it with mysql queries, as many changes in the DB.