Increase Price On Specific Brand Products

Hi,

The filter is fine. Are you sure that you have the text "Coach" in the product name of your products ?
Could you provide a screenshot of the settings of a product like that ?
Regarding the action however you can't do it like that.
You need to use the "update the values" action, on the "price_value" column, with the mode "operation" and the value:
price.price_value*1.1
Note that an easier way is to go in your products listing, search for "coach" to get the products with that text, check their checkboxes, and click on the "actions" button of the listing. In the popup you'll get, you'll be able to setup the action as explained above and it will process it on all the selected products, without then need to create a mass action and setup filters.

Hi,

1. Instead the same but instead of multiplying by 1.1 you can multiply by 0.9

2. It's [price]*1.1 = [price] * (100 + 10) / 100 = [price] + [price]*10%
For -10% it would be: [price] + [price]*-10% = [price] * (100 - 10) / 100 = [price]*0.9

3. Here is a blog article where we present that feature:
www.hikashop.com/home/blog/467-hikashop-4-4-2.html#action

Hi,

The product_manufacturer_id should be the id of the brand, not its name.
The rest looks fine.

Hi,

Your filter is on a brand but your screenshot is of a variants listing. Variants don't have a brand linked to them.
So you can't do it like that.
You could use the product_parent_id to target all the variants of a product, but you would have to do it one product at a time.
So it might not be suitable.
In your case, I'm afraid the best is to directly run a MySQL query in your PHPMyAdmin like that:

UPDATE #__hikashop_price AS price SET price.price_value = price.price_value*1.1 WHERE price.price_product_id IN (SELECT product_id FROM #__hikashop_product WHERE product_manufacturer_id = 75);

Hi,

My bad, I forgot about the variant issue while writting the MySQL query !
My previous query will only work for main products.
For variants you need to use this query instead:

UPDATE #__hikashop_price AS price SET price.price_value = price.price_value*1.1 WHERE price.price_product_id IN (SELECT p1.product_id FROM #__hikashop_product AS p1 WHERE p1.product_parent_id IN (SELECT p2.product_id FROM #__hikashop_product AS p2 WHERE p2.product_manufacturer_id = 75));