[Skip to main content](#vessel-content) # Export all orders including order total ## - **[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")** - [![yanliom's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45218-yanliom "View yanliom's Profile") Topic Author - [ Offline](/forum/user/45218-yanliom) Less More - Posts: 66 - Thank you received: 1 - - 4 years 3 months ago [\#343821](#343821) by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") *[Export all orders including order total](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343821 "-- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis")* was created by *[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")* -- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ4MzQtZXhwb3J0LWFsbC1vcmRlcnMtaW5jbHVkaW5nLW9yZGVyLXRvdGFsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 4 years 2 months ago - 4 years 3 months ago [\#343822](#343822) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Export all orders including order total](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343822 "-- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis")* Hello, There is another way to export via CSV order data by using Massaction (from HikaShop Configuration, System dropdown => Mass actions), where you can select which data will be in the CSV file. But by clicking on the export button you have the total order (as on backend order listing) see my screenshot : [ ![alt](https://i.ibb.co/fCKDvGq/screenshot.png) ](https://i.ibb.co/fCKDvGq/screenshot.png "alt") Regards Last edit: 4 years 3 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ4MzQtZXhwb3J0LWFsbC1vcmRlcnMtaW5jbHVkaW5nLW9yZGVyLXRvdGFsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")** - [![yanliom's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45218-yanliom "View yanliom's Profile") Topic Author - [ Offline](/forum/user/45218-yanliom) Less More - Posts: 66 - Thank you received: 1 - - 4 years 2 months ago [\#343831](#343831) by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") Replied by *[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")* on topic *[Export all orders including order total](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343831 "-- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis")* Hello Philip, the order_full_price in the exported CSV does not match the order total when the payment method is Credit card. It seems that there is some problem with the decimal operator. Please see the problem in the attached screenshots: [ ![csv_export.jpg](/forum/attachment/55359) ](/forum/attachment/55359 "csv_export.jpg") [ ![admin.jpg](/forum/attachment/55358) ](/forum/attachment/55358 "admin.jpg") - [ ![admin.jpg](/forum/attachment/55358) ](/forum/attachment/55358 "admin.jpg") [ ](/forum/attachment/55358?download=1 "admin.jpg") - [ ![csv_export.jpg](/forum/attachment/55359) ](/forum/attachment/55359 "csv_export.jpg") [ ](/forum/attachment/55359?download=1 "csv_export.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ4MzQtZXhwb3J0LWFsbC1vcmRlcnMtaW5jbHVkaW5nLW9yZGVyLXRvdGFsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 4 years 2 months ago - 4 years 2 months ago [\#343838](#343838) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Export all orders including order total](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343838 "-- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis")* Hello, Indeed, we will need more elements to better understand the root issue, and so can you provide these elements : **1.** Backend user **references** (with maximum ACL) **2.** **Url link** to your backend access **Note :** Use our **[ Contact us](https://www.hikashop.com/support/contact-us.html)** form to provide these elements, don't forget to add **an Url link to this topic** to keep the link. Awaiting your returns to progress on your subject. Regards Last edit: 4 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDQ4MzQtZXhwb3J0LWFsbC1vcmRlcnMtaW5jbHVkaW5nLW9yZGVyLXRvdGFsP3RtcGw9bWFya2Rvd24=) 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.059 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)