Why did my sandbox test fail due to not being able to obtain the product list?
Sandbox testing has no products
To learn how to successfully test in the sandbox, see the response in Missing the Required "In-App Purchases and Subscriptions" Section in App Store Connect.