I have VM 2.0.6 and i would like to solve a problem with price FORMAT.
I want VM to accept price with the following format 1.200,54 now this is accepted as 1000,54.
As i understand first i shall change the field in mysql to accept the price with the format i want. (i use a parser and this is the format i get from the xml).
I found in table virtuemart_product_prices the field Product_price has Decimal 15,5 how can i change it to accept the number as 1.000,54 ? After solving that what shall i change at VM to show the price like this ??
Thanks
Note: all VirtueMart versions before 2.0.10 are insecure, so an update is recommended.
In the current version the Decimals, Decimal Symbol and Thousands Separator are set in the currency editor.
http://docs.virtuemart.net/manual/21-configuration-menu/68-edit-currency.html
I have updated to 2.0.20b
I want the database field to accept this kind of number 1.203,58 i have to import those numbers as it. How can i do that ?
That change has to be at field in sql. Now product_price filed inside table virtuemart_product_prices is decimal(15,5) that is not accepting the number as 1.000,48 it only accepts 1000,48. To what shall i change this field in order to accept the dot ?
Thanks
change your input using a regex expression and leave the database alone - it will lead to issues in the rest of vm no doubt, if you mess with the DB