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 Return Reports.
This report shows your refund data in accordance to the purchase date - like Fetcher and Amazon’s API - and you can find it by first logging into Seller Central and then clicking on 'Reports'.
In the drop down that appears, click on 'Return Reports'. It should look like this:
From there, in the new page that opens, select your desired 'returns' date range, in the “Generate one-time report” field. Then click on the yellow 'Request' button. When that report appears under 'Generated Reports', click on the 'Download' button for both the XML and CSV files:
Finally, once your report opens, make sure to highlight and use the “purchase date” column to compare its data to that of Fetcher's
The return numbers in that report should match the numbers in Fetcher, but if they don't, please email us at firstname.lastname@example.org. We'll take a look to find out what's causing the discrepancy...and get it fixed for you!