Product does not show up in reports if category depth > 2

[rbarreca]

Describe the bug
Apparently there are lots of legacy categories with depth > 2 but no way to edit or view in system besides as an admin. If a legacy product is assigned to one of those categories, those products and their sales do not show up in reports. For example, if you go to Purchases by Products and select Broccoli, Cauliflower & Cabbage category. Anything that is in the Vegetables > Broccoli, Cauliflower & Cabbage > Brussels Sprouts category will not show up even though it will show up in report if you do not have a category filter selected.

To Reproduce
Steps to reproduce the behavior:

1. Go to http://app.localtest.me:3000/admin/taxonomy and find a product that is categorized in a depth 3 or above (i.e. 3rd column or to the right)
2. Make a purchase with that product
3. Go to Sales by Product report
4. With no category filter, find a report with that product
5. Then choose the 2nd level category (only one that you can see/select) from category filter
6. Refresh report and notice product will not be there

Expected behavior
All products assigned to a subcategory under a 2nd level category would show. But, I think the 3rd+ depth categories are NOT exposed anywhere in system so I think the easiest fix would be to reassign all products to a 2nd level category.

User reports

• https://localorbit.zendesk.com/agent/tickets/14397