Mass Action Not Working for price increase

-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.3.0
-- PHP version -- : 5.4.35

I want to create a mass action that increases all prices on the site by 6%
Following topic on forum:
-I set data to "product"
-I don't apply a trigger as I only want it to happen when admin says "process".
-I don't apply a filter as I want it to happen on all products.
-I set the action to "update the values" with "product_price_percentage" = "int" "106"

Nothing happens
Must be doing something stupid, help please

Hi,

You should set the action to "update the values" with "price_value" = "operation" "price.price_value*1.06"

Have set this up on 2 sites now. Its working fine on one site and updates the product prices and the characteristic varients price.
On the other site it is only updating the product price and not the varients.
Any suggestions

Hi,

Don't you have set a filter to restrict the mass action on main product only ?
Does your variants have a price set or it on 0 ? If they don't have price already set, the mass action can't work as it's a multiplication.

No filter set.
Some variants have prices, some do not.
I believe that if there is no price set, they take the main product price.

This is working fine on one site, but on another the variant price is not changing where there is one.

Hi,

Yes, if the variants have no price it take the main product price.
Please post a screenshot of your mass action settings.

Here is screenshot

Hi,

This mass action should affect all the products and the variants having a price different of 0.
How many products and variants do you have in your shop ?

If the total is bigger than 5000 so you can launch another mass action with the start value set at 5000 in the filter section.

Only 3000 products.
If I give you ftp and joomla login, can u have a look please?

Hi,

Yes you can send us a ftp and backend access to your website.
Please give the url of that topic in the message and more informations about the not updated products (ids).

The informations can be sent via a private message or via our contact form directly.

Thanks for help.
I understand what is happening now.
Is there a way of filtering so we can update only prices >.05
I presume this would then miss all the unpriced variants

Hi,

Yes it's indeed possible, I don't thought about that
You can add a filter on the price_value column and set the desired value.

Price update completed and all working!!!