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

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for 
quicker results and to prevent Google from blocking your account for 
24 hrs due to overloading their resources. 
=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

refundsorder Gorilla ROI

Description:

Gets the list of all orders that were refunded. Filter by SKU to track your refunded order IDs. This is a dump of the order IDs where the refunds occurred. If someone bought 10 items in an order from you and refunds 1, we can’t split out only that single unit from the order. We show the full order details that is linked to the refund.

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.

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

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:A1000) in your formula wherever possible for 
quicker results and to prevent Google from 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")

How can we help?