Why don't my returns in Fetcher match my returns in Seller Central?
Ah! Returns...they can be confusing since most sellers look at Seller Central's Refunds Report (found by going to Reports > Payments > transaction view > Refunds) when comparing Seller Central's returns to Fetcher's.
However, that particular report shows your Returns/Refunds in Seller Central under the “posted date”, which is when Amazon initiates the return. BUT, this isn't how Fetcher reports your refunds...and that's likely why your returns in Fetcher aren't matching the returns in Seller Central for a specific time frame.
You see, Fetcher uses the “purchase date” of the original order when looking at your refunds...not the date the refund was initiated.
We do it this way, not only because it is the correct approach for recording the negative transaction accounting-wise, but because this is the way Amazon stores the data in its API (Application Program Interface).
For example, if a customer purchased your product on December 25th, 2016 and then returned your product for a refund on January 5th, 2017, Fetcher will display that refund with a “purchase date” of December 25th, 2016 like this:
So, since the refund dates in Fetcher won’t match the refund dates in the refund section of your Seller Central Business Report, the report you want to pull to compare Fetcher's returns to your Seller Central account returns is the transactional report.
This report will show all of your transactions for the timeframe selected and include all refunds. You can compare your refunds from here based on the order ID.
But please note that the dates will be different because as noted above, Amazon uses refund requested dates while Fetcher uses the original order date.
- To retrieve the transactional report, please go to your seller central account & hover over Reports at the top. From here, Click Payments
2) Click the Date Range Reports tab and then Click Generate Report
3) From this screen make sure you have transaction view selected and then input the specific dates that need to be compared to in Fetcher
**It is recommended to select broad timeframes due to the fact that this report uses order posted date and not order purchase date"
4) Click Generate and then Click Refresh and the report should be there. Depending on how much data you have, it could take a few minutes.
The refund numbers in that report should match the numbers in Fetcher, but if they don't, please send me that report and I will investigate and compare the data for you.