[Skip to main content](#vessel-content)

Board Categories Reports &amp; Statistics

##

#  [Reports &amp; Statistics](/forum/36-reports-statistics "View Category 'Reports &amp; Statistics'")  341 topics

| All there is to know about reports and statisctics |
|---|

##

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post |
|---|---|---|---|
| [](/forum/36-reports-statistics/904682-report-show-errorss) | [Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM #&#95;&#95;hikashop&#95; AS a' at line 1  Hi, can you help to check why error shows out in the report")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 4 years 4 months ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")       [Last Post](/forum/36-reports-statistics/904682-report-show-errorss#343027 "Hi,  I changed code in several different places so it will be hard to patch manually. It will be easier to just wait for the next release to update. But you can ignore the error. Just delete the report and recreate a new one and you should not have the problem.") 4 years 4 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5  Views:948 | [Last Post](/forum/36-reports-statistics/904682-report-show-errorss#343027 "Hi,  I changed code in several different places so it will be hard to patch manually. It will be easier to just wait for the next release to update. But you can ignore the error. Just delete the report and recreate a new one and you should not have the problem.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 years 4 months ago |
| [](/forum/36-reports-statistics/904539-orders-listing-actions-export-a-csv-file-results-in-class-dbug-not-found) | [Orders listing, Actions, Export a CSV file results in Class 'dbug' not found](/forum/36-reports-statistics/904539-orders-listing-actions-export-a-csv-file-results-in-class-dbug-not-found "-- HikaShop version -- : 4.6.0 -- Joomla version -- : 3.10.9 -- PHP version -- : 7.49 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 0 Class 'dbug' not found  If we go to Orders, and select an order (we are trying to select all monthly orders for the previous month, etc. but it doesn't matter what you filter on).  Then select items (all, or a single order). Then Select Actions + Export as CSV File  Sometimes I can get results by unselecting specific fields, but it would be nice to trap this error to know what the cause is.  For example, on some orders I can select all fields without a problem. Then when I try to add fields to the selection list, the system throws this error.  I am trying to create a monthly sales detail report. This used to work when just using the EXPORT button, but now we lose order details...it only exports the order header information--not the order details. So I found this error while trying to find an alternative reporting scheme for the users.")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 4 years 5 months ago, by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")       [Last Post](/forum/36-reports-statistics/904539-orders-listing-actions-export-a-csv-file-results-in-class-dbug-not-found#342306 "Hi,  Indeed. You can leave them commented out. I've published a new build of HikaShop 4.6.0 with the patch to remove both lines.") 4 years 5 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:4  Views:1122 | [Last Post](/forum/36-reports-statistics/904539-orders-listing-actions-export-a-csv-file-results-in-class-dbug-not-found#342306 "Hi,  Indeed. You can leave them commented out. I've published a new build of HikaShop 4.6.0 with the patch to remove both lines.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 years 5 months ago |
| [](/forum/36-reports-statistics/904458-add-the-customers-email-address-in-the-invoice) | [Add the customer's email address in the invoice](/forum/36-reports-statistics/904458-add-the-customers-email-address-in-the-invoice "-- HikaShop version -- : 4.5.1 Business -- Joomla version -- : 3.10.9  Hello, I need to add the customer's email address in the invoice available in administration. I have found which view to edit (order/invoice.php), but I don't know how to call the email address. Thank you for your help.")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 4 years 5 months ago, by [Marti](/forum/user/2853-marti "View Marti's Profile")       [Last Post](/forum/36-reports-statistics/904458-add-the-customers-email-address-in-the-invoice#341895 "It's ok I found...  Thank's ;)") 4 years 5 months ago     by [Marti](/forum/user/2853-marti "View Marti's Profile") | Replies:1  Views:933 | [Last Post](/forum/36-reports-statistics/904458-add-the-customers-email-address-in-the-invoice#341895 "It's ok I found...  Thank's ;)") by [Marti](/forum/user/2853-marti "View Marti's Profile")      4 years 5 months ago |
| [](/forum/36-reports-statistics/903920-show-order-count-on-order-screen) | [Show Order Count on Order Screen](/forum/36-reports-statistics/903920-show-order-count-on-order-screen "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3  Is there a way to add to the orders page a listing of how many purchases a customer has done? I ask because currently, I have to manually go look to see if the purchase is by a new customer or not, as it is...it's a major pain in the butt and takes a lot of time.  Just an extra column, showing an order number total, would be perfectly fine with me.")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 4 years 9 months ago, by [Dragon41673](/forum/user/9651-dragon41673 "View Dragon41673's Profile")       [Last Post](/forum/36-reports-statistics/903920-show-order-count-on-order-screen#339315 "Fantastic, thank you very much for the referral. I was actually looking at that, but having someone in your position recommend it tends to put a different light on the plugin.") 4 years 9 months ago     by [Dragon41673](/forum/user/9651-dragon41673 "View Dragon41673's Profile") | Replies:12  Views:1552 | [Last Post](/forum/36-reports-statistics/903920-show-order-count-on-order-screen#339315 "Fantastic, thank you very much for the referral. I was actually looking at that, but having someone in your position recommend it tends to put a different light on the plugin.") by [Dragon41673](/forum/user/9651-dragon41673 "View Dragon41673's Profile")      4 years 9 months ago |
| [](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices) | [how to create report with total discount prices?](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices "hi i want create a report with total prices that get to all users via each Copoun or Discount.(i can create a report with number of discount uses by users but i need sum of price for each discount code) is it possible with report system? i can use query in PHPmyAdmin but i want to implement in joomla back-end. if you want say not possible please advise me to how to write php code to do it. is it need create massaction ar need write a custom plugin. thank you (tip: i can not set avatar for my profile. every time i upload my avatar in kunena profile it is not any action after upload)")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 4 years 9 months ago, by [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile")       [Last Post](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices#338915 "Hi,  If you activate the &quot;debug system&quot; setting in the Joomla configuration, you'll see all the MySQL queries run on the current page on each page of your backend and frontend. Just unfold the MySQL queries area and look for hikashop&#95;order when you're looking at the page where the report is displayed and you'll get the MySQL query the report uses.") 4 years 9 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:1019 | [Last Post](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices#338915 "Hi,  If you activate the &quot;debug system&quot; setting in the Joomla configuration, you'll see all the MySQL queries run on the current page on each page of your backend and frontend. Just unfold the MySQL queries area and look for hikashop&#95;order when you're looking at the page where the report is displayed and you'll get the MySQL query the report uses.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 years 9 months ago |
| [](/forum/36-reports-statistics/903593-warning-trim-expects-parameter-1-to-be-string-array-given-in) | [Warning trim() expects parameter 1 to be string, array given in](/forum/36-reports-statistics/903593-warning-trim-expects-parameter-1-to-be-string-array-given-in "-- HikaShop version -- : 4.4.4 -- Joomla version -- : 3.10.3 -- PHP version -- : 7.3 -- Browser(s) name and version -- : chrome 96.0.4664.45 -- Error-message(debug-mod must be tuned on) -- : Warning: trim() expects parameter 1 to be string, array given in /home/matrivub/public&#95;html/components/com&#95;hikashop/views/product/tmpl/filter.php on line 67  Warning: trim() expects parameter 1 to be string, array given in /home/matrivub/public&#95;html/components/com&#95;hikashop/views/product/tmpl/filter.php on line 67  Warning: trim() expects parameter 1 to be string, array given in /home/matrivub/public&#95;html/components/com&#95;hikashop/views/product/tmpl/filter.php on line 67  Warning: trim() expects parameter 1 to be string, array given in /home/matrivub/public&#95;html/components/com&#95;hikashop/views/product/tmpl/filter.php on line 67  Warning: trim() expects parameter 1 to be string, array given in /home/matrivub/public&#95;html/components/com&#95;hikashop/views/product/tmpl/filter.php on line 67  Warning: trim() expects parameter 1 to be string, array given in /home/matrivub/public&#95;html/components/com&#95;hikashop/views/product/tmpl/filter.php on line 67  Hello, in default mode in Joomla a saw a fowolling warning: 0 Warning: trim() expects parameter 1 to be string, array given in ...........  I&#96;ve donwloading the filter.php file and scrol down to 67 row. Here are the code at the rows 67,68,69:  if(!empty($data) &amp;&amp; !in&#95;array(trim($data), array('', 'none', '::'))) { $filter-&gt;filterActive = true; $filterActivated = true;  WHAT CAN I DO TO FIX THE WARNING IN DEFAULT JOOMLA MODE TO DISSAPEAR THE WARNING? Is the code below right?  if(!empty($data) &amp;&amp; !in&#95;array(trim($data), array('', 'none', '::'))) { $filter-&gt;filterActive = false; $filterActivated = false;")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 4 years 11 months ago, by [marto42](/forum/user/38319-marto42 "View marto42's Profile")       [Last Post](/forum/36-reports-statistics/903593-warning-trim-expects-parameter-1-to-be-string-array-given-in#337641 "Hi,  Well it's another notice message in another file and I didn't know about it so that's why it's still there. I've added a patch for Download again the install package of HikaShop on our website and install it on yours and it will fix the problem.  However, for the I don't see why you would get that message. Could you double check ? What do you have on that line of code in that file on your end ?") 4 years 11 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:3018 | [Last Post](/forum/36-reports-statistics/903593-warning-trim-expects-parameter-1-to-be-string-array-given-in#337641 "Hi,  Well it's another notice message in another file and I didn't know about it so that's why it's still there. I've added a patch for Download again the install package of HikaShop on our website and install it on yours and it will fix the problem.  However, for the I don't see why you would get that message. Could you double check ? What do you have on that line of code in that file on your end ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 years 11 months ago |
| [](/forum/36-reports-statistics/903370-the-figure-in-dashboard-and-graph-statistic) | [The figure in dashboard and graph statistic](/forum/36-reports-statistics/903370-the-figure-in-dashboard-and-graph-statistic "-- HikaShop version -- : 4.1.0 -- Joomla version -- : 3.7.3 -- PHP version -- : 7.2.34  Why the values from the graph and the value at the top are different? How the calculation of the sales is made?")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 2 weeks ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")       [Last Post](/forum/36-reports-statistics/903370-the-figure-in-dashboard-and-graph-statistic#336603 "Hi,  The value at the top is based on the orders paid in the last 30 days. The values in the graph are based on the orders paid for each month. So supposing you're looking at it on the 27th of October, the last value in the grapth is the sum for the orders from the 1st of October to now, while the value at the top is the same for the orders from the 27th of September to now. So it's normal that the value at the top is higher.") 5 years 2 weeks ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:1011 | [Last Post](/forum/36-reports-statistics/903370-the-figure-in-dashboard-and-graph-statistic#336603 "Hi,  The value at the top is based on the orders paid in the last 30 days. The values in the graph are based on the orders paid for each month. So supposing you're looking at it on the 27th of October, the last value in the grapth is the sum for the orders from the 1st of October to now, while the value at the top is the same for the orders from the 27th of September to now. So it's normal that the value at the top is higher.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 2 weeks ago |
| [](/forum/36-reports-statistics/903343-report-for-first-time-customers) | [Report for first time customers](/forum/36-reports-statistics/903343-report-for-first-time-customers "-- HikaShop version -- : 4.4.3  We would like to reach out to customers who have purchased for the first time. I'm having trouble finding out how to get a report for that. Any suggestions? It could just be a report for customers with a confirmed order value of 1.  Thanks!")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 3 weeks ago, by [brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")       [Last Post](/forum/36-reports-statistics/903343-report-for-first-time-customers#336507 "First of all, you are awesome. The SQL query works if I change the end to &quot;ORDER BY u.user&#95;id DESC&quot;. This essentially shows me the latest users and I can pick out the ones who have an order number of 1.  Thanks!") 5 years 2 weeks ago     by [brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") | Replies:2  Views:1105 | [Last Post](/forum/36-reports-statistics/903343-report-for-first-time-customers#336507 "First of all, you are awesome. The SQL query works if I change the end to &quot;ORDER BY u.user&#95;id DESC&quot;. This essentially shows me the latest users and I can pick out the ones who have an order number of 1.  Thanks!") by [brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")      5 years 2 weeks ago |
| [](/forum/36-reports-statistics/903221-carts-report) | [Carts report](/forum/36-reports-statistics/903221-carts-report "-- HikaShop version -- : 4.4.3 Business -- Joomla version -- : 3.9.28 -- PHP version -- : 7 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : None  Hi I was wondering if there is a way to generate a report of the past two months or so of all &quot;carts&quot; that have been created. I see this information from HikaShop -&gt; Users -&gt; Customers -&gt; Carts. Here I can see all carts which one may call &quot;abandoned carts&quot; that have been generated and not completed. Can I generate a report of this information? Also are there any tips on how to identify if there is something causing these carts to be abandoned or any more details that can be revealed?")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 1 month ago, by [rjrsinc](/forum/user/45016-rjrsinc "View rjrsinc's Profile")       [Last Post](/forum/36-reports-statistics/903221-carts-report#335857 "Hi,  There is no option to generate a report on the carts besides that listing in the backend. To check why carts are abandoned, you could use Google Analytics on your website. You'll get data on the flow of users and where they stop on your shop during their browsing (like stopping at the first step of the checkout, or stopping before reaching the checkout, etc). But it's hard to get more details. That would require the developement of a custom plugin to log the data of who clicked where etc.") 5 years 1 month ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:950 | [Last Post](/forum/36-reports-statistics/903221-carts-report#335857 "Hi,  There is no option to generate a report on the carts besides that listing in the backend. To check why carts are abandoned, you could use Google Analytics on your website. You'll get data on the flow of users and where they stop on your shop during their browsing (like stopping at the first step of the checkout, or stopping before reaching the checkout, etc). But it's hard to get more details. That would require the developement of a custom plugin to log the data of who clicked where etc.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 1 month ago |
| [](/forum/36-reports-statistics/902993-issues-with-dates-in-a-report) | [Issues with dates in a report](/forum/36-reports-statistics/902993-issues-with-dates-in-a-report "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.28 -- PHP version -- : 7.4.21  I have a simple report I am working with.  Type: Product Order Status: confirmed Limited to a specific category, and including sub categories Type: Listing Date type: Created Period Start Date: 2021-01-14 00:00 Period End Date: 2021-07-14 00:00 Limit: 50  The issue is that when I save the report, the year reduces by 1. So I enter 2021 for the year, and press save. The field now shows 2020. If I save it again the year becomes 2019, and so on.  Anyone else have this issue? If so, does anyone have a fix for it?")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 3 months ago, by [vanboke](/forum/user/4873-vanboke "View vanboke's Profile")       [Last Post](/forum/36-reports-statistics/902993-issues-with-dates-in-a-report#334624 "Hi,  I tried to reproduce the issue on my end with the same settings and I don't have the problem:   i.imgur.com/lVmuzu1.png  So I'm not sure why it would do that on your end only :/") 5 years 3 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:863 | [Last Post](/forum/36-reports-statistics/902993-issues-with-dates-in-a-report#334624 "Hi,  I tried to reproduce the issue on my end with the same settings and I don't have the problem:   i.imgur.com/lVmuzu1.png  So I'm not sure why it would do that on your end only :/") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 3 months ago |
| [](/forum/36-reports-statistics/902951-report-vat-shipping-costs) | [Report VAT shipping costs](/forum/36-reports-statistics/902951-report-vat-shipping-costs "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.28 -- PHP version -- : 7.4.21 -- Browser(s) name and version -- : Firefox  I use Hikashop for a customer to my satisfaction. What I can't figure out is a report. Can someone help me with this? Situation: There are different shipping options in the webshop, depending on the weight. Three shipping methods are subject to 21% VAT, the other two 9% VAT. I want to report on the calculated VAT on 21% and on 9% of the shipping costs only. Tried everything but can't figure it out. any of you tips?  Thanks in advance and with regards, Henk")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 4 months ago, by [netnog](/forum/user/58678-netnog "View netnog's Profile")       [Last Post](/forum/36-reports-statistics/902951-report-vat-shipping-costs#334382 "Hi,  You want to go in the menu System&gt;Taxes. There, click on the &quot;manage tax rates&quot; button and you'll see a listing of your tax rates with the amounts of tax paid, etc and you can change the period to take into account as well as the order statuses to take into account with the filters on the top right corner of the listing.") 5 years 4 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:807 | [Last Post](/forum/36-reports-statistics/902951-report-vat-shipping-costs#334382 "Hi,  You want to go in the menu System&gt;Taxes. There, click on the &quot;manage tax rates&quot; button and you'll see a listing of your tax rates with the amounts of tax paid, etc and you can change the period to take into account as well as the order statuses to take into account with the filters on the top right corner of the listing.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 4 months ago |
| [](/forum/36-reports-statistics/902859-how-to-customize-sort-and-display-reports) | [how to customize, sort and display reports](/forum/36-reports-statistics/902859-how-to-customize-sort-and-display-reports "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.27 -- PHP version -- : 7 -- Error-message(debug-mod must be tuned on) -- : none  hi  1. how can i sort or group orders by location, city or country? on the backend orders can only be sorted by date, payment type and status  2. i have custom fields on my order form how do i add this to the reports? how do i sort this?  thanks")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 4 months ago, by [ronron](/forum/user/40399-ronron "View ronron's Profile")       [Last Post](/forum/36-reports-statistics/902859-how-to-customize-sort-and-display-reports#333940 "Hello,  Can you give us more information about what you want to change through some screenshots for example so that we can properly understand it and advise you ? Thank you.  Note that if you want to change what's displayed in the &quot;Last orders&quot; module of the dashboard, the solution will probably be to directly edit the code of the &quot;getDashboard&quot; function of the file &quot;&#92;administrator&#92;components&#92;com&#95;hikashop&#92;classes&#92;statistics.php&quot;.  Kind regards, Mohamed.") 5 years 4 months ago     by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1  Views:824 | [Last Post](/forum/36-reports-statistics/902859-how-to-customize-sort-and-display-reports#333940 "Hello,  Can you give us more information about what you want to change through some screenshots for example so that we can properly understand it and advise you ? Thank you.  Note that if you want to change what's displayed in the &quot;Last orders&quot; module of the dashboard, the solution will probably be to directly edit the code of the &quot;getDashboard&quot; function of the file &quot;&#92;administrator&#92;components&#92;com&#95;hikashop&#92;classes&#92;statistics.php&quot;.  Kind regards, Mohamed.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")      5 years 4 months ago |
| [](/forum/36-reports-statistics/902590-reports) | [Reports](/forum/36-reports-statistics/902590-reports "Hi, please can you help me how to make a report to see 1. How many new customers I have this year? 2. How to see what was the salary in a certain time period, for example, what was the salary from 1.1.2021 to 15.1.2021? Thank you")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 5 months ago, by [komir](/forum/user/2810-komir "View komir's Profile")       [Last Post](/forum/36-reports-statistics/902590-reports#332896 "Hi,  There are no options for these, but with custom coding anything is possible.  1. if you edit the file dashboard/listing.php for your backend template via the menu Display&gt;Views, you can change the span4 to span4 on the line:  and it should do it. 2. In the same view file, if you add the code:  at the beginning, it will display the widgets below the main new dashboard if the &quot;dashboard legacy&quot; setting is turned off in the HikaShop configuration.") 5 years 5 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:15  Views:1487 | [Last Post](/forum/36-reports-statistics/902590-reports#332896 "Hi,  There are no options for these, but with custom coding anything is possible.  1. if you edit the file dashboard/listing.php for your backend template via the menu Display&gt;Views, you can change the span4 to span4 on the line:  and it should do it. 2. In the same view file, if you add the code:  at the beginning, it will display the widgets below the main new dashboard if the &quot;dashboard legacy&quot; setting is turned off in the HikaShop configuration.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 5 months ago |
| [](/forum/36-reports-statistics/902399-errors-in-dashboard-at-orders-and-geographic-sales) | [Errors in Dashboard at Orders and Geographic sales](/forum/36-reports-statistics/902399-errors-in-dashboard-at-orders-and-geographic-sales "Hello,  I am getting errors in the Hikashop's dashboard, at Orders and Geographic sales widgets. The errors are: &quot;b.split is not a function&quot; and &quot;Invalid row index NaN. Should be in the range &#91;0-0&#93;.&quot;.  Is there a way to fix that?  Thank you in advance!")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 6 months ago, by [Giscard](/forum/user/56241-giscard "View Giscard's Profile")       [Last Post](/forum/36-reports-statistics/902399-errors-in-dashboard-at-orders-and-geographic-sales#332174 "Hello,  That will be more easy for us to be able to directly see the display issue, but from what we see from your screenshot that there is a problem of match between your view and your frontend css.  Either you have an old view OR an old frontend file Css (as it seems that you have create a custome one). But we are more tempted to think that the problem here is more of a css frontend problem.  To get more clues, we will need to see the issue by ourselves as previously requested AND a backend access (url link &amp; user references with full access).  Note : Use our  form to provide these elements and don't forget to add an Url link to this topic.  Regards") 5 years 6 months ago     by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:12  Views:1339 | [Last Post](/forum/36-reports-statistics/902399-errors-in-dashboard-at-orders-and-geographic-sales#332174 "Hello,  That will be more easy for us to be able to directly see the display issue, but from what we see from your screenshot that there is a problem of match between your view and your frontend css.  Either you have an old view OR an old frontend file Css (as it seems that you have create a custome one). But we are more tempted to think that the problem here is more of a css frontend problem.  To get more clues, we will need to see the issue by ourselves as previously requested AND a backend access (url link &amp; user references with full access).  Note : Use our  form to provide these elements and don't forget to add an Url link to this topic.  Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile")      5 years 6 months ago |
| [](/forum/36-reports-statistics/902335-grouping-ot-items-incorrect-in-line-report) | [Grouping ot items incorrect in line report](/forum/36-reports-statistics/902335-grouping-ot-items-incorrect-in-line-report "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.3.27  Hi,  This problem concerns the legacy dashboard.  First I published a table report of the sales in a month. Period: this month The sales figures are displayed correctly.  Then I published a line report of sales this year. The items are grouped per month. Alas the resulting sales figures differ from the table report.  Looking into the cause of the difference I discovered that the exact start time and end time are incorrect when grouping per month in the line report. The start date is not March 1 00:00 but Febr 28 22:00 and the end date is March 31 22:00 So the month is pushed back 2 hours!  I tested several months, the same thing happened every month. And this problem also arises when grouping per week.  The selected date type in the line report: created  Please advise.  Udo")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 7 months ago, by [Udo](/forum/user/29928-udo "View Udo's Profile")       [Last Post](/forum/36-reports-statistics/902335-grouping-ot-items-incorrect-in-line-report#332037 "Hi, Almost 3 weeks ago now, still no reply... Has this topic been overlooked?  regards, Udo") 5 years 6 months ago     by [Udo](/forum/user/29928-udo "View Udo's Profile") | Replies:1  Views:820 | [Last Post](/forum/36-reports-statistics/902335-grouping-ot-items-incorrect-in-line-report#332037 "Hi, Almost 3 weeks ago now, still no reply... Has this topic been overlooked?  regards, Udo") by [Udo](/forum/user/29928-udo "View Udo's Profile")      5 years 6 months ago |
| [](/forum/36-reports-statistics/902433-when-cutom-date-selected-for-report-no-information-is-displayed-on-screen-or-exp) | [When Cutom Date selected for Report No Information is displayed on screen or exp](/forum/36-reports-statistics/902433-when-cutom-date-selected-for-report-no-information-is-displayed-on-screen-or-exp "-- HikaShop version -- : v4.4.2 -- Joomla version -- : 3.9.26 -- PHP version -- : 7.3.27-9+ubuntu16.04.1+deb.sury.org+1 -- Browser(s) name and version -- : FireFox 87  Hikashop version:  v4.4.2&#95;2021-04-22&#95;04-27-26  This was happening on stock version 4.4.2  When Custom Date selected for Report No Information is displayed on screen or exported. This occurs on new reports or altering running/old reports")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 6 months ago, by [thenorthernoffice](/forum/user/33750-thenorthernoffice "View thenorthernoffice's Profile")       [Last Post](/forum/36-reports-statistics/902433-when-cutom-date-selected-for-report-no-information-is-displayed-on-screen-or-exp#331939 "Thanks Nicholas ... you got it right! Perfect. Working as advertised gain. Many thanks for the very swift actions and reply.") 5 years 6 months ago     by [thenorthernoffice](/forum/user/33750-thenorthernoffice "View thenorthernoffice's Profile") | Replies:2  Views:1020 | [Last Post](/forum/36-reports-statistics/902433-when-cutom-date-selected-for-report-no-information-is-displayed-on-screen-or-exp#331939 "Thanks Nicholas ... you got it right! Perfect. Working as advertised gain. Many thanks for the very swift actions and reply.") by [thenorthernoffice](/forum/user/33750-thenorthernoffice "View thenorthernoffice's Profile")      5 years 6 months ago |
| [](/forum/36-reports-statistics/902398-dashboard-not-showing-stats) | [dashboard not showing stats](/forum/36-reports-statistics/902398-dashboard-not-showing-stats "-- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.26 -- PHP version -- : 7.4 -- Browser(s) name and version -- : chrome  Hi, Backend - dashboard is not showing some statistics  can You please help me solving it")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 6 months ago, by [marek393](/forum/user/31274-marek393 "View marek393's Profile")       [Last Post](/forum/36-reports-statistics/902398-dashboard-not-showing-stats#331879 "Thanks it works") 5 years 6 months ago     by [marek393](/forum/user/31274-marek393 "View marek393's Profile") | Replies:2  Views:863 | [Last Post](/forum/36-reports-statistics/902398-dashboard-not-showing-stats#331879 "Thanks it works") by [marek393](/forum/user/31274-marek393 "View marek393's Profile")      5 years 6 months ago |
| [](/forum/36-reports-statistics/902406-how-to-see-each-product-sell) | [how to see each product sell?](/forum/36-reports-statistics/902406-how-to-see-each-product-sell "hi. i want see each product how much sell? must to create custom report or it is exist in hikashop?")        Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 6 months ago, by [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile")       [Last Post](/forum/36-reports-statistics/902406-how-to-see-each-product-sell#331849 "Hi,  HikaShop has reporting tools included that you can use to get what you want. In the menu Orders&gt;Reports, you can create a new report and configure it to get the report you want. For example:   i.imgur.com/XUjiw5s.png  This gives me a report of the 50 most sold products, regardless of the period, based on orders with the statuses being either &quot;created&quot; or &quot;confirmed&quot; made in the EUR currency. Then, it's up to you to adapt the settings to your needs.") 5 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:1089 | [Last Post](/forum/36-reports-statistics/902406-how-to-see-each-product-sell#331849 "Hi,  HikaShop has reporting tools included that you can use to get what you want. In the menu Orders&gt;Reports, you can create a new report and configure it to get the report you want. For example:   i.imgur.com/XUjiw5s.png  This gives me a report of the 50 most sold products, regardless of the period, based on orders with the statuses being either &quot;created&quot; or &quot;confirmed&quot; made in the EUR currency. Then, it's up to you to adapt the settings to your needs.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 6 months ago |
| [](/forum/36-reports-statistics/902385-dashboard-red-errors) | [Dashboard red errors](/forum/36-reports-statistics/902385-dashboard-red-errors "-- HikaShop version -- : 4.4.1 -- Joomla version -- : Joomla! 3.9.26 -- PHP version -- : 7.3 -- Browser(s) name and version -- : Edge -- Error-message(debug-mod must be tuned on) -- : b.split is not a function× Invalid row index NaN. Should be in the range &#91;0-0&#93;.×  Hello, My dashboard under orders is showing b.split is not a function× and my Geographic sales is showing Invalid row index NaN. Should be in the range &#91;0-0&#93;.× ....see attached pic. Thanks for your help")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 6 months ago, by [ChristianLocal](/forum/user/35348-christianlocal "View ChristianLocal's Profile")       [Last Post](/forum/36-reports-statistics/902385-dashboard-red-errors#331795 "Hi,  Can you provide the full version information you can see at the top of the main tab of the HikaShop configuration ?") 5 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:1542 | [Last Post](/forum/36-reports-statistics/902385-dashboard-red-errors#331795 "Hi,  Can you provide the full version information you can see at the top of the main tab of the HikaShop configuration ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 6 months ago |
| [](/forum/36-reports-statistics/902368-all-reports-showing-error-message-cannot-read-property-offset-of-undefined) | [All reports showing error message: Cannot read property 'offset' of undefined](/forum/36-reports-statistics/902368-all-reports-showing-error-message-cannot-read-property-offset-of-undefined "-- HikaShop version -- : 4.4.1 -- Joomla version -- : latest -- PHP version -- : 7.4.16 -- Browser(s) name and version -- : Chrome Latest -- Error-message(debug-mod must be tuned on) -- : Cannot read property 'offset' of undefined  This has just started. All reports with charts or graphics showing Cannot read property 'offset' of undefined.")         Category: [Reports &amp; Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics")     Topic started 5 years 7 months ago, by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")       [Last Post](/forum/36-reports-statistics/902368-all-reports-showing-error-message-cannot-read-property-offset-of-undefined#331713 "Thanks Nicolas! All good now!") 5 years 7 months ago     by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") | Replies:4  Views:3342 | [Last Post](/forum/36-reports-statistics/902368-all-reports-showing-error-message-cannot-read-property-offset-of-undefined#331713 "Thanks Nicolas! All good now!") by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")      5 years 7 months ago |
| <a id="forumbottom"> </a> [   ](#forumtop) |  |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.070 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
