Why are some products not shown when I filter on categories ?
The category filter uses the product’s current default category, rather than every category associated with it.
For example, a product belongs to both “Clothes” and “Accessories”, with “Clothes” as its default category. A report filtered only on “Accessories” excludes that product even if it was sold. Select “Clothes” to include it.
- Open the product in the catalogue and check its default category.
- In the Products or Categories report, select that category in the product filters.
- Also check the period and order statuses, then export again.
This grouping assigns each product to one category. Changes to catalogue categories can therefore change how earlier sales are classified.