mb5 Posted January 22, 2006 Posted January 22, 2006 Hello, I hope somebody of you have experienced the following problem and can give me a solution! All my prices include the taxes, but gross and net are the same. All prices are shown correct in emails and on site, but in my database the fields "final_price" in order_products and "value" in order_total are rounded to zero / the last two digits are cut off. For example: Order amount 5.95 is shown correct in confirmation email, but in database in table order_products you have 5.95 in product_price BUT 5.00 in final_price. In table order_total the effect is the same: 5.00 in value. I really don't know, why this happens... Any idea? Greetz, mingel
Guest Posted January 23, 2006 Posted January 23, 2006 you may want first to check the currency decimal places and the tax decimal places settings in the osc admin.
mb5 Posted January 25, 2006 Author Posted January 25, 2006 I have Tax Decimal Places = 2 and Display Prices with Tax = true. Currency Decimal Places are two. I haven't defined any Tax Zones, Tax Classes or Tax Sets, so gross and net prices are the same. Where could the miscomputation happen?
Guest Posted January 25, 2006 Posted January 25, 2006 the final_price in the order_products will not include tax. The generated email formats the order items to include tax however. you can quickly test it if you toggle the switch to display items without tax to see if the products_price is consistent with the final price.
mb5 Posted January 25, 2006 Author Posted January 25, 2006 In both cases, displayed with or without tax, final_price contains the prices with the last two digits 00, so they are deleted. I could imagine that it depends on how taxes are calculated on prices, but I don't know, where to find the computation.
Guest Posted January 25, 2006 Posted January 25, 2006 the files to look for will be catalog\includes\classes\order.php and catalog\checkout_process.php where the final price is stored. There is a computation for the final_price that takes into account product attributes. You will see it in the order.php file.
mb5 Posted January 25, 2006 Author Posted January 25, 2006 Thank you for the fast answer. Good to know, where to look. As I see, order_total computation is also in that file...
XaviGracia Posted February 1, 2006 Posted February 1, 2006 I'm having the same exact problem, i don't why but order.php or checkout_process.php are rounding down the final_price field... What i would like to know is... what's the difference between products_price and final_price fields ??? Thanks !
Guest Posted February 1, 2006 Posted February 1, 2006 There is a computation for the final_price that takes into account product attributes. You will see it in the order.php file. because the products_price does not include the attributes price.
XaviGracia Posted February 2, 2006 Posted February 2, 2006 Mb5, if you are able to see what's the cause of the problem, please post it... Right now, i'm unable to see anything in the two aforementioned files... Right now, i have changed the 'final_price' => $order->products[$i]['final_price'], line for this one... 'final_price' => $order->products[$i]['price'], Yeah, i know, it's a awful, but as i don't use product attributes... :-)
mb5 Posted February 2, 2006 Author Posted February 2, 2006 Right now, i have changed the 'final_price' => $order->products[$i]['final_price'], line for this one... 'final_price' => $order->products[$i]['price'], Jackpot, that is exactly what I did to correct the wrong order_products prices in database. Order_total values are still rounded down to 0. Greetings mb5
Patty Posted April 8, 2006 Posted April 8, 2006 I'm having the same problem with one store. product_price shows the right value but final_price shows the price rounded down. If it's less than 1.00 then it rounds the price to 0.00. Shipping is also rounded down so there are no cents. Has anybody found a solution for this yet? Tks in advance for any help. Patty
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.