Main Currency

  • Posts: 48
  • Thank you received: 0
5 years 3 months ago #313886

-- HikaShop version -- : 4.2.2
-- Joomla version -- : 3.9.13
-- PHP version -- : 7.2
-- Browser(s) name and version -- : firefox
-- Error-message(debug-mod must be tuned on) -- : none

Hello I have imported all my products, However, I forgot to change the currency from euro to dollar before the import. Now all the products are showing euro as the currency. I have changed the currency in system/main main currency to $USD but they dont change in the price in back end or front end. Is there a mass action or something? I don't want to re import as there a lot of products 20k...please advise. thx

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

  • Posts: 83410
  • Thank you received: 13502
  • MODERATOR
5 years 3 months ago #313896

Hi,

Yes, you can do that with a mass action (menu System>Mass actions) with an action "update the values" on the column "price_currency_id" with the value corresponding to the id of the currency (2 for USD).
Note that the limitation area will restrict the change to the 500 first products when you run the mass action so you'll have to adapt the start/limit fields and run the mass action several times to cover all the products.

Otherwise, you could just run a MySQL query in your database via your phpmyadmin. It's quite an easy query:

UPDATE #__hikashop_price SET price_currency_id=2;
(you need to replace #__ by your table prefix)

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

Time to create page: 0.056 seconds
Powered by Kunena Forum