We are using Sitecore 9.0 update 1 and have run into an issue where one of our commerce items has been marked as Orphaned in the content editor, however in Commerce biz tools the item has parent associations. We have run a database clean, updated commerce cache, cleared sitecore caches, rerun main indexes and reset iis and the item still persists.
I cannot find it in the actual SQL database anywhere either for master or web. Is there another cache or file that Sitecore reads from to populate items in the content editor?
A few extra notes:
When we re-index the sitecore master index, the item will get pulled in.
We cannot browse to the item, but if we search for the ID itself, it will show a path of [orphan]/itemname when we hover over it. When clicking on the item, it shows the Sitecore root node information.