[Skip to main content](#vessel-content) # How to config report? ## - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 8 months ago [\#304071](#304071) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#304071 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* was created by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? 5. [ ![123.png](/forum/attachment/46181) ](/forum/attachment/46181 "123.png") - [ ![123.png](/forum/attachment/46181) ](/forum/attachment/46181 "123.png") [ ](/forum/attachment/46181?download=1 "123.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 7 years 8 months ago - 7 years 8 months ago [\#304119](#304119) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#304119 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hello, In order to help you can you provide a **complete report configuration screenshot**, and **order statuses screenshot** as well. Check another point that show your screenshot, your **order status** because maybe order with "**shipped**" status don't exist ? Just a question that can explain a lot. Awaiting more element to go more far on your subject. Regards Last edit: 7 years 8 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 8 months ago - 7 years 8 months ago [\#304144](#304144) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Replied by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#304144 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hi, Here they are. [ ![row.png](/forum/attachment/46193) ](/forum/attachment/46193 "row.png") [ ![status_2019-02-25.png](/forum/attachment/46195) ](/forum/attachment/46195 "...2019-02-25.png") Seems filtering by category just doesn't want to work... Thanks - [ ![row.png](/forum/attachment/46193) ](/forum/attachment/46193 "row.png") [ ](/forum/attachment/46193?download=1 "row.png") - [ ![status_2019-02-25.png](/forum/attachment/46195) ](/forum/attachment/46195 "...2019-02-25.png") [ ](/forum/attachment/46195?download=1 "...2019-02-25.png") Last edit: 7 years 8 months ago by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 7 years 8 months ago - 7 years 8 months ago [\#304218](#304218) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#304218 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hello Can you provide via our [ **Contact us**](https://www.hikashop.com/support/contact-us.html) form **backend reference** with complete access in order to see it by ourself and process some tests don't forget to add an **url link to this topic**. Awaiting news from you Regards Last edit: 7 years 8 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 1 month ago [\#311006](#311006) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Replied by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311006 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hi, It seems we accidently found what is causing the issue here. As topic first message states, we want to see sale report for products from one category only.... 1. As example, if product is in categories "shoes" and "new products", trying to set filter by category "shoes" will generate nothing. If that product is only in one category "shoes" the filtering works. So basically for filtering to work, in time the product was sold, it should be only in one category "shoes" else report will generate nothing... Would you able to reproduce the issue? 2. Any update on new dashboard? It has been releases with Hikashop 3 but nothing improved for almost 2 years. It would be great if we could use our own settings as with legacy dashboard and not just have those presets which doesn't give any options at all... Please consider to improve it for at least with Joomla 4. Right now we try to send all data to google analytics but there are some thing we want to keep only in back-end and see the report there. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 7 years 1 month ago [\#311073](#311073) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311073 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hello, 1. Thanks for these informations we successfully reproduced it on our end, so we'll send you a fix as soon as possible ! 2. It's actually on our TODO list but we actually have projects of highest priority so we can't five you any ETA for the moment. Thanks for your return ! Kind regards, Mohamed Thelji. The following user(s) said Thank You: [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 1 month ago [\#311082](#311082) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Replied by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311082 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hi, 1. Thanks. It would be great if you could update this topic with the fix. 2. I know it's on your todo list but this is one of the core things in ecommerce. This should have high priority tho... Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 7 years 1 month ago [\#311139](#311139) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311139 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hello, 1. To fix your issue you'll just have to edit the file, and change these lines : Code: $leftjoin['product_category_filter'] = ' LEFT JOIN '.hikashop_table('product_category').' AS cat_filter ON cat.product_id = cat_filter.product_id AND cat_filter.category_id < cat.category_id'; $filters[] = 'cat_filter.product_category_id IS NULL'; By: Code: if ($widget->widget_params->content != 'products') { $leftjoin['product_category_filter'] = ' LEFT JOIN '.hikashop_table('product_category').' AS cat_filter ON cat.product_id = cat_filter.product_id AND cat_filter.category_id < cat.category_id'; $filters[] = 'cat_filter.product_category_id IS NULL'; } 2. Sure we'll increase the priority of that project in that case. Kind regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 1 month ago - 7 years 1 month ago [\#311152](#311152) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Replied by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311152 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hi, 1. The file should be changed is the widget.php inside administrator->components>com_hikashop->classes folder? As this is there i found your code provided. I have changed it but it made no difference. The report numbers were same - wrong one.... So i have changed this line: Code: if ($widget->widget_params->content != 'products') { To this: Code: if ($widget->widget_params->content == 'products') { Generated numbers seems correct now. So what code should be used? 2. I know how much time it takes to develop something.. So it would be great if you could add few new features to dashboard with every new Hikashop release. Thank you Last edit: 7 years 1 month ago by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 7 years 1 month ago [\#311220](#311220) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311220 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hello, We'll do more research on our end ! If it fixed your issue you can let it like for the moment, we'll need some screenshots of how you configured every fields of your report, so that we can directly reproduce it on our end. Kind regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 1 month ago [\#311228](#311228) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Replied by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311228 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hi, Well you can find screenshot in this topic previous answers: [ www.hikashop.com/forum/reports-statistic...g-report.html#304144](https://www.hikashop.com/forum/reports-statistics/896967-how-to-config-report.html#304144) Unless you need something else? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 7 years 1 month ago [\#311242](#311242) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311242 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hello, Sure, I'll need the right part of the configuration page of your report, especially the "Display" tab section. Kind regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")** - [![kyratn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/redswirl.jpg)](/forum/user/38342-kyratn "View kyratn's Profile") Topic Author - [ Offline](/forum/user/38342-kyratn) Less More - Posts: 1119 - Thank you received: 114 - - [](http://kyra.lt) - 7 years 1 month ago [\#311260](#311260) by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") Replied by *[kyratn](/forum/user/38342-kyratn "View kyratn's Profile")* on topic *[How to config report?](/forum/36-reports-statistics/896967-how-to-config-report#311260 "Hi, We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it... Report generates nothing but we are sure that we have some product sales from that category this month. Any advise? *")* Hi, Here it is: [ ![dis.png](/forum/attachment/47773) ](/forum/attachment/47773 "dis.png") Thanks - [ ![dis.png](/forum/attachment/47773) ](/forum/attachment/47773 "dis.png") [ ](/forum/attachment/47773?download=1 "dis.png") The following user(s) said Thank You: [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy84OTY5NjctaG93LXRvLWNvbmZpZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.107 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)