Load Amazon FBA returns and refunds data into sheets

written by GORILLA ROI

You can now load the total number of FBA returns and the values of the returns by SKU or across your entire account.

This is on the heels of the newly released Amazon salestax function. If you have data importing requests, leave a comment below and we’ll add it to our consideration board.

As always, we update documentation consistently and in multiple locations to make it easy to find.

  1. Official page of all the functions we support
  2. Google Docs version
  3. Website version for easier navigation
  4. On any Google sheet > menu > addons > Gorilla > 2.See Supported Functions and examples

Load Amazon FBA returns and refunds data into sheets 1

Our latest FBA refunds function

We have created two separate functions for refunds. One is to get the qty of FBA returns over any period for any sku.

The other is to get the total value of the refunds.

See how to use it below and the dedicated functions and documentation pages and links to see more examples and usage.

GORILLA_REFUNDSCOUNT()

Easiest example:

=GORILLA_REFUNDSCOUNT("THIS YEAR")

More examples on the RefundsCount() explanation page.

gorilla refunds count function

You can see how easy it is to use. The only requirement is to enter the time period.

The list of time periods is extensive and you can also use custom dates.

=GORILLA_REFUNDSCOUNT("CUSTOM", "FR", A2:A34, "2020-01-01", "2020-01-15")

Enter “custom” in the period attribute. Then fill up the other attributes following the onscreen formula popup.

In the above formula, it’s grabbing the refunded count for:

  • custom time period from 2020 Jan 1 to Jan 15
  • France market
  • for all SKUs entered in cells A2 to A34

Here’s another example of how this looks on Google sheets.

refunds count results gorilla roi

Using ranges can load all the data in one shot.

Getting the returns like this using RefundsCount() is the same concept as SalesCount(). Think of the two functions are sisters. They work the same, just different results.

GORILLA_REFUNDSTOTAL()

Easiest example:

=GORILLA_REFUNDSTOTAL("THIS YEAR")

More examples on the RefundsTotal() explanation page.

gorilla refunds total

This is the same concept as RefundsCount. The only difference is that this pulls in the dollar value of all returns.

If you have 100 refunds for a $10 product, it will load $1,000 instead of 100.

All the same time periods are supported as well as custom time periods.

Here it is in action.

amazon fba returns refunds total results
Amazon fba returns refunds total results

To see other functions and examples, visit the functions page for all the features we support.

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

Leave a Reply

Your email address will not be published. Required fields are marked *

four × 1 =