[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/902375-hikashop-dashboard-error) | [Hikashop dashboard error](/forum/36-reports-statistics/902375-hikashop-dashboard-error "-- url of the page with the problem -- : accademiainfinita.it/administrator/index...ashop&ctrl=dashboard -- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.16 -- Browser(s) name and version -- : Brave V 1.22.71 -- Error-message(debug-mod must be tuned on) -- : b.split is not a function× AND Invalid row index NaN. Should be in the range [0-1].× Hello, in the dashboard the orders statistics is not showed anymore see nimb.ws/NZ2nPo Last time I checked 2 days ago it was working, I didn't update or installed anything else since then. Thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 5 years 7 months ago, by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") [Last Post](/forum/36-reports-statistics/902375-hikashop-dashboard-error#331701 "Hi, It's coming from an update of Google Visualization API: www.hikashop.com/forum/install-update/90...ph-error.html#331700") 5 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:1121 | [Last Post](/forum/36-reports-statistics/902375-hikashop-dashboard-error#331701 "Hi, It's coming from an update of Google Visualization API: www.hikashop.com/forum/install-update/90...ph-error.html#331700") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 years 7 months ago | | [](/forum/36-reports-statistics/902341-report-for-user) | [Report for user](/forum/36-reports-statistics/902341-report-for-user "I sell t-shirts, hoodies and other textiles with prints. Now I have 2 foundations (and more will follow) that try to raise money and give the supporter of the foundation a little something. So, I've set up a separate category for foundations and within that, the foundations. The foundation will forward there supporters to the site where they can order the items they want. Included in the price is a donation to the foundation which I need to transfer into their account. How can I make a front-end report with a link for only that foundation so they can see how much was ordered and how much I should make over to their account? Or, can I have a copy of the order mailed automatically to the foundation itself once it's paid? Hope you can follow what I try to accomplish.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 5 years 7 months ago, by [Borburgh](/forum/user/59804-borburgh "View Borburgh's Profile") [Last Post](/forum/36-reports-statistics/902341-report-for-user#331575 "Hi, The simplest would be to use HikaMarket Multivendor ( www.hikashop.com/hikamarket-multi-vendor.html ). Then, just create one vendor account for each foundation and link each product to the corresponding vendor. HikaMarket will then handle the mailing of the vendors automatically, you can set the fees/commissions so that the system will calculate the amount earned by each vendor automatically, and you can create a menu item of the type "HikaMarket vendor control panel" to give them access to their sales and statistics on the frontend. So it does everything you requested automatically for you once setup. The alternative would be hiring a developer to forward the emails based on the category of the products, and develop the frontend interfaces for the reporting. So it would cost a lot of money.") 5 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:936 | [Last Post](/forum/36-reports-statistics/902341-report-for-user#331575 "Hi, The simplest would be to use HikaMarket Multivendor ( www.hikashop.com/hikamarket-multi-vendor.html ). Then, just create one vendor account for each foundation and link each product to the corresponding vendor. HikaMarket will then handle the mailing of the vendors automatically, you can set the fees/commissions so that the system will calculate the amount earned by each vendor automatically, and you can create a menu item of the type "HikaMarket vendor control panel" to give them access to their sales and statistics on the frontend. So it does everything you requested automatically for you once setup. The alternative would be hiring a developer to forward the emails based on the category of the products, and develop the frontend interfaces for the reporting. So it would cost a lot of money.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 years 7 months ago | | [](/forum/36-reports-statistics/901981-google-analytics-message-no-fragment-found) | [Google analytics message no fragment found](/forum/36-reports-statistics/901981-google-analytics-message-no-fragment-found "-- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.4.1 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Googel analytics Hello I have installed the plugin for google analytics. I get the message no fragment found. In the screenshot I have blancked the code but it is inserted. What I do notice is that when I select the google analytics in the ordering field it changes to 0. System - Joomla Update, I marked it yellow. I understood that the plugin only registers orders, it that correct. I read a question why and what you want to know more. Well I am interested to see what pages are visited and how long. Is that possible. If not with this plugin, would the manually installing the tracking tag do the job. thanks jos") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 5 years 8 months ago, by [jes060](/forum/user/60240-jes060 "View jes060's Profile") [Last Post](/forum/36-reports-statistics/901981-google-analytics-message-no-fragment-found#329871 "Hi, The plugin is indeed only to send orders data to GA. Seeing what page is viisted for how long is something oyu can do with normal Joomla GA plugins or with the script provided by GA: www.joomlashine.com/blog/install-google-...GA%20tracking%20code . So you'll likely want both that and the GA plugin we provide. Now regarding the error "no fragment found", that's the first time I hear about it. Where did you get it ? Could you provide some screenshots ?") 5 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1092 | [Last Post](/forum/36-reports-statistics/901981-google-analytics-message-no-fragment-found#329871 "Hi, The plugin is indeed only to send orders data to GA. Seeing what page is viisted for how long is something oyu can do with normal Joomla GA plugins or with the script provided by GA: www.joomlashine.com/blog/install-google-...GA%20tracking%20code . So you'll likely want both that and the GA plugin we provide. Now regarding the error "no fragment found", that's the first time I hear about it. Where did you get it ? Could you provide some screenshots ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 years 8 months ago | | [](/forum/36-reports-statistics/899128-google-analytics-e-commerce-referrals-not-logged-properly) | [Google Analytics E-Commerce Referrals not Logged Properly](/forum/36-reports-statistics/899128-google-analytics-e-commerce-referrals-not-logged-properly "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.14 -- PHP version -- : 7.3 Not sure if this is on the Hikashop side or GA side. Description of problem: Google analytics reporting lumps all sales on website into the "Other" category. Upon further inspection, 99% of these are logged as "(not set)", implying there's either a lot of users using ad blocker, something is breaking in the direct call or there's some other thing going on with our checkout or GA that's preventing the correct logging. Screenshot of data logged in GA: Screenshot of Hikashop GA plugin: Most other statistics on referral traffic to the site are being tracked properly. The only delta seems to be the actual transactions. E.g., our facebook pixel tracks all traffic from watching ads or viewing our facebook page that get funneled to our website and converts to a sale. This accounts for a large number of sales on our website. By this logic, we should have a large percentage of transactions from Facebook. However, we do not. Any help with this issue or things i should check to T/S would be appreciated. Thanks! Holden") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 9 months ago, by [mojooutdoors-holden](/forum/user/12526-mojooutdoors-holden "View mojooutdoors-holden's Profile") [Last Post](/forum/36-reports-statistics/899128-google-analytics-e-commerce-referrals-not-logged-properly#329635 "Hi, Your issue might be related to this thread: www.hikashop.com/forum/payment-methods/9...entation.html#327659 We actually added the patch a few days ago to HikaShop 4.4.1. So if you still have HikaShop 4.4.0 (as we didn't activate yet the auto update for the 4.4.1) then you don't have the patch mentionned there and manually updating to the 4.4.1 by downloading the install package on our website and installing on yours will add the patch and maybe help.") 5 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:19 Views:2458 | [Last Post](/forum/36-reports-statistics/899128-google-analytics-e-commerce-referrals-not-logged-properly#329635 "Hi, Your issue might be related to this thread: www.hikashop.com/forum/payment-methods/9...entation.html#327659 We actually added the patch a few days ago to HikaShop 4.4.1. So if you still have HikaShop 4.4.0 (as we didn't activate yet the auto update for the 4.4.1) then you don't have the patch mentionned there and manually updating to the 4.4.1 by downloading the install package on our website and installing on yours will add the patch and maybe help.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 years 8 months ago | | [](/forum/36-reports-statistics/901896-best-customers-mass-export) | [Best customers mass export](/forum/36-reports-statistics/901896-best-customers-mass-export "-- HikaShop version -- : 4.4.0 Hello I need csv export for 1000 best customers for last year. So customers with most spend. Customers data should be name, address and total amount spent in last year. I can do it with Reports, but there is no address and problem with 1000 lines. I have only guest checkout, if that is importnat.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 5 years 9 months ago, by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") [Last Post](/forum/36-reports-statistics/901896-best-customers-mass-export#329489 "Thank you.") 5 years 9 months ago by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") | Replies:2 Views:908 | [Last Post](/forum/36-reports-statistics/901896-best-customers-mass-export#329489 "Thank you.") by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") 5 years 9 months ago | | [](/forum/36-reports-statistics/892489-order-email-notifications-after-purchase) | [order email notifications after purchase](/forum/36-reports-statistics/892489-order-email-notifications-after-purchase "-- url of the page with the problem -- : peak-performance.org.uk/index.php/en/store/public -- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.7.4 -- PHP version -- : 7 -- Browser(s) name and version -- : chorme, firefox Hi guys, ive spent the last 6 hours going through your forums and trying different options, but have had now joy. when a customer buys a product we receive a paypal email but no hikashop email, neither does the customer. the joomla settings are right as im using breezing forms and we are receiving email through the website. i have filled in the email section in hikashop config and gone into email and checked everything is enabled. we are using office 356 to host our emails, have you come across any issues before with office 365. hope you can help david") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 2 weeks ago, by [BigDai](/forum/user/41003-bigdai "View BigDai's Profile") [Last Post](/forum/36-reports-statistics/892489-order-email-notifications-after-purchase#325946 "Thanks for your response! I think the next thing to look at, might be the filtering you mentioned in the mail client. Before I switched to Office 365, I used Office 2010. In that situation, I did receive the emails in Outlook 2010 and in Gmail. With Office 365, I switched to Microsoft Exchange and had to change DNS etc. I have been on the phone with Microsoft helpdesk for 3 hours already and they have no clue either. Very frustrating.") 5 years 11 months ago by [OtenKing1](/forum/user/45848-otenking1 "View OtenKing1's Profile") | Replies:10 Views:4150 | [Last Post](/forum/36-reports-statistics/892489-order-email-notifications-after-purchase#325946 "Thanks for your response! I think the next thing to look at, might be the filtering you mentioned in the mail client. Before I switched to Office 365, I used Office 2010. In that situation, I did receive the emails in Outlook 2010 and in Gmail. With Office 365, I switched to Microsoft Exchange and had to change DNS etc. I have been on the phone with Microsoft helpdesk for 3 hours already and they have no clue either. Very frustrating.") by [OtenKing1](/forum/user/45848-otenking1 "View OtenKing1's Profile") 5 years 11 months ago | | [](/forum/36-reports-statistics/901158-how-do-i-customise-a-report-to-generate-as-per-attached) | [How do I customise a report to generate as per attached](/forum/36-reports-statistics/901158-how-do-i-customise-a-report-to-generate-as-per-attached "Hi, I am trying to get a report similar to the one attached. I have tried to work out the custom reporting but I'm not sure how I could get a similar output? Understand hat the VAT and total price may not be possible - they can be caclculated in excel thanks.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 3 days ago, by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile") [Last Post](/forum/36-reports-statistics/901158-how-do-i-customise-a-report-to-generate-as-per-attached#325674 "Hi, I don't see a way to get such report with the tools available in HikaShop. It's possible to have one row per product for all the orders, or one row per order. But there is no mechanism to have one row per product per order. So if that's what you want, the only solution will be to develop your own plugin to generate the report.") 6 years 3 days ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:856 | [Last Post](/forum/36-reports-statistics/901158-how-do-i-customise-a-report-to-generate-as-per-attached#325674 "Hi, I don't see a way to get such report with the tools available in HikaShop. It's possible to have one row per product for all the orders, or one row per order. But there is no mechanism to have one row per product per order. So if that's what you want, the only solution will be to develop your own plugin to generate the report.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 3 days ago | | [](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month) | [Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 3 months ago, by [Udo](/forum/user/29928-udo "View Udo's Profile") [Last Post](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#325007 "Thanks a lot, Mohamed. Problem solved! regards, Udo") 6 years 3 weeks ago by [Udo](/forum/user/29928-udo "View Udo's Profile") | Replies:13 Views:1188 | [Last Post](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#325007 "Thanks a lot, Mohamed. Problem solved! regards, Udo") by [Udo](/forum/user/29928-udo "View Udo's Profile") 6 years 3 weeks ago | | [](/forum/36-reports-statistics/900801-somme-des-ventes-erronee-dans-les-rapport) | [Somme des ventes erronée dans les rapport](/forum/36-reports-statistics/900801-somme-des-ventes-erronee-dans-les-rapport "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.8.9 -- Browser(s) name and version -- : Firefox Bonjour, Je suis novice avec l'outil Hikashop. Je rencontre un soucis au niveau des rapports. J'ai créé un rapport pour obtenir la somme des ventes avec un statut particulier. Quand l'option "inclure les coupons" est désactivée, la somme est correcte, quand cette option est activée la somme est erronée! Exemple: Je souhaite avoir le total des commandes en attente: Quand je fais la somme manuellement j'obtiens 5460€, (et la somme de tous le coupons est égale à 1200€) Avec le rapport, option "inclure les coupons" désactivée, j'obtiens 6660 €, et avec cette option activée j'obtiens 2460€!! Puis-je avoir une explication SVP? Cordialement,") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 1 month ago, by [kbouayed](/forum/user/59947-kbouayed "View kbouayed's Profile") [Last Post](/forum/36-reports-statistics/900801-somme-des-ventes-erronee-dans-les-rapport#324317 "Bonjour, Avez-vous trouvé d'où vient le problème SVP? Cordialement,") 6 years 1 month ago by [kbouayed](/forum/user/59947-kbouayed "View kbouayed's Profile") | Replies:3 Views:919 | [Last Post](/forum/36-reports-statistics/900801-somme-des-ventes-erronee-dans-les-rapport#324317 "Bonjour, Avez-vous trouvé d'où vient le problème SVP? Cordialement,") by [kbouayed](/forum/user/59947-kbouayed "View kbouayed's Profile") 6 years 1 month ago | | [](/forum/36-reports-statistics/900830-detailed-reports) | [Detailed reports](/forum/36-reports-statistics/900830-detailed-reports "Hi Guys how do we go about creating say a weekly report that shows Sales by customer with date and details of the order - eg a list of the products? Also I am finding when I export to open in Excel the format is unreadable. I can go through an import CSV if I save the file but I have to selct delimited then : etc This makes it hard for client to get a simple report of Sales and products - there is so much useless data in the CSV which makes it very un-user friendly for the person that needs to reconcile sales") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 1 month ago, by [MrBean](/forum/user/26959-mrbean "View MrBean's Profile") [Last Post](/forum/36-reports-statistics/900830-detailed-reports#324122 "Hi, If the CSV file is not easily opened with Excel, that's because of the CSV separator chosen in the Files section of the Hikashop configuration. Change it to the one your Excel prefers and that's it. Also, if you want to only have the columns you want, you can create a mass action of the type "order" via the menu System>Mass actions with an action "export CSV file". You'll be able to choose the columns you want, and add a filter on the order_created or order_invoice_created column of the orders and then click on the "proceed" button to get the CSV file.") 6 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1063 | [Last Post](/forum/36-reports-statistics/900830-detailed-reports#324122 "Hi, If the CSV file is not easily opened with Excel, that's because of the CSV separator chosen in the Files section of the Hikashop configuration. Change it to the one your Excel prefers and that's it. Also, if you want to only have the columns you want, you can create a mass action of the type "order" via the menu System>Mass actions with an action "export CSV file". You'll be able to choose the columns you want, and add a filter on the order_created or order_invoice_created column of the orders and then click on the "proceed" button to get the CSV file.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 1 month ago | | [](/forum/36-reports-statistics/900799-dashboard-add-report-but-not-diaplay-on-it) | [Dashboard add report but not diaplay on it](/forum/36-reports-statistics/900799-dashboard-add-report-but-not-diaplay-on-it "-- HikaShop version -- : 4.3.0 -- Joomla version -- : Joomla 3.9.18 Hi , I add a report and public it, but in Dashboard page, still the same Is there any setting wrong?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 1 month ago, by [tkboxlee](/forum/user/59514-tkboxlee "View tkboxlee's Profile") [Last Post](/forum/36-reports-statistics/900799-dashboard-add-report-but-not-diaplay-on-it#324028 "OK thanks") 6 years 1 month ago by [tkboxlee](/forum/user/59514-tkboxlee "View tkboxlee's Profile") | Replies:2 Views:1381 | [Last Post](/forum/36-reports-statistics/900799-dashboard-add-report-but-not-diaplay-on-it#324028 "OK thanks") by [tkboxlee](/forum/user/59514-tkboxlee "View tkboxlee's Profile") 6 years 1 month ago | | [](/forum/36-reports-statistics/898634-orders-shifted-one-or-two-months-back-in-report) | [orders shifted one or two months back in report](/forum/36-reports-statistics/898634-orders-shifted-one-or-two-months-back-in-report "-- HikaShop version -- : 4.2.2 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.1 I have a report with start date 2019-07-18 and end date 2020-04-22 the graph x-axis labels start with 2019-05-22 (not 2019-07-18) the next label is not on 6-22 but on 6-1 then it continues on first of the month until month 11. it ends with 2020-03-22 the graph then shows no orders for 2019-11-22 and only one order for 2019-10-1 there were more orders. but it somehow bundles those in month 9. other reports settings: - date type : created - group by month - type : orders with filter : status = shipped (see screenshot 21 and 22) when I change the settings to start date 2019-01-01 and end date 2019-12-31 the report sstarts 2 months earlier and ends one month early. and it lacks month 10 all together. (screenshot 23 and 24)") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 7 years 1 week ago, by [jivjivjiv](/forum/user/36762-jivjivjiv "View jivjivjiv's Profile") [Last Post](/forum/36-reports-statistics/898634-orders-shifted-one-or-two-months-back-in-report#323975 "Hello Udo, It actually fixed the issue when I tested it on my end and also on our client's website. Also I can't reproduce it on my end when I test it. Kind regards, Mohamed.") 6 years 1 month ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:6 Views:1239 | [Last Post](/forum/36-reports-statistics/898634-orders-shifted-one-or-two-months-back-in-report#323975 "Hello Udo, It actually fixed the issue when I tested it on my end and also on our client's website. Also I can't reproduce it on my end when I test it. Kind regards, Mohamed.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 6 years 1 month ago | | [](/forum/36-reports-statistics/900732-add-username-column-to-report-csv-download) | [Add username column to report csv download](/forum/36-reports-statistics/900732-add-username-column-to-report-csv-download "-- url of the page with the problem -- : shop.newmodelarmy.org -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.3 Hi, How would I add a additional column to the csv file that can be downloaded from reports? I have a report of all customers who have bought a specific product and would like to include their usernames in the csv download. Thanks KH") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 2 months ago, by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") [Last Post](/forum/36-reports-statistics/900732-add-username-column-to-report-csv-download#323606 "Hi, That would require some development in the file administrator/components/com_hikashop/classes/widget.php I would rather recommend to use a mass action for your export (menu System>Mass actions). You'll be able to use an export action and select the columns you want, and you can have a filter on the order_product_code to filter the orders for a specific product. That way, no coding is necessary.") 6 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:947 | [Last Post](/forum/36-reports-statistics/900732-add-username-column-to-report-csv-download#323606 "Hi, That would require some development in the file administrator/components/com_hikashop/classes/widget.php I would rather recommend to use a mass action for your export (menu System>Mass actions). You'll be able to use an export action and select the columns you want, and you can have a filter on the order_product_code to filter the orders for a specific product. That way, no coding is necessary.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 2 months ago | | [](/forum/36-reports-statistics/900428-how-to-add-id-or-invoice-number-in-the-subject-of-the-admin-emails) | [How to add ID or Invoice Number in the subject of the admin emails](/forum/36-reports-statistics/900428-how-to-add-id-or-invoice-number-in-the-subject-of-the-admin-emails "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.20 -- PHP version -- : 7.3.19 -- Browser(s) name and version -- : Google Chrome and other Hello! I use HikaShop Business 4.3.0. I want to add an ID or Invoice Number to the admin email subject. It's about that: ORDER_ADMIN_NOTIFICATION_SUBJECT="A new order has been created on your website" Now I receive an email with the subject: "A new order has been created on your website" I want it to be like this: "A new order has been created on your website with ID XXX or Invoice Number XXX" I ask for your help. Thank you in advance! :)") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 3 months ago, by [dtk](/forum/user/34999-dtk "View dtk's Profile") [Last Post](/forum/36-reports-statistics/900428-how-to-add-id-or-invoice-number-in-the-subject-of-the-admin-emails#323614 "Nicolas, That worked! THANKS! :-)") 6 years 2 months ago by [ltempest](/forum/user/1784-ltempest "View ltempest's Profile") | Replies:8 Views:1256 | [Last Post](/forum/36-reports-statistics/900428-how-to-add-id-or-invoice-number-in-the-subject-of-the-admin-emails#323614 "Nicolas, That worked! THANKS! :-)") by [ltempest](/forum/user/1784-ltempest "View ltempest's Profile") 6 years 2 months ago | | [](/forum/36-reports-statistics/900583-no-currency-found-google-analytics) | [NO\_CURRENCY\_FOUND\_GOOGLE\_ANALYTICS](/forum/36-reports-statistics/900583-no-currency-found-google-analytics "I got message NO_CURRENCY_FOUND_GOOGLE_ANALYTICS while changing order status from created to confirmed. The Google analitics currency is USD and in HikaShop Google Analytics plugin setting currency is USD too but the currency of orders is KZT. KZT is not supported by GA. So how to set up plugin to send data to GA ?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 3 months ago, by [Bender](/forum/user/38688-bender "View Bender's Profile") [Last Post](/forum/36-reports-statistics/900583-no-currency-found-google-analytics#322999 "Hello, You must edit Google analytics plugin in this folder : \plugins\system\hikashopanalytics And Edit hikashopanalytics.php to convert your currency to USD before sending data. Hope this will help you to get what you need, and if it's to complicated you can ask us to perform the custom work via our form. Regards") 6 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:3 Views:1347 | [Last Post](/forum/36-reports-statistics/900583-no-currency-found-google-analytics#322999 "Hello, You must edit Google analytics plugin in this folder : \plugins\system\hikashopanalytics And Edit hikashopanalytics.php to convert your currency to USD before sending data. Hope this will help you to get what you need, and if it's to complicated you can ask us to perform the custom work via our form. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 6 years 2 months ago | | [](/forum/36-reports-statistics/900395-product-sales-reports) | [Product Sales Reports](/forum/36-reports-statistics/900395-product-sales-reports "We would like to generate the following report and I am having difficulty determining the best way of accomplishing. We need to generate a sales report that tells us the quantity and frequency of sales by product. This should be a listing of products with the following columns. Product Name \| Quantity Where Quantity is the number of times the product was sold in a specific period (last month, last week, etc.) We also are using HikaMarket, so we would also want to be able to run this for specific vendors as well. Thank you.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 4 months ago, by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") [Last Post](/forum/36-reports-statistics/900395-product-sales-reports#321946 "Hi, You can do a report like this: monosnap.com/file/JQCKhAiSNuDQz7YMFSnO8p5ZMrCmdS That will give you a listing with the product name and the quantity over the period you selected. And you can also restrict the order statuses so that you only take into account shipped orders and/or confirmed orders. Now there is no mechanism to filter by vendor. But you can filter by category. And if you configured HikaMarket to have a category per vendor that would be something possible. Otherwise, I'm afraid this would require some development to add a filter on the vendors to the system.") 6 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1240 | [Last Post](/forum/36-reports-statistics/900395-product-sales-reports#321946 "Hi, You can do a report like this: monosnap.com/file/JQCKhAiSNuDQz7YMFSnO8p5ZMrCmdS That will give you a listing with the product name and the quantity over the period you selected. And you can also restrict the order statuses so that you only take into account shipped orders and/or confirmed orders. Now there is no mechanism to filter by vendor. But you can filter by category. And if you configured HikaMarket to have a category per vendor that would be something possible. Otherwise, I'm afraid this would require some development to add a filter on the vendors to the system.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 4 months ago | | [](/forum/36-reports-statistics/900278-comment-generer-un-rapport-de-type-massaction-avec-une-plage-horaire-donnee) | [Comment générer un rapport de type MassAction avec une plage horaire donnée](/forum/36-reports-statistics/900278-comment-generer-un-rapport-de-type-massaction-avec-une-plage-horaire-donnee "Bonjour, j'aimerais savoir s'il est possible d'ajouter à un rapport de type Mass Action, une période donnée. Mon client à besoin de faire l'export d'un rapport précis chaque semaine. La période visée doit être du vendredi 12h au vendredi 12h. Je ne trouve pas dans la section système - Mass Action la possibilité d'ajouter une plage horaire détaillée pour le rapport. Est-ce possible de faire une telle requête? Merci de m'éclairer à ce sujet.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 4 months ago, by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") [Last Post](/forum/36-reports-statistics/900278-comment-generer-un-rapport-de-type-massaction-avec-une-plage-horaire-donnee#321623 "Un grand merci tout fonctionne!!!") 6 years 4 months ago by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") | Replies:8 Views:1037 | [Last Post](/forum/36-reports-statistics/900278-comment-generer-un-rapport-de-type-massaction-avec-une-plage-horaire-donnee#321623 "Un grand merci tout fonctionne!!!") by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") 6 years 4 months ago | | [](/forum/36-reports-statistics/900211-add-custom-date-field-in-mail-order-admin-notification) | [Add custom DATE field in mail ORDER\_ADMIN\_NOTIFICATION](/forum/36-reports-statistics/900211-add-custom-date-field-in-mail-order-admin-notification "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.8 HI, We have added a custom field (table address column date) and would like to add this to the mail send to the admin. This works with {VAR:billing_address.date} but the result is "20200620000000" where we would like to format the date like d/m/Y. How can we do this? Kinds regards.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 4 months ago, by [wexpose](/forum/user/30901-wexpose "View wexpose's Profile") [Last Post](/forum/36-reports-statistics/900211-add-custom-date-field-in-mail-order-admin-notification#320968 "Hi, Yes, the email tags display the raw data from the database. So for the date, you can't do it like that. However, if it's a custom address field, why not add its tag to the "address format" setting under the Checkout tab of the Hikashop configuration ? In that case, the field data will be converted properly and it will appear along with the rest of the address.") 6 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:979 | [Last Post](/forum/36-reports-statistics/900211-add-custom-date-field-in-mail-order-admin-notification#320968 "Hi, Yes, the email tags display the raw data from the database. So for the date, you can't do it like that. However, if it's a custom address field, why not add its tag to the "address format" setting under the Checkout tab of the Hikashop configuration ? In that case, the field data will be converted properly and it will appear along with the rest of the address.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 6 years 4 months ago | | [](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days) | [Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 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 ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 6 years 6 months ago, by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") [Last Post](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#320500 "Hi Nicolas, Sorry for my late reply, but I don't get e-mails from the ticketsystem (also not in the spam box). So sometime I have to check the issues by my selfs. But I have send you the FTP access. UPDATE: You can login, access is tested and working now! Kind regards, Lumiga") 6 years 5 months ago by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") | Replies:7 Views:1046 | [Last Post](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#320500 "Hi Nicolas, Sorry for my late reply, but I don't get e-mails from the ticketsystem (also not in the spam box). So sometime I have to check the issues by my selfs. But I have send you the FTP access. UPDATE: You can login, access is tested and working now! Kind regards, Lumiga") by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") 6 years 5 months ago | | [](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register) | [How to filter sales to guest customers vs register](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register "-- HikaShop version -- : 2.5.0 Hi, My e-shop allows guest customers to buy. is it possible to get a report with sales to guest customer ? Many Thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 11 years 3 months ago, by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") [Last Post](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#320212 "Hi Nicolas ! I updated Joomla from 3.9.18 to 3.9.19 and Hikashop from 4.3.0 [2005091545] to [2006031845] and now it's OK. It works. Thank you !") 6 years 5 months ago by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") | Replies:4 Views:1836 | [Last Post](/forum/36-reports-statistics/878482-how-to-filter-sales-to-guest-customers-vs-register#320212 "Hi Nicolas ! I updated Joomla from 3.9.18 to 3.9.19 and Hikashop from 4.3.0 [2005091545] to [2006031845] and now it's OK. It works. Thank you !") by [Thierry H.](/forum/user/33573-thierry-h "View Thierry H.'s Profile") 6 years 5 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.150 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)