[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/894846-solved-add-discount-code-on-order-listing) | [\[SOLVED\] Add discount code on order listing](/forum/36-reports-statistics/894846-solved-add-discount-code-on-order-listing "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2.5 -- Browser(s) name and version -- : various, all updated - Chrome is primary I would like to have the discount code added to the order listing page, next to the Partner ID on the right side. However, I am having difficulty in finding the 'view'. I looked at 'listing' but could not find the "order_partner_id" field on the page. Can you tell me what view I need to edit?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 5 months ago, by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile") [Last Post](/forum/36-reports-statistics/894846-solved-add-discount-code-on-order-listing#293376 "Nicolas, Thanks. Worked like a charm!") 8 years 5 months ago by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile") | Replies:2 Views:3221 | [Last Post](/forum/36-reports-statistics/894846-solved-add-discount-code-on-order-listing#293376 "Nicolas, Thanks. Worked like a charm!") by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile") 8 years 5 months ago | | [](/forum/36-reports-statistics/894564-dashboard-slow-loading) | [Dashboard Slow Loading](/forum/36-reports-statistics/894564-dashboard-slow-loading "-- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 For a while now, our dashboard takes an abnormal amount of time to load -- sometimes more than 20 seconds. Is there a particular database table that might be slowing it down? Large order or email log table? I've been trying to locate a fix but haven't had much luck. The dashboard is the only page to load slowly. The rest of the backend has minimal loading times.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 6 months ago, by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") [Last Post](/forum/36-reports-statistics/894564-dashboard-slow-loading#292438 "Thanks guys. Sorry for the lack of knowledge of SQL tables. Pretty much my first experience with them. Dashboard loading time went from +10 seconds down to just 2-3 seconds.") 8 years 6 months ago by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") | Replies:15 Views:3963 | [Last Post](/forum/36-reports-statistics/894564-dashboard-slow-loading#292438 "Thanks guys. Sorry for the lack of knowledge of SQL tables. Pretty much my first experience with them. Dashboard loading time went from +10 seconds down to just 2-3 seconds.") by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") 8 years 6 months ago | | [](/forum/36-reports-statistics/894313-chang-showed-information-on-order-e-mail) | [Chang showed information on order (e-mail)](/forum/36-reports-statistics/894313-chang-showed-information-on-order-e-mail "-- url of the page with the problem -- : www.rotterdamseuitdaging-bestelportal.nl...r-categories-listing -- HikaShop version -- : 3.3.0 -- Joomla version -- : 3.8.6 -- PHP version -- : 7.1.15 -- Browser(s) name and version -- : Firefox (last) Hi, For your information , i maked a new Field ( Display-Costum Files) with the name: " Naam Organisatie ". When a costumer makes a order, the costumer gets a email and also the administrator gets a email. My question is about the email about the order the administatrator wil get it in its e-mailadress. At this e-mail you can see severs information: Client Ordernr Name Adres City etc.etc I want tot add the new Field " Naam Organistie " to this e-mail. How do i manage that!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 7 months ago, by [fvdn](/forum/user/48779-fvdn "View fvdn's Profile") [Last Post](/forum/36-reports-statistics/894313-chang-showed-information-on-order-e-mail#290698 "Hi, Yes, the old method was to edit the address_template view file.") 8 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:3163 | [Last Post](/forum/36-reports-statistics/894313-chang-showed-information-on-order-e-mail#290698 "Hi, Yes, the old method was to edit the address_template view file.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 7 months ago | | [](/forum/36-reports-statistics/894286-sales-do-not-show-up-in-google-analytics) | [Sales do not show up in google analytics](/forum/36-reports-statistics/894286-sales-do-not-show-up-in-google-analytics "-- url of the page with the problem -- : www.ericspeanuts.com -- HikaShop version -- : 3.4.0 -- Joomla version -- : 3.8.6 -- PHP version -- : 7.0.15 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : Missing E-commerce Data in google Analytics Showing my sales in Google Analytics (GA) is impossible. I installed both plugins: ->System - Google Analytics ->HikaShop Google Analytics plugin with "Always use direct call (UA)" set to Yes. I read the documentation in the forum, and I set the plugins a long time ago, but still, the sales do not show up in GA. Can you please help? Any suggestions? Best regards, Eric") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 7 months ago, by [epware](/forum/user/28245-epware "View epware's Profile") [Last Post](/forum/36-reports-statistics/894286-sales-do-not-show-up-in-google-analytics#290520 "Hi, So how did you configure the settings of these plugins ? Coudl you provide some screenshots ?") 8 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:3221 | [Last Post](/forum/36-reports-statistics/894286-sales-do-not-show-up-in-google-analytics#290520 "Hi, So how did you configure the settings of these plugins ? Coudl you provide some screenshots ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 7 months ago | | [](/forum/36-reports-statistics/893796-product-purchase-records) | [Product Purchase Records](/forum/36-reports-statistics/893796-product-purchase-records "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : various -- Error-message(debug-mod must be tuned on) -- : none Hi is it possible to find / or / create a list of customers who bought a specific product ? e.g. all people who bought - Big Red Shoes thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") [Last Post](/forum/36-reports-statistics/893796-product-purchase-records#289391 "Hi Mohamed thank you for that code, appreciated") 8 years 8 months ago by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") | Replies:9 Views:3741 | [Last Post](/forum/36-reports-statistics/893796-product-purchase-records#289391 "Hi Mohamed thank you for that code, appreciated") by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") 8 years 8 months ago | | [](/forum/36-reports-statistics/894005-dont-show-the-dashboard) | [Don't show The Dashboard](/forum/36-reports-statistics/894005-dont-show-the-dashboard "-- url of the page with the problem -- : www.egimotors.it/index.php/services-ricambi-egimotors -- HikaShop version -- : 3.3.0 -- Joomla version -- : 3.8.5 Hi, in the backend i can't to see the reports in tha dashboard") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 8 months ago, by [marcob@polarisitalia.com](/forum/user/37355-marcob-polarisitalia-com "View marcob@polarisitalia.com's Profile") [Last Post](/forum/36-reports-statistics/894005-dont-show-the-dashboard#289184 "Ok, Now work very well.... I set the System>order Statuses and set "statistics" on create. Thank You") 8 years 8 months ago by [marcob@polarisitalia.com](/forum/user/37355-marcob-polarisitalia-com "View marcob@polarisitalia.com's Profile") | Replies:2 Views:3558 | [Last Post](/forum/36-reports-statistics/894005-dont-show-the-dashboard#289184 "Ok, Now work very well.... I set the System>order Statuses and set "statistics" on create. Thank You") by [marcob@polarisitalia.com](/forum/user/37355-marcob-polarisitalia-com "View marcob@polarisitalia.com's Profile") 8 years 8 months ago | | [](/forum/36-reports-statistics/892522-adwords-tracking) | [Adwords Tracking](/forum/36-reports-statistics/892522-adwords-tracking "-- url of the page with the problem -- : www.awards4u.ca -- HikaShop version -- : 3.2.1 -- Error-message(debug-mod must be tuned on) -- : AdWords Has anyone got adwords tracking to work. I can not seem to get it to work. I put the adwords tracking code at the end of: View - after_end However, can not get it to work. I am not getting any data. Any idea.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 2 weeks ago, by [Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile") [Last Post](/forum/36-reports-statistics/892522-adwords-tracking#288625 "Hello! It works, thank you for your assistance") 8 years 8 months ago by [sapunov](/forum/user/50610-sapunov "View sapunov's Profile") | Replies:6 Views:4024 | [Last Post](/forum/36-reports-statistics/892522-adwords-tracking#288625 "Hello! It works, thank you for your assistance") by [sapunov](/forum/user/50610-sapunov "View sapunov's Profile") 8 years 8 months ago | | [](/forum/36-reports-statistics/893645-error-when-creating-reports) | [Error when creating reports](/forum/36-reports-statistics/893645-error-when-creating-reports "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM #__hikashop_ AS a' at line 1 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [jonike](/forum/user/53999-jonike "View jonike's Profile") [Last Post](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "Hi, If you go in the menu Orders>Reports and open the report of the same name, you should get the error again. In that case, do the modification as explained in www.hikashop.com/support/forum/install-u...mbiguous.html#287405 and check the report again. It will provide the full MySQL query.") 8 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:3586 | [Last Post](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "Hi, If you go in the menu Orders>Reports and open the report of the same name, you should get the error again. In that case, do the modification as explained in www.hikashop.com/support/forum/install-u...mbiguous.html#287405 and check the report again. It will provide the full MySQL query.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 8 months ago | | [](/forum/36-reports-statistics/893567-edit-confirmation-email-additional-information) | [Edit confirmation Email "Additional Information"](/forum/36-reports-statistics/893567-edit-confirmation-email-additional-information "-- HikaShop version -- : 3.2.2 Business -- Joomla version -- : 3.8.3 -- PHP version -- : 5.6/7.1 -- Browser(s) name and version -- : chrome / firefox -- Error-message(debug-mod must be tuned on) -- : n/a Where do I edit the output for "additional Information" in the admin confirmation email? Currently it is only passing through the date field, but there are 6 other custom fields that are not showing up.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") [Last Post](/forum/36-reports-statistics/893567-edit-confirmation-email-additional-information#287910 "Hello, Can you please follow the previous instructions and edit your custom field for the display setting ? www.hikashop.com/support/documentation/1...form.html#additional Regards,") 8 years 9 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:3 Views:3750 | [Last Post](/forum/36-reports-statistics/893567-edit-confirmation-email-additional-information#287910 "Hello, Can you please follow the previous instructions and edit your custom field for the display setting ? www.hikashop.com/support/documentation/1...form.html#additional Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/893745-searching-for-coupons-in-report-results-in-404) | [Searching for coupons in report results in 404.](/forum/36-reports-statistics/893745-searching-for-coupons-in-report-results-in-404 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.4 -- PHP version -- : 7.1.11 -- Browser(s) name and version -- : Chrome 63.0.3239 -- Error-message(debug-mod must be tuned on) -- : 404 Hi, When creating a new report, i want to search for a particular coupon. The coupon code is not listed initially, so we need to search. The search (ajax) does not give any answer. In the console it seems it results in a 404 - page not found. Which is correct. The called url is: [...]/administrator/index.php?option=com_hikashop&ctrl=&search=dan&start=HIKASTART I think the ctrl= bit should not be empty?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [kovoks](/forum/user/38126-kovoks "View kovoks's Profile") [Last Post](/forum/36-reports-statistics/893745-searching-for-coupons-in-report-results-in-404#287632 "Hi there, Thank you for the fix, it works! The reporting widget takes some fiddeling about to get the results you want. Took me a while to realise the comparison setting should be off cause it was making a mess of the export file. Anyway, this was what the client wanted so I am happy...") 8 years 9 months ago by [kovoks](/forum/user/38126-kovoks "View kovoks's Profile") | Replies:2 Views:3098 | [Last Post](/forum/36-reports-statistics/893745-searching-for-coupons-in-report-results-in-404#287632 "Hi there, Thank you for the fix, it works! The reporting widget takes some fiddeling about to get the results you want. Took me a while to realise the comparison setting should be off cause it was making a mess of the export file. Anyway, this was what the client wanted so I am happy...") by [kovoks](/forum/user/38126-kovoks "View kovoks's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/893679-change-hikashop-3-dashboard-defaults) | [Change Hikashop 3 Dashboard Defaults](/forum/36-reports-statistics/893679-change-hikashop-3-dashboard-defaults "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 I really enjoy the new dashboard, but is there any way to change the modules displayed or at least change their options? For example, the "orders" block (see screenshot) defaults to "This Year" and "group by month." Any way to change this to maybe "All" and "group by month/year?" Mainly cosmetic as reports feature still works and i could use legacy. Just wanted to know if the new dashboard is easily customizable.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") [Last Post](/forum/36-reports-statistics/893679-change-hikashop-3-dashboard-defaults#287160 "Hi, It would be possible by developing a custom plugin. But there is no ready made options screen for that, at least not for now.") 8 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:3483 | [Last Post](/forum/36-reports-statistics/893679-change-hikashop-3-dashboard-defaults#287160 "Hi, It would be possible by developing a custom plugin. But there is no ready made options screen for that, at least not for now.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/893070-out-of-stock-email-add-variant-name) | [Out of Stock Email: Add variant Name](/forum/36-reports-statistics/893070-out-of-stock-email-add-variant-name "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 How can i add variant name to the out of stock email sent out by the cron task? Here's what i'm seeing in the email. For variants, it says "the product has a stock of only XXX items." The product SCOOT-N-SHOOT Chassis has a stock of only 0 items. The product SHAKE'N JAKE Tail Fan has a stock of only 8 items. The product SCOOT-N-SHOOT / Tail Chaser Tail Fan has a stock of only 0 items. The product SHAKE'N JAKE Stake has a stock of only 0 items. The product has a stock of only 0 items. The product has a stock of only 0 items. The product has a stock of only 0 items. The product has a stock of only 0 items. The product has a stock of only 5 items. The product has a stock of only 6 items. The product has a stock of only 6 items.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 11 months ago, by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") [Last Post](/forum/36-reports-statistics/893070-out-of-stock-email-add-variant-name#287143 "Successfully updated and now have this feature! Thanks Nicolas. Great support as always!") 8 years 9 months ago by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") | Replies:2 Views:3213 | [Last Post](/forum/36-reports-statistics/893070-out-of-stock-email-add-variant-name#287143 "Successfully updated and now have this feature! Thanks Nicolas. Great support as always!") by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/893576-order-history-information-in-admin-order-notifcation) | [Order History Information in Admin order notifcation](/forum/36-reports-statistics/893576-order-history-information-in-admin-order-notifcation "-- HikaShop version -- : 3.2.2 Hi, Is there a way to include order history information table into the admin order email notification?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [savvygents](/forum/user/49684-savvygents "View savvygents's Profile") [Last Post](/forum/36-reports-statistics/893576-order-history-information-in-admin-order-notifcation#286679 "Hi, $this->order doesn't exist in the emails. You need to replace it by $data->cart and that should work.") 8 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:3046 | [Last Post](/forum/36-reports-statistics/893576-order-history-information-in-admin-order-notifcation#286679 "Hi, $this->order doesn't exist in the emails. You need to replace it by $data->cart and that should work.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly) | [Can't import sales CSV data correctly](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly "-- Joomla version -- : 3.8 -- PHP version -- : 7 Hi, I am trying to import our exported CVS sales report content but the format breaks at the currency column Can you see what's wrong ? Thanks Danny") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [iDanny](/forum/user/43074-idanny "View iDanny's Profile") [Last Post](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly#286528 "Hi, Ah, I see what you mean. You're talking about the export of reports and this happens only for some reports, not all of them. Fortunately, I was able to reproduce the problem thanks to your screenshot and I've added a patch. You can download the install package again on our website and install it on yours to get the patch.") 8 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:3773 | [Last Post](/forum/36-reports-statistics/893570-cant-import-sales-csv-data-correctly#286528 "Hi, Ah, I see what you mean. You're talking about the export of reports and this happens only for some reports, not all of them. Fortunately, I was able to reproduce the problem thanks to your screenshot and I've added a patch. You can download the install package again on our website and install it on yours to get the patch.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/880665-how-to-send-invoice-pdf) | [How to send invoice PDF ?](/forum/36-reports-statistics/880665-how-to-send-invoice-pdf "-- Joomla version -- : 3.4.5 -- PHP version -- : 2.6.0 I wonder if when someone places an order, you can automatically attach a PDF invoice to the customer. Also I would like to edit the text of additional information generated in the mail when you purchase. Thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 11 months ago, by [rober1903](/forum/user/37591-rober1903 "View rober1903's Profile") [Last Post](/forum/36-reports-statistics/880665-how-to-send-invoice-pdf#286312 "Hi, 1. It would require modifying the code of the PDF plugin where the font is set: stackoverflow.com/questions/5263588/how-...ustom-fonts-in-tcpdf 2. The invoice number is supposed to contain the invoice number already. If not, then it means that you have to check the translation: PDF_INVOICE="Invoice %s" which is used for the name of the PDF file. The %s is dynamically replaced by the invoice number.") 8 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:10 Views:4052 | [Last Post](/forum/36-reports-statistics/880665-how-to-send-invoice-pdf#286312 "Hi, 1. It would require modifying the code of the PDF plugin where the font is set: stackoverflow.com/questions/5263588/how-...ustom-fonts-in-tcpdf 2. The invoice number is supposed to contain the invoice number already. If not, then it means that you have to check the translation: PDF_INVOICE="Invoice %s" which is used for the name of the PDF file. The %s is dynamically replaced by the invoice number.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 9 months ago | | [](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference) | [Report Statistic Date & Order actual date difference](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 5.4.45 Hi We found some abnormalities after upgraded to the latest version Our Global Configuration are using MYT time zone as well as the server Date is MYT All the order date are display and created nicely For example, currently we have 1 confirmed order on 15/12 and 14 confirmed order on 14/12 However, when we run the sales this month report or the dashboard report System capture 7 sales on 15/12 instead of 1 sales Is it some reconfiguration of us ? we also notice that there is an invoice_created date in order sql table, is it the cause?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 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/893197-report-statistic-date-order-actual-date-difference#285093 "Hi, Thanks. So for the order SF05273, the timestamp 1513840307 corresponds to 2017-12-21 07:11:47 UTC ( www.unixtimestamp.com/index.php ) The code of the statistics system is: So that means that the system interprets that 1513840307 with something like that: On my end, this MySQL query results in: 2017-12-21 16:11:47 So this means that there is the timezone shift of Joomla plus the one from mysql (UTC+1) as it should normally output 2017-12-21 15:11:47 So let's try this: Add the code: $this->db->setQuery('SET @ = \'+00:00\''); $this->db->query(); before the line: $this->db->setQuery($query, $offset, $limit); in the file administrator/components/com_hikashop/classes/statistics.php That should remove the timezone issue.") 8 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:15 Views:4056 | [Last Post](/forum/36-reports-statistics/893197-report-statistic-date-order-actual-date-difference#285093 "Hi, Thanks. So for the order SF05273, the timestamp 1513840307 corresponds to 2017-12-21 07:11:47 UTC ( www.unixtimestamp.com/index.php ) The code of the statistics system is: So that means that the system interprets that 1513840307 with something like that: On my end, this MySQL query results in: 2017-12-21 16:11:47 So this means that there is the timezone shift of Joomla plus the one from mysql (UTC+1) as it should normally output 2017-12-21 15:11:47 So let's try this: Add the code: $this->db->setQuery('SET @ = \'+00:00\''); $this->db->query(); before the line: $this->db->setQuery($query, $offset, $limit); in the file administrator/components/com_hikashop/classes/statistics.php That should remove the timezone issue.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 10 months ago | | [](/forum/36-reports-statistics/893199-entries-admin-listing-shows-nothing-but-the-form-works-pretty-well) | [Entries admin listing shows nothing (but the form works pretty well !)](/forum/36-reports-statistics/893199-entries-admin-listing-shows-nothing-but-the-form-works-pretty-well "Hi there, I plan to use the Entries functionnalities for a clien... * it works perfectly with the products and the corresponding orders * ....but I can't see the list * and of course I need to export theses values... Sure, I miss something..; could you help me ? Thx, MA") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 10 months ago, by [marc@ma74.net](/forum/user/42540-marc-ma74-net "View marc@ma74.net's Profile") [Last Post](/forum/36-reports-statistics/893199-entries-admin-listing-shows-nothing-but-the-form-works-pretty-well#284655 "Ok, works fine ; good for my client's needs. Looking forward next release. MA") 8 years 10 months ago by [marc@ma74.net](/forum/user/42540-marc-ma74-net "View marc@ma74.net's Profile") | Replies:2 Views:3113 | [Last Post](/forum/36-reports-statistics/893199-entries-admin-listing-shows-nothing-but-the-form-works-pretty-well#284655 "Ok, works fine ; good for my client's needs. Looking forward next release. MA") by [marc@ma74.net](/forum/user/42540-marc-ma74-net "View marc@ma74.net's Profile") 8 years 10 months ago | | [](/forum/36-reports-statistics/892938-some-additional-information-missing-in-the-order-creation-notification-subject) | [Some Additional Information missing in the ORDER\_CREATION\_NOTIFICATION\_SUBJECT](/forum/36-reports-statistics/892938-some-additional-information-missing-in-the-order-creation-notification-subject "-- url of the page with the problem -- : www.mangialarossa.com/ -- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.7.5 -- PHP version -- : 7.0 -- Browser(s) name and version -- : firefox HI, After copying and paste from HIKASHOP DEMO (version 3.2.1) the email configuration, I lost part of the information which was shown in Additional Information (see printscreen). In particular, the information regarding the delivery point is now missing in the email received by the client after the order is placed. Here there are the string I copied and pasted from HIKASHOP DEMO (version 3.2.1): {TXT:ADDITIONAL_INFORMATION} {VAR:ORDER_SUMMARY} How to restore full additional information? Does it depend from PHP code?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 11 months ago, by [idimarco](/forum/user/40745-idimarco "View idimarco's Profile") [Last Post](/forum/36-reports-statistics/892938-some-additional-information-missing-in-the-order-creation-notification-subject#283280 "Hi, That information is added in the "preload" section of the email at the bottom of the email edition page. So it's that one that you want to copy/paste.") 8 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1198 | [Last Post](/forum/36-reports-statistics/892938-some-additional-information-missing-in-the-order-creation-notification-subject#283280 "Hi, That information is added in the "preload" section of the email at the bottom of the email edition page. So it's that one that you want to copy/paste.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 11 months ago | | [](/forum/36-reports-statistics/892900-product-buyers-list-how-to) | [Product buyers list - How to](/forum/36-reports-statistics/892900-product-buyers-list-how-to "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 7.1.9 -- Browser(s) name and version -- : Chrome 62 Hi guys, I set an eTicket Event with HikaShop and HikaSerial. Now, Please: 1 - How to export a "buyers list" of the product event ? 2 - Is there a way to send that list by email when the "Available to" product date is came ? 3 - How to view a "buyers list" of the product ? Into "Orders" I'm not able to find a way to sort orders "by product" Many Thanks for help :)") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 11 months ago, by [joomleb](/forum/user/2322-joomleb "View joomleb's Profile") [Last Post](/forum/36-reports-statistics/892900-product-buyers-list-how-to#283315 "Hello, 1 - Thanks for the report. Indeed there is an issue when performing a search. We will see to fix that issue as soon as possible (or use a namebox system instead of the popup). If you do not perform a search, the lines can be "click" to select the user (but you will have to know in which page the user is). 2 - If you need the names in the address ; you do not require the information regarding the user assigned to the serial since you can load the billing (or shipping) address of the order. A view override is not hacking ; it's a way to perform customization, to change a design or add extra elements. And unfortunately no, there is no feature that you can use since the information is in a table and you need to load the data manually for the batch of order you have in your export. It is customization/specific development. www.hikashop.com/support/documentation/1...-display.html#layout Regards,") 8 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:7 Views:3682 | [Last Post](/forum/36-reports-statistics/892900-product-buyers-list-how-to#283315 "Hello, 1 - Thanks for the report. Indeed there is an issue when performing a search. We will see to fix that issue as soon as possible (or use a namebox system instead of the popup). If you do not perform a search, the lines can be "click" to select the user (but you will have to know in which page the user is). 2 - If you need the names in the address ; you do not require the information regarding the user assigned to the serial since you can load the billing (or shipping) address of the order. A view override is not hacking ; it's a way to perform customization, to change a design or add extra elements. And unfortunately no, there is no feature that you can use since the information is in a table and you need to load the data manually for the batch of order you have in your export. It is customization/specific development. www.hikashop.com/support/documentation/1...-display.html#layout Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 8 years 11 months ago | | [](/forum/36-reports-statistics/892937-s-not-showing-the-corrisponding-order-number-in-the-email) | [%s not showing the corrisponding order number in the email](/forum/36-reports-statistics/892937-s-not-showing-the-corrisponding-order-number-in-the-email "-- url of the page with the problem -- : www.mangialarossa.com/ -- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.7.5 -- PHP version -- : 7.0 -- Browser(s) name and version -- : firefox Hi In the email received by the client after placing the order (ORDER_CREATION_NOTIFICATION_SUBJECT), it is shown "Do not forget to include the order number %s in the comments of the bank transfer so that we can match it to your order. " How to replace %s with the corresponding order number? Here it is the string in the HTML version for the email ORDER_CREATION_NOTIFICATION_SUBJECT: {TXT:INCLUDE_ORDER_NUMBER_TO_TRANSFER} Here it is the string in the English language file: INCLUDE_ORDER_NUMBER_TO_TRANSFER="Do not forget to include the order number ( %s ) in the comments of the bank transfer so that we can match it to your order." What should I change? Thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 11 months ago, by [idimarco](/forum/user/40745-idimarco "View idimarco's Profile") [Last Post](/forum/36-reports-statistics/892937-s-not-showing-the-corrisponding-order-number-in-the-email#283270 "Hi, The text in the subject is wrong. It should be only "INCLUDE_ORDER_NUMBER_TO_TRANSFER" without the quotes. There is no tag system in the subject, so you need just the translation key, like it is by default for all the emails.") 8 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1422 | [Last Post](/forum/36-reports-statistics/892937-s-not-showing-the-corrisponding-order-number-in-the-email#283270 "Hi, The text in the subject is wrong. It should be only "INCLUDE_ORDER_NUMBER_TO_TRANSFER" without the quotes. There is no tag system in the subject, so you need just the translation key, like it is by default for all the emails.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 11 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.060 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)