如何在Apple商家账户查询In-app purchase交易ID及退款用户信息

Hey there, let's break down your Apple In-App Purchase questions step by step:

1. How to find transactionIDs for your app's In-App Purchases #

Here's how to locate those transactionIDs in your App Store Connect account:

• Log into your App Store Connect merchant account.
• From the left sidebar, select "My Apps" and choose the specific app you're working with.
• Navigate to the Sales and Trends section (it's in the top menu of the app's detail page).
• Switch to the Transactions tab at the top of this page.
• Use the filters to narrow down results: set the date range, select "In-App Purchase" as the transaction type, and any other relevant criteria. Each listed transaction will display its unique transactionID.
• If you need to process bulk data, head to the Reports sub-section under Sales and Trends. You can download a CSV report that includes all transaction details—including transactionIDs—for easy sorting and analysis.

2. Tracking refunded users and their transactionIDs to stop server services #

You absolutely can do both, here's how:

Checking the number of refunded subscription users #

• Go back to Sales and Trends > Transactions in App Store Connect.
• Adjust the filter to set "Transaction Type" to Refund. The total number of entries here is the count of refunded transactions. Keep in mind: if a user has multiple refunds, this count will reflect that—if you need unique user counts, you'll have to cross-reference these transactions with the user IDs you've stored on your server (Apple doesn't share direct user identifiers in these reports).
• For a more precise count, download the CSV report from Sales and Trends. You can use spreadsheet tools (like Excel or Google Sheets) to count unique users by matching the transaction data to your own user records.

Retrieving refunded transactionIDs to stop service #

• In the filtered Transactions view (set to Refund), each entry will show the original transactionID from the initial purchase.
• The CSV report will also include these transactionIDs, clearly marked with "Transaction Type" as "Refund".
• Since you should have linked each transactionID to a user account on your server when the purchase was completed, you can match the refunded transactionIDs to your user database and manually halt service for those users.

内容的提问来源于stack exchange，提问作者Krishna Maru