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?
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.
it should be possible with phpmyadmin and a sql update query
something like
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";
Of course you can do it with mysql queries, as many changes in the DB.