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:
Please do a backup before anything

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

Hi,

We are not able to understand your question.

Regards,

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


set up

---

shoes product use 2 characteristics that have each 2 values
size -> small big
color -> red , blue
so i have 2*2=4 variants ( sub product ) attach to the main product


question

---

can we define for each variant a specific price
big red 100€
small red 50€
where this value price is store in sql database ! i want sql table name , column name and type name

Hi,

Yes, you can do that.
In the interface, under the "variants" tab of the product, you can edit each variant and enter a price for each.
All the products and variants prices are stored in the table hikashop_price in the column "price_value" which is a decimal.