How to empty variants price through mass action?

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.8

Hi, is there any way to empty the price of my variants. Due to an import error all my products have 0 in the variants pricefield. I need it totally empty so I will see the main price of each product again.
Any suggestion how to do it? Actually I can just change the price but not empty it.
I have the Business Edition of Hikashop
Thanks & regards
Markus

Hi,

This is indeed a missing feature in the mass actions. We can only set a price value but not remove a price.
I add this on our todo list.

For now, you can use this MySQL request to remove the price entries of the variants:

DELETE price FROM #__hikashop_price AS price JOIN #__hikashop_product AS product ON price.price_product_id = product.product_id WHERE product.product_type = 'variant'

Thanks for the quick solution. Would be great to see it implemented soon.

Jooomla 3.5
Hikashop 2.6.3

After updating prices and adding tax with massaction I have som products with variants, and these variants now has the price 0

I need to remove the price 0 in these variants and make them blank.
The other products that have variants with different prices has to stay this way, and not be affected.

Is this possible with Mass action ?

Hi,

You can potentially set a mass action like that: take.ms/8yCDV
That way the action will be applied only on variants with a price higher than 0.

As always, before doing any action please backup your database.

hi
what is the default SQL type and value of price for variant in SQL table ?
regard's

i ll do a test myself and give feedback ! here another way to ask my question


set up