You can use In-App purchase test users, to test In-App purchase in sandbox mode.
Create test users in the “Users and Access” section of appstoreconnect.apple.com
Before testing In-App purchase, Using the Settings app, logout your actual Apple ID and login the test user account directly via your app. (DON’T login the test user via Settings app or AppStore.)