viprem Posted September 16, 2020 Share Posted September 16, 2020 In my store prices displaying like AED34.00 I want to have AED 34.00 but not getting this in anywhere in admin panel. Can anyone help to achieve this ..Thanks in advance Link to comment Share on other sites More sharing options...
Oxbow8 Posted December 10, 2020 Share Posted December 10, 2020 Nobody knows ? Want to do the same Link to comment Share on other sites More sharing options...
Guest Posted December 10, 2020 Share Posted December 10, 2020 Just change the value in the ps_currency_lang table in the symbol column. Or you can collectively place a space before the symbol and a space after the symbol for all prices. UPDATE `ps_currency_lang` SET `symbol` = CONCAT(' ',`symbol`,' '); Link to comment Share on other sites More sharing options...
ABABA Posted December 10, 2020 Share Posted December 10, 2020 8 hours ago, Guest said: Just change the value in the ps_currency_lang table in the symbol column. Or you can collectively place a space before the symbol and a space after the symbol for all prices. UPDATE `ps_currency_lang` SET `symbol` = CONCAT(' ',`symbol`,' '); in which file one should do this? because I got the same problem Link to comment Share on other sites More sharing options...
Guest Posted December 10, 2020 Share Posted December 10, 2020 This is an SQL query that runs in a database. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now