[Skip to main content](#vessel-content) # order export puntuation ## - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") Topic Author - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 11 months ago [\#77707](#77707) by [jesper](/forum/user/8151-jesper "View jesper's Profile") *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#77707 "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 ?")* was created by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* 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 ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) 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: 4078 - - [](http://obsi.dev) - 13 years 11 months ago [\#77710](#77710) 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#77710 "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, Can you create a new export, save your CSV file and open it using a simple text editor ? It is possible that your spreadsheet software convert the number without understanding the number separator. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") Topic Author - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 11 months ago [\#77712](#77712) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#77712 "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 ?")* thanx that seems to be the problem that its exported with 5 decimals and excel can't figure this out. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[niqui](/forum/user/2055-niqui "View niqui's Profile")** - [![niqui's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2055-niqui "View niqui's Profile") - [ Offline](/forum/user/2055-niqui) Less More - Posts: 70 - Thank you received: 4 - - - [](http://apestaart.info) - 13 years 8 months ago [\#91427](#91427) by [niqui](/forum/user/2055-niqui "View niqui's Profile") Replied by *[niqui](/forum/user/2055-niqui "View niqui's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91427 "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 ?")* How did you solve this? I'm having the same problem with the prices in my csv. Did you find a way to handle the prices correctly in excel? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") Topic Author - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 8 months ago [\#91428](#91428) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91428 "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 ?")* i did string replace in a text editor for this to work.... its still not fixed... maybee making a xls export button would be the smarter way to do this as it seems the csv isn't compatible with it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 13 years 8 months ago [\#91550](#91550) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91550 "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 ?")* The CSV is fine. You can for example open it with OpenOffice Calc instead of Excel and you won't have the issue. It is important in some cases to export the prices with more than 2 decimals or the prices wouldn't be correct. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") Topic Author - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 8 months ago [\#91562](#91562) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91562 "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 ?")* the csv is fine to csv standarts, but when ppl need to use it with excel and don't wanna install openoffice or use other means of converting it, its not fine. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[niqui](/forum/user/2055-niqui "View niqui's Profile")** - [![niqui's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2055-niqui "View niqui's Profile") - [ Offline](/forum/user/2055-niqui) Less More - Posts: 70 - Thank you received: 4 - - - [](http://apestaart.info) - 13 years 8 months ago [\#91573](#91573) by [niqui](/forum/user/2055-niqui "View niqui's Profile") Replied by *[niqui](/forum/user/2055-niqui "View niqui's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91573 "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 ?")* I've asked a friend who's an excel expert how I could solve this issue. And it is indeed an excel issue. It has to do with the configuration of excel (or your system software, depending of which version of excel you're using). If it has a dot (.) as decimal separator it is working fine. If you have a comma (,) as a decimal separator then the prices are messed up. And that has to do with how excel 'reads' the numbers of the csv file. Has nothing to do with a bug or a bad csv file ![;)](/media/kunena/emoticons/11.png ";)") The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") Topic Author - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 8 months ago [\#91720](#91720) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91720 "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 ?")* still doesn't help that the normal user/admin who tries to use this function can't get it to work... doesn't matter if the "error" is in hikashop or excel... just need a way for them, to get it working easy. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 8 months ago [\#91923](#91923) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#91923 "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 there, You may understand that we can't adapt Hikashop to fit an external software bug... it's nonsense. It you really want to avoid this, a solution would be to edit the export.php file in administrator/com_hikashop/views/order/tmpl and add some code there to replace the coma by a dot in every price. However it will require some good php skills and I definitely think that using another software (maybe simply a more recent version of excel, we don't have this bug here) is the best solution. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") Topic Author - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 7 months ago [\#93579](#93579) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#93579 "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 ?")* A lot of people use comma as a decimal separator. So all of those people will not be able to open the CSV file correctly in Excel without tampering with system settings. Another solution would be to make the export configurable to use a user defined (or just choose between comma and dot) decimal separator and then make the export do the string replace. Let's call that a feature request for the future ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 13 years 7 months ago [\#93811](#93811) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#93811 "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 ?")* Actually, you should be able to change the decimal separator in the export CSV by just adding a line at the top of the export.php file to change the locale of PHP: [ stackoverflow.com/questions/2996743/cast...wertab=votes#tab-top](http://stackoverflow.com/questions/2996743/cast-string-with-coma-to-float-with-dot?answertab=votes#tab-top) Also, the decimal separator support in Excel can also be changed so that it can import both comma or dot separated formats: [ superuser.com/questions/385511/easy-way-...l-separator-in-excel](http://superuser.com/questions/385511/easy-way-to-one-off-import-data-with-different-decimal-separator-in-excel) That's even easier than setting the locale in the code in HikaShop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) 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/avatars/resized/size144/users/avatar_2013-02-01.png)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 11 months ago [\#129869](#129869) 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#129869 "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 ?")* Although an older topic, it is still an issue. Just had some clients complaining they could not import the CSV into their bookkeeping program. Here in the Netherlands we use the comma as decimal separator and the export makes some strange numbers: We get a dot for the thousands as well as for the decimal separator. That doesn't make sense to me and impossible to run a script or do a simple search and replace. Example: Price of product is: 3,97 in the export it shows as 397.000 Items that cost 270 euro, display as 2.700.00 Please help us fix this in a professional manner. It is really an issue and clients need those exports to work well for their monthly bookkeeping. I have several sites where this is an issue and I am afraid I will have to offer an alternative component if this is not fixed soon. Thank you for your understanding. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 11 months ago [\#129899](#129899) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#129899 "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, In my previous post, I already gave a link to some code to add in order to change the exported format of prices. You can add that code from stackoverflow in the file "export" of the view "order" via the menu Display>Views. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) 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/avatars/resized/size144/users/avatar_2013-02-01.png)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 11 months ago [\#129904](#129904) 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#129904 "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, of course I tried that but it does not help. It seems a combination of how it gets out of Hikashop and the local decimal separator. It is not so simple to just set PHP and get the result right out the examples I gave above. Please take this as a serious request, I am now forced to test VM ![:-(](/media/kunena/emoticons/4.png ":-(") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) 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/avatars/resized/size144/users/avatar_2013-02-01.png)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 11 months ago [\#129990](#129990) 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#129990 "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 ?")* Allow me to explain why this is important to get sorted: When I build websites I advice people to use Hikashop. I think it is well made, stable and has good support. Almost all Hikashop owners are small companies that need to do their VAT and other bookkeeping monthly and use an electronic bookkeeping system. Mainly online here. We have about 20 different online bookkeeping options here in the Netherlands. Paying and reporting tax is only possible online so the whole process is an electronic one. Most bookkeeping systems I know have a connector for at least Magento and Virtuemart. None has one for Hikashop. I have done research and got quotes for building a connector which will be around 2500 euro if the online bookkeeping system has an API. Most people are asking me if it would not be cheaper to use VM2. If I convince them Hika is better they usually are willing to make the extra step of export/import but then it needs to be a seamless effort. It has to be done at least once a month and then fiddling around is not an option. So please help me keeping Hika on the map here by trying to find a proper way around this silly comma/decimal system. Part is PHP and localisation, part is also the export of Hika that spits out different number in different ways. CSV export is not just a gimmick, for a lot of people it is the main connection to the their bookkeeping. Hikashop has grown mature, the pressure for new feature is no longer there. Please spent a bit of your resources to make this all work. Bastiaan The following user(s) said Thank You: [Zian](/forum/user/34782-zian "View Zian's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 11 months ago [\#131078](#131078) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#131078 "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, As Nicolas said, you just have to replace the comma by a dot with some code. All the exports are working fine, there is no price problems, so if it's adding a 0 at the end of the price it's probably due to a wrong modification. Actually, thanks to the mass actions present in HikaShop you can export the desired data. Not formatting the prices as wanted, but it can be possible by creating a plugin based on the current export feature. By this way you can format the csv file as wanted. I have added your request in the todo list, but if you need it shortly, you can ask for a quote via our contact form, or post a request on the commercial jobs section of this forum. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Zian](/forum/user/34782-zian "View Zian's Profile")** - [![Zian's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34782-zian "View Zian's Profile") - [ Offline](/forum/user/34782-zian) Less More - Posts: 1 - Thank you received: 0 - - 11 years 11 months ago - 11 years 11 months ago [\#177498](#177498) by [Zian](/forum/user/34782-zian "View Zian's Profile") Replied by *[Zian](/forum/user/34782-zian "View Zian's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#177498 "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 ?")* Has there been any progress on this? *I have managed to get it going correctly by using the data import function in excel but it is still a too lengthy process in comparison with Magento (which is "supposed to be" difficult etc.). Hikashop is a great piece software but I hope, you really start to focus more on the business aspects as well.* As the previous commenter said, Hikashop has matured and it is time to focus on running the business as well as selling products. Otherwise it will be impossible for you to compete on a larger scale (for example with Magento etc.). Best regards, Zian EDITED: got it working with your suggestion. but some of the post still applies. Last edit: 11 years 11 months ago by [Zian](/forum/user/34782-zian "View Zian's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) 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/avatars/resized/size144/users/avatar_2013-02-01.png)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 11 years 11 months ago [\#178754](#178754) 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#178754 "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 ?")* Zia how did you get it working? It starts to become a major issue here with the accounting department and they want us to switch webshop.... We need a weekly CSV export to accounting and they go crazy with this export. I can't expect them to convert and convert before they import it in their accounting software. Accounts use windows and excel so there must be a proper way to make them happy. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 11 months ago [\#178790](#178790) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[order export puntuation](/forum/3-bug-report/75971-order-export-puntuation#178790 "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, The exported files are properly openable in Excel without changing anything of the CSV. Simply, when you open the CSV with Excel you need to make sure that it uses the correct punctuation to read the CSV file. See the answers of that link: [ stackoverflow.com/questions/11421260/csv-decimal-dot-in-excel](http://stackoverflow.com/questions/11421260/csv-decimal-dot-in-excel) It's a shame to want to switch the webshop just because Excel is not configured properly to open the CSV. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTk3MS1vcmRlci1leHBvcnQtcHVudHVhdGlvbj90bXBsPW1hcmtkb3du) 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.593 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)