[Skip to main content](#vessel-content) # Order report by category/status stopped working ## - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 6 months ago - 10 years 6 months ago [\#239760](#239760) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") *[Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#239760 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: Here is the screen shot before we make the change to remove the top level category: And if we remove the top-level category, and just select the sub levels, we get: Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")* was created by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* -- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: [ ![1_original_report.png](/forum/attachment/31329) ](/forum/attachment/31329 "...nal_report.png") Here is the screen shot before we make the change to remove the top level category: [ ![2_show_category_options_before_change.png](/forum/attachment/31330) ](/forum/attachment/31330 "...ore_change.png") And if we remove the top-level category, and just select the sub levels, we get: [ ![3_select_sub-level-only.png](/forum/attachment/31331) ](/forum/attachment/31331 "...level-only.png") Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped. - [ ![1_original_report.png](/forum/attachment/31329) ](/forum/attachment/31329 "...nal_report.png") [ ](/forum/attachment/31329?download=1 "...nal_report.png") - [ ![2_show_category_options_before_change.png](/forum/attachment/31330) ](/forum/attachment/31330 "...ore_change.png") [ ](/forum/attachment/31330?download=1 "...ore_change.png") - [ ![3_select_sub-level-only.png](/forum/attachment/31331) ](/forum/attachment/31331 "...level-only.png") [ ](/forum/attachment/31331?download=1 "...level-only.png") Last edit: 10 years 6 months ago by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile"). Reason: added note about order status Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODQ0Mzgtb3JkZXItcmVwb3J0LWJ5LWNhdGVnb3J5LXN0YXR1cy1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240168](#240168) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240168 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: Here is the screen shot before we make the change to remove the top level category: And if we remove the top-level category, and just select the sub levels, we get: Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")* Hi, I really don't see why changing the status used would solve the problem with the categories filtering in the reports. It looks like an issue with the reports categories filtering only. Could you provide a backend access so that we could activate the debug mode of the Joomla configuration and check the MySQL queries run for the filtering with the different reports (if you can provide the name of the reports with the different settings so that we can easily find them it would help) ? [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODQ0Mzgtb3JkZXItcmVwb3J0LWJ5LWNhdGVnb3J5LXN0YXR1cy1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 5 months ago [\#240194](#240194) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240194 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: Here is the screen shot before we make the change to remove the top level category: And if we remove the top-level category, and just select the sub levels, we get: Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")* Okay, I've made a clone of the production site for you and sent you the information to access it. Thanks!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODQ0Mzgtb3JkZXItcmVwb3J0LWJ5LWNhdGVnb3J5LXN0YXR1cy1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240251](#240251) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240251 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: Here is the screen shot before we make the change to remove the top level category: And if we remove the top-level category, and just select the sub levels, we get: Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")* Hi, I see. The problem is that the report system only loads 20 sub categories (to avoid crashing because of resource restrictions). Change the line: $childs = $categoryClass->getChildren($parents,true); to: $childs = $categoryClass->getChildren($parents,true, array(), '', 0, 200); in the file administrator/components/com_hikashop/classes/widget.php and that will load more categories avoiding the issue. You can also try with $childs = $categoryClass->getChildren($parents,true, array(), '', 0, 0); That should load the categories without any restriction on the amount. The following user(s) said Thank You: [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODQ0Mzgtb3JkZXItcmVwb3J0LWJ5LWNhdGVnb3J5LXN0YXR1cy1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 5 months ago [\#240290](#240290) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240290 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: Here is the screen shot before we make the change to remove the top level category: And if we remove the top-level category, and just select the sub levels, we get: Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")* That worked! Thank you. Do I need to keep this or is this something that will be in future updates? I noticed that this has been this way (at least in the widgets.php module) since 2.6.0 ... but it just recently stopped working as before. Is there something else that has changed in scope or do we need to be doing our reports differently?) Thanks, Kevin Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODQ0Mzgtb3JkZXItcmVwb3J0LWJ5LWNhdGVnb3J5LXN0YXR1cy1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240291](#240291) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order report by category/status stopped working](/forum/36-reports-statistics/884438-order-report-by-category-status-stopped-working#240291 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no error messages We have a report that stopped working and we can't figure out why. The report will not show products in the top-level category and its sub-categories. It is a published, Listing report, for all dates, with Type = Orders. We selected Confirmed status and in Categories the top-level product category for filters. Before, we just had the top-level category selected and Yes to Include sub categories. But now there are no orders listed. We found that we can go in to the next level of categories and select them, but if we include the top-most category, nothing results. I have tried rebuilding the categories, have even created a new report. If I go back and de-select the top-most category, and then select the next sub-level categories the report appears to work, but now we are afraid we may be missing things and use this report to process orders with. Here is what we had before: Here is the screen shot before we make the change to remove the top level category: And if we remove the top-level category, and just select the sub levels, we get: Note, even with the other categories included, if we go back and add the top-level products category back into the filter, nothing shows up. Also note that this is only if we choose Confirmed status. If I choose any other status we seem to get results, but we had the report configured for just confirmed orders. We have another status we change that to during picking/shipping and this report is used to show us only paid merchandise orders that need to be shipped.")* Hi, I've checked on our end but that code has always been like that. I suppose that the difference doesn't come from the version of HikaShop, but from the fact that you've added more categories, no? That fix will be included in the next version so there will be nothing to do on your end for that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODQ0Mzgtb3JkZXItcmVwb3J0LWJ5LWNhdGVnb3J5LXN0YXR1cy1zdG9wcGVkLXdvcmtpbmc/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.087 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)