X-Cart forums - How to delete price decimals ?

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - How to delete price decimals ? (https://forum.x-cart.com/showthread.php?t=57232)

burak.82

12-25-2010 02:22 AM

How to delete price decimals ? {Solved}

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

12-27-2010 06:44 AM

Re: How to delete price decimals ?

Try the following SQL:

Code:

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

12-28-2010 02:42 AM

Re: How to delete price decimals ?

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

qualiteam

12-28-2010 02:55 AM

Re: How to delete price decimals ?

Quote:

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

01-03-2011 02:54 AM

Re: How to delete price decimals ?

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

All times are GMT -8. The time now is 11:29 PM.