Skip to main content

Change the price of all products

More
12 years 9 months ago #135521 by melisari
Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135542 by nicolas
You set a filter so that the mass action only affect the products with a price of 50.
So you probably don't want any filter and only an action with a price of 50 set so that it updates the value of all the products.

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135550 by melisari
Yes of course, i want to change only de products that cost 50, but then... i dont understand the options (INT, FLOAT, STRING, OPERATION) i even tried with each one, but nothing happened.

What i want to do, is simple change 50 to 114

Thank you so much in advance and for your patient!

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135586 by nicolas
Then you need to keep the filter on 50 and in your action select INT and enter 114.
Also, add a second filter on "limit" and make sure that you increase the limit as otherwise, it will only apply to the first 500 products costing 50.
Once you're set, you can click on "process" in order to run the mass action and change the price.

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135619 by melisari
Nothing happened... im sure im missing something...

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135685 by nicolas
This will only do it for 500 products. Do you have more products with that 50 price ?
In that case, you should either rerun it several times or increase the limit.

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135686 by melisari
I only have 100 products, and those i need to change are just 71

If i cant do it with mass actions, could you please help me do it in php myadmin? Once i did it that way, i remember I increased the price by 15%, but i dont know how to do it if i only need to change the price... maybe with a sum?

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135784 by nicolas
I'm not just why it wouldn't work with the mass action, but it's indeed quite easy to do with a mysql query.
Simply use such query:

UPDATE jos_hikashop_price SET price_value=114 WHERE price_value=50;
The following user(s) said Thank You: melisari

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #135801 by melisari
Thank you so much! You are my hero!

Please Log in or Create an account to join the conversation.

Time to create page: 0.174 seconds
Powered by Kunena Forum