[Skip to main content](#vessel-content) # Custom report ## - **[ltempest](/forum/user/1784-ltempest "View ltempest's Profile")** - [![ltempest's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1784-ltempest "View ltempest's Profile") Topic Author - [ Offline](/forum/user/1784-ltempest) Less More - Posts: 237 - Thank you received: 5 - - 9 years 9 months ago [\#260118](#260118) by [ltempest](/forum/user/1784-ltempest "View ltempest's Profile") *[Custom report](/forum/36-reports-statistics/888420-custom-report#260118 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I'd like to setup a custom report that includes, both the order and customer details. I can't see how to create a report that will export both the order details and the customer details in one CSV file. i have looked at the Mass Actions, and they work to a point, but I cannot seem to figure out how to order the fields being exported. I have found the export.php file which I can see does the clever stuff of exporting the data you select via the Reports menu option. Is it possible to modify this to include both the order details and the customer details in one CSV file. Thanks Lee")* was created by *[ltempest](/forum/user/1784-ltempest "View ltempest's Profile")* -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I'd like to setup a custom report that includes, both the order and customer details. I can't see how to create a report that will export both the order details and the customer details in one CSV file. i have looked at the Mass Actions, and they work to a point, but I cannot seem to figure out how to order the fields being exported. I have found the export.php file which I can see does the clever stuff of exporting the data you select via the Reports menu option. Is it possible to modify this to include both the order details and the customer details in one CSV file. Thanks Lee Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODg0MjAtY3VzdG9tLXJlcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 9 months ago [\#260194](#260194) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom report](/forum/36-reports-statistics/888420-custom-report#260194 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I'd like to setup a custom report that includes, both the order and customer details. I can't see how to create a report that will export both the order details and the customer details in one CSV file. i have looked at the Mass Actions, and they work to a point, but I cannot seem to figure out how to order the fields being exported. I have found the export.php file which I can see does the clever stuff of exporting the data you select via the Reports menu option. Is it possible to modify this to include both the order details and the customer details in one CSV file. Thanks Lee")* Hi, The mass action system can indeed export the order data together with the user data in a CSV file and you can choose the columns you want to export. However, there is no system to choose the order of the columns. The "export" button of the orders listing can also do such export but there is no option to choose which column to export. So the only solution to get exactly what you want will be to modify the code. For the mass action export, you would have to edit the function _exportCSV in the file administrator/components/com_hikashop/classes/massaction.php By changing the order of the fields in $params->action, you'll be able to do that. For the orders export button, you can edit the file "export" of the view "order" via the menu Display>Views. The first solution is easier to implement but you'll loose it each time you update HikaShop. The second will be a bit more complex but you'll keep the changes when you update your HikaShop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODg0MjAtY3VzdG9tLXJlcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ltempest](/forum/user/1784-ltempest "View ltempest's Profile")** - [![ltempest's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1784-ltempest "View ltempest's Profile") Topic Author - [ Offline](/forum/user/1784-ltempest) Less More - Posts: 237 - Thank you received: 5 - - 9 years 9 months ago [\#260220](#260220) by [ltempest](/forum/user/1784-ltempest "View ltempest's Profile") Replied by *[ltempest](/forum/user/1784-ltempest "View ltempest's Profile")* on topic *[Custom report](/forum/36-reports-statistics/888420-custom-report#260220 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I'd like to setup a custom report that includes, both the order and customer details. I can't see how to create a report that will export both the order details and the customer details in one CSV file. i have looked at the Mass Actions, and they work to a point, but I cannot seem to figure out how to order the fields being exported. I have found the export.php file which I can see does the clever stuff of exporting the data you select via the Reports menu option. Is it possible to modify this to include both the order details and the customer details in one CSV file. Thanks Lee")* Nicolas, Thanks for the reply. I would much prefer the editing of the export.php override, all be it I'm probably not going to upgrade past 2.6.4 because of the changes to the template views. Is there any documentation on how to customise the export.php to select the fields I require? I have found this thread: [ www.hikashop.com/forum/import-export-csv...r-export.html#239067](https://www.hikashop.com/forum/import-export-csv-xls/884310-edit-fields-in-order-export.html#239067) But not sure I understand it! could you give a better example? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODg0MjAtY3VzdG9tLXJlcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 9 months ago [\#260273](#260273) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom report](/forum/36-reports-statistics/888420-custom-report#260273 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I'd like to setup a custom report that includes, both the order and customer details. I can't see how to create a report that will export both the order details and the customer details in one CSV file. i have looked at the Mass Actions, and they work to a point, but I cannot seem to figure out how to order the fields being exported. I have found the export.php file which I can see does the clever stuff of exporting the data you select via the Reports menu option. Is it possible to modify this to include both the order details and the customer details in one CSV file. Thanks Lee")* Hi, I'm not sure what more I can say. There is even an example provided there with the code you can use to remove a column from the CSV: [ www.hikashop.com/forum/import-export-csv...r-export.html#239282](https://www.hikashop.com/forum/import-export-csv-xls/884310-edit-fields-in-order-export.html#239282) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODg0MjAtY3VzdG9tLXJlcG9ydD90bXBsPW1hcmtkb3du) 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.052 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)