[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/890510-payment-log-file-not-working) | [Payment log file not working](/forum/36-reports-statistics/890510-payment-log-file-not-working "The Payment log file button is not working in the back-end. I get an empty pop-up. The .log file itself seems outdated with no useable content. Thanks in advance") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 5 months ago, by [Pixcraft](/forum/user/48792-pixcraft "View Pixcraft's Profile") [Last Post](/forum/36-reports-statistics/890510-payment-log-file-not-working#271643 "Hello, The payment log is used by the plugins to store their debug data ; it is purely plugin related. The only thing that HikaShop can store in that log is the content return by the "payment notification", but once again, it depends on the content returned by the plugin for that function. So, the fact that you have an empty log is not a problem in HikaShop ; but it is something that your payment plugin should do. Regards,") 9 years 5 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:3 Views:2236 | [Last Post](/forum/36-reports-statistics/890510-payment-log-file-not-working#271643 "Hello, The payment log is used by the plugins to store their debug data ; it is purely plugin related. The only thing that HikaShop can store in that log is the content return by the "payment notification", but once again, it depends on the content returned by the plugin for that function. So, the fact that you have an empty log is not a problem in HikaShop ; but it is something that your payment plugin should do. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 5 months ago | | [](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that) | [Error on report 1064 You have an error in your SQL syntax; check the manual that](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that "-- url of the page with the problem -- : waterline.nl -- HikaShop version -- : 3.1.0 -- Joomla version -- : 3.7.2 -- PHP version -- : 7 -- 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 #__hikashop_ AS a' at line 1 Hi Guys, When i go to te reports and click on my sales for making a report i get this: 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_ AS a' at line 1 I updated to the newest version and fixed any database errors with Admin tools and default joomla tool. What is going wrong here?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 5 months ago, by [joris85](/forum/user/28344-joris85 "View joris85's Profile") [Last Post](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270857 "We will try that, thanks! I will not add the credentials again :-)") 9 years 5 months ago by [joris85](/forum/user/28344-joris85 "View joris85's Profile") | Replies:5 Views:2329 | [Last Post](/forum/36-reports-statistics/890443-error-on-report-1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that#270857 "We will try that, thanks! I will not add the credentials again :-)") by [joris85](/forum/user/28344-joris85 "View joris85's Profile") 9 years 5 months ago | | [](/forum/36-reports-statistics/890402-last-xx-orders) | [Last XX orders](/forum/36-reports-statistics/890402-last-xx-orders "-- Error-message(debug-mod must be tuned on) -- : none Hi on my hikashop dash I have "last orders", order no. \| Customer \| Order Status \| Total is it possible that I can add time or date / ? thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 5 months ago, by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") [Last Post](/forum/36-reports-statistics/890402-last-xx-orders#270345 "Hi, The new dashboard of HikaShop 3.x does include the date of the orders on the last orders listing: monosnap.com/file/aso9TTt6lXQb5KvRbi1i5IMiiEO5ER If you don't see that, it's probably that you're using the old dashboard of HikaShop. Go in the HikaShop configuration and turn off the "dashboard legacy" and you'll get the new dashboard. If you want to stay on the old dashboard and get that data added, it's not impossible but it will require some coding as there is no option for that.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1851 | [Last Post](/forum/36-reports-statistics/890402-last-xx-orders#270345 "Hi, The new dashboard of HikaShop 3.x does include the date of the orders on the last orders listing: monosnap.com/file/aso9TTt6lXQb5KvRbi1i5IMiiEO5ER If you don't see that, it's probably that you're using the old dashboard of HikaShop. Go in the HikaShop configuration and turn off the "dashboard legacy" and you'll get the new dashboard. If you want to stay on the old dashboard and get that data added, it's not impossible but it will require some coding as there is no option for that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/36-reports-statistics/890390-double-timezone-specification) | [Double timezone specification](/forum/36-reports-statistics/890390-double-timezone-specification "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Chrome last version -- Error-message(debug-mod must be tuned on) -- : 0 DateTime::__construct(): Failed to parse time string (-001-11-29T23:40:28+00:00) at position 7 (-): Double timezone specification Hi ! After update to the latest J! version today, wanting to edit my report, i get the following error : 0 DateTime::__construct(): Failed to parse time string (-001-11-29T23:40:28+00:00) at position 7 (-): Double timezone specification In my search in the forum, I could only find this topic that is related : But this seems to old to be of help. Any help will be grately appreciated ! Thanks !") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 5 months ago, by [ijsbaanleuven](/forum/user/34667-ijsbaanleuven "View ijsbaanleuven's Profile") [Last Post](/forum/36-reports-statistics/890390-double-timezone-specification#270271 "Hi, We'll look at doing a better patch then. I'm glad the problem is now solved for you.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:3259 | [Last Post](/forum/36-reports-statistics/890390-double-timezone-specification#270271 "Hi, We'll look at doing a better patch then. I'm glad the problem is now solved for you.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/36-reports-statistics/890219-out-of-stock-notification-question) | [Out of Stock Notification Question](/forum/36-reports-statistics/890219-out-of-stock-notification-question "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 I have a question that I cannot figure out a solution to and it is a big product I have I have the Out of Stock Notification enabled. However, I have a category of products that have stock all set to 0 because they are catalog products that cannot be purchased. Then I have another set of products that when the stock falls below 200 from any of these product I need to be emailed that the stock is low. This is obviously an issue because the cron constantly notifies me because i have a category of products that are set to zero because I do not want the add to cart button to show. How can I exclude the category of products that have a zero quantity? Would this require custom modification of the plugin? Please let me know. Thanks, Josh") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 6 months ago, by [jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile") [Last Post](/forum/36-reports-statistics/890219-out-of-stock-notification-question#269465 "Hi, If you want to keep the stock to zero in these products and have the notification only for the other products, then yes, it would require the customization of the code of the plugin. An alternative would be to set the stock to unlimited in these products and instead set the sale start date in the future or the sale end date in the past for these products. That way, the add to cart button will still be unavailable for them but the out of stock notification plugin won't take these products into account as their stock will be unlimited.") 9 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:2150 | [Last Post](/forum/36-reports-statistics/890219-out-of-stock-notification-question#269465 "Hi, If you want to keep the stock to zero in these products and have the notification only for the other products, then yes, it would require the customization of the code of the plugin. An alternative would be to set the stock to unlimited in these products and instead set the sale start date in the future or the sale end date in the past for these products. That way, the add to cart button will still be unavailable for them but the out of stock notification plugin won't take these products into account as their stock will be unlimited.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 6 months ago | | [](/forum/36-reports-statistics/890048-pie-chart-breakdown-of-sale-by-payment-types-is-it-possible) | [Pie Chart breakdown of sale by payment types, is it possible?](/forum/36-reports-statistics/890048-pie-chart-breakdown-of-sale-by-payment-types-is-it-possible "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.5.38 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No Error Message I have tried to create a pie chart of sales by payment type, but this doesn't seem possible, I am correct in thinking it can't be done? All I need is sales over the year to show which payment method is prefered by the customer. Any help would be much appreciated. Many Thanks Ian") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 6 months ago, by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") [Last Post](/forum/36-reports-statistics/890048-pie-chart-breakdown-of-sale-by-payment-types-is-it-possible#268633 "Hi, There is indeed no option to generate such report. You can have a report as a table and configure each row of the table to display the total sales over the year for one payment method. That way, you can have a report of the data you're talking about. You just won't get the pie chart. And you can also export its data and generate the pie chart on excel easily.") 9 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1903 | [Last Post](/forum/36-reports-statistics/890048-pie-chart-breakdown-of-sale-by-payment-types-is-it-possible#268633 "Hi, There is indeed no option to generate such report. You can have a report as a table and configure each row of the table to display the total sales over the year for one payment method. That way, you can have a report of the data you're talking about. You just won't get the pie chart. And you can also export its data and generate the pie chart on excel easily.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 6 months ago | | [](/forum/36-reports-statistics/890008-reports-using-etickets) | [Reports using eTickets](/forum/36-reports-statistics/890008-reports-using-etickets "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.7.0 We are using the eTickets plugin for Hikashop and selling raffle tickets. We are trying to get a report that will show the customer name, number of tickets ordered and the ticket numbers that they have from their order. I am not able to create a report to show that info. Can someone help me with this effort.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 6 months ago, by [masweb](/forum/user/28463-masweb "View masweb's Profile") [Last Post](/forum/36-reports-statistics/890008-reports-using-etickets#268499 "Hello, For support on HikaSerial ; please use the HikaSerial section of the forum. In order to send the e-ticket, the ordre must be confirmed by a payment plugin or in the order details in the backend. If you confirm the ordre in the backend order listing, HikaSerial won't be able to send the image because the email is prepare before the order confirmation ; so before a serial is generated. But for more details ; please open a new thread.") 9 years 6 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:3 Views:1675 | [Last Post](/forum/36-reports-statistics/890008-reports-using-etickets#268499 "Hello, For support on HikaSerial ; please use the HikaSerial section of the forum. In order to send the e-ticket, the ordre must be confirmed by a payment plugin or in the order details in the backend. If you confirm the ordre in the backend order listing, HikaSerial won't be able to send the image because the email is prepare before the order confirmation ; so before a serial is generated. But for more details ; please open a new thread.") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 6 months ago | | [](/forum/36-reports-statistics/889921-eliminate-flash-requirement) | [Eliminate Flash Requirement](/forum/36-reports-statistics/889921-eliminate-flash-requirement "Flash is an outdated and insecure browser plugin and increasingly users will not or are not allowed to install it in work computers. Is there a version of HikaShop that does not require Flash to view...") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 6 months ago, by [boyjah](/forum/user/49643-boyjah "View boyjah's Profile") [Last Post](/forum/36-reports-statistics/889921-eliminate-flash-requirement#268025 "Turning off Legacy mode settings eliminated the Flash error.") 9 years 6 months ago by [boyjah](/forum/user/49643-boyjah "View boyjah's Profile") | Replies:4 Views:1526 | [Last Post](/forum/36-reports-statistics/889921-eliminate-flash-requirement#268025 "Turning off Legacy mode settings eliminated the Flash error.") by [boyjah](/forum/user/49643-boyjah "View boyjah's Profile") 9 years 6 months ago | | [](/forum/36-reports-statistics/889833-donation-meter) | [Donation meter](/forum/36-reports-statistics/889833-donation-meter "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 7.0.10 Anyone got developed a donation meter for Hikashop and would like to share?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 6 months ago, by [mindgem](/forum/user/49449-mindgem "View mindgem's Profile") [Last Post](/forum/36-reports-statistics/889833-donation-meter#267567 "No worries. Found the hikashopStatisticsClass and can use the queries from there in my module. Good stuff!") 9 years 6 months ago by [mindgem](/forum/user/49449-mindgem "View mindgem's Profile") | Replies:2 Views:1694 | [Last Post](/forum/36-reports-statistics/889833-donation-meter#267567 "No worries. Found the hikashopStatisticsClass and can use the queries from there in my module. Good stuff!") by [mindgem](/forum/user/49449-mindgem "View mindgem's Profile") 9 years 6 months ago | | [](/forum/36-reports-statistics/889683-order-this-month-shows-data-of-previous-month) | [Order this month..... shows data of previous month?](/forum/36-reports-statistics/889683-order-this-month-shows-data-of-previous-month "-- HikaShop version -- : 3.0.1 I was aspecting that Order this month shows the orders of the actual month.... but it shows the total order amount. I would be really handy if every month this Order this month was reset to zero an counting up the actual month. What a'm i missing? Kind regards René") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 7 months ago, by [renem](/forum/user/47055-renem "View renem's Profile") [Last Post](/forum/36-reports-statistics/889683-order-this-month-shows-data-of-previous-month#266761 "Clear to me now. I just enabled the legacy dashboard so i can use the report on my dashboard.") 9 years 7 months ago by [renem](/forum/user/47055-renem "View renem's Profile") | Replies:2 Views:1258 | [Last Post](/forum/36-reports-statistics/889683-order-this-month-shows-data-of-previous-month#266761 "Clear to me now. I just enabled the legacy dashboard so i can use the report on my dashboard.") by [renem](/forum/user/47055-renem "View renem's Profile") 9 years 7 months ago | | [](/forum/36-reports-statistics/889588-order-export-doesnt-create-csv-but-opens-new-page) | [Order export doesn´t create csv, but opens new page.](/forum/36-reports-statistics/889588-order-export-doesnt-create-csv-but-opens-new-page "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7.0.2 HI, when I try to export orders, it doesn´t generate csv, but opens new page with hikashop menu (not a standard page, but only links with broken diacritics). It used to work normally. We used our customised php for order export view, but even If i delete the customisation and use original version, there is no difference - still no export. Export of products works normally. I have found advice in this forum to increase memory limit in php.ini. I did - from 128 MB to 256 MB. It didn´t help. I have also tried to export only one order, but with the same result. Could you, please, check what coudl be the reason? I have sent admin login details via contact form. Thank you very much in advance for your help! Jarka") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 7 months ago, by [montemama](/forum/user/43131-montemama "View montemama's Profile") [Last Post](/forum/36-reports-statistics/889588-order-export-doesnt-create-csv-but-opens-new-page#266163 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7.0.2 HI, when I try to export orders, it doesn´t generate csv, but opens new page with hikashop menu (not a standard page, but only links with broken diacritics). It used to work normally. We used our customised php for order export view, but even If i delete the customisation and use original version, there is no difference - still no export. Export of products works normally. I have found advice in this forum to increase memory limit in php.ini. I did - from 128 MB to 256 MB. It didn´t help. I have also tried to export only one order, but with the same result. Could you, please, check what coudl be the reason? I have sent admin login details via contact form. Thank you very much in advance for your help! Jarka") 9 years 7 months ago by [montemama](/forum/user/43131-montemama "View montemama's Profile") | Replies:0 Views:1587 | [Last Post](/forum/36-reports-statistics/889588-order-export-doesnt-create-csv-but-opens-new-page#266163 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7.0.2 HI, when I try to export orders, it doesn´t generate csv, but opens new page with hikashop menu (not a standard page, but only links with broken diacritics). It used to work normally. We used our customised php for order export view, but even If i delete the customisation and use original version, there is no difference - still no export. Export of products works normally. I have found advice in this forum to increase memory limit in php.ini. I did - from 128 MB to 256 MB. It didn´t help. I have also tried to export only one order, but with the same result. Could you, please, check what coudl be the reason? I have sent admin login details via contact form. Thank you very much in advance for your help! Jarka") by [montemama](/forum/user/43131-montemama "View montemama's Profile") 9 years 7 months ago | | [](/forum/36-reports-statistics/889528-reports-for-customers-with-repeat-orders-within-the-last-x-months) | [Reports for Customers with Repeat Orders within the last X months](/forum/36-reports-statistics/889528-reports-for-customers-with-repeat-orders-within-the-last-x-months "-- HikaShop version -- : 2.1.3 -- Joomla version -- : 2.5.18 -- PHP version -- : 5.4.45 -- Browser(s) name and version -- : Any -- Error-message(debug-mod must be tuned on) -- : none Hi. I'm trying to find a way to generate a report based on Customers that have repeat ordered over the last 2,3,4,5,6,7,8,9,10,11,12 months. I'd like a high level report first that just shows Customer and "Yes repeat ordered", a medium level report showing Customer and "X Number of Repeat Orders" and a high detail level report that shows Customer and "Order Dates". So pretty much 3 different reports where I can change the months value. Is that possible? I haven't been able to work out how to do it. Many thanks :) KBIT") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 7 months ago, by [KBIT](/forum/user/9694-kbit "View KBIT's Profile") [Last Post](/forum/36-reports-statistics/889528-reports-for-customers-with-repeat-orders-within-the-last-x-months#265859 "Hi, There is no system in HikaShop to get such report. So the only solution I can propose is to export the orders as a CSV with the export button of the HikaShop orders listing. And then import it in Excel and use some functions of Excel to extract such report from the data. I suppose something like that might do it: www.ibm.com/support/knowledgecenter/en/S...ls_excel_output.html") 9 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1945 | [Last Post](/forum/36-reports-statistics/889528-reports-for-customers-with-repeat-orders-within-the-last-x-months#265859 "Hi, There is no system in HikaShop to get such report. So the only solution I can propose is to export the orders as a CSV with the export button of the HikaShop orders listing. And then import it in Excel and use some functions of Excel to extract such report from the data. I suppose something like that might do it: www.ibm.com/support/knowledgecenter/en/S...ls_excel_output.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 7 months ago | | [](/forum/36-reports-statistics/889363-low-quantity-notification-email-not-sent) | [Low quantity notification email not sent](/forum/36-reports-statistics/889363-low-quantity-notification-email-not-sent "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello My client is testing the low quantity notification email function. So she made a new order and a product has now 0 stock. But no emails where sent. I saw that I forgot to setup the CRON task. Now I received the repport that the Cron task was launched correctly, But I never receveide the email that tells me about my product that don't have stock anymore. What is happening ? Thanks !") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 7 months ago, by [skouf](/forum/user/7130-skouf "View skouf's Profile") [Last Post](/forum/36-reports-statistics/889363-low-quantity-notification-email-not-sent#265537 "Great ! Your patch worked ! Thanks for your time ! I will test on the PROD environment now") 9 years 7 months ago by [skouf](/forum/user/7130-skouf "View skouf's Profile") | Replies:11 Views:2524 | [Last Post](/forum/36-reports-statistics/889363-low-quantity-notification-email-not-sent#265537 "Great ! Your patch worked ! Thanks for your time ! I will test on the PROD environment now") by [skouf](/forum/user/7130-skouf "View skouf's Profile") 9 years 7 months ago | | [](/forum/36-reports-statistics/889379-product-warranty-period) | [Product Warranty Period](/forum/36-reports-statistics/889379-product-warranty-period "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.5 Hi Is there any way to track product warranty after sales in hikashop? thanks & regards.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 7 months ago, by [shenkstore](/forum/user/42859-shenkstore "View shenkstore's Profile") [Last Post](/forum/36-reports-statistics/889379-product-warranty-period#265159 "Hello, Hard to answer you because we don't have lots of information, and especially about context. Tell us which kind of products you have in mind, does product have something that can allow to identified them ? Does this solution must works for few products or a lot ?... Awaiting details from you to better answer you. Regards") 9 years 7 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:1 Views:1280 | [Last Post](/forum/36-reports-statistics/889379-product-warranty-period#265159 "Hello, Hard to answer you because we don't have lots of information, and especially about context. Tell us which kind of products you have in mind, does product have something that can allow to identified them ? Does this solution must works for few products or a lot ?... Awaiting details from you to better answer you. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 9 years 7 months ago | | [](/forum/36-reports-statistics/889275-exporting-order-prices-with-and-without-vat) | [Exporting order prices with and without VAT](/forum/36-reports-statistics/889275-exporting-order-prices-with-and-without-vat "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I know we can export orders to a CSV file and have the order_price and order_full_tax included. However my client has products that do and do not have VAT applied to them. Is it possible to export the total price of products that have VAT, and the total price of product without VAT. Thanks Lee") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 8 months ago, by [ltempest](/forum/user/1784-ltempest "View ltempest's Profile") [Last Post](/forum/36-reports-statistics/889275-exporting-order-prices-with-and-without-vat#264559 "Hi, There is no option for that. You would have to edit the file "export" of the view "order" via the menu Display>Views and add some custom code to calculate that for each order.") 9 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1631 | [Last Post](/forum/36-reports-statistics/889275-exporting-order-prices-with-and-without-vat#264559 "Hi, There is no option for that. You would have to edit the file "export" of the view "order" via the menu Display>Views and add some custom code to calculate that for each order.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 8 months ago | | [](/forum/36-reports-statistics/889000-how-to-setting-hikashop-dashboard) | [how to setting hikashop dashboard](/forum/36-reports-statistics/889000-how-to-setting-hikashop-dashboard "-- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.4.45 -- Error-message(debug-mod must be tuned on) -- : no error msg hai, i try to enable hikashop plugin for backend dashboard. but the report didnt show any data.. the report not syc as shown on dashboard inside hikashop extension. please refer to the attachment for more understanding") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 8 months ago, by [sayasani](/forum/user/45193-sayasani "View sayasani's Profile") [Last Post](/forum/36-reports-statistics/889000-how-to-setting-hikashop-dashboard#264333 "Hi, As we said earlier, you need to make sure that the "statistics" settings in the menu System>Order statuses correspond to what you want to display. So if your orders are created and not confirmed, you want to activate "created" there. If your orders are confirmed, you want to activate "confirmed" there. Etc.") 9 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:16 Views:4192 | [Last Post](/forum/36-reports-statistics/889000-how-to-setting-hikashop-dashboard#264333 "Hi, As we said earlier, you need to make sure that the "statistics" settings in the menu System>Order statuses correspond to what you want to display. So if your orders are created and not confirmed, you want to activate "created" there. If your orders are confirmed, you want to activate "confirmed" there. Etc.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 8 months ago | | [](/forum/36-reports-statistics/889229-custom-reports) | [Custom Reports](/forum/36-reports-statistics/889229-custom-reports "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.5 -- PHP version -- : 7.0.1 -- Browser(s) name and version -- : Firefox 51 Can we change the labels on reports? If so how, or is this a feature in an upgrade the client will need to look at? In the image attached we have created a report which has two years being compared, we would like it to show 2017 vs 2016 i.e. This YYYY vs Last YYYY") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 8 months ago, by [twhcreations](/forum/user/3186-twhcreations "View twhcreations's Profile") [Last Post](/forum/36-reports-statistics/889229-custom-reports#264336 "Hi, I've configured a report like you: monosnap.com/file/bYzHHGfwsEpqNhqZxWw4Bbi8c2gDVH And it displays fine on my end with HikaShop 2.6.4 Now regarding the labels, you can edit the file "chart" of the view "dashboard" via the menu Display>Views and change the line: in order to set your own name.") 9 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1371 | [Last Post](/forum/36-reports-statistics/889229-custom-reports#264336 "Hi, I've configured a report like you: monosnap.com/file/bYzHHGfwsEpqNhqZxWw4Bbi8c2gDVH And it displays fine on my end with HikaShop 2.6.4 Now regarding the labels, you can edit the file "chart" of the view "dashboard" via the menu Display>Views and change the line: in order to set your own name.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 8 months ago | | [](/forum/36-reports-statistics/889111-3-0-0-dashboard-question) | [3.0.0 dashboard question](/forum/36-reports-statistics/889111-3-0-0-dashboard-question "-- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 Hi, I have read this thread attentively. The new dashboard uses numbers and dates of invoices. I don't use invoices, there are only data of orders . In the legacy mode the dashboard is well displayed. I'm trying to switch the site to the new system. And I want to use the new dashboard. Jerome wrote: But, there is no the setting "stats_valid_order_statuses" in the backend order status listing. I have the newest version 3.0.0. Will there be this option in the near future? Or the new dashboard will always use only invoices? Best regards,") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 8 months ago, by [almika](/forum/user/15732-almika "View almika's Profile") [Last Post](/forum/36-reports-statistics/889111-3-0-0-dashboard-question#264022 "Hi, Oh yes, that's right. The "this.day" have the same content than "this.week". I'll push the patch. Regards,") 9 years 8 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:7 Views:2082 | [Last Post](/forum/36-reports-statistics/889111-3-0-0-dashboard-question#264022 "Hi, Oh yes, that's right. The "this.day" have the same content than "this.week". I'll push the patch. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 8 months ago | | [](/forum/36-reports-statistics/888479-monthly-spend) | [Monthly Spend](/forum/36-reports-statistics/888479-monthly-spend "-- HikaShop version -- : Business -- Error-message(debug-mod must be tuned on) -- : none Hi, I'm not sure how I did it but I've made the Dashboard report "total spend this month" disappear, and I cant get it back, Ive tried to create a new one but cant find how to add the total monthly income, any advice ? thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 9 months ago, by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") [Last Post](/forum/36-reports-statistics/888479-monthly-spend#260401 "Update: found it - :) thanks anyway") 9 years 9 months ago by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") | Replies:1 Views:2193 | [Last Post](/forum/36-reports-statistics/888479-monthly-spend#260401 "Update: found it - :) thanks anyway") by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") 9 years 9 months ago | | [](/forum/36-reports-statistics/888420-custom-report) | [Custom report](/forum/36-reports-statistics/888420-custom-report "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.5 Hello, I'd like to setup a custom report that includes, both the order and customer details. I can't see how to create a report that will export both the order details and the customer details in one CSV file. i have looked at the Mass Actions, and they work to a point, but I cannot seem to figure out how to order the fields being exported. I have found the export.php file which I can see does the clever stuff of exporting the data you select via the Reports menu option. Is it possible to modify this to include both the order details and the customer details in one CSV file. Thanks Lee") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 9 months ago, by [ltempest](/forum/user/1784-ltempest "View ltempest's Profile") [Last Post](/forum/36-reports-statistics/888420-custom-report#260273 "Hi, I'm not sure what more I can say. There is even an example provided there with the code you can use to remove a column from the CSV: www.hikashop.com/forum/import-export-csv...r-export.html#239282") 9 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1949 | [Last Post](/forum/36-reports-statistics/888420-custom-report#260273 "Hi, I'm not sure what more I can say. There is even an example provided there with the code you can use to remove a column from the CSV: www.hikashop.com/forum/import-export-csv...r-export.html#239282") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 9 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)