How to change currency in fronted?

[AshJi]

@AshJi said in How to change currency in fronted?:

Select all the currencies

Hi @Vaishali-Agarwal I am facing a peculiar issue with currency in production. I have setup the currency to INR as suggestion above. But when I try to add new product or edit existing products, it still shows $ sign in 'Pricing" section.

[Vaishali Agarwal]

@AshJi
when we set the default currency from the channel then it's only used for the frontend, to change the admin end default currency, it's configuration change from the config/app.php file https://prnt.sc/trqov8

[AshJi]

@Vaishali-Agarwal I made the changes in config/app.php and ran this command

php artisan config:clear

Now I can see ₹ symbol in Shop - Home, Product Detail, Cart etc but when I open 'Edit Product' or 'New Product' in Admin then it still shows $ symbol. Do I need to change somewhere else as well?

[Vaishali Agarwal]

@AshJi
could you run php artisan config:cache

[AshJi]

@Vaishali-Agarwal said in How to change currency in fronted?:

php artisan config:cache

Ran the command but no difference in Admin.

[AshJi]

Should I have to restart the server to address the Currency issue? What will be the command to restart the server on Google CLoud server

php artisan serve

or

sudo service apache2 restart

Please confirm.

[Vaishali Agarwal]

@AshJi

No need to restart the server configuration but still if you want to restart your server then run

sudo service apache2 restart

can you go to .env file and add the APP_CURRENCY=INR then flush the cache or see if still having same issue?

[AshJi]

@Vaishali-Agarwal in .env file variable 'APP_CURRENCY' had value 'USD'. I changed it to 'INR' and ran below commands

php artisan view:clear
php artisan cache:clear
composer dump-autoload

Open Admin in incognito mode. But currency is still in USD. I noticed that while doing SQL query, it is still fetching details from currency table for 'USD' even though the env variable is 'INR'

[AshJi]

is this a bug in Bagisto?

[Vaishali Agarwal]

@AshJi
no it's not an bug, may be u missed something
kindly check all the below solution:
https://forums.bagisto.com/topic/451/how-to-change-currency-and-locale-for-admin

https://forums.bagisto.com/topic/1129/update-the-base-currency-in-admin-panel/3

https://forums.bagisto.com/topic/50/how-can-i-change-the-base-currency-symbol-on-admin-dashboard

[AshJi]

@Vaishali-Agarwal said in How to change currency in fronted?:

may be u missed something

This isn't much helpful

Anyway I investigated found the issue. It seems that Bagisto is fetching currency details picking code from both from cache and "currency" variable. I noticed that following 2 SQLs were executed on each page

select * from `currencies` where `code` = 'INR'
select * from `currencies` where `code` = 'USD'

In /bootstrap/cache/config.php APP_CURRENCY was set to 'USD'. I changed it to 'INR' and fixed the problem. I will lated delete the cache and try.