[Skip to main content](#vessel-content) # Prices are differents on Cart (corrects) than on Order, Invoice and Mails ## - **[dylis](/forum/user/4744-dylis "View dylis's Profile")** - [![dylis's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4744-dylis "View dylis's Profile") Topic Author - [ Offline](/forum/user/4744-dylis) Less More - Posts: 33 - Thank you received: 0 - - 8 years 7 months ago [\#290580](#290580) by [dylis](/forum/user/4744-dylis "View dylis's Profile") *[Prices are differents on Cart (corrects) than on Order, Invoice and Mails](/forum/27-checkout/894304-prices-are-differents-on-cart-corrects-than-on-order-invoice-and-mails#290580 "-- HikaShop version -- : 3.4.0 business -- Joomla version -- : 3.8.6 -- PHP version -- : 7.1.14 -- Browser(s) name and version -- : Firefox 59.0.2 (64 bits) Hi, Im facing a problem with prices in orders (from order history front end and backend), emails and invoices, for some reason prices seems to be rounded one more time after the user validate his cart (prices are ok in cart) some screenshot joined so you understand the problem : - prices in cart (all ok) - prices in order, mails and invoice (TVA and TTC are ok, item price and subtotal are wrong) you can reproduce this exemple (order n°CDE-91-31/03/18) with product Enveloppes Office/114x162 / 80g / no options / qty 8500 Thanks")* was created by *[dylis](/forum/user/4744-dylis "View dylis's Profile")* -- HikaShop version -- : 3.4.0 business -- Joomla version -- : 3.8.6 -- PHP version -- : 7.1.14 -- Browser(s) name and version -- : Firefox 59.0.2 (64 bits) This message contains confidential information Hi, Im facing a problem with prices in orders (from order history front end and backend), emails and invoices, for some reason prices seems to be rounded one more time after the user validate his cart (prices are ok in cart) some screenshot joined so you understand the problem : - prices in cart (all ok) - prices in order, mails and invoice (TVA and TTC are ok, item price and subtotal are wrong) you can reproduce this exemple (order n°CDE-91-31/03/18) with product Enveloppes Office/114x162 / 80g / no options / qty 8500 Thanks - [ ![facture.png](/forum/attachment/43206) ](/forum/attachment/43206 "facture.png") [ ](/forum/attachment/43206?download=1 "facture.png") - [ ![email.png](/forum/attachment/43207) ](/forum/attachment/43207 "email.png") [ ](/forum/attachment/43207?download=1 "email.png") - [ ![panier.png](/forum/attachment/43208) ](/forum/attachment/43208 "panier.png") [ ](/forum/attachment/43208?download=1 "panier.png") - [ ![commande.png](/forum/attachment/43209) ](/forum/attachment/43209 "commande.png") [ ](/forum/attachment/43209?download=1 "commande.png") - [ ![invoice.png](/forum/attachment/43210) ](/forum/attachment/43210 "invoice.png") [ ](/forum/attachment/43210?download=1 "invoice.png") - [ ![email_2018-03-31.png](/forum/attachment/43211) ](/forum/attachment/43211 "...2018-03-31.png") [ ](/forum/attachment/43211?download=1 "...2018-03-31.png") - [ ![order.png](/forum/attachment/43212) ](/forum/attachment/43212 "order.png") [ ](/forum/attachment/43212?download=1 "order.png") - [ ![cart.png](/forum/attachment/43213) ](/forum/attachment/43213 "cart.png") [ ](/forum/attachment/43213?download=1 "cart.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg5NDMwNC1wcmljZXMtYXJlLWRpZmZlcmVudHMtb24tY2FydC1jb3JyZWN0cy10aGFuLW9uLW9yZGVyLWludm9pY2UtYW5kLW1haWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dylis](/forum/user/4744-dylis "View dylis's Profile")** - [![dylis's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4744-dylis "View dylis's Profile") Topic Author - [ Offline](/forum/user/4744-dylis) Less More - Posts: 33 - Thank you received: 0 - - 8 years 7 months ago - 8 years 7 months ago [\#290595](#290595) by [dylis](/forum/user/4744-dylis "View dylis's Profile") Replied by *[dylis](/forum/user/4744-dylis "View dylis's Profile")* on topic *[Prices are differents on Cart (corrects) than on Order, Invoice and Mails](/forum/27-checkout/894304-prices-are-differents-on-cart-corrects-than-on-order-invoice-and-mails#290595 "-- HikaShop version -- : 3.4.0 business -- Joomla version -- : 3.8.6 -- PHP version -- : 7.1.14 -- Browser(s) name and version -- : Firefox 59.0.2 (64 bits) Hi, Im facing a problem with prices in orders (from order history front end and backend), emails and invoices, for some reason prices seems to be rounded one more time after the user validate his cart (prices are ok in cart) some screenshot joined so you understand the problem : - prices in cart (all ok) - prices in order, mails and invoice (TVA and TTC are ok, item price and subtotal are wrong) you can reproduce this exemple (order n°CDE-91-31/03/18) with product Enveloppes Office/114x162 / 80g / no options / qty 8500 Thanks")* Hi, I found the origine of the problem, the mysql table structure was limited to 5 decimals where I needed 6, so, I altered the table structure with decimal (16,6) for column order_product_price in hikashop_order_product table and for column currency_rate in table hikashop_currency (not sure I need to alter this one?), and everything works fine. But, are those table structure going to change with next hikashop updates ? Thanks Last edit: 8 years 7 months ago by [dylis](/forum/user/4744-dylis "View dylis's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg5NDMwNC1wcmljZXMtYXJlLWRpZmZlcmVudHMtb24tY2FydC1jb3JyZWN0cy10aGFuLW9uLW9yZGVyLWludm9pY2UtYW5kLW1haWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4077 - - [](http://obsi.dev) - 8 years 7 months ago [\#290602](#290602) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Prices are differents on Cart (corrects) than on Order, Invoice and Mails](/forum/27-checkout/894304-prices-are-differents-on-cart-corrects-than-on-order-invoice-and-mails#290602 "-- HikaShop version -- : 3.4.0 business -- Joomla version -- : 3.8.6 -- PHP version -- : 7.1.14 -- Browser(s) name and version -- : Firefox 59.0.2 (64 bits) Hi, Im facing a problem with prices in orders (from order history front end and backend), emails and invoices, for some reason prices seems to be rounded one more time after the user validate his cart (prices are ok in cart) some screenshot joined so you understand the problem : - prices in cart (all ok) - prices in order, mails and invoice (TVA and TTC are ok, item price and subtotal are wrong) you can reproduce this exemple (order n°CDE-91-31/03/18) with product Enveloppes Office/114x162 / 80g / no options / qty 8500 Thanks")* Hello, HikaShop updates can add new columns but generally do not modify the structure of existing columns. So the hikashop_price and the hikashop_order_product tables won't be impacted with future HikaShop updates. And if one day we want to change the structure of these price columns, it will only to make them more accurate. But in 8 years it was fine with 16.5 for the biggest majority our users (but you're not the only one who changed that floating precision). Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg5NDMwNC1wcmljZXMtYXJlLWRpZmZlcmVudHMtb24tY2FydC1jb3JyZWN0cy10aGFuLW9uLW9yZGVyLWludm9pY2UtYW5kLW1haWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)