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("TOY STORE", "LAST 30 DAYS")
=GORILLA_REFUNDSORDER("TOY STORE", "THIS MONTH" ,"SKU111,SKU222,SKU333″, "DE")
=GORILLA_REFUNDSORDER("TOY STORE", "THIS MONTH" , A1:A34, "DE")
=GORILLA_REFUNDSORDER("TOY STORE", "CUSTOM", A2:A34, "FR", "ALL", "2022-01-01", "2022-01-15")
Syntax description
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(Seller ID, period, [filter], [marketplace], [status], [start_date], [end_date])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
period – REQUIRED
Predefined period to get refunded units. See full list of predefined periods below.
| Today | This month | Last 3 Months |
| Yesterday | This quarter | Last 12 Months |
| Same day last week | This year | Last 7 Days Week Ago |
| Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
| Same day last year | Last Week | Last 30 Days Month Ago |
| Last 7 Days | Last Month | Last 30 Days Year Ago |
| Last 14 Days | Last Quarter | Last Week Year Ago |
| Last 30 Days | Last Year | Last Month Year Ago |
| Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
| This week | YYYY | 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.
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("TOY STORE", "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("TOY STORE", "THIS MONTH" ,"SKU111,SKU222,SKU333″, "DE")
=GORILLA_REFUNDSORDER("TOY STORE", "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("TOY STORE", "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.