X-Cart forums

[burak.82]

Hi,

My price in my site shows the following;

17500.00Ft

and i would like to change it as;

17 500 Ft

is this possible?

tia

burak

[qualiteam]

Try the following SQL:

UPDATE xcart_config SET variants="2.,:1,999.53\n2.:1999.53\n2, :1 999,53\n2,.:1.999,53\n0  :1 999" WHERE name="number_format";

[burak.82]

thanks alex but where i am going to put this command to ?

[qualiteam]

Originally Posted by burak.82

thanks alex but where i am going to put this command to ?

This is SQL patch that needs to be applied via X-Cart admin back end or phpMyAdmin.

It will add new selection entry to the Appearance options page for the number format option.

Note: BACKUP the database first!

[burak.82]

Added the line you gave me to a .txt file and saved it as patch.sql, before backed up the DB, applied the patch and voila works.

Big thanks to you

cheers