[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/907870-customiser-le-dashboard) | [Customiser le Dashboard](/forum/36-reports-statistics/907870-customiser-le-dashboard "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 4.4.3 -- PHP version -- : 8.1.27 Bonjour, Je ne vois pas comment customiser le dasboard… J'ai supprimé les rapports inutiles, créé et activé les rapports dont j'ai besoin : rien ne change dans le dasboard Rien de cela dans la config globale Comment doit-on s'y prendre ? Merci") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 8 months ago, by [marcmarc](/forum/user/1529-marcmarc "View marcmarc's Profile") [Last Post](/forum/36-reports-statistics/907870-customiser-le-dashboard#364564 "Hi, In your custom plugin, you can implement the event like so: That will display the data used by HikaShop to generate the new dashboard. You can then directly modify the content of the $data variable in order to adapt it to your needs. In $data, you have access to the placement of each block, the formatting, the elements to build the MySQL query to load the data, etc. For example, if you want to change the title "Last orders" of the section with the list of the latest orders, you could use: Or if you wanted the orders of that listing to be loaded based on the "order_invoice_created" column instead of the "order_created" column, you could add: Or if you wanted this area to use the whole width on big screens, you could add: Basically, you have all the latitude to build your own dashboard, or do small tweaks here and there.") 1 year 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:4 Views:1209 | [Last Post](/forum/36-reports-statistics/907870-customiser-le-dashboard#364564 "Hi, In your custom plugin, you can implement the event like so: That will display the data used by HikaShop to generate the new dashboard. You can then directly modify the content of the $data variable in order to adapt it to your needs. In $data, you have access to the placement of each block, the formatting, the elements to build the MySQL query to load the data, etc. For example, if you want to change the title "Last orders" of the section with the list of the latest orders, you could use: Or if you wanted the orders of that listing to be loaded based on the "order_invoice_created" column instead of the "order_created" column, you could add: Or if you wanted this area to use the whole width on big screens, you could add: Basically, you have all the latitude to build your own dashboard, or do small tweaks here and there.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 11 months ago | | [](/forum/36-reports-statistics/908460-cart-to-big) | [Cart to big](/forum/36-reports-statistics/908460-cart-to-big "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 3.10 -- PHP version -- : 8.4 -- Browser(s) name and version -- : chrome The cart has got so big I need to clear it out. I have changed the settings to every minute for now, but with so many entries it will take a while for it to clear out automatically . Can I via phpmyadmin Clear the hikashop_cart_product and hikashop_cart tables using the empty link/button and nothing bad will happen? Seen other posts around this subject just wanted to make sure before I do that. Thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 3 months ago, by [dailybread](/forum/user/41988-dailybread "View dailybread's Profile") [Last Post](/forum/36-reports-statistics/908460-cart-to-big#362457 "Hi, Yes. You can do that. People with a cart or a wishlist will just loose them. But everything will work fine.") 2 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1050 | [Last Post](/forum/36-reports-statistics/908460-cart-to-big#362457 "Hi, Yes. You can do that. People with a cart or a wishlist will just loose them. But everything will work fine.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 3 months ago | | [](/forum/36-reports-statistics/908365-sales-report-gives-unsupported-operand-error) | [Sales Report gives Unsupported Operand Error](/forum/36-reports-statistics/908365-sales-report-gives-unsupported-operand-error "-- HikaShop version -- : 5.1.0 -- Joomla version -- : 4.4.5 -- PHP version -- : 8.2.21 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 0 Unsupported operand types: int - string Call stack # Function Location 1 () JROOT/administrator/components/com_hikashop/classes/widget.php:625 2 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:89 3 dashboardViewDashboard->widgets() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:26 4 dashboardViewDashboard->listing() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 5 dashboardViewDashboard->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 6 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2596 7 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2305 8 hikashopController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:693 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2574 10 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 11 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 12 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 14 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 15 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 16 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 17 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 18 require_once() JROOT/administrator/index.php:32 Running the Sales Report with the following parameters gives an error: O:8:"stdClass":26:{s:7:"display";s:7:"listing";s:9:"date_type";s:7:"created";s:10:"date_group";s:5:"%j %Y";s:10:"periodType";s:14:"proposedPeriod";s:14:"proposedPeriod";s:12:"previousWeek";s:6:"period";s:1:"0";s:7:"content";s:6:"orders";s:7:"filters";s:97:"a:2:{s:14:"a.order_status";a:1:{i:0;s:7:"shipped";}s:19:"a.order_currency_id";a:1:{i:0;s:1:"6";}}";s:15:"category_childs";s:1:"0";s:9:"customers";s:14:"last_customers";s:15:"customers_order";s:5:"sales";s:8:"partners";s:14:"last_customers";s:14:"partners_order";s:5:"sales";s:12:"compare_with";s:6:"values";s:5:"limit";s:2:"20";s:6:"region";s:5:"world";s:6:"format";s:5:"UTF-8";s:10:"map_source";s:8:"shipping";s:12:"product_data";s:5:"sales";s:16:"product_order_by";s:4:"best";s:15:"orders_order_by";s:4:"last";s:24:"orders_total_calculation";s:12:"include_fees";s:10:"categories";s:3:"all";s:8:"products";s:6:"a:0:{}";s:7:"coupons";s:6:"a:0:{}";s:6:"status";s:0:"";} This results in an Unsupported Operand error and means the entire Dashboard is unavailable. Please advise if you need any further information or if you need access to the site.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 4 months ago, by [bmm01](/forum/user/14439-bmm01 "View bmm01's Profile") [Last Post](/forum/36-reports-statistics/908365-sales-report-gives-unsupported-operand-error#362064 "Hi, For anyone with the same issue, we've added a patch for this problem. If you're on HikaShop 5.1.0, download again the install package of HikaShop on our website and install it on yours to get the latest version of HikaShop with that patch. If you're on a lower version of HikaShop, just update HikaShop. If you're on a higher version of HikaShop, you should not have that error. It's probably another error. Please open a new topic and provide information about your error. You can provide a link to this thread as reference in your message.") 2 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:1004 | [Last Post](/forum/36-reports-statistics/908365-sales-report-gives-unsupported-operand-error#362064 "Hi, For anyone with the same issue, we've added a patch for this problem. If you're on HikaShop 5.1.0, download again the install package of HikaShop on our website and install it on yours to get the latest version of HikaShop with that patch. If you're on a lower version of HikaShop, just update HikaShop. If you're on a higher version of HikaShop, you should not have that error. It's probably another error. Please open a new topic and provide information about your error. You can provide a link to this thread as reference in your message.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 4 months ago | | [](/forum/36-reports-statistics/908244-reports-questions) | [Reports Questions](/forum/36-reports-statistics/908244-reports-questions "Hello, I want to export all the store products and include the quantity and price. Is there an easy way to do this? I also want to generate a report listing the sales and quantity of a given amount of time.. like from jan - aug. Is there an easy way to do this? I need to add the cost of each product to each product can I do this using custom fields or is there already a built-in feature for this? I am using HiksShop business and reports are not my strong points and I need a little help figuring these out. Thank you.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 5 months ago, by [GrandLodgeIL](/forum/user/78970-grandlodgeil "View GrandLodgeIL's Profile") [Last Post](/forum/36-reports-statistics/908244-reports-questions#361640 "I will study this more and come back if I have specific questions. Thank you") 2 years 4 months ago by [GrandLodgeIL](/forum/user/78970-grandlodgeil "View GrandLodgeIL's Profile") | Replies:3 Views:1088 | [Last Post](/forum/36-reports-statistics/908244-reports-questions#361640 "I will study this more and come back if I have specific questions. Thank you") by [GrandLodgeIL](/forum/user/78970-grandlodgeil "View GrandLodgeIL's Profile") 2 years 4 months ago | | [](/forum/36-reports-statistics/908276-the-backend-main-statistic-report-cannot-load) | [The backend main statistic report cannot load](/forum/36-reports-statistics/908276-the-backend-main-statistic-report-cannot-load "-- HikaShop version -- : 4.5.1 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : Google Chrome Hi, can check also why the backend dashboard main statistics cannot load. currently is disable the main statistic report, if enable it keep loading and lead to timeout session issue. Waiting for your quick update on the matters, thanks bookshop.school2u.my/administrator/index...hikashop&ctrl=report --> prnt.sc/Ta4NhCgoZwJm Timeout issue error --> prnt.sc/W_ubwxHPZeBy") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 5 months ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") [Last Post](/forum/36-reports-statistics/908276-the-backend-main-statistic-report-cannot-load#361508 "Hi, This indicates that the report is configured to run MySQL queries which takes too much time for the restrictions set by your hosting. Since you can't edit the report, you need to delete it and reconfigure it and make sure it doesn't have to process too much data. For example, if you have thousands of orders or more in your shop, you want to restrict the time period of your report. For example, to last year only. That way, instead of processing all your orders to generate stats, it will only process the orders of last year.") 2 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1014 | [Last Post](/forum/36-reports-statistics/908276-the-backend-main-statistic-report-cannot-load#361508 "Hi, This indicates that the report is configured to run MySQL queries which takes too much time for the restrictions set by your hosting. Since you can't edit the report, you need to delete it and reconfigure it and make sure it doesn't have to process too much data. For example, if you have thousands of orders or more in your shop, you want to restrict the time period of your report. For example, to last year only. That way, instead of processing all your orders to generate stats, it will only process the orders of last year.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 5 months ago | | [](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report) | [1054 Unknown column 'o.order\_created' in 'where clause' when generating report](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report "-- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.2 -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'o.order_created' in 'where clause' Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Hi, I'm trying to generate a table based report that includes the 'total customers' option, see here for details: scribehow.com/shared/Generate_a_Customer...DKl9nPTMSeTaLdlj5yuA When report is saved I get a page stating An error has occurred. 1054 Unknown column 'o.order_created' in 'where clause' Doing this with debug turned on gives me: Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Do you have any ideas how I can resolve this? Thanks in advance. KH") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 5 months ago, by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") [Last Post](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report#361063 "Thanks Nicolas, All working now. KH") 2 years 5 months ago by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") | Replies:2 Views:996 | [Last Post](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report#361063 "Thanks Nicolas, All working now. KH") by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") 2 years 5 months ago | | [](/forum/36-reports-statistics/907857-ga4-plugin-results-in-ga4-gtag-ads) | [GA4 plugin results in ga4 + gtag + ads](/forum/36-reports-statistics/907857-ga4-plugin-results-in-ga4-gtag-ads "Hi, My ads manager asked if i can ask how to perfect the plugin connection for sales details. He mentioned it has probably to do with "datalayer" but i am not skilled at all. Could someone skilled in the GA4 plugin and how it should work in GA4 and gtag/ads check my attachment to see why we only get "not set" results on all sales and how to specify in gtag/ga4 what kind of sales they actually are? Kind regards.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 8 months ago, by [NicoW](/forum/user/58228-nicow "View NicoW's Profile") [Last Post](/forum/36-reports-statistics/907857-ga4-plugin-results-in-ga4-gtag-ads#359925 "Hi, There are two javascript files: - For GA4, you have this file : www.googletagmanager.com/gtag/js The GA4 plugin we developed adds it to the pages automatically. I can see it is also added by something else on your website, right at the end of the pages. This is not necessary and could be deactivated. - For tag manager, you have this file: www.googletagmanager.com/gtm.js Our GA4 plugin doesn't add it to the pages. Yet, you have it added to your pages twice somehow.") 2 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:13 Views:1443 | [Last Post](/forum/36-reports-statistics/907857-ga4-plugin-results-in-ga4-gtag-ads#359925 "Hi, There are two javascript files: - For GA4, you have this file : www.googletagmanager.com/gtag/js The GA4 plugin we developed adds it to the pages automatically. I can see it is also added by something else on your website, right at the end of the pages. This is not necessary and could be deactivated. - For tag manager, you have this file: www.googletagmanager.com/gtm.js Our GA4 plugin doesn't add it to the pages. Yet, you have it added to your pages twice somehow.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 7 months ago | | [](/forum/36-reports-statistics/907852-shipping-method-on-the-delivery-note-printout) | [Shipping method on the delivery note printout.](/forum/36-reports-statistics/907852-shipping-method-on-the-delivery-note-printout "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 4.4.3 -- PHP version -- : 8.2 -- Browser(s) name and version -- : Edge Chrome FF Hello I would like to specify the shipping method on the delivery note printout. In which file do I have to edit the delivery note? I assume I can take the code from the invoice. Where can I find the invoice file? best regards adi") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 8 months ago, by [info@adiheutschi.ch](/forum/user/56513-info-adiheutschi-ch "View info@adiheutschi.ch's Profile") [Last Post](/forum/36-reports-statistics/907852-shipping-method-on-the-delivery-note-printout#359546 "Hi, The shipping method name will be added to the shipping invoice and the invoice automatically as long as a shipping method has been selected in the order. Views can be edited via the menu Display>Views. And to find out which view file is used where, you want to activate the "Display view files" setting of the HikaShop configuration. You can read more about this here: www.hikashop.com/support/documentation/1...-display.html#layout") 2 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:781 | [Last Post](/forum/36-reports-statistics/907852-shipping-method-on-the-delivery-note-printout#359546 "Hi, The shipping method name will be added to the shipping invoice and the invoice automatically as long as a shipping method has been selected in the order. Views can be edited via the menu Display>Views. And to find out which view file is used where, you want to activate the "Display view files" setting of the HikaShop configuration. You can read more about this here: www.hikashop.com/support/documentation/1...-display.html#layout") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 8 months ago | | [](/forum/36-reports-statistics/907602-hikashop-dashboard-widget) | [Hikashop Dashboard Widget](/forum/36-reports-statistics/907602-hikashop-dashboard-widget "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.0 -- Error-message(debug-mod must be tuned on) -- : none Hi I updated to Paypal checkout plugin. On the dashboard it shows total paypal sales amount, however it displays only created, even though I selected confirmed in settings. I have created additional widgets using different status for each, created, pending, confirmed, yet the total sales for paypal only displays 'created' no matter what the status please see pdf for example can you please advise? thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 9 months ago, by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") [Last Post](/forum/36-reports-statistics/907602-hikashop-dashboard-widget#358331 "Thanks nicolas, apologies for wasting your time here I missed the "you've turned off the "include coupon" setting" I didn't notice that at all and it was set to off by default I think, I was looking for 81 not 120 as 120 was the failed payment on the 3rd purchase 'created'. Thanks and sorry for the confusion.") 2 years 9 months ago by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") | Replies:4 Views:868 | [Last Post](/forum/36-reports-statistics/907602-hikashop-dashboard-widget#358331 "Thanks nicolas, apologies for wasting your time here I missed the "you've turned off the "include coupon" setting" I didn't notice that at all and it was set to off by default I think, I was looking for 81 not 120 as 120 was the failed payment on the 3rd purchase 'created'. Thanks and sorry for the confusion.") by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") 2 years 9 months ago | | [](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose) | [Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2.34 Hi Hikashop Team, Our side got settings the date at report as image attach : prnt.sc/4WObxPQ3cJ5Y But the listing are total how many coupons been used not in the specific day that been choose. How to settings make it become list out only the amount of coupons been use on the day or date been selected? Kindly advise. Thank you.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 10 months ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") [Last Post](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358073 "Hi, In the file administrator/components/com_hikashop/classes/widget.php you can change the code: to:") 2 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:9 Views:1013 | [Last Post](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358073 "Hi, In the file administrator/components/com_hikashop/classes/widget.php you can change the code: to:") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 10 months ago | | [](/forum/36-reports-statistics/906899-after-converting-to-joomla-4-reporting-no-longer-work-properly) | [After converting to Joomla 4 Reporting no longer work properly?](/forum/36-reports-statistics/906899-after-converting-to-joomla-4-reporting-no-longer-work-properly "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 4 Latest -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : Report widgets not working correctly. Notice: Undefined index: billing in /var/www/web/joomla4/administrator/components/com_hikashop/views/user/tmpl/form_address.php on line 37 Warning: Invalid argument supplied for foreach() in /var/www/web/joomla4/administrator/components/com_hikashop/views/user/tmpl/form_address.php on line 37 Notice: Undefined property: stdClass::$user_id in /var/www/web/joomla4/administrator/components/com_hikashop/views/user/tmpl/form_address.php on line 67 Default shipping address No address Notice: Undefined index: shipping in /var/www/web/joomla4/administrator/components/com_hikashop/views/user/tmpl/form_address.php on line 37 Warning: Invalid argument supplied for foreach() in /var/www/web/joomla4/administrator/components/com_hikashop/views/user/tmpl/form_address.php on line 37 Notice: Undefined property: stdClass::$user_id in /var/www/web/joomla4/administrator/components/com_hikashop/views/user/tmpl/form_address.php on line 67 Hi All, Report Widgets don't work as they did in Joomla3 All previous report Widgets are missing replaced with default reports. I can goo in and try and edit the old reports but it comes up with errors. Thanks Ian") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 2 months ago, by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") [Last Post](/forum/36-reports-statistics/906899-after-converting-to-joomla-4-reporting-no-longer-work-properly#354787 "Hello, Can you process somes tests : - With a default template (Cassiopeia) - Without any custom css in your Css Options part (Main configuration => Display tab) Make your returns Regards") 3 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:12 Views:1239 | [Last Post](/forum/36-reports-statistics/906899-after-converting-to-joomla-4-reporting-no-longer-work-properly#354787 "Hello, Can you process somes tests : - With a default template (Cassiopeia) - Without any custom css in your Css Options part (Main configuration => Display tab) Make your returns Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 3 years 2 months ago | | [](/forum/36-reports-statistics/906447-custom-report) | [Custom Report](/forum/36-reports-statistics/906447-custom-report "-- url of the page with the problem -- : maineroots.org -- HikaShop version -- : 4.7.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : none Hi, I've a request to put all of the following fields into a report. Is it possible? If so, what is the best way to proceed? order_id order_status order_number order_created order_modified Total Purchase Tax order_shipping_price order_full_price order_payment_method order_shipping_method order_weight order_volume order_member address_firstname address_lastname address_street address_post_code address_city address_state item name quantity ordered Thanks for any assistance") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 5 months ago, by [a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile") [Last Post](/forum/36-reports-statistics/906447-custom-report#351953 "Hi, You want to create a mass action of the type "order" with an action "export a CSV file" via the menu System>Mass actions. Select the columns you want and click on the "process" button and it will give you a CSV file with the data. You can then open that CSV with Excel or libreoffice.") 3 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:914 | [Last Post](/forum/36-reports-statistics/906447-custom-report#351953 "Hi, You want to create a mass action of the type "order" with an action "export a CSV file" via the menu System>Mass actions. Select the columns you want and click on the "process" button and it will give you a CSV file with the data. You can then open that CSV with Excel or libreoffice.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 5 months ago | | [](/forum/36-reports-statistics/906415-custom-report-of-product-sales) | [Custom Report of Product Sales](/forum/36-reports-statistics/906415-custom-report-of-product-sales "What would be the best way to go about creating a report with the following? A list of all products/variants with the following fields: Product ID, Product Name, Product Category, Total Sales, Quantity on Hand, Published Status Where Total Sales is the total number of individual products sold of that product. I need to be able to export this data as a csv. Seems like getting this data out of an Ecommerce solution should be easy. For the life of me, I can't seem to get this to work. Am I missing something?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 5 months ago, by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") [Last Post](/forum/36-reports-statistics/906415-custom-report-of-product-sales#351888 "Thank you. The issue was a 180 second timeout on the firewall we have on the website. We are working around it.") 3 years 5 months ago by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") | Replies:4 Views:1052 | [Last Post](/forum/36-reports-statistics/906415-custom-report-of-product-sales#351888 "Thank you. The issue was a 180 second timeout on the firewall we have on the website. We are working around it.") by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") 3 years 5 months ago | | [](/forum/36-reports-statistics/905985-mass-actions-sort-error) | [Mass Actions Sort Error](/forum/36-reports-statistics/905985-mass-actions-sort-error "-- HikaShop version -- : 4.7.1 -- Joomla version -- : 4.2.8 -- PHP version -- : 8.1.16 -- Browser(s) name and version -- : google -- Error-message(debug-mod must be tuned on) -- : none Hi, Since updating to 4.2.8 we now cannot sort tables by 'Name' in Mass Actions (a single click on name used to sort tables) there is something that was not there before, I have noticed this is also in the products and seems pointless to me as you can filter by using filter options?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 8 months ago, by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") [Last Post](/forum/36-reports-statistics/905985-mass-actions-sort-error#349715 "Yes its the custom css thank you") 3 years 8 months ago by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") | Replies:2 Views:817 | [Last Post](/forum/36-reports-statistics/905985-mass-actions-sort-error#349715 "Yes its the custom css thank you") by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") 3 years 8 months ago | | [](/forum/36-reports-statistics/905752-rapport-des-ventes-en-hors-taxes) | [Rapport des ventes en Hors taxes](/forum/36-reports-statistics/905752-rapport-des-ventes-en-hors-taxes "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 3.10.11 Bonjour, Il n'est pas trop tard: Meilleurs voeux pour cette nouvelle année pour toute l'équipe de développeurs de la meilleure solution E-Commerce..... Svp, comment feriez vous pour exporter depuis le menu "Rapports" toutes les ventes en Hors taxes (sans frais de livraisons bien sûr) ? je n'arrive qu'à exporter en TTC... Merci beaucoup ! A bientôt") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 9 months ago, by [ghislain](/forum/user/8263-ghislain "View ghislain's Profile") [Last Post](/forum/36-reports-statistics/905752-rapport-des-ventes-en-hors-taxes#348562 "Bonjour, Merci et bonne année 2023 à vous aussi ! Je ne pense pas que cela soit faisable depuis le menu Rapports, même en modifiant le code. Par contre, avec une action de masse, c'est assez facile. Vous allez dans Système>Actions de masse, et créez une action de masse de type "commande". Vous pouvez ajouter des filtres, pour le statut de commande, ou la date de création de la facture, etc. Et ensuite, vous pouvez utiliser une action "exporter un fichier CSV" et choisir les colonnes. Il y aura une colonne pour le montant total HT. Il inclura les frais de livraison, mais vous pouvez également exporter les frais de livraison TTC et le montant de taxes sur les frais de livraison. Donc ensuite, sous excel vous pouvez soustraire les colonnes dans une nouvelle colonne pour obtenir le montant total HT, livraison non comprise.") 3 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:804 | [Last Post](/forum/36-reports-statistics/905752-rapport-des-ventes-en-hors-taxes#348562 "Bonjour, Merci et bonne année 2023 à vous aussi ! Je ne pense pas que cela soit faisable depuis le menu Rapports, même en modifiant le code. Par contre, avec une action de masse, c'est assez facile. Vous allez dans Système>Actions de masse, et créez une action de masse de type "commande". Vous pouvez ajouter des filtres, pour le statut de commande, ou la date de création de la facture, etc. Et ensuite, vous pouvez utiliser une action "exporter un fichier CSV" et choisir les colonnes. Il y aura une colonne pour le montant total HT. Il inclura les frais de livraison, mais vous pouvez également exporter les frais de livraison TTC et le montant de taxes sur les frais de livraison. Donc ensuite, sous excel vous pouvez soustraire les colonnes dans une nouvelle colonne pour obtenir le montant total HT, livraison non comprise.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 9 months ago | | [](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order) | [Unbale to export orders with amount of products per order](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order "-- HikaShop version -- : 4.6.2 -- Joomla version -- : 4.2.5 -- PHP version -- : 8.1.11 I am trying to look for a way to perform an export of our orders which shows per order, how many of each product was chosen. I am currently doing this with a Mass Action, using "order" as the datasource and only exporting order_id, order_product_code and order_product_quantity Let's say I am only selling 4 items: Coke, Sprite, Milk and Juice. The first customer places an order for 3 cokes The next customer orders 1 juice and 1 sprite The next customer orders 4 times milk The next customer orders 1 Sprite + 1 Coke + 2 Juices and 5 times Milk The last customer orders 2 times Sprite and 1 Milk In an ideal world, I would have an export showing the following: (see attached screenshot 1) With Hikashop, the best I seem to get is: (see attached screenshot 2) ID 1 only has data for the fields relating to item1 since the customer ordered 1 product ID 2 has data for the fields item1 and item2 since the customer ordered 2 products ... ID 4 has data for all the fields since the customer ordered 4 products Hikashop uses the order in which a customer adds products to his cart to populate the fields item1_productcode, item2_productcode etc.. Item1_productcode can, in my example, contain 4 possible values.. Since the amount of columns is different per row and since the values in the productcode or set based on the ordere a product is added, it is impossible with Excel to transform the data into my example above 'for the ideal world'. What I would need is the 4 possible values (Coke, Sprite, Milk, Juice) as the column header and per order (row) the amount of articles that was chosen for that product. Does anybody have an idea on how to create this export which seems to be rather logical functionality... Any help would be much appreciated!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 years 11 months ago, by [maartenxbosmans@gmail.com](/forum/user/60008-maartenxbosmans-gmail-com "View maartenxbosmans@gmail.com's Profile") [Last Post](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order#346635 "Hi, I don't see a way to do that inside HikaShop. It's possible to generate a report to get the number of sales of each products (one per row) like this: But there is no option to keep it split by order. That would require a complex MySQL query like this: where XX, YY, ZZ and AA would be the id of the products Coke, Sprite, Milk and Juice, and #__ the prefix of your tables (setting in the joomla configuration). You could run that MySQL query in your PHPMyAdmin to get the export you want.") 3 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:921 | [Last Post](/forum/36-reports-statistics/905361-unbale-to-export-orders-with-amount-of-products-per-order#346635 "Hi, I don't see a way to do that inside HikaShop. It's possible to generate a report to get the number of sales of each products (one per row) like this: But there is no option to keep it split by order. That would require a complex MySQL query like this: where XX, YY, ZZ and AA would be the id of the products Coke, Sprite, Milk and Juice, and #__ the prefix of your tables (setting in the joomla configuration). You could run that MySQL query in your PHPMyAdmin to get the export you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 11 months ago | | [](/forum/36-reports-statistics/904303-out-of-stock-notification-just-one-mail-when-only-a-product-stock-drops-to-cero) | [Out of stock notification:just one mail when only a product stock drops to cero?](/forum/36-reports-statistics/904303-out-of-stock-notification-just-one-mail-when-only-a-product-stock-drops-to-cero "-- HikaShop version -- : 4.5.0 -- Joomla version -- : 3.9.24 -- PHP version -- : 7.2.34 Hi Nicholas and the Hikashop team: I have set up an "out of stock notification" and it works. Everyday I receive a report with all the products out of stock in the same message. But, is there any way to configurate this notification to work individually and only when a product is out of stock or below X unities. I mean, instead of receiving everyday the "same" mail, I would like to receive just an e-mail informing me that the product "whatever" is now out of stock, and that's all. This mail will trigger just once, when the product is out of stock or drops below X unities. Thank you once and again for your great support and congratulations for your top position in the last "CMS Awards" contest.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 4 years 6 months ago, by [Galle43](/forum/user/36383-galle43 "View Galle43's Profile") [Last Post](/forum/36-reports-statistics/904303-out-of-stock-notification-just-one-mail-when-only-a-product-stock-drops-to-cero#346269 "Hi, Ah, that 's nice. A small improvement of the filter in the second mass action for out of stock products getting new stock. You proposed using the filter product quantity column being greater than 0. In that way product quantity -1 (unlimited) is not selected. That is why I use the filter !=0 Thanks for the great support Udo") 4 years 1 week ago by [Udo](/forum/user/29928-udo "View Udo's Profile") | Replies:8 Views:1564 | [Last Post](/forum/36-reports-statistics/904303-out-of-stock-notification-just-one-mail-when-only-a-product-stock-drops-to-cero#346269 "Hi, Ah, that 's nice. A small improvement of the filter in the second mass action for out of stock products getting new stock. You proposed using the filter product quantity column being greater than 0. In that way product quantity -1 (unlimited) is not selected. That is why I use the filter !=0 Thanks for the great support Udo") by [Udo](/forum/user/29928-udo "View Udo's Profile") 4 years 1 week ago | | [](/forum/36-reports-statistics/905188-pas-de-notification-dannulation-de-commande) | [Pas de notification d'annulation de commande](/forum/36-reports-statistics/905188-pas-de-notification-dannulation-de-commande "-- url of the page with the problem -- : bases-netsources.com -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 7.4.32 Bonjour, Je gère un site avec la version Business d'HikaShop et Hikaserial pour la gestion d'abonnements. Lorsqu'une personne ne finalise pas son paiement en ligne et qu'elle clique sur le bouton "Annuler" de la console de paiement, aucune notification mail n'est envoyée pour le signaler, les autres notifications fonctionnent bien. Une idée de quoi cela peut venir ?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 4 years 4 weeks ago, by [Marti](/forum/user/2853-marti "View Marti's Profile") [Last Post](/forum/36-reports-statistics/905188-pas-de-notification-dannulation-de-commande#346180 "Hello Nicolas, Désolé pour mon temps de réponse, eu d'autres urgences à traiter Ça roule merci, j'espère qu'il en est de même pour toi :) Comme tu vois je gère et crée toujours des sites avec Joomla et HikaShop ;) Merci pour l'astuce, je l'ai notée afin de l'avoir sous la main, j'ai toutefois convaincu le client de se contenter de vérifier en admin afin de ne pas avoir à refaire la modif à chaque mise à jour, les annulations sont rares et il y a toujours la notification de commande.") 4 years 1 week ago by [Marti](/forum/user/2853-marti "View Marti's Profile") | Replies:4 Views:887 | [Last Post](/forum/36-reports-statistics/905188-pas-de-notification-dannulation-de-commande#346180 "Hello Nicolas, Désolé pour mon temps de réponse, eu d'autres urgences à traiter Ça roule merci, j'espère qu'il en est de même pour toi :) Comme tu vois je gère et crée toujours des sites avec Joomla et HikaShop ;) Merci pour l'astuce, je l'ai notée afin de l'avoir sous la main, j'ai toutefois convaincu le client de se contenter de vérifier en admin afin de ne pas avoir à refaire la modif à chaque mise à jour, les annulations sont rares et il y a toujours la notification de commande.") by [Marti](/forum/user/2853-marti "View Marti's Profile") 4 years 1 week ago | | [](/forum/36-reports-statistics/905254-report-for-shipping-cost-vs-total-sales) | [Report for Shipping Cost VS Total Sales](/forum/36-reports-statistics/905254-report-for-shipping-cost-vs-total-sales "-- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.9.10 -- PHP version -- : 7.2 Hi Dear Is there a way we can generate the report for total shipping cost VS total sales?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 4 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/905254-report-for-shipping-cost-vs-total-sales#346053 "Thanks Nicolas I managed to get the report from mass action shiiping price vs order_full price") 4 years 2 weeks ago by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") | Replies:2 Views:914 | [Last Post](/forum/36-reports-statistics/905254-report-for-shipping-cost-vs-total-sales#346053 "Thanks Nicolas I managed to get the report from mass action shiiping price vs order_full price") by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") 4 years 2 weeks ago | | [](/forum/36-reports-statistics/904775-get-the-shipping-invoice-attached-to-the-admin-email) | [Get the shipping invoice attached to the admin email](/forum/36-reports-statistics/904775-get-the-shipping-invoice-attached-to-the-admin-email "HI, I have the attach invoice plugin installed, which works fine for attaching the invoice. However, for the admin email, could the shipping invoice also be attached (two attachments, the invoice and shipping invoice). Many thanks.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 4 years 3 months ago, by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile") [Last Post](/forum/36-reports-statistics/904775-get-the-shipping-invoice-attached-to-the-admin-email#343482 "Hello, In the Attach invoice, you have an option for this, in order to generate your Shipping invoice at the end of the plugin settings. Regards") 4 years 3 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:1 Views:937 | [Last Post](/forum/36-reports-statistics/904775-get-the-shipping-invoice-attached-to-the-admin-email#343482 "Hello, In the Attach invoice, you have an option for this, in order to generate your Shipping invoice at the end of the plugin settings. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 4 years 3 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.055 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)