[Skip to main content](#vessel-content) # order export puntuation ## - **[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")** - [![zebrafilm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 5 days ago [\#178823](#178823) by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Replied by *[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation?start=20#178823 "hey, when i export orders from the shop, the total prices are written wrong in the CSV file. exampel in backend 338,95 dkk and in csv it stands as 33.895.000 i can see its same number, but shouldn't it look the same ?")* Hi Nicolas, yes I agree that it would be a pity but we are running a lot of sites, selling thousands of items. Just too much to manually process. It needs not only a smooth experience for the buyers, it also needs a smooth backend. Yes I am able to get it working in Excel but we need all sites to deliver smooth export / imports also to other accounting software and they have the same issue. As mentioned in the a request messages, the exports is to say it politely "chaotic" for most people. There is also the issues of the dashboard not showing the right numbers for some reason. (which I have mentioned several times. ) We need to deliver weekly reports to shareholders and decision makers. We have build a bridge to vTiger to get it all in. It might be a solution but it is a bit absurd that it is needed. I am also looking with Germinal if his Invoice Manager could do the 'translation' to a proper export. It's getting closer so that might be the solution. Still I believe that Hika should step to approve the output and solve the dashboard issues.He potential is there but you can't say to clients "oh just add a bit of PHP there" ![:-)](/media/kunena/emoticons/3.png ":-)") But thats just my 2cents after working daily with it on lots of site.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj9zdGFydD0yMCZ0bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 12 years 5 days ago [\#178824](#178824) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation?start=20#178824 "hey, when i export orders from the shop, the total prices are written wrong in the CSV file. exampel in backend 338,95 dkk and in csv it stands as 33.895.000 i can see its same number, but shouldn't it look the same ?")* Hi, So override the view "backend | your-backend-template | order | export" and replace the line Code: $format = $config->get('export_format','csv'); By Code: $format = 'xls'; in order to generate XLS files which will be open directly by excel. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj9zdGFydD0yMCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")** - [![zebrafilm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 5 days ago [\#178846](#178846) by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Replied by *[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation?start=20#178846 "hey, when i export orders from the shop, the total prices are written wrong in the CSV file. exampel in backend 338,95 dkk and in csv it stands as 33.895.000 i can see its same number, but shouldn't it look the same ?")* Hi Jerome, typical answer form a coder, of course I appreciate that you take the time to answer, no doubt. And yes I can change all 20 (or so) website we are running one by one but no that is not a solution. As written above, most times it needs a careful manual import in excel to get the decimals right. Not to mention the accounting programs that are far worse in imports. Understand that I put my time in these discussions because I daily work with hika users and customers and would like to see Hika grow to the best allround webshop. The front end is working fine, the backend is ok for the casual user, not for bigger setups that need to satisfy managers, accountant etc. I hope to contribute to a better Hika. Despite the fact that there is no open roadmap..... Instead of telling me how to add the line, you could also say, we will put it on the todo list and create a proper excel export button with preselection for fields and formats. (The excel format is more than an extension) That makes sense, it will make more people happy and one update will fix all my sites in one go. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj9zdGFydD0yMCZ0bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 12 years 4 days ago [\#178859](#178859) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation?start=20#178859 "hey, when i export orders from the shop, the total prices are written wrong in the CSV file. exampel in backend 338,95 dkk and in csv it stands as 33.895.000 i can see its same number, but shouldn't it look the same ?")* Hi, You want to contribute to a better HikaShop ? That's not a problem at all you know. If you want to solve your punctuation problem, the best will be to improve the Spreadsheet helper. File : "administrator/components/com_hikashop/helpers/speadsheet.php" It's a little file that I wrote several years ago (before the first HikaShop release) and I shared with the HikaShop team. As you could see the class have some options, some modes and dedicated functions. There is for example a function to write a number in the spreadsheet file. Why don't you add an option in order to convert the number in that Helper ? You can add the option support in the init function (and manage the conflict with the separator) ; and then add the number conversion in the writeNumber function (for the CSV ; Like you will see excel have his own way to write it, I'm not just changing the extension). So, contributing and sharing your modification will improve HikaShop and provide new options for the export, like a "csv_decimal_separator" option. But you will have to test it with the HikaShop import system, in order to be sure that the new exported format is working right with the HikaShop import ; otherwise the HikaShop users could have a serious problem during the import and we will have a lot of messages in the forum for this trouble. Yes I am a developer and I am an HikaShop contributor and my contributions are done for free. When I am contributing, I test my developments in order to be sure that it won't impact something else in HikaShop ; I am thinking about the HikaShop support team in order to improve HikaShop in the right way (and not give us more support). There is no open roadmap for the reason that a roadmap has to be followed ; depending the HikaShop forum support, to the discovered bugs, to the idea we got, to the customer requests, to the custom jobs, to the needs in other plugins/components ; HikaShop is improved all the time. It is not possible to write a open roadmap so there is a private roadmap and only the HikaShop team have access to it. Because if one point of the roadmap could not be completed in the right time ; there won't be any problem with the HikaShop users who won't complain at it. When we say that a feature will be in the next release ; it means that we are working on it and we are sure that we will finish it for the next release. > you could also say, we will put it on the todo list and create a proper excel export button with preselection for fields and formats. (The excel format is more than an extension) 1/ The spreadsheet helper does not change the extension to generate an excel file ; And I'm still trying to not take this point personally. 2/ If you want to select the fields, you can use a mass-action and export whatever you want and select all columns to export. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj9zdGFydD0yMCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")** - [![zebrafilm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 3 days ago [\#179010](#179010) by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Replied by *[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation?start=20#179010 "hey, when i export orders from the shop, the total prices are written wrong in the CSV file. exampel in backend 338,95 dkk and in csv it stands as 33.895.000 i can see its same number, but shouldn't it look the same ?")* Dear Jerome, No don't take it personal, as said before the goal is to improve Hika and there has been a tremendous job done , including you. Never said anything else. But there is room for improvement and I am battling upset managers day by day about the backend options. So why not let me give feedback and solve those? To stick to this thread: the comma decimal separator is not full supported by Hika exports and that is a pity. Yes I will see if I can assign a coder to look at your file but I think it would be better if the Hika team fixes bugs like these. Thanks for your insights ![:-)](/media/kunena/emoticons/3.png ":-)") Bastiaan Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj9zdGFydD0yMCZ0bXBsPW1hcmtkb3du) 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: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 12 years 3 days ago [\#179012](#179012) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation?start=20#179012 "hey, when i export orders from the shop, the total prices are written wrong in the CSV file. exampel in backend 338,95 dkk and in csv it stands as 33.895.000 i can see its same number, but shouldn't it look the same ?")* Hi, Okay. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj9zdGFydD0yMCZ0bXBsPW1hcmtkb3du) 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.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)