Unable to Delete Product – “There are transactions in the system using this product.”

Hi ​@Chao,

Once RevenueCat receives purchases for a product, the product cannot be deleted so as to maintain the consistency of our backend and data reporting systems, like charts. There is no harm in keeping the product in RevenueCat, you can keep it removed from any offerings and entitlements so that it does not display in your app. You can also remove the product from App Store Connect/Google Play Console to make sure no one can purchase it.

If the only purchases that exist for a product are sandbox, then yes you can delete all of the users who have these purchases before deleting the product itself. More info on deleting users here: https://docs.revenuecat.com/docs/manage-users

Regarding getting a list of app user ids or transaction ids - the easiest way to do this would likely be Scheduled Data Exports. You can get a CSV of all your historical transaction data, query by the product id, and see right away if these are sandbox purchases. If yes, you can pull up the user in the RevenueCat dashboard and delete them following the process in the link above.