Page 1 of 1

[SOLVED][1.4.9.3] Remove Decimals On Length, weight and cost

Posted: Fri Jun 03, 2011 6:31 pm
by webpie it.
Hi guys

Just customising the admin for my new porject and basically i am using:

Length, weight and cost Fields for different entries which, and as it is expected numbers will be enetred in these it adds

.00 to my inputs.

These inuts are now words so just looking for quick guide as to how to change these from decomal to varchar i suppose, did have a good look in phpmyadmin, but got a little lost as to how to change the type from decimal to varchar.

Or am i going about this in a more complicated way, can i just edit the system/library files?

Ay answeres would be great.

Thnaks guys

Chris

Re: [1.4.9.3] Remove Decimals On Length, weight and cost

Posted: Sat Jun 04, 2011 7:38 am
by nosecret
You can remove decimal via phpmyadmin.
Open your database via phpmyadmin
Select table product, select field (example length),
In length/value: change (5,2) to (5,0)
In default: change (0,00) to (0)

Re: [1.4.9.3] Remove Decimals On Length, weight and cost

Posted: Sat Jun 04, 2011 2:01 pm
by webpie it.
Thanks Man that worked a treat

Re: [SOLVED][1.4.9.3] Remove Decimals On Length, weight and

Posted: Sun Sep 30, 2012 6:03 am
by jeglash
Hi all,

Thanks for this info - but I can't seem to get it to work, and specifically, I have no field names in my oc_product page, via phpmyadmin. My current issue is that all of the products in my client's catalog uploaded with ".00000000" after the proper digit. I want to just display the digit - eg "100" instead of "100.00000000". Thanks for any help!!