How can I effectively tag order purchases for easier filtering?

You can already Filter by product in Shopify > Orders

But if you still want to tag, I’d check on Shopify Flow workflows: https://apps.shopify.com/flow