Page 1 of 1

This Prices annyoin me 1000.0000, please help!

Posted: Sat Feb 05, 2011 2:07 pm
by locktar
hi

im front store the prices show well ex: 1,999.66 but in admin store the prices annoyin i cant imagine look 1000 products with 1000.0000 or 10.0000 ... please i like so much the opencart ... someone help me ... to solution it ... i want to type and see the real prices ... 1,999.66 ... i know u think is fool ... but is important to me ...

ty
locktar

Re: This Prices annyoin me 1000.0000, please help!

Posted: Sat Feb 05, 2011 3:15 pm
by locktar
well im a php noob but i did a progress ...

in catalog > products ... the original price show is ...

Image

i found this in /admin/controller/catalog/product.php

$this->data['products'][] = array(
'product_id' => $result['product_id'],
'name' => $result['name'],
'model' => $result['model'],
'price' => $result['price'],
'special' => $special['price'],

i change to ...

$this->data['products'][] = array(
'product_id' => $result['product_id'],
'name' => $result['name'],
'model' => $result['model'],
'price' => $this->currency->format($result['price']),
'special' => $this->currency->format($special['price']),

now show the price with format that i like ...
Image

but ... i cant do this ... in product edit and insert ...

can any help to do it? in theory ... in the database all prices stay in original format ex: 1999.3600 ... when we click in edit product ... before show the price ... we can put a command to convert to the choiced currency ... if we need to change or insert a new price ... we put with the choiced currency format example 1,999.36 after press button the script convert to the original format 1999.3600 ... but i dont know how do that ... sorry my bad english ... im tryin ... =/

ty
Locktar

Re: This Prices annyoin me 1000.0000, please help!

Posted: Sat Feb 05, 2011 7:21 pm
by nosecret
Do you want set decimal place in admin product list? If yes, open your database by phpmyadmin, open table product, select price and convert decimal place (15,4) to what you want. Number 4 is decimal place.

Re: This Prices annyoin me 1000.0000, please help!

Posted: Sun Feb 06, 2011 5:04 am
by philbydevil
No, I think that he wants to be able to input prices that include tax, not ex tax.

There is no option to select this but there may be a way to do it, not sure. I'm sure that I've seen Daniel answer this question somewhere before (so search), but he was saying that it can't/shouldn't be done this way.

I think that it may be quite complicated, given that OC is set up with the option for different geo zones, which can/or cannot have tax allocated to them. I think that there's a bit more to changing this than you think locktar.