[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/887907-duplicate-sales-in-google-analytics) | [Duplicate sales in Google Analytics](/forum/36-reports-statistics/887907-duplicate-sales-in-google-analytics "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 For some reason our sales are showing as duplicate sales in Google Analytics (GA). We have got GA running on the site and have setup the Hikashop GA plugin, but when a sale is made on the site it's showing as 1 sale in Google analytics but the product value is doubled. For example, our product price is 100 with a quantity of 6 = total according to Hikashop should be 600 but when viewing this on GA, it's showing 1200 with a quantity of 12 Any ideas?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/36-reports-statistics/887907-duplicate-sales-in-google-analytics#257780 "Hi, Without details about your current configuration ; I'm afraid that we are not able to provide you any further advice or help. Please understand that we need informations and elements to be able to understand a situation and provide an answer. Regards") 9 years 10 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:5 Views:1824 | [Last Post](/forum/36-reports-statistics/887907-duplicate-sales-in-google-analytics#257780 "Hi, Without details about your current configuration ; I'm afraid that we are not able to provide you any further advice or help. Please understand that we need informations and elements to be able to understand a situation and provide an answer. Regards") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 10 months ago | | [](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders) | [Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [montemama](/forum/user/43131-montemama "View montemama's Profile") [Last Post](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257792 "Hi, The plugin works fine with the standard HikaShop export file. So if you get an error, it means that you messed up something. Download the install package on our website and get the content of the file back/views/order/tmpl/export.php and paste it to your order/export view file so that it will have the correct code that is in HikaShop by default.") 9 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:2586 | [Last Post](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257792 "Hi, The plugin works fine with the standard HikaShop export file. So if you get an error, it means that you messed up something. Download the install package on our website and get the content of the file back/views/order/tmpl/export.php and paste it to your order/export view file so that it will have the correct code that is in HikaShop by default.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 10 months ago | | [](/forum/36-reports-statistics/887874-end-message) | [end message](/forum/36-reports-statistics/887874-end-message "Hello: I want to change the end-message after the user paid. I only get XXXXXXX. How can I change the fields Thanks Adres: XX XXXX XXXXXX XXXXX XXXXXXXX IBAN Internationaal Bank Account nummer: XXXX XXXX XXXX XXXX XXXX XXXX XXX BIC swift Bank Identification Code: XXXXXXXXXXXXXX Bank naam: XXXXXXXXXXX Bank adres: XX XXXX XXXXXX XXXXX XXXXXXXX Vergeet niet het bestel nummer ( T17 ) in te geven in de vermelding van de overschrijving zodat we dit kunnen koppelen aan uw bestelling. Bedankt voor uw aankoop.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [caroline.b](/forum/user/46446-caroline-b "View caroline.b's Profile") [Last Post](/forum/36-reports-statistics/887874-end-message#257318 "Hi, Edit your payment method via the menu System>Payment methods and change the XXX to what you want in the "informations" area of the payment method.") 9 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:3278 | [Last Post](/forum/36-reports-statistics/887874-end-message#257318 "Hi, Edit your payment method via the menu System>Payment methods and change the XXX to what you want in the "informations" area of the payment method.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 11 months ago | | [](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work) | [Today value in reporting does not work](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 I am trying to figure out how to get the Value of "TODAY" working for the reporting. No matter if I select TODAY in any type of reporting whether it be a table or gauge, etc it does not show the sales of just that days from 0:00 to 23:59 hours. It seems to just take whenever the last 24 hrs was when the widget was published. How do I fix this? This does not make sense to me because there is a last 24 hrs options, I would think if you selected TODAY that it would start from the beginning of the day? How do I fix this because the gauge and the table and using sales, it is not reporting the correct dollar amounts. For example it was 22:00 hours and the gauge was set to TODAY and days and the sales reset to 0 on the gauge when it should not have reset until 23:59:59. The only way I can get it to report "TODAY" is to set it to manual to the date range and time that I want, which I need it to be automatic. How can this be fixed? Thanks, Josh") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile") [Last Post](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work#256646 "Hi, I've tried to reproduce the issue with the same configuration on my end and I get that MySQL query: the order_created checks are valid and correspond to what it is supposed to do. I've also checked the modifications done to the reporting system since the 2.6.3 and no modifications are linked to the period calculations. So as far as I understand, what you have is correct and updating won't help. You must be missing something. For example, you've set the statuses setting to all statuses, meaning that even cancelled, refunded and created orders will be taken into account while you might only want to take into account confirmed and shipped orders. It could also be something relative to your timezone. The report system uses this code to calculate "today at 00:00": This takes into account the timezone of your server. But it doesn't take into account the timezone of your user in Joomla nor the timezone of the Joomla configuration. So it might be why you think that it does the same as "the last 24h" because the time difference you have between your server and your user fill in the gap between "the last 24h" and "today".") 9 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1689 | [Last Post](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work#256646 "Hi, I've tried to reproduce the issue with the same configuration on my end and I get that MySQL query: the order_created checks are valid and correspond to what it is supposed to do. I've also checked the modifications done to the reporting system since the 2.6.3 and no modifications are linked to the period calculations. So as far as I understand, what you have is correct and updating won't help. You must be missing something. For example, you've set the statuses setting to all statuses, meaning that even cancelled, refunded and created orders will be taken into account while you might only want to take into account confirmed and shipped orders. It could also be something relative to your timezone. The report system uses this code to calculate "today at 00:00": This takes into account the timezone of your server. But it doesn't take into account the timezone of your user in Joomla nor the timezone of the Joomla configuration. So it might be why you think that it does the same as "the last 24h" because the time difference you have between your server and your user fill in the gap between "the last 24h" and "today".") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 11 months ago | | [](/forum/36-reports-statistics/882224-cannot-include-images-into-invoice) | [Cannot include images into invoice](/forum/36-reports-statistics/882224-cannot-include-images-into-invoice "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.3.10 -- Browser(s) name and version -- : Safari 6.2.8 -- Error-message(debug-mod must be tuned on) -- : × ERROR n°6 File : /var/www/clients/client65/web100/web/plugins/hikashop/attachinvoice/attachinvoice/html2pdf.class.php Line : 1326 Impossible to load the image www.meintraining.at/images/logo.gif I edited the file /hikashop/attachinvoice/attachinvoice/invoice.php to customize the invoice layout. All works fine, except when I try to include the logo image to the invoice. Tried several ways: and with format .png but keep getting above error. I read through several forum entries and checked php setting allow_url_fopen On There must be a problem with tcpdf opening an image file, but don't know how to debug or solve. Pls advice on how to include logo image to the invoice.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 9 months ago, by [carniel](/forum/user/39404-carniel "View carniel's Profile") [Last Post](/forum/36-reports-statistics/882224-cannot-include-images-into-invoice#256431 "Hi, If it would be too old to work with PHP7, then you wouldn't be able to get PDF files at all for your invoices. The changelog for HTML2PDF is here: raw.githubusercontent.com/spipu/html2pdf/master/_changelog.txt And it doesn't mention anything regarding PHP7 support since the 4.0.3 or anything regarding improvments on images support. So if you have a problem with image display, all I can think of is a server restriction of some sort.") 9 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:13 Views:5828 | [Last Post](/forum/36-reports-statistics/882224-cannot-include-images-into-invoice#256431 "Hi, If it would be too old to work with PHP7, then you wouldn't be able to get PDF files at all for your invoices. The changelog for HTML2PDF is here: raw.githubusercontent.com/spipu/html2pdf/master/_changelog.txt And it doesn't mention anything regarding PHP7 support since the 4.0.3 or anything regarding improvments on images support. So if you have a problem with image display, all I can think of is a server restriction of some sort.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 11 months ago | | [](/forum/36-reports-statistics/887614-how-to-view-clicks) | [how to view clicks](/forum/36-reports-statistics/887614-how-to-view-clicks "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5 -- Error-message(debug-mod must be tuned on) -- : none hi how can i view clicks and impressions for products? thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [ronron](/forum/user/40399-ronron "View ronron's Profile") [Last Post](/forum/36-reports-statistics/887614-how-to-view-clicks#256321 "Hi, Reports are an HikaShop feature and it's only in the backend. Statistics is an HikaMarket feature and it require custom development to create new blocks. Vendor page customization need a view override. Regards,") 9 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:7 Views:1550 | [Last Post](/forum/36-reports-statistics/887614-how-to-view-clicks#256321 "Hi, Reports are an HikaShop feature and it's only in the backend. Statistics is an HikaMarket feature and it require custom development to create new blocks. Vendor page customization need a view override. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 11 months ago | | [](/forum/36-reports-statistics/887644-report-who-ordered-product) | [Report - who ordered product](/forum/36-reports-statistics/887644-report-who-ordered-product "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I would like to know if it is possible to make a report (or mass action): First column - product code (or product id), second column - list of order numbers of all orders, which contain this product (comma separated in one row is OK, or one number per line), third colum - quantity of ordered product. One row per product. I need to show only orders, which are not shipped yet. Is this possible? Thanks for your help ! Jarka") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 9 years 11 months ago, by [montemama](/forum/user/43131-montemama "View montemama's Profile") [Last Post](/forum/36-reports-statistics/887644-report-who-ordered-product#256096 "Hi, You can configure a mass action like that: take.ms/7fAMh And that will display a listing like that: take.ms/vjKLo That's the closest to what you want. To get exactly what you want, I can only see it with a MySQL query on your PHPMyAdmin or a custom development.") 9 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1541 | [Last Post](/forum/36-reports-statistics/887644-report-who-ordered-product#256096 "Hi, You can configure a mass action like that: take.ms/7fAMh And that will display a listing like that: take.ms/vjKLo That's the closest to what you want. To get exactly what you want, I can only see it with a MySQL query on your PHPMyAdmin or a custom development.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 11 months ago | | [](/forum/36-reports-statistics/872672-totals-on-dashboard-still-off) | [Totals on dashboard still off.](/forum/36-reports-statistics/872672-totals-on-dashboard-still-off "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4 I have reported this earlier on and hoped it would be fixed but totals in table reports we setup are still way off. They only reasons I can think off that Hika has issues with comma separation for decimals? When I export the totals and do a check in excel I get completely different numbers. Very frustrating for our managers. Its also not a little off: Hika total for this year: around 20.000 than excel comes around 14.000 Simpel setting for the totals: this year, tax excluded and only confirmed payments. Tried to set it to fixed date to get around an earlier bug but that does not change anything. It's also the same for all websites. Besides that I constantly loose my widgets with all setup totals. More frustration. We want to use Hika as a professional tool but this is not good.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 12 years 2 weeks ago, by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") [Last Post](/forum/36-reports-statistics/872672-totals-on-dashboard-still-off#254975 "Hi, As far as we know, the totals are corrects now and the patch that was provided on this thread 1 year ago was implemented at that time in HikaShop. To be able to help you, we would need screenshots of how your reports are configured, their results, and a clear description of the problem (what is wrong and what is ok in the screenshots) so that we can analyze the situation.") 10 years 3 days ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:15 Views:2049 | [Last Post](/forum/36-reports-statistics/872672-totals-on-dashboard-still-off#254975 "Hi, As far as we know, the totals are corrects now and the patch that was provided on this thread 1 year ago was implemented at that time in HikaShop. To be able to help you, we would need screenshots of how your reports are configured, their results, and a clear description of the problem (what is wrong and what is ok in the screenshots) so that we can analyze the situation.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 3 days ago | | [](/forum/36-reports-statistics/887280-sales-report-shows-total-before-coupon-is-applied) | [Sales report shows total before coupon is applied](/forum/36-reports-statistics/887280-sales-report-shows-total-before-coupon-is-applied "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : Sales report shows total before coupon is applied. When creating a table report for a sales total number for a period of time, how can we see the sales with coupons applied? Currently, the sales total includes order amounts before a coupon has been applied so it doesn't match the money that changed hands. On the flip side, Orders listing reports show the correct order total after the coupon was applied.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 1 week ago, by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") [Last Post](/forum/36-reports-statistics/887280-sales-report-shows-total-before-coupon-is-applied#254282 "Hi, Turn on the "include shipping" and "include taxes" options in your report and it will use the full total of the order instead of calculating the sum of the prices of the products. Note that we've also added an "include coupon" setting so if you update to the 2.6.4, you should be able to have the sum of products + coupon value without shipping and/or without taxes calculated. So it should cover all possible cases.") 10 years 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1299 | [Last Post](/forum/36-reports-statistics/887280-sales-report-shows-total-before-coupon-is-applied#254282 "Hi, Turn on the "include shipping" and "include taxes" options in your report and it will use the full total of the order instead of calculating the sum of the prices of the products. Note that we've also added an "include coupon" setting so if you update to the 2.6.4, you should be able to have the sum of products + coupon value without shipping and/or without taxes calculated. So it should cover all possible cases.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 1 week ago | | [](/forum/36-reports-statistics/887082-reports-and-statistics) | [Reports and statistics](/forum/36-reports-statistics/887082-reports-and-statistics "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5 -- Error-message(debug-mod must be tuned on) -- : none hi im using hikashop plus hikamarket. i just want to check if it is now possible to display the reports from the back end to the front end thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 3 weeks ago, by [ronron](/forum/user/40399-ronron "View ronron's Profile") [Last Post](/forum/36-reports-statistics/887082-reports-and-statistics#253256 "Hi, The report system in the HikaShop backend is not compatible with the front-end (or with add-ons). That is why HikaMarket have his own statistics/report system in the front-end and that system has been integrated into HikaShop 3. For the moment there is no interface to configure and create new reports but it is possible to create them using view overrides or custom plugins. The statistics system in HikaMarket is very flexible and his allow to use any kind of SQL query to retrieve some data (while the HikaShop report system have an algorithm which will generate queries depending a configuration). Once HikaShop 3 and the statistic system will be integrated ; it is plan to work on a configuration interface which will allow to generate new blocks. Maybe we will find a good interface to simplify the report generation without needed to write some SQL queries, it will highly depends on the feedback and ideas we will receive. Regards,") 10 years 3 weeks ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:1 Views:1535 | [Last Post](/forum/36-reports-statistics/887082-reports-and-statistics#253256 "Hi, The report system in the HikaShop backend is not compatible with the front-end (or with add-ons). That is why HikaMarket have his own statistics/report system in the front-end and that system has been integrated into HikaShop 3. For the moment there is no interface to configure and create new reports but it is possible to create them using view overrides or custom plugins. The statistics system in HikaMarket is very flexible and his allow to use any kind of SQL query to retrieve some data (while the HikaShop report system have an algorithm which will generate queries depending a configuration). Once HikaShop 3 and the statistic system will be integrated ; it is plan to work on a configuration interface which will allow to generate new blocks. Maybe we will find a good interface to simplify the report generation without needed to write some SQL queries, it will highly depends on the feedback and ideas we will receive. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 10 years 3 weeks ago | | [](/forum/36-reports-statistics/886928-report-for-top-50-customer) | [Report for Top 50 customer](/forum/36-reports-statistics/886928-report-for-top-50-customer "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.4.45 Any where to show top 50 customer in the dashboard? We can currently find the top customer in the dash board, would like to show it as 50") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 1 month ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") [Last Post](/forum/36-reports-statistics/886928-report-for-top-50-customer#253199 "Hi, Could you turn on the "debug mode" of the Joomla configuration and try again to display that report. There, at the bottom of the page, in the list of MySQL queries of the debug data, could you search the big query done on the table hikashop_order and provide the information about it (and the query itself) ? That would greatly help understand the situation.") 10 years 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1680 | [Last Post](/forum/36-reports-statistics/886928-report-for-top-50-customer#253199 "Hi, Could you turn on the "debug mode" of the Joomla configuration and try again to display that report. There, at the bottom of the page, in the list of MySQL queries of the debug data, could you search the big query done on the table hikashop_order and provide the information about it (and the query itself) ? That would greatly help understand the situation.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 3 weeks ago | | [](/forum/36-reports-statistics/886925-logo-in-the-invoice) | [Logo in the invoice](/forum/36-reports-statistics/886925-logo-in-the-invoice "-- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.2 Hi. As you could insert the logo on the invoice, please? Regards") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 1 month ago, by [rober1903](/forum/user/37591-rober1903 "View rober1903's Profile") [Last Post](/forum/36-reports-statistics/886925-logo-in-the-invoice#252542 "Hi, Yes. Edit the file "invoice" of the view "order" via the menu Display>Views and add an img tag for your logo image in there.") 10 years 4 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1192 | [Last Post](/forum/36-reports-statistics/886925-logo-in-the-invoice#252542 "Hi, Yes. Edit the file "invoice" of the view "order" via the menu Display>Views and add an img tag for your logo image in there.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 4 weeks ago | | [](/forum/36-reports-statistics/886842-display-orders-where-only-product-x-was-purchased) | [Display orders where ONLY Product X was purchased](/forum/36-reports-statistics/886842-display-orders-where-only-product-x-was-purchased "-- HikaShop version -- : 2.6.x -- Joomla version -- : 3.6.2 -- PHP version -- : 7.x -- Browser(s) name and version -- : var. Is there any way to create a report that shows all orders where Product X was purchased but NO OTHER products were purchased? If they purchased Product X AND Product Y I don't want that in the report. If it's not available somehow within the report system, can you give any tips on how to do that via sql?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 1 month ago, by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile") [Last Post](/forum/36-reports-statistics/886842-display-orders-where-only-product-x-was-purchased#252079 "Hi, I don't see a way to do that with either the reports system or the mass actions system. It will require a custom MySQL query. Something like that for example (to be tested): SELECT o.*, op1.* FROM #__hikashop_order as o LEFT JOIN #__hikashop_order_product as op1 ON o.order_id = op1.order_id AND op1.product_id = XXX LEFT JOIN #__hikashop_order_product as op2 ON o.order_id = op2.order_id AND op2.product_id != XXX WHERE op2.product_id IS NULL; Here with load all the orders with a product with the id XXX and with no products with the id different from XXX.") 10 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1309 | [Last Post](/forum/36-reports-statistics/886842-display-orders-where-only-product-x-was-purchased#252079 "Hi, I don't see a way to do that with either the reports system or the mass actions system. It will require a custom MySQL query. Something like that for example (to be tested): SELECT o.*, op1.* FROM #__hikashop_order as o LEFT JOIN #__hikashop_order_product as op1 ON o.order_id = op1.order_id AND op1.product_id = XXX LEFT JOIN #__hikashop_order_product as op2 ON o.order_id = op2.order_id AND op2.product_id != XXX WHERE op2.product_id IS NULL; Here with load all the orders with a product with the id XXX and with no products with the id different from XXX.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 1 month ago | | [](/forum/36-reports-statistics/886805-google-analytics-product-category-reporting) | [Google Analytics - Product Category reporting](/forum/36-reports-statistics/886805-google-analytics-product-category-reporting "-- HikaShop version -- : Business 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.6.22 I have come across an issue related to product variants that is affecting a bunch of different stuff. With Google Analytics specifically, the Product Category reporting shows as NOT SET for all orders. I believe the problem is that all of the products in our store have variants (size and color) and variants do not have a category. It would appear that the product category does not get reported when the item is a variant. Is there a way to fix this?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 1 month ago, by [BNRBranding](/forum/user/26254-bnrbranding "View BNRBranding's Profile") [Last Post](/forum/36-reports-statistics/886805-google-analytics-product-category-reporting#252040 "It's not necessarily a problem but would be nice to have. In the case of this store, each category is configured to be a stand alone store for clients so it would be very useful. I thought this might...") 10 years 1 month ago by [BNRBranding](/forum/user/26254-bnrbranding "View BNRBranding's Profile") | Replies:2 Views:1387 | [Last Post](/forum/36-reports-statistics/886805-google-analytics-product-category-reporting#252040 "It's not necessarily a problem but would be nice to have. In the case of this store, each category is configured to be a stand alone store for clients so it would be very useful. I thought this might...") by [BNRBranding](/forum/user/26254-bnrbranding "View BNRBranding's Profile") 10 years 1 month ago | | [](/forum/36-reports-statistics/886369-disappearing-widgets-using-table-view) | [disappearing widgets using table view](/forum/36-reports-statistics/886369-disappearing-widgets-using-table-view "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.2 Hi, Untill recently I ignored the reports on the dashboard. Now I started using them. I noticed an issue while editing table widgets (like the standard Main statistics). Sometimes they disappear. Suddenly they are gone from the dashboard and from the reports listing. This might happen after saving the widget (but not always), but once a widget was gone without anyone changing it. They are not deleted or depublished. These widgets still are in the dbase table hikashop_widget. However the column widget_access is empty. Other widgets have 'all' in the column widget_access. After adding 'all' to this column, these missing widgets show again Apparently somehow the value 'all' gets lost. This has happened in Hikashop 2.6.3 (Joomla 3.6.2) and Hikashop 2.3.3 (Joomla 2.5.28). Is this a bug, or did I do something wrong? regards, Udo") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 2 months ago, by [Udo](/forum/user/29928-udo "View Udo's Profile") [Last Post](/forum/36-reports-statistics/886369-disappearing-widgets-using-table-view#250206 "Yeah, this hack helps!") 10 years 1 month ago by [Udo](/forum/user/29928-udo "View Udo's Profile") | Replies:4 Views:1259 | [Last Post](/forum/36-reports-statistics/886369-disappearing-widgets-using-table-view#250206 "Yeah, this hack helps!") by [Udo](/forum/user/29928-udo "View Udo's Profile") 10 years 1 month ago | | [](/forum/36-reports-statistics/886399-google-analytics-products-plug-in-not-working) | [Google Analytics Products Plug-in Not Working](/forum/36-reports-statistics/886399-google-analytics-products-plug-in-not-working "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 We've set up the Hikashop Google Analytics Plugin (settings attached). Since we set it up we've had over 20 orders confirmed on the website, but only 3 have actually transferred to our Google Analytics account (In the Ecommerce conversions area). Do you have any idea why it's not reporting everything?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 2 months ago, by [dancingkazzaf](/forum/user/31984-dancingkazzaf "View dancingkazzaf's Profile") [Last Post](/forum/36-reports-statistics/886399-google-analytics-products-plug-in-not-working#249779 "Hi Jerome, Thanks for your help, i'll make these changes and see how it goes. :)") 10 years 2 months ago by [dancingkazzaf](/forum/user/31984-dancingkazzaf "View dancingkazzaf's Profile") | Replies:2 Views:1602 | [Last Post](/forum/36-reports-statistics/886399-google-analytics-products-plug-in-not-working#249779 "Hi Jerome, Thanks for your help, i'll make these changes and see how it goes. :)") by [dancingkazzaf](/forum/user/31984-dancingkazzaf "View dancingkazzaf's Profile") 10 years 2 months ago | | [](/forum/36-reports-statistics/878188-google-conversion-does-not-work) | [Google conversion does not work](/forum/36-reports-statistics/878188-google-conversion-does-not-work "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.4.38 I have a plugin enabled Google HikaShop Dynamic Remarketing (conversion tracking) and HikaShop Google Analytics plugin. Additional pasted google analytics code in the template. With the confirmation of the order shows shopping in google analytics, but for all TRANSACTIONS are as direct input for the first time, the location of the seller (vendor supports shop in another country), session time is 0.00 seconds. With the debug ga - in the console does not show error, but in tag assistant displays an error: Conversion ID malformed in the tag: -4399 and No HTTP response detected. What is wrong?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 11 years 3 months ago, by [StudioPrzyLesie](/forum/user/31654-studioprzylesie "View StudioPrzyLesie's Profile") [Last Post](/forum/36-reports-statistics/878188-google-conversion-does-not-work#249777 "OK forget it. I solved it by putting in the "Conversion ID" in the "Adwords ID" in the Google conversion plugin hikashop.") 10 years 2 months ago by [river](/forum/user/9591-river "View river's Profile") | Replies:8 Views:3142 | [Last Post](/forum/36-reports-statistics/878188-google-conversion-does-not-work#249777 "OK forget it. I solved it by putting in the "Conversion ID" in the "Adwords ID" in the Google conversion plugin hikashop.") by [river](/forum/user/9591-river "View river's Profile") 10 years 2 months ago | | [](/forum/36-reports-statistics/886227-extraction-de-rapport-erreur) | [Extraction de rapport erreur](/forum/36-reports-statistics/886227-extraction-de-rapport-erreur "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Ce site est inaccessible Il se peut que la page Web à l'adresse monsite.com/administrator/index.php?opti...=report&task=csv&cid []=22&d9ecebd619dfde1159bd0e52f141509e=1 soit temporairement inaccessible ou qu'elle ait été déplacée de façon permanente à une autre adresse Web. ERR_INVALID_RESPONSE Bonjour, je n'ai pas trouvé la solution sur le forum ni ailleurs... Pour les besoins de notre compta je souhaite extraire un rapport personnalisé de la liste des commandes du mois et de leurs montants. Tout a toujours bien fonctionné, jusqu'à maintenant (sans modification effectuée). Lorsque je clique sur le bouton Exporter aucun fichier n'est généré et j'obtiens une erreur de type ERR_INVALID_RESPONSE Sur d'autres rapports qui ne sont pas en mode Liste le rapport se génère correctement (Top Sales par exemple). De même dans "commandes" le bouton exporter fonctionne très bien et m'exporte des fichiers de plusieurs mégaoctets... Je suis en hébergement mutualisé pro ches OVH avec PHP-FPM activé (ce qui n'a jamais posé de problèmes avant). Mon max_execution_time est à 300 et memory_limit à 512M ce qui devrait être amplement suffisant... Là sincèrement je sèche un peu et il faut absolument que nous puissions faire ces exportations car nous devons clore l'exercice comptable pour fin du mois... Je vous joins une capture de l'erreur et de la config du Rapport en question (que j'ai supprimé/recréé plusieurs fois en vain) En vous remerciant par avance.") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 2 months ago, by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") [Last Post](/forum/36-reports-statistics/886227-extraction-de-rapport-erreur#249674 "Content d´avoir pu contribuer à l´amélioration continue ! ;)") 10 years 2 months ago by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") | Replies:12 Views:2341 | [Last Post](/forum/36-reports-statistics/886227-extraction-de-rapport-erreur#249674 "Content d´avoir pu contribuer à l´amélioration continue ! ;)") by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") 10 years 2 months ago | | [](/forum/36-reports-statistics/882935-integration-of-facebook-pixel-and-other-scripts) | [Integration of Facebook Pixel and other scripts](/forum/36-reports-statistics/882935-integration-of-facebook-pixel-and-other-scripts "-- url of the page with the problem -- : travelsat.com.au/shop/satellite-dishes/product/minimax75-dish -- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 41.0.2 -- Error-message(debug-mod must be tuned on) -- : No message Hello, I am integrating hikashop with facebook pixel and Google Analytics Dynamic Remarketing and need your help with setting this up. 1. How to get price on product page (view show_tabular). I need to insert this variable into Google Analytics Dynamic Remarketing script. And how to get product ID? Is it $this->element->main->product_id ? 2. How to add onlick event to add to cart button? In the file administrator/components/com_hikashop/helpers/cart.php I see this line: $html= ''; I need to add custom script for onclick event. This code is: var dataLayer = window.dataLayer \|\| []; dataLayer.push({ 'event': 'fireRemarketingTag', 'google_tag_params': { 'ecomm_pagetype': 'cart', 'ecomm_prodid': '', 'ecomm_totalvalue': } }); ecomm_prodid is product id ecomm_totalvalue is price*quantity (there is a quantity box on the page) I see currently there is alredy exist onclick event for add to cart button (I see script in browser). But when I add change mentioned line in cart.php to smth like this: $html= ''; this erases previous script for add to cart button and this button doesn't work well. How to combine my script with the script, that I see in browser currently: 3. Also how i can get values mentioned in question (2) in cart.php? ecomm_prodid is product id ecomm_totalvalue is product_price*quantity (there is a quantity box on the page) 4. I need to insert this code on after_end view file: var dataLayer = window.dataLayer \|\| []; dataLayer.push({ 'event': 'fireRemarketingTag', 'google_tag_params': { 'ecomm_pagetype': 'purchase', 'ecomm_prodid': '', 'ecomm_totalvalue': } }); Here is ecomm_prodid is array of products IDs, like: 'ecomm_prodid': [123, 456, 789], 'ecomm_totalvalue' - order price (sum of all prices for products in the order) How can I get values for ecomm_prodid and ecomm_totalvalue?") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 8 months ago, by [mypetfly](/forum/user/39734-mypetfly "View mypetfly's Profile") [Last Post](/forum/36-reports-statistics/882935-integration-of-facebook-pixel-and-other-scripts#248967 "Hi, What do you mean by "I don't see this code here" ? How come you say that you still see the default onclick code ? Please provide a screenshot for what you're saying because I too, like Jerome, see your code in the onclick of the add to cart buttons on your own website: take.ms/W4APC So we can't help for something that already works...") 10 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:19 Views:3592 | [Last Post](/forum/36-reports-statistics/882935-integration-of-facebook-pixel-and-other-scripts#248967 "Hi, What do you mean by "I don't see this code here" ? How come you say that you still see the default onclick code ? Please provide a screenshot for what you're saying because I too, like Jerome, see your code in the onclick of the add to cart buttons on your own website: take.ms/W4APC So we can't help for something that already works...") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 2 months ago | | [](/forum/36-reports-statistics/885906-add-fields-from-payment-plugin-to-csv-export) | [Add fields from Payment Plugin to CSV Export](/forum/36-reports-statistics/885906-add-fields-from-payment-plugin-to-csv-export "-- HikaShop version -- : HikaShop Business: 2.6.3 -- Joomla version -- : 3.6 -- PHP version -- : 5.6 Hey When using Purchase Order payment method there an input box for the order number. Also, I have added to it another inout box called The Workflow Code. I have managed to pass the values to the order, the confirmation emails and to the invoice but can't find how to add those 2 fields to the CSV Export file... Ideas? Thanks") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 10 years 3 months ago, by [tariaki](/forum/user/43507-tariaki "View tariaki's Profile") [Last Post](/forum/36-reports-statistics/885906-add-fields-from-payment-plugin-to-csv-export#247606 "Hi, As Jerome said, the information is in the report. If you want it as its own column, then create a custom field of the table "order" via the menu Display>Custom fields and replace the line: by:where XXX is the column name of your custom field. You'll then get your value is a separate column with its title being the column name of your custom field.") 10 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:1377 | [Last Post](/forum/36-reports-statistics/885906-add-fields-from-payment-plugin-to-csv-export#247606 "Hi, As Jerome said, the information is in the report. If you want it as its own column, then create a custom field of the table "order" via the menu Display>Custom fields and replace the line: by:where XXX is the column name of your custom field. You'll then get your value is a separate column with its title being the column name of your custom field.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 2 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.066 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)