[Skip to main content](#vessel-content) # Detailed reports ## - **[MrBean](/forum/user/26959-mrbean "View MrBean's Profile")** - [![MrBean's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26959-mrbean "View MrBean's Profile") Topic Author - [ Offline](/forum/user/26959-mrbean) Less More - Posts: 29 - Thank you received: 0 - - 6 years 1 month ago - 6 years 1 month ago [\#324113](#324113) by [MrBean](/forum/user/26959-mrbean "View MrBean's Profile") *[Detailed reports](/forum/36-reports-statistics/900830-detailed-reports#324113 "Hi Guys how do we go about creating say a weekly report that shows Sales by customer with date and details of the order - eg a list of the products? Also I am finding when I export to open in Excel the format is unreadable. I can go through an import CSV if I save the file but I have to selct delimited then : etc This makes it hard for client to get a simple report of Sales and products - there is so much useless data in the CSV which makes it very un-user friendly for the person that needs to reconcile sales")* was created by *[MrBean](/forum/user/26959-mrbean "View MrBean's Profile")* Hi Guys how do we go about creating say a weekly report that shows Sales by customer with date and details of the order - eg a list of the products? Also I am finding when I export to open in Excel the format is unreadable. I can go through an import CSV if I save the file but I have to selct delimited then : etc This makes it hard for client to get a simple report of Sales and products - there is so much useless data in the CSV which makes it very un-user friendly for the person that needs to reconcile sales Last edit: 6 years 1 month ago by [MrBean](/forum/user/26959-mrbean "View MrBean's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA4MzAtZGV0YWlsZWQtcmVwb3J0cz90bXBsPW1hcmtkb3du) 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: 86541 - Thank you received: 14304 - - 6 years 1 month ago [\#324122](#324122) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Detailed reports](/forum/36-reports-statistics/900830-detailed-reports#324122 "Hi Guys how do we go about creating say a weekly report that shows Sales by customer with date and details of the order - eg a list of the products? Also I am finding when I export to open in Excel the format is unreadable. I can go through an import CSV if I save the file but I have to selct delimited then : etc This makes it hard for client to get a simple report of Sales and products - there is so much useless data in the CSV which makes it very un-user friendly for the person that needs to reconcile sales")* Hi, If the CSV file is not easily opened with Excel, that's because of the CSV separator chosen in the Files section of the Hikashop configuration. Change it to the one your Excel prefers and that's it. Also, if you want to only have the columns you want, you can create a mass action of the type "order" via the menu System>Mass actions with an action "export CSV file". You'll be able to choose the columns you want, and add a filter on the order_created or order_invoice_created column of the orders and then click on the "proceed" button to get the CSV file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA4MzAtZGV0YWlsZWQtcmVwb3J0cz90bXBsPW1hcmtkb3du) 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)