What is the best way to look for latest transaction_id for a given original_transaction_id?

We have been using the purchase date to identify the latest transaction_id for a given original_transaction_id. However, I’ve noticed several cases where an immediate upgrade does not result in a later purchase date—in some instances, it is actually earlier than the previous transaction.

Given this inconsistency, would it be more reliable to sort by transaction_id in descending order instead?

Hello, have you tried calling Get All Subscription Statuses using the original TransactionId?
This API returns the status for all of the customer’s subscriptions by their subscription group identifier.

On the returned SubscriptionGroupIdentifierItem you can look at lastTransactionsItem to get the most recent transaction and renewal information for an auto-renewable subscription. Then, you can use status to determine the latest status for the user’s subscription.

What is the best way to look for latest transaction_id for a given original_transaction_id?
 
 
Q