[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/900001-e-mail-order-create-length) | [E-mail "order create" length](/forum/36-reports-statistics/900001-e-mail-order-create-length "Hi, since 20.08.2019, when I receive the automatic email of a created order, it arrives on two pages, even if the order is short. The second page is empty and with a gray background. I attach screenshots of the print preview: The order ends in the middle of the first page, but there are 2 pages to print, the second empty. Until 19.08.2019 instead, the page to be printed ended with the order total. Is it possible to fix this situation and print only the order automatically without telling the printing program to print only the pages containing the order and not the empty ones? Thanks in advance augusto") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 5 months ago, by [gus](/forum/user/39157-gus "View gus's Profile") [Last Post](/forum/36-reports-statistics/900001-e-mail-order-create-length#319869 "Hi Nicolas, it's just the standard print preview of my Mac. Your words made me reflect on why this happens on our computers, all Apple, all with only the default client (Mail), and all with the box load / not load images in the mail, disabled. If I check images loading, everything is perfect, but if I don't want the images loaded and I want a text-only version for notifications to us, then the email gets longer than a blank page with grey background.. I'll fix it but thanks, I've found that it could be a problem with our mail client. Thank you. augusto") 6 years 5 months ago by [gus](/forum/user/39157-gus "View gus's Profile") | Replies:2 Views:1127 | [Last Post](/forum/36-reports-statistics/900001-e-mail-order-create-length#319869 "Hi Nicolas, it's just the standard print preview of my Mac. Your words made me reflect on why this happens on our computers, all Apple, all with only the default client (Mail), and all with the box load / not load images in the mail, disabled. If I check images loading, everything is perfect, but if I don't want the images loaded and I want a text-only version for notifications to us, then the email gets longer than a blank page with grey background.. I'll fix it but thanks, I've found that it could be a problem with our mail client. Thank you. augusto") by [gus](/forum/user/39157-gus "View gus's Profile") 6 years 5 months ago | | [](/forum/36-reports-statistics/899935-session-on-database-is-too-large) | [session on database is too large](/forum/36-reports-statistics/899935-session-on-database-is-too-large "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6 -- PHP version -- : 7 -- Error-message(debug-mod must be tuned on) -- : none hi i got a report from my host that this database is occupying a lot of space when i explored the database it seems to be a record of the last item viewed. i attached a screen shot how can i trim this database? can i delete the content of xxx_session ? thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 5 months ago, by [ronron](/forum/user/40399-ronron "View ronron's Profile") [Last Post](/forum/36-reports-statistics/899935-session-on-database-is-too-large#319490 "Hi, Yes you can empty that table. Here is a thread about this on the joomla forum: forum.joomla.org/viewtopic.php?t=851192") 6 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1211 | [Last Post](/forum/36-reports-statistics/899935-session-on-database-is-too-large#319490 "Hi, Yes you can empty that table. Here is a thread about this on the joomla forum: forum.joomla.org/viewtopic.php?t=851192") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 5 months ago | | [](/forum/36-reports-statistics/899761-customizable-and-exportable-report) | [Customizable and exportable report](/forum/36-reports-statistics/899761-customizable-and-exportable-report "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.0.33 Hi, it is possible to create an exportable report of a selection of orders with only some fields selected manually and also have a summary of the quantities per item within the selection of orders in the report? Thank's Maurizio") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 6 months ago, by [Scudeletti](/forum/user/59520-scudeletti "View Scudeletti's Profile") [Last Post](/forum/36-reports-statistics/899761-customizable-and-exportable-report#318722 "Hi, thanks Nicolas for the information. I will talk about it with the client to understand what he prefers to do. Thanks Maurizio") 6 years 6 months ago by [Scudeletti](/forum/user/59520-scudeletti "View Scudeletti's Profile") | Replies:4 Views:1001 | [Last Post](/forum/36-reports-statistics/899761-customizable-and-exportable-report#318722 "Hi, thanks Nicolas for the information. I will talk about it with the client to understand what he prefers to do. Thanks Maurizio") by [Scudeletti](/forum/user/59520-scudeletti "View Scudeletti's Profile") 6 years 6 months ago | | [](/forum/36-reports-statistics/898871-export-customer-orders-for-single-product) | [Export Customer Orders for Single Product](/forum/36-reports-statistics/898871-export-customer-orders-for-single-product "-- HikaShop version -- : 4.2.2 -- Joomla version -- : 3.9.14 -- PHP version -- : 7.2 -- Browser(s) name and version -- : Firefox Developer -- Error-message(debug-mod must be tuned on) -- : None Hi looking for some guidance as some of the threads I have read regarding Mass exporter, etc are a little confusing as is using Export function of all data, takes some messing with Unicode, etc to format data in Excel correctly and far too much data. All I would like to do is export all orders (single rows for multiple customer order) for a single product in a specific date range or entirely if easier as I can just sort by date using Excel. Is this possible, and if so please could you tell me how? Kindest regards, Mark") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 10 months ago, by [ImageVillage](/forum/user/58780-imagevillage "View ImageVillage's Profile") [Last Post](/forum/36-reports-statistics/898871-export-customer-orders-for-single-product#317982 "Got there in the end I think! No worries, it's all there I think, just got to dig it out! Again thanks for your patience and help.") 6 years 6 months ago by [ImageVillage](/forum/user/58780-imagevillage "View ImageVillage's Profile") | Replies:13 Views:2070 | [Last Post](/forum/36-reports-statistics/898871-export-customer-orders-for-single-product#317982 "Got there in the end I think! No worries, it's all there I think, just got to dig it out! Again thanks for your patience and help.") by [ImageVillage](/forum/user/58780-imagevillage "View ImageVillage's Profile") 6 years 6 months ago | | [](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes) | [Report--Orders missing address\_xxx fields sometimes](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : none This is weird. I have a sales report we use to export orders for and it had been working okay. Now we've discovered that when we have certain products sold in the report, the address fields are excluded from the export/csv file. If we select a specific product in the filter, things are fine. But when the filter includes a specific product, they're gone. What is triggering this and how can I fix this? These are the fields that are missing: address_id address_user_id address_title address_firstname address_lastname address_company address_street address_street2 address_post_code address_city address_telephone address_state address_country address_published address_default address_type Again, only when the same saved report is used on certain products in the filters. The orders are not any different than others, no specific date or order type.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 6 months ago, by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") [Last Post](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317903 "I had emailed private access and steps to reproduce, but the account wasn’t accessed in over 5 days and was disabled. If you still need access to resolve this bug, please send me an email/pm (the...") 6 years 6 months ago by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") | Replies:5 Views:874 | [Last Post](/forum/36-reports-statistics/899555-report-orders-missing-address-xxx-fields-sometimes#317903 "I had emailed private access and steps to reproduce, but the account wasn’t accessed in over 5 days and was disabled. If you still need access to resolve this bug, please send me an email/pm (the...") by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") 6 years 6 months ago | | [](/forum/36-reports-statistics/899287-dashboard-problems) | [Dashboard problems](/forum/36-reports-statistics/899287-dashboard-problems "The dashboard of Hikashop seems not to work correctly or has bugs. What does 'best customer' means? Now it's showing a costumer who's not the customer who purchased most products or paid the highest price this month and is confirmed. Total orders (I assume confirmed and this month) are not correct. Strange") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 8 months ago, by [Pistol](/forum/user/25667-pistol "View Pistol's Profile") [Last Post](/forum/36-reports-statistics/899287-dashboard-problems#317406 "Thanks Nicolas. I made the changes in the statistics.php file. I did notice that I needed to change all the past.month values to this.month to ensure the other data was also accurate (# of orders etc.) I understand the logic behind some users not wanting to see current Months orders but I think the title of that block is misleading at the moment? Maybe have a dropdown as per the other blocks on the dashboard? The plugin is useful and would be a good option to include as part of the Hikashop install so that users were directed straight to the dashboard.") 6 years 7 months ago by [serbofleconcepts](/forum/user/37141-serbofleconcepts "View serbofleconcepts's Profile") | Replies:5 Views:1109 | [Last Post](/forum/36-reports-statistics/899287-dashboard-problems#317406 "Thanks Nicolas. I made the changes in the statistics.php file. I did notice that I needed to change all the past.month values to this.month to ensure the other data was also accurate (# of orders etc.) I understand the logic behind some users not wanting to see current Months orders but I think the title of that block is misleading at the moment? Maybe have a dropdown as per the other blocks on the dashboard? The plugin is useful and would be a good option to include as part of the Hikashop install so that users were directed straight to the dashboard.") by [serbofleconcepts](/forum/user/37141-serbofleconcepts "View serbofleconcepts's Profile") 6 years 7 months ago | | [](/forum/36-reports-statistics/899459-admin-dashboard-error) | [Admin dashboard error](/forum/36-reports-statistics/899459-admin-dashboard-error "-- HikaShop version -- : 4.2.3 -- Joomla version -- : 3.9.16 -- PHP version -- : 7.3 -- Error-message(debug-mod must be tuned on) -- : Warning: Invalid argument supplied for foreach() in ...\administrator\components\com_hikashop\classes\statistics.php on line 1118 Hello, When I login and view the backend admin with the dashboard module displayed and Error reporting set to development I see an error: Warning: Invalid argument supplied for foreach() in ...\administrator\components\com_hikashop\classes\statistics.php on line 1118 What is this and how can I fix it?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 7 months ago, by [eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile") [Last Post](/forum/36-reports-statistics/899459-admin-dashboard-error#317241 "Is this the right link: www.hikashop.com/component/updateme/down...t-zip.html?Itemid=99 I just tried it. It works! Thank you very much.") 6 years 7 months ago by [rkhirsch](/forum/user/59356-rkhirsch "View rkhirsch's Profile") | Replies:4 Views:1248 | [Last Post](/forum/36-reports-statistics/899459-admin-dashboard-error#317241 "Is this the right link: www.hikashop.com/component/updateme/down...t-zip.html?Itemid=99 I just tried it. It works! Thank you very much.") by [rkhirsch](/forum/user/59356-rkhirsch "View rkhirsch's Profile") 6 years 7 months ago | | [](/forum/36-reports-statistics/899231-report-sales-by-category) | [Report sales by category](/forum/36-reports-statistics/899231-report-sales-by-category "Helo, something that may be basic for you, but I can't succed in, even looking in report and mass actions How do you have sales by category (product, price, dates, user) ? Thanks!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 8 months ago, by [LAPUYADE](/forum/user/55813-lapuyade "View LAPUYADE's Profile") [Last Post](/forum/36-reports-statistics/899231-report-sales-by-category#317151 "Hi, No worries. However, I don't see a solution without development I'm afraid. Take care !") 6 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:12 Views:1174 | [Last Post](/forum/36-reports-statistics/899231-report-sales-by-category#317151 "Hi, No worries. However, I don't see a solution without development I'm afraid. Take care !") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 7 months ago | | [](/forum/36-reports-statistics/899296-notifications) | [Notifications](/forum/36-reports-statistics/899296-notifications "Please when some product get quantity 0, all sold 1. Is it possible admin to get an email notification for the product is the quantity get 0? 2. Is it possible to get an email notification about selling statistics, like an email about the previous week, a previous month? Thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 8 months ago, by [komir](/forum/user/2810-komir "View komir's Profile") [Last Post](/forum/36-reports-statistics/899296-notifications#316278 "Hi, 1. Yes, there is a "out of stock" plugin you can enable and configure via the Joomla plugins manager for that. Note that it requires that you activated your cron task: www.hikashop.com/support/documentation/5...ashop-cron-task.html 2. There is no such mechanism. However, you can use the Orders>Reports system to configure reports that you can check when you want.") 6 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:882 | [Last Post](/forum/36-reports-statistics/899296-notifications#316278 "Hi, 1. Yes, there is a "out of stock" plugin you can enable and configure via the Joomla plugins manager for that. Note that it requires that you activated your cron task: www.hikashop.com/support/documentation/5...ashop-cron-task.html 2. There is no such mechanism. However, you can use the Orders>Reports system to configure reports that you can check when you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 8 months ago | | [](/forum/36-reports-statistics/899247-hikashop-ask-a-question-about-this-product-report) | [Hikashop - Ask a Question about this Product Report](/forum/36-reports-statistics/899247-hikashop-ask-a-question-about-this-product-report "-- HikaShop version -- : HikaShop Essential: 4.2.2 -- Joomla version -- : 3.9.14 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : No Error Message - not applicable Good Day, How can I get a Report of all submitted Enquirers in HikaShop Essential: 4.2.2? So in short - every Product has a "Get a Quick Quote" Button and I want a report of all submissions so far.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 8 months ago, by [Uriel](/forum/user/31103-uriel "View Uriel's Profile") [Last Post](/forum/36-reports-statistics/899247-hikashop-ask-a-question-about-this-product-report#316070 "Hello, Do you mean the list of every customers which have used the "contact us for more information" button ? If that's the case there's no option to do it, but a solution can be to list every "A contact request has been made" emails via "Hikashop->Customers->Emails". Kind regards, Mohamed.") 6 years 8 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:1300 | [Last Post](/forum/36-reports-statistics/899247-hikashop-ask-a-question-about-this-product-report#316070 "Hello, Do you mean the list of every customers which have used the "contact us for more information" button ? If that's the case there's no option to do it, but a solution can be to list every "A contact request has been made" emails via "Hikashop->Customers->Emails". Kind regards, Mohamed.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 6 years 8 months ago | | [](/forum/36-reports-statistics/898985-dashboard-information) | [Dashboard Information](/forum/36-reports-statistics/898985-dashboard-information "-- url of the page with the problem -- : 11plus-exam.co.uk/administrator/index.ph...ashop&ctrl=dashboard -- HikaShop version -- : 4.2.2 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.2 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi, In Hikashop Dashboard View. I have a widget to show the total of each payment type (e.g. paypal / bank transfer). I also have a widget to list each order that is confirmed during each month. As I only opened this site for 2020 yesterday, I have just 1 order, which makes it simple to see the problem. A customer purchased £320 of product. As he purchased over x amount he got a discount. Therefore he actually only paid £280 for it. Widget 1 - Payment Type shows £320 Widget 2 - customer orders - he spent £280 I cannot find a way to produce £280 in the payment type widget. This is important as it will calculate the gross income over time, and that information needs to be actual income not the initial no-discount amount of the goods. thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 10 months ago, by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") [Last Post](/forum/36-reports-statistics/898985-dashboard-information#315387 "Hi, Yes. What you can do is export the hikashop tables you want via PHPMyAdmin and import them back on the other website via the PHPMyAdmin. If the table prefix is different, you'll have to edit the file to change that. and you want to rename the tables before the import so that the tables from your old website can replace the ones already there. However, if the issue comes from the orders data in your database and you move the orders data on the new website, you might end up with the same issue again.") 6 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:16 Views:1362 | [Last Post](/forum/36-reports-statistics/898985-dashboard-information#315387 "Hi, Yes. What you can do is export the hikashop tables you want via PHPMyAdmin and import them back on the other website via the PHPMyAdmin. If the table prefix is different, you'll have to edit the file to change that. and you want to rename the tables before the import so that the tables from your old website can replace the ones already there. However, if the issue comes from the orders data in your database and you move the orders data on the new website, you might end up with the same issue again.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 9 months ago | | [](/forum/36-reports-statistics/898673-having-problems-creating-a-report) | [Having problems creating a report](/forum/36-reports-statistics/898673-having-problems-creating-a-report "We need to create a report with the following information for internal reporting. I've tried doing this in the HikaShop Reports but can't seem to get it how we need it. I've also looked at the...") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 6 hours ago, by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") [Last Post](/forum/36-reports-statistics/898673-having-problems-creating-a-report#314507 "Hi, That's right. The name changed a couple months ago: rolandd.com/news/ro-payments-5-0-0-available And last time I checked the website was still displaying "CSV improved".") 6 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:12 Views:1644 | [Last Post](/forum/36-reports-statistics/898673-having-problems-creating-a-report#314507 "Hi, That's right. The name changed a couple months ago: rolandd.com/news/ro-payments-5-0-0-available And last time I checked the website was still displaying "CSV improved".") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 10 months ago | | [](/forum/36-reports-statistics/898899-geographic-sales-display-incorrect) | [Geographic Sales display incorrect](/forum/36-reports-statistics/898899-geographic-sales-display-incorrect "-- HikaShop version -- : 4.2.2 I have recently upgraded from a very old version of Hikashop and noticed that the "Geographic sales" map doesn't show any sales for the United States of America which is at least 30% of my sales. It does show sales in other countries. I think I would use this statistic the most. I am wondering if there is a country code mismatch. And maybe this is because of my upgrade from old version. How can I troubleshoot this? Also is it possible to limit which products are included or should I switch to old dashboard in that situation? Thank you, Adam") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 10 months ago, by [adamells](/forum/user/39863-adamells "View adamells's Profile") [Last Post](/forum/36-reports-statistics/898899-geographic-sales-display-incorrect#314239 "Hello, Can you eventually send us temporary access to your back-end through our contact form and also specify a link to that thread so that we can directly test and debug it on your end ? Thank you. www.hikashop.com/support/contact-us.html Kind regards, Mohamed.") 6 years 10 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:4 Views:1340 | [Last Post](/forum/36-reports-statistics/898899-geographic-sales-display-incorrect#314239 "Hello, Can you eventually send us temporary access to your back-end through our contact form and also specify a link to that thread so that we can directly test and debug it on your end ? Thank you. www.hikashop.com/support/contact-us.html Kind regards, Mohamed.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 6 years 10 months ago | | [](/forum/36-reports-statistics/898557-reports-stop-at-certain-date) | [Reports stop at certain date](/forum/36-reports-statistics/898557-reports-stop-at-certain-date "-- HikaShop version -- : 4.2.2 -- Joomla version -- : 3.9.12 Hello, I have been having an issue with Reports- I cannot see data from any date after 9/1/19. I dont remember doing anything around that time that could have caused this. I have since updated Hikahop and the problem remains. Any ideas? Thanks Matt") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 3 weeks ago, by [mrooke](/forum/user/18053-mrooke "View mrooke's Profile") [Last Post](/forum/36-reports-statistics/898557-reports-stop-at-certain-date#312873 "Hello, Can you provide a screenshot of this report on the Month October (now finished) AND as the last time with the configuration visible. Awaiting news from you to move forward. Regards") 7 years 6 days ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:5 Views:1558 | [Last Post](/forum/36-reports-statistics/898557-reports-stop-at-certain-date#312873 "Hello, Can you provide a screenshot of this report on the Month October (now finished) AND as the last time with the configuration visible. Awaiting news from you to move forward. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 7 years 6 days ago | | [](/forum/36-reports-statistics/898624-report-for-total-value-of-all-shipping-charges-for-a-month) | [Report for total value of all shipping charges for a month](/forum/36-reports-statistics/898624-report-for-total-value-of-all-shipping-charges-for-a-month "-- url of the page with the problem -- : shop.newmodelarmy.org/ -- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.2.24 Hi, Is it possible to create a report that shows the total value of shipping fees for a time period? Thanks in advance, Kev") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 1 week ago, by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") [Last Post](/forum/36-reports-statistics/898624-report-for-total-value-of-all-shipping-charges-for-a-month#312809 "Hello Kev, There's actually no option to display Shipping price as, you'll only have order or sales prices displayed for the moment. However, you can actually restrict you the orders & sales displayed based on the shipping method used. Displaying the shipping price will require code customization. Kind regards, Mohamed.") 7 years 1 week ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:887 | [Last Post](/forum/36-reports-statistics/898624-report-for-total-value-of-all-shipping-charges-for-a-month#312809 "Hello Kev, There's actually no option to display Shipping price as, you'll only have order or sales prices displayed for the moment. However, you can actually restrict you the orders & sales displayed based on the shipping method used. Displaying the shipping price will require code customization. Kind regards, Mohamed.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 7 years 1 week ago | | [](/forum/36-reports-statistics/898528-appearance-of-legacy-dashboard) | [Appearance of legacy dashboard](/forum/36-reports-statistics/898528-appearance-of-legacy-dashboard "-- HikaShop version -- : 4.2.2 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.3 -- Browser(s) name and version -- : Safari 13.0.1 -- Error-message(debug-mod must be tuned on) -- : none Hello, we use the legacy dashboard. It suits better our needs. the apparence of some reports seems to be altered by the length of username of some clients. Some very long usernames stretch or enlarge the listing reports. such "enlarged" listing report is partially covered by the other report. it happens unless you use a large screen. the attached screenshot is taken on an Apple laptop. The display is ok on an big (20 or 27") screen. How to fix it ? Thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 3 weeks ago, by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") [Last Post](/forum/36-reports-statistics/898528-appearance-of-legacy-dashboard#312302 "Perfect Nicolas ! I changed 30 to 20 to get the 20 first letters of the usernames. with 30, it was still too large. By the way, those extra long usernames come from Amazon login I've enabled of the site. Merci / Thanks.") 7 years 3 weeks ago by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") | Replies:2 Views:1052 | [Last Post](/forum/36-reports-statistics/898528-appearance-of-legacy-dashboard#312302 "Perfect Nicolas ! I changed 30 to 20 to get the 20 first letters of the usernames. with 30, it was still too large. By the way, those extra long usernames come from Amazon login I've enabled of the site. Merci / Thanks.") by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") 7 years 3 weeks ago | | [](/forum/36-reports-statistics/898412-modifications-to-reports-are-giving-sql-errors-dashboard-not-available-now) | [modifications to reports are giving SQL errors, dashboard not available now](/forum/36-reports-statistics/898412-modifications-to-reports-are-giving-sql-errors-dashboard-not-available-now "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.0.33 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 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 #__hikashop_order AS a WHERE a.order_type='sale' AND a.order_status IN (' at line 1 Return to Control Panel Can't access the dashboard after making a change to the comparison sales data, get sql syntax error. Any ideas?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 1 month ago, by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") [Last Post](/forum/36-reports-statistics/898412-modifications-to-reports-are-giving-sql-errors-dashboard-not-available-now#311622 "Hi, First, you can disable the report via the Orders>Reports menu. That way, it won't appear as a widget on the dashboard and thus won't crash the dashboard. Then, you can create a new report and publish it once it's working like you want. Also, you might want to try to reproduce the issue and provide a screenshot of the settings of the report just before you save it (after you save it, the report edition page will crash as it will also run the report so you won't be able to do a screenshot of the settings once you have the issue with the report.") 7 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:974 | [Last Post](/forum/36-reports-statistics/898412-modifications-to-reports-are-giving-sql-errors-dashboard-not-available-now#311622 "Hi, First, you can disable the report via the Orders>Reports menu. That way, it won't appear as a widget on the dashboard and thus won't crash the dashboard. Then, you can create a new report and publish it once it's working like you want. Also, you might want to try to reproduce the issue and provide a screenshot of the settings of the report just before you save it (after you save it, the report edition page will crash as it will also run the report so you won't be able to do a screenshot of the settings once you have the issue with the report.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 years 1 month ago | | [](/forum/36-reports-statistics/898294-can-t-see-conversion-source-in-analytics) | [Can t see conversion source in analytics](/forum/36-reports-statistics/898294-can-t-see-conversion-source-in-analytics "-- url of the page with the problem -- : raskal.shop -- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.25 Hello,i have Hikashop Business, and I'm really frustrated because i can t see conversion source in analytics. When order is done, i see in source column "other" (see picture). I configured joomla analytics plugin and hikashop analytics plugin, all work fine excepted this. I dont konw if it is important but 99% of customers came from a landing page from another domain (wixi.raska-shop) Can someone help me? Thank You Regards Emiliano") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 1 month ago, by [raskal](/forum/user/57424-raskal "View raskal's Profile") [Last Post](/forum/36-reports-statistics/898294-can-t-see-conversion-source-in-analytics#311303 "Thank You Jerome, I have 3 site: 2 hikashop 1 virtuemart In all 2 hikashop site i can t see costumers sources, and this sound strange. Same analytics configuration. i ll investigate. Regards Emiliano") 7 years 1 month ago by [raskal](/forum/user/57424-raskal "View raskal's Profile") | Replies:12 Views:1486 | [Last Post](/forum/36-reports-statistics/898294-can-t-see-conversion-source-in-analytics#311303 "Thank You Jerome, I have 3 site: 2 hikashop 1 virtuemart In all 2 hikashop site i can t see costumers sources, and this sound strange. Same analytics configuration. i ll investigate. Regards Emiliano") by [raskal](/forum/user/57424-raskal "View raskal's Profile") 7 years 1 month ago | | [](/forum/36-reports-statistics/896967-how-to-config-report) | [How to config report?](/forum/36-reports-statistics/896967-how-to-config-report "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 8 months ago, by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") [Last Post](/forum/36-reports-statistics/896967-how-to-config-report#311260 "Hi, Here it is: Thanks") 7 years 1 month ago by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") | Replies:12 Views:2588 | [Last Post](/forum/36-reports-statistics/896967-how-to-config-report#311260 "Hi, Here it is: Thanks") by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") 7 years 1 month ago | | [](/forum/36-reports-statistics/898296-weird-report-display-when-comparing-data-lines-are-side-by-side) | [Weird report display when comparing data : Lines are side-by-side ...](/forum/36-reports-statistics/898296-weird-report-display-when-comparing-data-lines-are-side-by-side "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.2.19 -- Browser(s) name and version -- : Safari 12.1.2 -- Error-message(debug-mod must be tuned on) -- : none Hello, as the "column type" display has been removed, I have been using "line display" reports for a while. The line display reports used to show 2 lines (blue and red) on the same chart, as the "graph type" does. Now my "line display" reports show 2 separated side-by-side lines, each one on its own chart (see attachement). Is it a way to have the blue and red lines on the same chart, like the "line display" was before ? ... easier to compare sales, in a glance, over 2 period of time. Thanks !") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 1 month ago, by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") [Last Post](/forum/36-reports-statistics/898296-weird-report-display-when-comparing-data-lines-are-side-by-side#311129 "You made my day ! The line display is fine now. Thank you Nicolas !") 7 years 1 month ago by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") | Replies:6 Views:1011 | [Last Post](/forum/36-reports-statistics/898296-weird-report-display-when-comparing-data-lines-are-side-by-side#311129 "You made my day ! The line display is fine now. Thank you Nicolas !") by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") 7 years 1 month ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.131 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)