Mass Action Update Product with Multiple Pricing Tiers

-- HikaShop version -- : 4.5.0
-- Joomla version -- : 4.1.0
-- PHP version -- : 7.4.28

I have multiple products that are priced at $7.00 and also $3.00 if the customer purchases 25 or more. I would like to do 2 things.

• Update just the 7.00 price to 5.25 on all of the products in that category
• Add an additional price break at 2.50 for 75 or more on all products in that category

I have read how to add to the price or even deduct like this price.price_value/0.75...but it changes both the 3 and 7 dollar pricing structures. How do I just affect the one price value?

Thanks in advance.

Hi,

You can't use an "update the values" action for that since it will target all the prices of the products.
Instead, you want to use a "run MySQL query" action with such a query to update the price: And another action "run MySQL query" action with such a query to add a new price: where xxx is the id of the currency of your prices.

Please disregard this post. I didn't set the limitations to 1.

The first one worked perfect. The second added a ton of rows instead of just one. Any idea why it would have done that?

Hello,

You to keep the tag id ("{product_id}"), you just have to replace only the "xxx" and this may work.
Hope this will help you.

Regards