[Skip to main content](#vessel-content)
Board Categories Reports & Statistics
##
# [Reports & Statistics](/forum/36-reports-statistics "View Category 'Reports & Statistics'") 340 topics
| All there is to know about reports and statisctics |
|---|
##
| [ ](#forumbottom) | Subject | Replies / Views | Last Post |
|---|---|---|---|
| [](/forum/36-reports-statistics/100000095-email-font-changed-after-updating) | [Email font changed after updating](/forum/36-reports-statistics/100000095-email-font-changed-after-updating "-- HikaShop version -- : 6.7.1 -- Joomla version -- : 6.2.0 -- Browser(s) name and version -- : Chrome 156.0 Hi, I noticed that the email font has changed after updating to the latest version. You can see in the screenshots the difference. How can i change it to how it was? Thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 day 8 hours ago, by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") [Last Post](/forum/36-reports-statistics/100000095-email-font-changed-after-updating#100000505 "Hi! I clicked on the pencil icon and i see no settings, only code (see screenshot). Thank you") 9 hours 36 minutes ago by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") | Replies:1 Views:25 | [Last Post](/forum/36-reports-statistics/100000095-email-font-changed-after-updating#100000505 "Hi! I clicked on the pencil icon and i see no settings, only code (see screenshot). Thank you") by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") 9 hours 36 minutes ago |
| [](/forum/36-reports-statistics/887330-print-report-of-people-who-booked-an-event-on-a-set-date) | [Print Report of People who booked an event on a set date](/forum/36-reports-statistics/887330-print-report-of-people-who-booked-an-event-on-a-set-date "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.7 -- Browser(s) name and version -- : IE 11 -- Error-message(debug-mod must be tuned on) -- : NA Hi I have followed the tutorial on setting up Event Registration, and it seems to do almost everything I need, but I do need to be able to print out a list of all of the people who have booked in for an event. My context is that I have parents who are booking one or more children into one or more events on different dates. If I choose entries from the Order tab, and then export this, I get a spreadsheet with all of the children's names, all of the events, the order ID, and whether they are booked into the event or not. This is so close to what I want - I just need to get the details of the person who placed the order (the parent) on each line Is there a way to edit the export wizard, and would anybody know the SQL I would need to change it to? I have attached what I get from the export. Many thanks Mikki") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [mikkistorey](/forum/user/40365-mikkistorey "View mikkistorey's Profile") [Last Post](/forum/36-reports-statistics/887330-print-report-of-people-who-booked-an-event-on-a-set-date#100000434 "Hi, For anyone reading this: the plugin now covers this kind of event registration. Each event can have its list of dates with its own number of places, and the plugin adds a bookings listing in the backend that you can filter by product, date period and order status, then export to CSV. When places are cancelled or refunded, they go back on sale for that date.") 5 days 6 hours ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:9 Views:1764 | [Last Post](/forum/36-reports-statistics/887330-print-report-of-people-who-booked-an-event-on-a-set-date#100000434 "Hi, For anyone reading this: the plugin now covers this kind of event registration. Each event can have its list of dates with its own number of places, and the plugin adds a bookings listing in the backend that you can filter by product, date period and order status, then export to CSV. When places are cancelled or refunded, they go back on sale for that date.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 days 6 hours ago |
| [](/forum/36-reports-statistics/100000037-no-access-to-cron-tasks) | [No access to CRON tasks](/forum/36-reports-statistics/100000037-no-access-to-cron-tasks "-- url of the page with the problem -- : hrrps://www.121time.com -- HikaShop version -- : 6.6.0 -- Joomla version -- : 5.4.9 -- PHP version -- : 8.5.9 -- Browser(s) name and version -- : Safari 605.1 -- Error-message(debug-mod must be tuned on) -- : www.hikashop.com n'autorise pas la connexion Good morning all, Any idea about this little issue? May HTProtect cause an issue? Thank our for your help Jean-Loup") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 weeks 3 days ago, by [jean-loup](/forum/user/40284-jean-loup "View jean-loup's Profile") [Last Post](/forum/36-reports-statistics/100000037-no-access-to-cron-tasks#100000194 "Hello Jean-Loup, HTProtect is not the cause. The "Create/Edit your Cron task" button opens a page of our website in a popup on your back end, and since our website moved to new servers, browsers refused to show it there. It was the same for every HikaShop website, and we changed the Cron tab so that it does not need that popup any more. Your web cron itself is fine: it is set up and running on our side. Our server triggers your cron URL every hour, and it last ran today at 08:14 (UTC). To see it or change it from your back end, download the HikaShop 6.7.0 package again from your account on our website (it was updated today) and install it over your current version. Then, on HikaShop > Configuration > Cron, click on "Show the web cron": you will see whether it runs, its frequency, its next and last run and its last report, and you can change its frequency and save it there. The cron task documentation describes it: www.hikashop.com/support/documentation/55-hikashop-cron-task") 3 weeks 3 days ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:95 | [Last Post](/forum/36-reports-statistics/100000037-no-access-to-cron-tasks#100000194 "Hello Jean-Loup, HTProtect is not the cause. The "Create/Edit your Cron task" button opens a page of our website in a popup on your back end, and since our website moved to new servers, browsers refused to show it there. It was the same for every HikaShop website, and we changed the Cron tab so that it does not need that popup any more. Your web cron itself is fine: it is set up and running on our side. Our server triggers your cron URL every hour, and it last ran today at 08:14 (UTC). To see it or change it from your back end, download the HikaShop 6.7.0 package again from your account on our website (it was updated today) and install it over your current version. Then, on HikaShop > Configuration > Cron, click on "Show the web cron": you will see whether it runs, its frequency, its next and last run and its last report, and you can change its frequency and save it there. The cron task documentation describes it: www.hikashop.com/support/documentation/55-hikashop-cron-task") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 weeks 3 days ago |
| [](/forum/36-reports-statistics/910702-report-with-products) | [Report with products](/forum/36-reports-statistics/910702-report-with-products "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 Hi when i export sales report, i have the information of each order. how can i have the products bought on each order as well ? and is there any way that i can choose which columns to have in csv file ? now the report has all the info which lots of them is not needed. i want to have only the order id, customer namee, price and orders he/she bought for example thank in advance for your help") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 months 1 week ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/36-reports-statistics/910702-report-with-products#372776 "Hi, The sales report export is order based and its columns are fixed, so it cannot list the products of each order nor let you pick the columns. For what you want, use a Mass action with a CSV export instead, it lets you choose exactly the columns, and it can output the products of each order. Here is how to set it up: 1) In your HikaShop control panel, open the Mass actions page (System menu, Mass actions) and create a new one. 2) For the area (the table it works on), choose "Order". 3) In the "Actions" area, add an action and choose "Export a csv file". 4) The export action then shows the available columns as checkboxes, grouped by the Order, Order products, Address and User tables. Tick only the ones you need, for example: - Order: order_id (and order_full_price if you want the order total) - Address: address_lastname and address_firstname (the customer name) - Order products: order_product_name, order_product_price, order_product_quantity 5) Tick the "One product per row" option (it appears for the Order area). This is the key part: it exports one line per product of each order, so you get the products bought on each order instead of a single line per order. 6) Choose the format "CSV". You can leave the "Export path" and "To address" fields empty to simply download the file, or fill them to save it on the server and receive it by email. 7) Save the mass action, then run it with the "Process" button to generate and download the CSV. If you only want part of your orders (for instance a date range or a given status), add a filter to the mass action before processing and only the matching orders will be exported.") 3 months 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:252 | [Last Post](/forum/36-reports-statistics/910702-report-with-products#372776 "Hi, The sales report export is order based and its columns are fixed, so it cannot list the products of each order nor let you pick the columns. For what you want, use a Mass action with a CSV export instead, it lets you choose exactly the columns, and it can output the products of each order. Here is how to set it up: 1) In your HikaShop control panel, open the Mass actions page (System menu, Mass actions) and create a new one. 2) For the area (the table it works on), choose "Order". 3) In the "Actions" area, add an action and choose "Export a csv file". 4) The export action then shows the available columns as checkboxes, grouped by the Order, Order products, Address and User tables. Tick only the ones you need, for example: - Order: order_id (and order_full_price if you want the order total) - Address: address_lastname and address_firstname (the customer name) - Order products: order_product_name, order_product_price, order_product_quantity 5) Tick the "One product per row" option (it appears for the Order area). This is the key part: it exports one line per product of each order, so you get the products bought on each order instead of a single line per order. 6) Choose the format "CSV". You can leave the "Export path" and "To address" fields empty to simply download the file, or fill them to save it on the server and receive it by email. 7) Save the mass action, then run it with the "Process" button to generate and download the CSV. If you only want part of your orders (for instance a date range or a given status), add a filter to the mass action before processing and only the matching orders will be exported.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 months 1 week ago |
| [](/forum/36-reports-statistics/910517-problem-with-amazon-ses) | [Problem with Amazon SES](/forum/36-reports-statistics/910517-problem-with-amazon-ses "-- HikaShop version -- : 6.4.0 -- Joomla version -- : 4.4.0 -- PHP version -- : 8.3.30 -- Browser(s) name and version -- : Chrome Hello, Just created an Amazon SES account and Joomla sends correct through Amazon SES. When i notify users by changing their order state the they don`t receive the mail. It only happens in Hikashop. For example the invoice plugin doesn`t work either. Always says "SMTP Error: data not accepted." Am i doing something wrong or can`t Amazon SES used by Hikashop? Best regards") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 5 months 3 weeks ago, by [nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile") [Last Post](/forum/36-reports-statistics/910517-problem-with-amazon-ses#371901 "Hi, HikaShop has no problem sending emails via Amazon SES. The invoice plugin will add an attachment to the emails. Amazon SES has limitations on email size repost.aws/questions/QUyA0h1vpsSgqMtSgHP...achments-above-10-mb but that should not be a problem. Try disabling the plugin and see if you receive the email when you change the status. If, even with the plugin disabled, it doesn't work, it's likely a problem with the settings under the Emails section of the Main tab of the HikaShop configuration page. Please review them and make sure they match what Amazon SES requires.") 5 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:296 | [Last Post](/forum/36-reports-statistics/910517-problem-with-amazon-ses#371901 "Hi, HikaShop has no problem sending emails via Amazon SES. The invoice plugin will add an attachment to the emails. Amazon SES has limitations on email size repost.aws/questions/QUyA0h1vpsSgqMtSgHP...achments-above-10-mb but that should not be a problem. Try disabling the plugin and see if you receive the email when you change the status. If, even with the plugin disabled, it doesn't work, it's likely a problem with the settings under the Emails section of the Main tab of the HikaShop configuration page. Please review them and make sure they match what Amazon SES requires.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 months 3 weeks ago |
| [](/forum/36-reports-statistics/909955-where-to-add-pixel-for-specific-events) | [Where to add pixel for specific events](/forum/36-reports-statistics/909955-where-to-add-pixel-for-specific-events "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 5.3.1 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I would like to add a Meta pixel on my website. I have already added the base pixel and would like to know where to add the "view content", "add to cart" and "intiiated checkout" scripts. I am seeing that it needs to be added to the view files in display, but i'm not sure which view file is the correct one for each event. Also, I'm wondering where in the file to add it in order not to mess up with the php code. Thank you!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 months 3 weeks ago, by [Noe](/forum/user/60747-noe "View Noe's Profile") [Last Post](/forum/36-reports-statistics/909955-where-to-add-pixel-for-specific-events#369703 "Hi, The head area is displayed by the Joomla template. In the views, you need to use code like this so that the template receives your JS code and adds it to the head: docs.joomla.org/Adding_JavaScript The popup after an add to cart is not displayed with a view file. To be able to inject JS code at this point, you need to implement the cart.updated event : www.hikashop.com/support/documentation/6...ocumentation.html#js Normally, you would want to place this code with a plugin of the group "system" implementing the onBeforeCompileHead event of Joomla: docs.joomla.org/Plugin/Events/System#onBeforeCompileHead Please understand that all this is not easy. It requires properly development. It's not something where you can just copy/paste a few lines of code here and there. I would rather recommend you check with the support of meta pixel tracking plugin how to get the token you need.") 10 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:639 | [Last Post](/forum/36-reports-statistics/909955-where-to-add-pixel-for-specific-events#369703 "Hi, The head area is displayed by the Joomla template. In the views, you need to use code like this so that the template receives your JS code and adds it to the head: docs.joomla.org/Adding_JavaScript The popup after an add to cart is not displayed with a view file. To be able to inject JS code at this point, you need to implement the cart.updated event : www.hikashop.com/support/documentation/6...ocumentation.html#js Normally, you would want to place this code with a plugin of the group "system" implementing the onBeforeCompileHead event of Joomla: docs.joomla.org/Plugin/Events/System#onBeforeCompileHead Please understand that all this is not easy. It requires properly development. It's not something where you can just copy/paste a few lines of code here and there. I would rather recommend you check with the support of meta pixel tracking plugin how to get the token you need.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 months 3 weeks ago |
| [](/forum/36-reports-statistics/909926-dashboard) | [Dashboard](/forum/36-reports-statistics/909926-dashboard "-- HikaShop version -- : 6.1 Hi! Currently the dashboard view is not really optimized. Please look at the big data sets and numbers.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 11 months 1 week ago, by [Rusty](/forum/user/83085-rusty "View Rusty's Profile") [Last Post](/forum/36-reports-statistics/909926-dashboard#369543 "Hi, Thanks for the extra details. I see what you mean. On my end, the display is quite ok : i.imgur.com/5rfj5lw.png But I guess it's because first there is not much data on my test website, and the texts are longer in German, which messes with the layout. Could you provide a backend access in order to analyze the situation directly on your website ? That would help me better understand what needs to be done to improve the look in cases like yours. If so, please go through our contact form to provide the access: www.hikashop.com/support/contact-us.html") 11 months 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:600 | [Last Post](/forum/36-reports-statistics/909926-dashboard#369543 "Hi, Thanks for the extra details. I see what you mean. On my end, the display is quite ok : i.imgur.com/5rfj5lw.png But I guess it's because first there is not much data on my test website, and the texts are longer in German, which messes with the layout. Could you provide a backend access in order to analyze the situation directly on your website ? That would help me better understand what needs to be done to improve the look in cases like yours. If so, please go through our contact form to provide the access: www.hikashop.com/support/contact-us.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 months 1 week ago |
| [](/forum/36-reports-statistics/909891-fields-added-to-a-product-not-displayed) | [Fields added to a product not displayed](/forum/36-reports-statistics/909891-fields-added-to-a-product-not-displayed "-- url of the page with the problem -- : www.vobovie.nl -- HikaShop version -- : 6.1.0 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2.29 -- Browser(s) name and version -- : Chrome 142.0.7444.162 -- Error-message(debug-mod must be tuned on) -- : na I created a custom field named lokatie for a product. It is a text field. It appaers on the packing slip but not on Order Administrator notification mail, although I added {LINEVAR:LOKATIE} to the product line section in the HTML part. In the attachment is the whole source. Why is the content of the field lokatie not displayed in het mail.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 11 months 3 weeks ago, by [hkoopman](/forum/user/83103-hkoopman "View hkoopman's Profile") [Last Post](/forum/36-reports-statistics/909891-fields-added-to-a-product-not-displayed#369369 "Hi, Yes, you need to use the same case as you have in the "column name" setting of the custom field.") 11 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:573 | [Last Post](/forum/36-reports-statistics/909891-fields-added-to-a-product-not-displayed#369369 "Hi, Yes, you need to use the same case as you have in the "column name" setting of the custom field.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 months 3 weeks ago |
| [](/forum/36-reports-statistics/909809-creer-un-rapport-avec-le-detail-des-commandes) | [Créer un rapport avec le détail des commandes](/forum/36-reports-statistics/909809-creer-un-rapport-avec-le-detail-des-commandes "-- HikaShop version -- : 6.1.0 -- Joomla version -- : 5.3.4 -- PHP version -- : 8.2 -- Browser(s) name and version -- : Google Chrome Bonjour, Je cherche à créer un rapport qui me donnerait un listing facile à lire avec le détail de toutes les commandes d'une période. Ce que j'ai besoin : Commande 1 - nom client 1 - Produit 1 - Option1 - Option 2 Commande 1 - nom client 1 - Produit 2 - Option1 - Option 2 Commande 2 - nom client 2 - Produit 1 - Option1 - Option 2 Etc... Je débute, et les informations reprise sur le tutos de ce site ne sont pas évidente pour faire ce que je cherche. Je ne demande pas de solution toute faite, plutôt des pistes à suivre pour comprendre ce que je fais. Merci d'avance") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 2 weeks ago, by [NouNat2024](/forum/user/83653-nounat2024 "View NouNat2024's Profile") [Last Post](/forum/36-reports-statistics/909809-creer-un-rapport-avec-le-detail-des-commandes#369100 "Merci pour votre réponse qui nous aide énormément.") 1 year 1 week ago by [NouNat2024](/forum/user/83653-nounat2024 "View NouNat2024's Profile") | Replies:2 Views:666 | [Last Post](/forum/36-reports-statistics/909809-creer-un-rapport-avec-le-detail-des-commandes#369100 "Merci pour votre réponse qui nous aide énormément.") by [NouNat2024](/forum/user/83653-nounat2024 "View NouNat2024's Profile") 1 year 1 week ago |
| [](/forum/36-reports-statistics/909647-getting-a-report-on-taxes) | [Getting a report on Taxes](/forum/36-reports-statistics/909647-getting-a-report-on-taxes "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 3.10.12 -- PHP version -- : 7.4.33 Hello. I am trying to create a report on the taxes people are playing for their orders. I have the report set as follows: * Report Type: Taxes * Order Status: Confirmed & Shipped * Display Type: Listing * Date Type: Created * Period: This Year * Options->Limit: 50 All I get is the orders, but with now numbers for the taxes people paid. I know there are orders with taxes that were paid. What am I doing wrong? Am I not using this correctly? Thanks.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 2 months ago, by [vanboke](/forum/user/4873-vanboke "View vanboke's Profile") [Last Post](/forum/36-reports-statistics/909647-getting-a-report-on-taxes#368204 "Thank you Nicolas. I don't think I would ever have found that on my own as that is the last place I would have looked. I appreciate the help finding it.") 1 year 2 months ago by [vanboke](/forum/user/4873-vanboke "View vanboke's Profile") | Replies:2 Views:767 | [Last Post](/forum/36-reports-statistics/909647-getting-a-report-on-taxes#368204 "Thank you Nicolas. I don't think I would ever have found that on my own as that is the last place I would have looked. I appreciate the help finding it.") by [vanboke](/forum/user/4873-vanboke "View vanboke's Profile") 1 year 2 months ago |
| [](/forum/36-reports-statistics/909641-how-to-crr-arpc-rpr-atbp-cr) | [How to CRR, ARPC, RPR, ATBP, CR](/forum/36-reports-statistics/909641-how-to-crr-arpc-rpr-atbp-cr "-- HikaShop version -- : 5.1.6 I'm trying to create specific statistics and need some help. How to set report for: 1. Customer Retention Rate 2. Average Revenue per Customer 3. Repeat Purchase Rate 4. Average Time Between Purchases 5. Churn Rate 6. Average sales per customer Is this even possible directly in hikashop?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 2 months ago, by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") [Last Post](/forum/36-reports-statistics/909641-how-to-crr-arpc-rpr-atbp-cr#368187 "Hi, I am not familiar with CRM software. I now of Dolibarr which is also open source and is used widely: www.dolibarr.org/ I also know of someone who used it with HikaShop. But I don't know what is can do regarding your needs of statistics.") 1 year 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:661 | [Last Post](/forum/36-reports-statistics/909641-how-to-crr-arpc-rpr-atbp-cr#368187 "Hi, I am not familiar with CRM software. I now of Dolibarr which is also open source and is used widely: www.dolibarr.org/ I also know of someone who used it with HikaShop. But I don't know what is can do regarding your needs of statistics.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 2 months ago |
| [](/forum/36-reports-statistics/909562-ga-plugin-errors) | [GA plugin errors](/forum/36-reports-statistics/909562-ga-plugin-errors "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 4 -- PHP version -- : 8.2 In the php error log I have the following warnings almost every minute: PHP Warning: Undefined variable $checkout_mode in public_html/plugins/system/hikashop_ga4/hikashop_ga4.php on line 1032 PHP Warning: Undefined variable $checkout_mode in public_html/plugins/system/hikashop_ga4/hikashop_ga4.php on line 996 Hikashop - Google Analytics 4 version is 1.2.3") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 3 months ago, by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") [Last Post](/forum/36-reports-statistics/909562-ga-plugin-errors#367827 "Hi, Thank you for your feedback. I've just made a new release of the plugin with a patch for these warnings.") 1 year 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:749 | [Last Post](/forum/36-reports-statistics/909562-ga-plugin-errors#367827 "Hi, Thank you for your feedback. I've just made a new release of the plugin with a patch for these warnings.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 3 months ago |
| [](/forum/36-reports-statistics/909457-in-ga4-plugin-item-id-product-code) | [In GA4 plugin - item\_id = product\_code?](/forum/36-reports-statistics/909457-in-ga4-plugin-item-id-product-code "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 5.3.0 -- PHP version -- : 8.1 -- Browser(s) name and version -- : Google chrome Hi, Is this right or it was a mistake, shouldn't that be product_id? I ended up checking the plugin after noticing that my remarketing integration with newsman was no longer working. GA4 sends the product code to the dataLayer at "product id" instead of the id. I'm not saying it's wrong one way or another, I know that a long time ago when I did the integration everything worked ok with newsman and now it doesn't. I'm trying to figure out where the change was made that creates this situation for me now ::side:: For a future update, perhaps the option to choose from the plugin settings what information to send to the dataLayer would be useful. If I edit the plugin and make this change, will it still work ok with Google Analytics?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 5 months ago, by [oxido](/forum/user/29793-oxido "View oxido's Profile") [Last Post](/forum/36-reports-statistics/909457-in-ga4-plugin-item-id-product-code#367324 "Hi, The product id is a number attributed automatically by HikaShop for internal use. Also, GA doesn't have a field named "item_code". And GA recommends you to use the "SKU" for the item_id: support.google.com/analytics/answer/13782210?hl=en And the SKU of a product is usually stored in product_code. So it's not a mistake. This is done like this because that's how it is supposed to be. If your integration worked in the past, then I don't think you want to do this modification because the plugin has always used the product_code for the item_id. The problem must be elsewhere. If you edit the code of the plugin with that change it should still work ok with GA. Note however that in your GA interface, you'll have your products in double. One product for the item_id with the id (from after the change) and one product for the item_id with the code (from before). So, you likely don't want to make that change.") 1 year 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:820 | [Last Post](/forum/36-reports-statistics/909457-in-ga4-plugin-item-id-product-code#367324 "Hi, The product id is a number attributed automatically by HikaShop for internal use. Also, GA doesn't have a field named "item_code". And GA recommends you to use the "SKU" for the item_id: support.google.com/analytics/answer/13782210?hl=en And the SKU of a product is usually stored in product_code. So it's not a mistake. This is done like this because that's how it is supposed to be. If your integration worked in the past, then I don't think you want to do this modification because the plugin has always used the product_code for the item_id. The problem must be elsewhere. If you edit the code of the plugin with that change it should still work ok with GA. Note however that in your GA interface, you'll have your products in double. One product for the item_id with the id (from after the change) and one product for the item_id with the code (from before). So, you likely don't want to make that change.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 5 months ago |
| [](/forum/36-reports-statistics/909441-ho-do-i-report-on-just-shipping) | [Ho do I report on JUST shipping](/forum/36-reports-statistics/909441-ho-do-i-report-on-just-shipping "Hi, How can I get the total sales of shipping during a given period please? Many thanks.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 5 months ago, by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile") [Last Post](/forum/36-reports-statistics/909441-ho-do-i-report-on-just-shipping#367228 "Hi, There is no mechanism to do that just in HikaShop. What you can do is this: - use the order status filter and the start and end date filters on the orders listing in the backend, so that you only see the orders you want to be taken into account for that total. - click on the "export" button. That will give you a CSV file with all the data of all the orders based on the selected filters. - open that CSV file with Excel or LibreOffice Calc. - search for the "order_shipping_price" column which contains the shipping fee for each order - use the "sum" function on the column to get the total at the bottom: support.microsoft.com/en-us/office/sum-f...80-8f32-07b23e057f89") 1 year 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1005 | [Last Post](/forum/36-reports-statistics/909441-ho-do-i-report-on-just-shipping#367228 "Hi, There is no mechanism to do that just in HikaShop. What you can do is this: - use the order status filter and the start and end date filters on the orders listing in the backend, so that you only see the orders you want to be taken into account for that total. - click on the "export" button. That will give you a CSV file with all the data of all the orders based on the selected filters. - open that CSV file with Excel or LibreOffice Calc. - search for the "order_shipping_price" column which contains the shipping fee for each order - use the "sum" function on the column to get the total at the bottom: support.microsoft.com/en-us/office/sum-f...80-8f32-07b23e057f89") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 5 months ago |
| [](/forum/36-reports-statistics/909378-orders-not-being-created) | [Orders not being created](/forum/36-reports-statistics/909378-orders-not-being-created "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 5.3.0 -- PHP version -- : 8.1.32 Hi Please help. Over the last month, several emails have come through from Paypal saying a payment has been received but there are no order details included and no order number. We have contacted PayPal who say that the payment was made through the site however there is no order created in Hikashop. All of these orders it seems are from email addresses that are not registered on the site so I'm assuming they have checked out as guests. All I can see from the emails from Paypal is how much the amount paid, by which email address and the date and time of the purchase but no order has been generated in Hikashop.. I am more than happy to provided login details for the site if required. Many thanks.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 6 months ago, by [askjim](/forum/user/44078-askjim "View askjim's Profile") [Last Post](/forum/36-reports-statistics/909378-orders-not-being-created#366965 "Thank you Nicolas, it makes sense now. There is a subdomain with a copy of the old site on it (which was using Hikashop) as the site owners wanted to have it for reference when the new site went live....") 1 year 6 months ago by [askjim](/forum/user/44078-askjim "View askjim's Profile") | Replies:6 Views:934 | [Last Post](/forum/36-reports-statistics/909378-orders-not-being-created#366965 "Thank you Nicolas, it makes sense now. There is a subdomain with a copy of the old site on it (which was using Hikashop) as the site owners wanted to have it for reference when the new site went live....") by [askjim](/forum/user/44078-askjim "View askjim's Profile") 1 year 6 months ago |
| [](/forum/36-reports-statistics/909365-report-showing-incorrect-amount) | [Report showing incorrect amount](/forum/36-reports-statistics/909365-report-showing-incorrect-amount "-- url of the page with the problem -- : eop-inc.com -- HikaShop version -- : 5.1.6 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.2.28 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : n/a I've taken the "Weekly Performance" report and turned it into an annual report. It is showing one category as having over $30,000 worth of sales when it has only had about $1,200. Other categories appear to be correct. Where could this innacuracy possibly be coming from? My report settings are: Display: Type: Listing, Date Type: Created, Period 2025-01-01 to 2025-12-31 Filters: Order Status: Confirmed, Including Sub Categories Yes (No shows same result) Options: Limit:100 All other settings are still at defualt") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 6 months ago, by [a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile") [Last Post](/forum/36-reports-statistics/909365-report-showing-incorrect-amount#366894 "I'll run it by the site owner for confirmation, but that looks so much better, thank you!") 1 year 6 months ago by [a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile") | Replies:6 Views:843 | [Last Post](/forum/36-reports-statistics/909365-report-showing-incorrect-amount#366894 "I'll run it by the site owner for confirmation, but that looks so much better, thank you!") by [a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile") 1 year 6 months ago |
| [](/forum/36-reports-statistics/908657-creating-customised-report) | [Creating Customised Report](/forum/36-reports-statistics/908657-creating-customised-report "-- HikaShop version -- : 5.1.1 [2409180854] -- Joomla version -- : 4.4.8 -- PHP version -- : 8.2.23 Our install is selling products some of which have tax applied and some which don't. We need to generate a quarterly report detailing the items, their price and tax collected, so when lodging with the taxation authority we have that report to provide Is there any documentation, that my searching hasn't uncovered, that you can point me to about creating a custom report? I've tried a few times and my logic is flawed as I constantly get an error saying that report cannot be exported. Looking to begin again with a different optic. Thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 2 years 1 month ago, by [yerg55](/forum/user/60833-yerg55 "View yerg55's Profile") [Last Post](/forum/36-reports-statistics/908657-creating-customised-report#365869 "Hi, That is indeed the case. The category information of the products in an order is not included in the order data. That's why you can't select it in the interface.") 1 year 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:1165 | [Last Post](/forum/36-reports-statistics/908657-creating-customised-report#365869 "Hi, That is indeed the case. The category information of the products in an order is not included in the order data. That's why you can't select it in the interface.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 8 months ago |
| [](/forum/36-reports-statistics/909110-complaince) | [Complaince](/forum/36-reports-statistics/909110-complaince "-- HikaShop version -- : 5.1.3 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.2 Hello, For complaince i must produce a report with clients who did not order the last 7 years (and after i know who these are i must anonymize the personal credentials). Is there a way to produce this report? Regards Michel") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 8 months ago, by [zegenrijk](/forum/user/29981-zegenrijk "View zegenrijk's Profile") [Last Post](/forum/36-reports-statistics/909110-complaince#365543 "Hi, You can create a mass action via the menu System>Mass actions. There, you can use the type "user" and the filter "have / don't have", with the "don't have" mode with either the "order" or "order status" submode. You can also use an action "export CSV file" with the columns you want to get a CSV file of the data when using the "process" button at the top. Then, you can open the CSV with Excel to visualize the data. Note that in the "limitations" area, it is limited to 500 elements by default. You'll want to increase it if you have more than 500 users without an order. However, the more you have users, and the more you increase that limitation, the more you might hit the resources limits of your hosting. If you have 100 000 users without an order, trying to export them all like this will be difficult as it will likely hit the limits of your hosting.") 1 year 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:866 | [Last Post](/forum/36-reports-statistics/909110-complaince#365543 "Hi, You can create a mass action via the menu System>Mass actions. There, you can use the type "user" and the filter "have / don't have", with the "don't have" mode with either the "order" or "order status" submode. You can also use an action "export CSV file" with the columns you want to get a CSV file of the data when using the "process" button at the top. Then, you can open the CSV with Excel to visualize the data. Note that in the "limitations" area, it is limited to 500 elements by default. You'll want to increase it if you have more than 500 users without an order. However, the more you have users, and the more you increase that limitation, the more you might hit the resources limits of your hosting. If you have 100 000 users without an order, trying to export them all like this will be difficult as it will likely hit the limits of your hosting.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 8 months ago |
| [](/forum/36-reports-statistics/908916-report-does-not-show-the-correct-number-of-products-sold) | [Report does not show the correct number of products sold.](/forum/36-reports-statistics/908916-report-does-not-show-the-correct-number-of-products-sold "-- HikaShop version -- : 5.1.1 -- Joomla version -- : 5.2.1 -- PHP version -- : 8.3 Hello Support, The report does not show the correct number of products sold. There were not 2 tins of 250 ml sold, but more. See the example order where 6 were already purchased. The naming in the report also does not match the names of the products. "Tin of Olive Oil - 250 ml" is not the correct name when you compare it to the actual product. See screenshots See order See productnames Hope you can help me. Kind regards, Lumiga") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 1 year 11 months ago, by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") [Last Post](/forum/36-reports-statistics/908916-report-does-not-show-the-correct-number-of-products-sold#364677 "Hi, Thanks for the access. From what I can see the issue is that the name of the product was changed during the period of the report and as the name is taken into account to group the orders together, it messed the algorithm. I've made a patch to better handle this. Now, it outputs one row for each name of the product, with the number of orders corresponding to that particular name, but the total amount is for all of the orders of the product regardless of the name.") 1 year 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:1016 | [Last Post](/forum/36-reports-statistics/908916-report-does-not-show-the-correct-number-of-products-sold#364677 "Hi, Thanks for the access. From what I can see the issue is that the name of the product was changed during the period of the report and as the name is taken into account to group the orders together, it messed the algorithm. I've made a patch to better handle this. Now, it outputs one row for each name of the product, with the number of orders corresponding to that particular name, but the total amount is for all of the orders of the product regardless of the name.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 11 months ago |
| [](/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 7 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:1189 | [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 |
| [ ](#forumtop) | |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.068 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)