- Posts: 103
- Thank you received: 2
Change the price of all products
12 years 9 months ago #135521
by melisari
Change the price of all products was created 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.
12 years 9 months ago #135542
by nicolas
Replied by nicolas on topic Change the price of all products
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.
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.
12 years 9 months ago #135550
by melisari
Replied by melisari on topic Change the price of all products
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!
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.
12 years 9 months ago #135586
by nicolas
Replied by nicolas on topic Change the price of all products
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.
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.
12 years 9 months ago #135619
by melisari
Replied by melisari on topic Change the price of all products
Nothing happened... im sure im missing something...
Please Log in or Create an account to join the conversation.
12 years 9 months ago #135685
by nicolas
Replied by nicolas on topic Change the price of all products
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.
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.
12 years 9 months ago #135686
by melisari
Replied by melisari on topic Change the price of all products
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?
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.
12 years 9 months ago #135784
by nicolas
Replied by nicolas on topic Change the price of all products
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;
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.
12 years 9 months ago #135801
by melisari
Replied by melisari on topic Change the price of all products
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