[Skip to main content](#vessel-content) Board Categories Reports & Statistics ## # [Reports & Statistics](/forum/36-reports-statistics "View Category 'Reports & Statistics'") 341 topics | All there is to know about reports and statisctics | |---| ## | [ ](#forumbottom) | Subject | Replies / Views | Last Post | |---|---|---|---| | [](/forum/36-reports-statistics/896819-hikashop-dashboard-statistic-graph-not-working-correctly) | [hikashop dashboard statistic graph not working correctly](/forum/36-reports-statistics/896819-hikashop-dashboard-statistic-graph-not-working-correctly "Hello, since updating to 4.0.1 the dashboard graph does not show values correctly see: www.screencast.com/t/k41DZMypJTj see also: www.screencast.com/t/mHH5WsW6 I checked the order statuses configurations and everything seems fine there, see: www.screencast.com/t/Tendm9AF the order listing works fine and I can correctly generate reports, it's just the dashboard graph that is not working, so it's not a big issue, but it was handy to be able to check the months orders quickly form there Thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 9 months ago, by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") [Last Post](/forum/36-reports-statistics/896819-hikashop-dashboard-statistic-graph-not-working-correctly#303484 "Anyway, look... it's not a big issue, I'll just create a mass action to change all created orders to pending after 3 days and will set created orders to show in the statistics too, I just tried and...") 7 years 9 months ago by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") | Replies:5 Views:2011 | [Last Post](/forum/36-reports-statistics/896819-hikashop-dashboard-statistic-graph-not-working-correctly#303484 "Anyway, look... it's not a big issue, I'll just create a mass action to change all created orders to pending after 3 days and will set created orders to show in the statistics too, I just tried and...") by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") 7 years 9 months ago | | [](/forum/36-reports-statistics/896736-question-about-a-specific-annual-report-view) | [Question about a specific annual report view](/forum/36-reports-statistics/896736-question-about-a-specific-annual-report-view "Hello, Is there a possibility to generate a view at the end of the year with the list of the products, and for each product three numbers: - how many item od each product where in the stock 1.1 - how many items were sold - how many items are left as of 31.12 (or 1.1 next year) All the products in one view. I am new to Reports so thanks for your help!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 9 months ago, by [bolando](/forum/user/38611-bolando "View bolando's Profile") [Last Post](/forum/36-reports-statistics/896736-question-about-a-specific-annual-report-view#302972 "Hi, There is no option to do that. With the reports system you can have a list of the products with the number of items sold over the past year. You can configure it like that: monosnap.com/file/zekCEH79ovx8Pvtj1Cvxxhqdw8rL2P If you wanted to do what you're talking about it would require manual calculations or your own script to generate a report like that.") 7 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1621 | [Last Post](/forum/36-reports-statistics/896736-question-about-a-specific-annual-report-view#302972 "Hi, There is no option to do that. With the reports system you can have a list of the products with the number of items sold over the past year. You can configure it like that: monosnap.com/file/zekCEH79ovx8Pvtj1Cvxxhqdw8rL2P If you wanted to do what you're talking about it would require manual calculations or your own script to generate a report like that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 9 months ago | | [](/forum/36-reports-statistics/896728-new-reporting-module-request) | [New reporting module request](/forum/36-reports-statistics/896728-new-reporting-module-request "-- HikaShop version -- : 4.0.2 -- Joomla version -- : 3.9.2 -- PHP version -- : 7.1.20 -- Browser(s) name and version -- : Firefox latest Hi, May I suggest to build a completely new reporting module? One that is more flexible in terms of what to export, and how to filter, order and summarize. The current reporting possibilities partly overlap, and all in all not everything is present that a business needs, for example for it's tax reports. Like a report by VAT (tax) category, report by product, by customer, etc. My suggestion would be: Filters: like those in "Reports" plus - date/time ranges - customer (category) - address (country/region/city etc) - tax category Grouping and sorting on above items, so it's possible to report by product(group), country, tax category, etc. Sums only, or details (individual order lines) Items to show: selection like in Mass Actions I feel this would make the reporting much clear and above all much more useful! Regards, Eric") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 9 months ago, by [ericdewaal](/forum/user/57169-ericdewaal "View ericdewaal's Profile") [Last Post](/forum/36-reports-statistics/896728-new-reporting-module-request#302953 "Hi, Thank you for your feedback. We'll take that into account for future developments. Note that for tax reports, you should use the listing you have when you go in the menu System>Taxes and click on the "manage tax rates" button. There, you'll have the sum of the taxes for each tax rate and you can use the date fields at the top to limit the calculations to only the period you need.") 7 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1949 | [Last Post](/forum/36-reports-statistics/896728-new-reporting-module-request#302953 "Hi, Thank you for your feedback. We'll take that into account for future developments. Note that for tax reports, you should use the listing you have when you go in the menu System>Taxes and click on the "manage tax rates" button. There, you'll have the sum of the taxes for each tax rate and you can use the date fields at the top to limit the calculations to only the period you need.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 9 months ago | | [](/forum/36-reports-statistics/896719-where-to-enter-product-cost-versus-the-sell-price-to-customers) | [Where to enter product cost (versus the sell price to customers)](/forum/36-reports-statistics/896719-where-to-enter-product-cost-versus-the-sell-price-to-customers "-- url of the page with the problem -- : pumpkinvines.com/e -- HikaShop version -- : 4.0.2 -- Joomla version -- : 3.9.1 -- PHP version -- : 7.1.22 Working on setting up a new online shop using HikaShop Business. I would like to record the cost of an item (how much it costs ME) I do not want this information shown to customers. It would be for my own records. Is there a way to do this? Thanks K") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 9 months ago, by [diaperaddict](/forum/user/46326-diaperaddict "View diaperaddict's Profile") [Last Post](/forum/36-reports-statistics/896719-where-to-enter-product-cost-versus-the-sell-price-to-customers#302885 "Yes. You can create a custom field of the table "product" and of the type "text" via the menu Display>Custom fields for that.") 7 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1147 | [Last Post](/forum/36-reports-statistics/896719-where-to-enter-product-cost-versus-the-sell-price-to-customers#302885 "Yes. You can create a custom field of the table "product" and of the type "text" via the menu Display>Custom fields for that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 9 months ago | | [](/forum/36-reports-statistics/896613-how-to-print-a-product-list) | [How to print a product list](/forum/36-reports-statistics/896613-how-to-print-a-product-list "-- url of the page with the problem -- : aquacorals.com -- HikaShop version -- : 4.0.1 -- Joomla version -- : 3.9.1 -- PHP version -- : 7.2 -- Browser(s) name and version -- : Firefox 63.0.3 Is there a way to print a product variant list with prices?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 10 months ago, by [a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile") [Last Post](/forum/36-reports-statistics/896613-how-to-print-a-product-list#302491 "Hi, Then, you can change temporarily the "characteristic selection method" setting of the HikaShop configuration to "list" and access the product page on the frontend. You'll have a listing of variants there which should be nicer than what you have in the backend.") 7 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:1391 | [Last Post](/forum/36-reports-statistics/896613-how-to-print-a-product-list#302491 "Hi, Then, you can change temporarily the "characteristic selection method" setting of the HikaShop configuration to "list" and access the product page on the frontend. You'll have a listing of variants there which should be nicer than what you have in the backend.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 10 months ago | | [](/forum/36-reports-statistics/896599-deactivate-exchange-rates-cron-report-email) | [deactivate exchange rates cron report email](/forum/36-reports-statistics/896599-deactivate-exchange-rates-cron-report-email "-- HikaShop version -- : 4.0.1 -- Joomla version -- : 3.9.1 -- PHP version -- : 7.2 i want to deactivate the cron report for the exchange rates, the rest should stay as it is. how can i do this?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 10 months ago, by [n00bster](/forum/user/56367-n00bster "View n00bster's Profile") [Last Post](/forum/36-reports-statistics/896599-deactivate-exchange-rates-cron-report-email#302268 "Hi, There is no setting to send the cron report for some tasks and not other tasks. It's either: - send no email at all - send an email when at least a task is triggered - send an email for each cron trigger, even when no task is triggered These can be selected with the "send a report" setting of your screenshot. If you want something else, that would require code customization to the core of the cron trigger system in HikaShop. I don't recommend changing that as you'll loose your changes after each update of HikaShop.") 7 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1360 | [Last Post](/forum/36-reports-statistics/896599-deactivate-exchange-rates-cron-report-email#302268 "Hi, There is no setting to send the cron report for some tasks and not other tasks. It's either: - send no email at all - send an email when at least a task is triggered - send an email for each cron trigger, even when no task is triggered These can be selected with the "send a report" setting of your screenshot. If you want something else, that would require code customization to the core of the cron trigger system in HikaShop. I don't recommend changing that as you'll loose your changes after each update of HikaShop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 10 months ago | | [](/forum/36-reports-statistics/896548-report-sales-by-quantity) | [Report Sales by Quantity?](/forum/36-reports-statistics/896548-report-sales-by-quantity "-- HikaShop version -- : 4.0.1 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.25 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : No Errors - this is a reports question In the Admin, under Orders, Reports - my customer can't find a good report that shows ALL the items sold, with quantities. Right now she just sees total sales. For instance, we have a report "All Items Sold" which is a 'Listing' of 'Products. It shows the 'Name', the 'ID', and the 'Total' (sales in dollars). Can we add a column to that report that also shows the Quantity sold? If not, can you tell me how to create a new report that his Item name with Qty Sold and total sales?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 10 months ago, by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") [Last Post](/forum/36-reports-statistics/896548-report-sales-by-quantity#302055 "Thanks Nicolas, I will try that!") 7 years 10 months ago by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") | Replies:2 Views:1618 | [Last Post](/forum/36-reports-statistics/896548-report-sales-by-quantity#302055 "Thanks Nicolas, I will try that!") by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") 7 years 10 months ago | | [](/forum/36-reports-statistics/896423-backend-dashboard-legacy-doesnt-work) | ["Backend dashboard legacy" doesn't work](/forum/36-reports-statistics/896423-backend-dashboard-legacy-doesnt-work "-- HikaShop version -- : 4.0.1 -- Joomla version -- : 3.9.1 -- PHP version -- : 7.1.24 Hello. I've kept the "Backend dashboard legacy" active, because it lets me customize the reports. After I upgraded to Hikashop Business 4.0.0, the old dashboard throws this error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON a.o' at line 1 I upgraded to 4.0.1 but the issue persists. Can you help, please?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 11 months ago, by [panefs](/forum/user/35481-panefs "View panefs's Profile") [Last Post](/forum/36-reports-statistics/896423-backend-dashboard-legacy-doesnt-work#301520 "Thank you very much, that worked great. I was able to isolate and delete the report that was giving the error.") 7 years 11 months ago by [panefs](/forum/user/35481-panefs "View panefs's Profile") | Replies:4 Views:2074 | [Last Post](/forum/36-reports-statistics/896423-backend-dashboard-legacy-doesnt-work#301520 "Thank you very much, that worked great. I was able to isolate and delete the report that was giving the error.") by [panefs](/forum/user/35481-panefs "View panefs's Profile") 7 years 11 months ago | | [](/forum/36-reports-statistics/896397-adwords-plugin) | [Adwords plugin](/forum/36-reports-statistics/896397-adwords-plugin "I have found multiple topics about attempts to report hikashop sales to Adwords. The most current solution seems to be to hack the return page of the payment method to report the sales to Adwords: www.hikashop.com/forum/reports-statistic...dwords-tracking.html But you need to add some code to also track the actual amount of the purchase. However, I prefer to use standard solutions than to make hacks everywhere in the code. I wonder why there isn't one general plugin that does this? I am sure that most hikashop users run Adwords campaigns too, and there is already an Analytics plugin that AFAIK does for Analytics what we need for Adwords: reporting the exact value of each sale. Why not do the same for Adwords? If someone already made a plugin, please set it for sale so we all can buy it.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 11 months ago, by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") [Last Post](/forum/36-reports-statistics/896397-adwords-plugin#301504 "Hi, 0. The img link is an idea but I'm not sure as the initiator would be the server, not the customer, it might not work properly. 1. Finding the order data on the thank you page won't be a problem as you hav ehte order_id stored in the session of the customer. That's what the google analytics plugin uses when it is used in "javascript mode". 2. Ok, I see. thanks for the details. 3. Frankly I don't see us developing it in the short term as we didn't get much requests so far for it besides you. I suppose that most people use the Google Analytics plugin and import the data from Analytics to Adwords as we talked about before. So there isn't much insentive. Now, if you want to pay someone to develop the plugin, you can contact our partners: www.hikashop.com/home/our-partners.html For example, Obsidev and TsukiDev have developed many plugins for HikaShop and published them on our marketplace so maintenance in the long run won't be a problem with them.") 7 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:1429 | [Last Post](/forum/36-reports-statistics/896397-adwords-plugin#301504 "Hi, 0. The img link is an idea but I'm not sure as the initiator would be the server, not the customer, it might not work properly. 1. Finding the order data on the thank you page won't be a problem as you hav ehte order_id stored in the session of the customer. That's what the google analytics plugin uses when it is used in "javascript mode". 2. Ok, I see. thanks for the details. 3. Frankly I don't see us developing it in the short term as we didn't get much requests so far for it besides you. I suppose that most people use the Google Analytics plugin and import the data from Analytics to Adwords as we talked about before. So there isn't much insentive. Now, if you want to pay someone to develop the plugin, you can contact our partners: www.hikashop.com/home/our-partners.html For example, Obsidev and TsukiDev have developed many plugins for HikaShop and published them on our marketplace so maintenance in the long run won't be a problem with them.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 11 months ago | | [](/forum/36-reports-statistics/896003-sales-breakdown-by-category-broken) | [Sales breakdown by Category broken](/forum/36-reports-statistics/896003-sales-breakdown-by-category-broken "-- HikaShop version -- : 3.5.0 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1 Situation: I am trying to show the yearly sales for two master categories. However, some products exist within multiple subcategories. For example, Product A might exist in Master A - > Subcategory A and Master A -> subcategory B. In the reports, i would think that it would filter through this and calculate the total for a given product no matter if it exist in multiple categories. However, this is what displays for the total yearly breakdown (no category filter) and is the correct total for each month: with the following settings (no category filter): Now if i choose the first master category (products in this case): with settings (only thing different is "Products" selected as the category): Is this just a config error or is something broken? Odd that the category specific case shows MUCH HIGHER totals and is definitely incorrect. I would like to just break down the monthly sales into "products" and "parts" which are both main categories. I should also note we may have one or two products that exist in both "products" and "parts" but that shouldn't skew the data too much.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 3 weeks ago, by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") [Last Post](/forum/36-reports-statistics/896003-sales-breakdown-by-category-broken#301150 "Gotcha. I misunderstood. It took some time to manually select each individual product, but the report now displays properly. Thanks for your help! Hopefully, I will be able to upgrade our hikashop version after the first of the year.") 7 years 11 months ago by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") | Replies:14 Views:1806 | [Last Post](/forum/36-reports-statistics/896003-sales-breakdown-by-category-broken#301150 "Gotcha. I misunderstood. It took some time to manually select each individual product, but the report now displays properly. Thanks for your help! Hopefully, I will be able to upgrade our hikashop version after the first of the year.") by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") 7 years 11 months ago | | [](/forum/36-reports-statistics/896219-order-summary-export) | [Order summary export](/forum/36-reports-statistics/896219-order-summary-export "-- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.12 -- PHP version -- : 5.6.37 -- Browser(s) name and version -- : Chrome When i export the table of order summaries from hikashop many of the orders are not listing the product ordered. This export summary is needed so we can reconcile our accounts but with missing details we cannot do this. When i go into an individual order the product ordered is shown. It is too time consuming to go into each order to achieve this. We should be able to see this information in the complete report Is there a chance i need to make at this end thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 1 day ago, by [cmoorhouse](/forum/user/38971-cmoorhouse "View cmoorhouse's Profile") [Last Post](/forum/36-reports-statistics/896219-order-summary-export#300801 "Hello, If you cannot provide private links, then send a message to the contact forum, we will reply to you and you will be able to add your attachments to the email. Best regards,") 7 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:10 Views:2149 | [Last Post](/forum/36-reports-statistics/896219-order-summary-export#300801 "Hello, If you cannot provide private links, then send a message to the contact forum, we will reply to you and you will be able to add your attachments to the email. Best regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 7 years 11 months ago | | [](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports) | [No correlation between orders and reports](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports "-- url of the page with the problem -- : aradtextile.com -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 Hello, We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off. Please advice, Guy.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 6 days ago, by [theguy](/forum/user/32584-theguy "View theguy's Profile") [Last Post](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300746 "Thank you very much Jerome. Looking forward for the next release :)") 7 years 11 months ago by [theguy](/forum/user/32584-theguy "View theguy's Profile") | Replies:8 Views:1908 | [Last Post](/forum/36-reports-statistics/896186-no-correlation-between-orders-and-reports#300746 "Thank you very much Jerome. Looking forward for the next release :)") by [theguy](/forum/user/32584-theguy "View theguy's Profile") 7 years 11 months ago | | [](/forum/36-reports-statistics/896103-last-x-orders-info) | [Last X orders info](/forum/36-reports-statistics/896103-last-x-orders-info "-- HikaShop version -- : 4 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : none Hi I have a widget showing most recent orders, it shows: INV No. - Customer - Status - Total in the customer part, it shows the customer name, then email address twice, once in brackets, once with edit pen. Asxxxxgh Bxxxxn ( ) edit [1] can I change that to just the name? [2] Can I add the date of the sale? thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 2 weeks ago, by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") [Last Post](/forum/36-reports-statistics/896103-last-x-orders-info#299915 "excellent :) thanks nicolas") 8 years 2 weeks ago by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") | Replies:2 Views:2052 | [Last Post](/forum/36-reports-statistics/896103-last-x-orders-info#299915 "excellent :) thanks nicolas") by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") 8 years 2 weeks ago | | [](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column) | [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 "-- 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.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 2 weeks ago, by [rwestpga](/forum/user/57248-rwestpga "View rwestpga's Profile") [Last Post](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299806 "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: to: in the file administrator/components/com_hikashop/classes/widget.php") 8 years 2 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:1902 | [Last Post](/forum/36-reports-statistics/896083-report-generation-item-sales-by-date-range-with-tax-in-separate-column#299806 "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: to: in the file administrator/components/com_hikashop/classes/widget.php") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 2 weeks ago | | [](/forum/36-reports-statistics/895819-product-statistics-at-front-end) | [Product statistics at front end](/forum/36-reports-statistics/895819-product-statistics-at-front-end "Hi. Can I show different statistics for a product on my clients? I see that in the administration I can show everything and at the front end can it?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 1 month ago, by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") [Last Post](/forum/36-reports-statistics/895819-product-statistics-at-front-end#298572 "Hello, As this option shown in the Filters part on my screenshot : You can create as much report as you want for only 1 products, the rest will depends from other you settings. Hope this will help you to get what you needs. Regards") 8 years 1 month ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:5 Views:1714 | [Last Post](/forum/36-reports-statistics/895819-product-statistics-at-front-end#298572 "Hello, As this option shown in the Filters part on my screenshot : You can create as much report as you want for only 1 products, the rest will depends from other you settings. Hope this will help you to get what you needs. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 8 years 1 month ago | | [](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number) | [Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 2 months ago, by [gasoline](/forum/user/6454-gasoline "View gasoline's Profile") [Last Post](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297612 "Hello, If you delete orders via "Hikashop->Orders", it will delete datas of your order through your database and you won't have any trace of that order. If you want to display product from "confirmed" / "paid" orders, you'll just have to set the "Order status" option of your report to "confirmed". Kind regards, Mohamed Thelji.") 8 years 2 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:5 Views:2028 | [Last Post](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297612 "Hello, If you delete orders via "Hikashop->Orders", it will delete datas of your order through your database and you won't have any trace of that order. If you want to display product from "confirmed" / "paid" orders, you'll just have to set the "Order status" option of your report to "confirmed". Kind regards, Mohamed Thelji.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 8 years 2 months ago | | [](/forum/36-reports-statistics/895525-dashboards-widgets-and-exports-editable-or-not) | [Dashboards widgets and exports, editable or not?](/forum/36-reports-statistics/895525-dashboards-widgets-and-exports-editable-or-not "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.11 -- PHP version -- : 7.1.20 -- Browser(s) name and version -- : Firefox, Chrome Hi, The documentation for Orders / Reports says: "This screen enables you to manage all your reports and therefore your dashboard's widgets." But the Dashbord widgets seem to come from somewhere else. When I edit, depublish or even delete all reports, the dashboard still looks the same! How does this work? Also, it would be great to be able to select which columns end up in exports, as the current info is quite overwhelming for my clients. Is this possible somehow? Regards, Eric") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 2 months ago, by [ericdewaal](/forum/user/57169-ericdewaal "View ericdewaal's Profile") [Last Post](/forum/36-reports-statistics/895525-dashboards-widgets-and-exports-editable-or-not#297218 "Hi, 5. And again, thanks a lot in advance. Getting better all the time!") 8 years 2 months ago by [ericdewaal](/forum/user/57169-ericdewaal "View ericdewaal's Profile") | Replies:11 Views:2199 | [Last Post](/forum/36-reports-statistics/895525-dashboards-widgets-and-exports-editable-or-not#297218 "Hi, 5. And again, thanks a lot in advance. Getting better all the time!") by [ericdewaal](/forum/user/57169-ericdewaal "View ericdewaal's Profile") 8 years 2 months ago | | [](/forum/36-reports-statistics/895388-affiliate-program) | [Affiliate program](/forum/36-reports-statistics/895388-affiliate-program "I would like to know if there is a way to know that a specific purchase has been made from a specific site. I'll explain: hikashop is installed at www.Asite.com the products are also advertised on the websites www.Bsite.com and www.Csite.com . I would like to make sure that there is a trace of the customer's provenance to www.Asite.com . For example with a token in the URL: www.Asite.com/checkout?token=www.Bsite.com Is there any way to do this?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 3 months ago, by [testdrive](/forum/user/50310-testdrive "View testdrive's Profile") [Last Post](/forum/36-reports-statistics/895388-affiliate-program#296102 "Hi, 1. It's a one-off fee. After that you can use your HikaShop Business for as long as you want. On top of that, you get a 1 year free subscription to updates and support that you can renew for 60€ a year, but it's not mandatory. Your HikaShop will continue to run on your website after that even if you don't renew. However, you won't be able to update it and thus, if you update your Joomla, you might end up at some point with bugs due to things changing in Joomla that would require also updating your HikaShop. 2. yes, you can just upgrade. You will have to install the HikaShop Business install package and it will automaticale perform the upgrade. You won't loose your data, like a normal update of HikaShop.") 8 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:2597 | [Last Post](/forum/36-reports-statistics/895388-affiliate-program#296102 "Hi, 1. It's a one-off fee. After that you can use your HikaShop Business for as long as you want. On top of that, you get a 1 year free subscription to updates and support that you can renew for 60€ a year, but it's not mandatory. Your HikaShop will continue to run on your website after that even if you don't renew. However, you won't be able to update it and thus, if you update your Joomla, you might end up at some point with bugs due to things changing in Joomla that would require also updating your HikaShop. 2. yes, you can just upgrade. You will have to install the HikaShop Business install package and it will automaticale perform the upgrade. You won't loose your data, like a normal update of HikaShop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 3 months ago | | [](/forum/36-reports-statistics/895089-last-7-days-or-last-week) | ['Last 7 days' or 'last week'](/forum/36-reports-statistics/895089-last-7-days-or-last-week "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.8 Hi, I'm struggling with reports. It is about a shop that has specific opening hours every week (orders can be placed weekly from monday at noon until thursday at noon - and deliviery will be on friday/saturday). This shop has mostly the same group of customers every week. My client needs reports, so on thursday afternoon he has to have an overview of the amount of ordererd products. I have configured reports for that. But something seems 'off'. Sometimes, not all the orders are included in the totals. I have tried and looked for the cause of this so many times. Sometimes it seems like - if orders come in on monday short after opening hour) - these very early orders are not included. But I can't be really sure if that is case. It is lots of work to check the totals 'by hand' because we are talking about 70+ products every week. I was wondering: in the report I can choose for a period called 'Last week'. When does the week start and end in this option? And what if I choose 'Last 7 days'? Is the current day included in this period? If you can answer this for me, that would be helpful to find out why the totals are not always rigth (and sometimes, they are...) An option to create a weekly report where you can define the beginning and the end, just like the opening hours. Seems so much easier :-) Thanks. Niqui") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 4 months ago, by [niqui](/forum/user/2055-niqui "View niqui's Profile") [Last Post](/forum/36-reports-statistics/895089-last-7-days-or-last-week#294556 "Hi, "Last 7 days" is the time from 7days from now to now. "This week" is the time from monday at 00.00 to now. "Last week" is the time from monday at 00.00 last week to sunday at 23.59 last week. Please also note that the timezone settings of your user/your website/your server can influence these so that could explain why orders from monday morning would be missing if you use "last/this week" Using "Last 7 days" would indeed prevent that from happening.") 8 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:2664 | [Last Post](/forum/36-reports-statistics/895089-last-7-days-or-last-week#294556 "Hi, "Last 7 days" is the time from 7days from now to now. "This week" is the time from monday at 00.00 to now. "Last week" is the time from monday at 00.00 last week to sunday at 23.59 last week. Please also note that the timezone settings of your user/your website/your server can influence these so that could explain why orders from monday morning would be missing if you use "last/this week" Using "Last 7 days" would indeed prevent that from happening.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 4 months ago | | [](/forum/36-reports-statistics/894891-options-in-report) | [Options in report](/forum/36-reports-statistics/894891-options-in-report "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.0.29 Hi i made some options to my products (names of participants). Now my question is. where can i find these option, because i want them in my reports. So i sell a product (event) and i want a report (list) with the soled product and the participants. Can you tell me how to do that or redirect me to some documentation on how to do that ? regards jan") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 5 months ago, by [Polleke](/forum/user/39281-polleke "View Polleke's Profile") [Last Post](/forum/36-reports-statistics/894891-options-in-report#293520 "Hello, Sorry but I'm not sure to follow you, can you be more specific, with some concrete example ? Apologies for this return. Regards") 8 years 5 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:1 Views:2682 | [Last Post](/forum/36-reports-statistics/894891-options-in-report#293520 "Hello, Sorry but I'm not sure to follow you, can you be more specific, with some concrete example ? Apologies for this return. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 8 years 5 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)