Change the price of all products

  • Posts: 103
  • Thank you received: 2
10 years 4 months ago #135521

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!

Attachments:

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

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
10 years 4 months ago #135542

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.

  • Posts: 103
  • Thank you received: 2
10 years 4 months ago #135550

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.

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
10 years 4 months ago #135586

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.

  • Posts: 103
  • Thank you received: 2
10 years 4 months ago #135619

Nothing happened... im sure im missing something...

Attachments:

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

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
10 years 4 months ago #135685

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.

  • Posts: 103
  • Thank you received: 2
10 years 4 months ago #135686

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.

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
10 years 4 months ago #135784

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.

  • Posts: 103
  • Thank you received: 2
10 years 4 months ago #135801

Thank you so much! You are my hero!

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

Time to create page: 0.082 seconds
Powered by Kunena Forum