Increase Price On Specific Brand Products

-- HikaShop version -- : 4.4.2

Hi,

I tried to create a mass action but not sure how to do it correctly.

I would like to increase the price on all products with the name COACH in it by 10%.

As you can see from the attached, the Product columns says "0 results", not sure why that is. Also I'm not sure if what I put in the Actions is correct.

Thank you!

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.

My bad, regarding the product name. I forgot that the product brand name is not included in the product name. I was still able to get it to work though as per the attached.

1) Would you mind letting me know how to decrease the price by X%, example 10%?

2) And please explain this part *1.1 (so I can figure out how to enter the % for myself next time)

3) I am still interested in knowing how to do the easier version. For some reason I don't see an "actions" button, unless I went to the wrong place. I went to Hikashop > Products and did the search there, check the boxes, but I don't see an "actions" button. What did I miss?

Thanks!

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

Ok thank you!

Hello,
would you help me to increase the price with 10% by a manufacterer.
Here what I tried, but notting`s gonna happend.
Thanks!

Hi,

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

I put the real ID 75 and save it, but the prices not increased.

Probably because I`ve got a variables in my products.

Where I`ve made mistake?

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: where #__ is replaced by the table prefix of your Joomla configuration to match with the tables in the database.

Hello,
I`ve tested on my localhost but still notings gonna happend!
ixks1_ - that is my joomla localhost prefix.
Here are my MySQL query:
UPDATE ixks1_hikashop_price AS price SET price.price_value = price.price_value*1.1 WHERE price.price_product_id IN (SELECT product_id FROM ixks1_hikashop_product WHERE product_manufacturer_id = 75);

Maybe because there are no price at main tab, only in variables!

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:

Thanks, work great!