I'm missing or don't see a product on the Manual COGS page.

Your Shopify products most likely need to be re-synced. This can also be done manually on this page here with the "Sync All Products from Shopify" button.