I reached the max of 600 records for refund data. How do I add more?

The refund report we use from Amazon has a max of 600 items. To get more data than this you will have to run more than one report with different date ranges. Amazon typically will give you the most recent 600 items, so you will have to run more reports for the older data.

To do this for v1.0:

  1. Go to Reports > Payments > Transaction View (tab)
  2. Select Custom date range
  3. Select a To: date that is a day before the data begins on the last report you ran.
  4. Filter view by: Refund
  5. Click download (below “update”, to the right) – make sure to save it in a known location on your computer
  6. Open this file in notepad (or similar) and copy all data after the first row
  7. Open the Refunds sheet in the spreadsheet and select the last open cell in column A
  8. Right click and Paste the data that you previously copied
  9. Check to make sure there are no gaps in data – for example, you selected a ‘from’ date of Jan 1st, but there is only data going back to May 1st. This means you exceeded 600 records, and need to select a shorter date range
  10. Repeat the process for dates before the ones you selected in the 2nd step
  11. To make everything easier to read click the down arrow for column E, Payment Type, click ‘(Select All)’, then click ‘Product Charges’ to filter

 

To do this for v2.0:

  1. Go to Reports > Payments > Transaction View (tab)
  2. Select Custom date range
  3. Select a To: date that is a day before the data begins on the last report you ran.
  4. Filter view by: Refund
  5. Click download (below “update”, to the right) – make sure to save it in a known location on your computer
  6. Import the report into the Refunds sheet by clicking Import/Update
  7. Repeat the process for dates before the ones you selected in the 2nd step