Also worth noting that archived (deactivated) products also show up in ANY app that imports products such as bundling apps, multi platform inventory mgmt apps, wholesale apps, and download apps. Suddenly, they’re live products again.
It’s a massive pain in the ass … Such a basic feature … you can rest assured it will NEVER be corrected by Shopify.