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. See using Products and Categories reports.