News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Change multi variant to generic child variant?

Started by websmith, January 03, 2017, 16:16:50 PM

Previous topic - Next topic

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

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.