Bug #5977
openProducts (Sales Page) – Category filter shows data only after sales & behaves incorrectly with date filter
0%
Description
Module: Product Analysis & Sales → Products Tab
Issue Type: Functional (Filter logic)
Steps to Reproduce:
Go to Categories page.
Create a new Category.
Create a Sub-Category under the created category.
Create Products under the same Category and Sub-Category.
Go to Sales Page → Products tab.
Open the Category filter dropdown.
Select the newly created category.
Apply different Date filters.
Observe the product data displayed.
Actual Result:
Newly created category appears in the Category filter dropdown ✅
However, when selecting the category:
Products are shown only if sales are already done under that category ❌
Even then, results are shown only based on date filter, not consistently ❌
Category filter does not work independently and behaves inconsistently.
Products without sales are not shown, making the filter misleading.
Expected Result:
Category filter should:
Show all products under the selected category, regardless of whether sales are done or not ✅
Work independently of date filter, or clearly apply date filter logic consistently ✅
If the page is meant to show only sales-based data, then:
Category filter behavior should be clearly defined and consistent
Empty/no-sales state should be handled properly with a message like “No sales data available for selected category”
Subtasks