Amazon return requests

Hello all, We’re a big business on Amazon and we get around 250 open returns per day, we used to track the returns using a package tracker to see what was delivered back to us and refund those orders manually.

But the package tracker on google sheets is always letting us down , how do you tackle that issue?