Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_REFUNDSORDER() – Display orders that were refunded across any time period

GORILLA_REFUNDSORDER() – Display orders that were refunded across any time period

Sample Usage

=GORILLA_REFUNDSORDER("LAST 30 DAYS")
=GORILLA_REFUNDSORDER("THIS MONTH" ,"SKU111,SKU222,SKU333″, "DE")
=GORILLA_REFUNDSORDER("THIS MONTH" , A1:A34, "DE")
=GORILLA_REFUNDSORDER("CUSTOM", A2:A34, "FR", "ALL", "2022-01-01", "2022-01-15")

Syntax description

GORILLA_REFUNDSORDER() – Display orders that were refunded across any time period 1

Description:

Gets the list of all orders that were refunded. Filter by SKU to track your refunded orders.

WARNING: For large sellers, do NOT use this function for a long time period, like “last year”. It will try to load thousands and thousands of orders. Google will timeout and will block your requests for the next 24hrs as it thinks you are a bot.

Syntax:

GORILLA_REFUNDSORDER(period, [filter], [marketplace], [status], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_REFUNDSORDER(sellerID, period, [filter], [marketplace], [status], [start_date], [end_date])

period – REQUIRED

Predefined period to get refunded units. See full list of predefined periods below.

  • Custom
  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM (change format to text)
  • YYYYQ1… YYYYQ4

filter – OPTIONAL

SKU, ASIN or Amazon Order Id to filter the results. Can be a range of values like A1:A100 or SKU111, SKU222, SKU333 or ASIN123..

marketplace – OPTIONAL

Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, SE, AU, SG, JP. Use ALL to combine values from a single account, EU for all Europe markets EXCEPT UK, EURO to combine countries using EURO currency. Amazon Marketplace ID like ATVPDKIKX0DER can be used too.

status – OPTIONAL

Order status. Valid values are:

  • All
  • Canceled
  • Pending
  • PartiallyShipped
  • Unshipped
  • Shipped
  • Shipping

start_date – OPTIONAL

Starting date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date – OPTIONAL

Ending date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_REFUNDSORDER("LAST 30 DAYS")

Returns the list of all orders that were refunded in the last 30 days. No SKUs are specified which will pull the orders for all SKUs that had a refund in the time period.

=GORILLA_REFUNDSORDER("THIS MONTH" ,"SKU111,SKU222,SKU333″, "DE")
=GORILLA_REFUNDSORDER("THIS MONTH" , A1:A34, "DE")

Returns a list of all refunded orders this month for the 3 SKUs manually entered for the German market.

It will not show other SKU refunded orders.

Supports bulk SKUs by using ranges in your spreadsheet. You can have a list of SKUs or ASINs in A2:A34.

=GORILLA_REFUNDSORDER("CUSTOM", A2:A34, "FR", "ALL", "2022-01-01", "2022-01-15")

Returns the list of refunded orders for the SKUs listed in A2:A34 in the French market between the custom start and end date.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_REFUNDSORDER(sellerID, "LAST 30 DAYS")
=GORILLA_REFUNDSORDER(seller ID, "THIS MONTH" ,"SKU111,SKU222,SKU333″, "DE")
=GORILLA_REFUNDSORDER(seller ID, "THIS MONTH" , A1:A34, "DE")
=GORILLA_REFUNDSORDER(seller ID, "CUSTOM", A2:A34, "FR", "ALL", "2022-01-01", "2022-01-15")

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.

How can we help?