[Skip to main content](#vessel-content) # Report Generation - Item Sales by Date Range, with Tax in separate column. ## - **[rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile")** - [![rwestpga's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/57248-rwestpga "View rwestpga's Profile") Topic Author - [ Offline](/forum/user/57248-rwestpga) Less More - Posts: 24 - Thank you received: 1 - - 8 years 2 weeks ago [\#299720](#299720) by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") *[Report Generation - Item Sales by Date Range, with Tax in separate column.](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299720 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help.")* was created by *[rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile")* -- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYwODMtcmVwb3J0LWdlbmVyYXRpb24taXRlbS1zYWxlcy1ieS1kYXRlLXJhbmdlLXdpdGgtdGF4LWluLXNlcGFyYXRlLWNvbHVtbj90bXBsPW1hcmtkb3du) 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 - - 8 years 2 weeks ago [\#299733](#299733) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Generation - Item Sales by Date Range, with Tax in separate column.](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299733 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help.")* Hi, 1. I don't see a way to do that in one screen. The number of items sold for each product is something used for your own statistics, marketing or even inventory. The taxes collected is something used for tax reporting. Having a screen to get the taxes collected for each product in a period doesn't usually make sense for tax reporting since normally you just enter the total amount in the papers you give to the administration. If you want to get a total of the tax collected for each tax rate over a particular period, you can access the "manage tax rates" button of the System>Taxes menu. It's done especially for that. And if you want to get the number of items sold for each product, you can configure a report in the menu Orders>Reports. But doing both at the same time is not possible with the default views of HikaShop. 2. That's not a problem of the export. That's a problem of the CSV reader tool you're using (or the way you configured it) which doesn't handle the comma as a separator. If you use LibreOffice (the free equivalent to excel) it will handle the commas properly. For Excel, it depends on the version you're using, and your locale. So versions handles the comma by default, some the semi colons, and there is usually a setting to change that. Also, in the HikaShop configuration, there is a setting in the main tab, in the files section to change the CSV separator. So you could change that setting too. The following user(s) said Thank You: [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYwODMtcmVwb3J0LWdlbmVyYXRpb24taXRlbS1zYWxlcy1ieS1kYXRlLXJhbmdlLXdpdGgtdGF4LWluLXNlcGFyYXRlLWNvbHVtbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile")** - [![rwestpga's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/57248-rwestpga "View rwestpga's Profile") Topic Author - [ Offline](/forum/user/57248-rwestpga) Less More - Posts: 24 - Thank you received: 1 - - 8 years 2 weeks ago [\#299746](#299746) by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") Replied by *[rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile")* on topic *[Report Generation - Item Sales by Date Range, with Tax in separate column.](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299746 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help.")* Thanks Nicolas - I'll try to make due with what you have. For #2, I was able to change the setting to 'comma'. However, the report is setup to show Product Name, Orders, and Total. But after clicking 'Export', the 'Total' column does not transfer. I've attached screenshots. Can this be fixed? Not sure if i'm doing something wrong... - [ ![report.jpg](/forum/attachment/45223) ](/forum/attachment/45223 "report.jpg") [ ](/forum/attachment/45223?download=1 "report.jpg") - [ ![export.jpg](/forum/attachment/45224) ](/forum/attachment/45224 "export.jpg") [ ](/forum/attachment/45224?download=1 "export.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYwODMtcmVwb3J0LWdlbmVyYXRpb24taXRlbS1zYWxlcy1ieS1kYXRlLXJhbmdlLXdpdGgtdGF4LWluLXNlcGFyYXRlLWNvbHVtbj90bXBsPW1hcmtkb3du) 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 - - 8 years 2 weeks ago [\#299763](#299763) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Generation - Item Sales by Date Range, with Tax in separate column.](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299763 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help.")* Hi, Can you provide a screenshot of all the settings of your report ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYwODMtcmVwb3J0LWdlbmVyYXRpb24taXRlbS1zYWxlcy1ieS1kYXRlLXJhbmdlLXdpdGgtdGF4LWluLXNlcGFyYXRlLWNvbHVtbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile")** - [![rwestpga's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/57248-rwestpga "View rwestpga's Profile") Topic Author - [ Offline](/forum/user/57248-rwestpga) Less More - Posts: 24 - Thank you received: 1 - - 8 years 2 weeks ago [\#299802](#299802) by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") Replied by *[rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile")* on topic *[Report Generation - Item Sales by Date Range, with Tax in separate column.](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299802 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help.")* Sure thing...thx! - [ ![report_2018-10-29.jpg](/forum/attachment/45228) ](/forum/attachment/45228 "...2018-10-29.jpg") [ ](/forum/attachment/45228?download=1 "...2018-10-29.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYwODMtcmVwb3J0LWdlbmVyYXRpb24taXRlbS1zYWxlcy1ieS1kYXRlLXJhbmdlLXdpdGgtdGF4LWluLXNlcGFyYXRlLWNvbHVtbj90bXBsPW1hcmtkb3du) 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 - - 8 years 2 weeks ago [\#299806](#299806) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report Generation - Item Sales by Date Range, with Tax in separate column.](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299806 "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox We are trying to get some very simple reporting of what we sold. I can't seem to configure anything that separates what we need. Do you have a report that can be configured to: 1) Show how many items sold in a date range? It should list the item, how many were sold, and how much tax collected in a separate column The customer should be able to just go to the report, put in the dates, then have the info show up on screen. 2) When trying to EXPORT, all the data is in 1 column, separated by commas. Nothing lines up, is totaled, or makes any sense at all. PLEASE HELP! Current report capabilities seem useless, or we are not understanding how to create what we need. Thanks in advance for your help.")* Hi, Ok, I see what you mean. Well, it's not really a bug. When you select "sales" under the "specific options" area, it gives you the total amount of the sales for the products. When you select instead "orders", it gives you the quantity. As an added bonus, on the displayed listing, we also display the total amount as we can easily have it, but it's not the focus in such case. That's why it's not included in the CSV export. But we could of course add it to the CSV, it's just a matter of changing a bit the code. We'll add that for the next version of HikaShop. If you want to do it before then, you can change the code: Code: $widget->exportFields=array('order_product_name', 'Total'); to: Code: $widget->exportFields=array('order_product_name', 'Total'); }elseif($widget->widget_params->product_data=='orders'){ $widget->exportFields=array('order_product_name', 'quantity', 'Total'); in the file administrator/components/com_hikashop/classes/widget.php Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTYwODMtcmVwb3J0LWdlbmVyYXRpb24taXRlbS1zYWxlcy1ieS1kYXRlLXJhbmdlLXdpdGgtdGF4LWluLXNlcGFyYXRlLWNvbHVtbj90bXBsPW1hcmtkb3du) 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.080 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)