I attempted to retrieve all transactions from our Shopify stores using the GET method but encountered an issue. Despite using "any" as the status parameter, I couldn't retrieve all orders. It's possible that some transactions are archived, or there might be something I'm overlooking. Can we investigate this to determine the cause and find a solution?
For the transactions that are not being returned in the get request, are there any specific commonalities, eg: they are all archived, all associated with a specific payment gateway. If you can narrow down the properties of the missing transactions you may be able to get them via a request that has a specific structure.
You also might be able to retrieve them via the GraphQL API rather than using REST.
In some cases, I've noticed that I can retrieve transaction data up to a specific date for a particular store, but for other stores, I'm unable to retrieve all the transactions, and there doesn't seem to be a consistent pattern for the missing data. My suspicion is that these missing orders might be archived, and it's possible that the REST API is not providing access to this archived data. After reviewing the documentation, I understand that the API should, in theory, be able to access archived orders. Let me know if I'm missing something here ? I believe that retrieval of transactions are limited in my account.