I'm sure this question has been asked, but there is no answer, and now it is critical that I upgrade from 2.0.6 due to the new advisory.
I have tried several different ways to upgrade, via CLI with composer and magento:upgrade ala this guide
I have tried fresh install from scratch only using my previous database and installing with the composer.
the end result for both is a page that has the category tree, but all products do not exist, yet the product count on the side within the category tree is the full count of all products including products not in inventory.
I've done just about everything imaginable, I've reindexed, I've flushed the cache, I've verified permissions.
In the admin, I can see all of my products, and all of my categories are populated with all my products
any pointers any suggestions, I'm practically at my wit's end.