GORILLA_REIMBURSEREPLACE() – Find orders Amazon replaced and refunded
⭐ Separate reimbursement data upgrade is required to access this function ⭐
Add from your account or see the reimbursement plan info
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_REIMBURSEREPLACE("TOY STORE", "LAST 60 DAYS")=GORILLA_REIMBURSEREPLACE("TOY STORE", "THIS YEAR", A2:A10)=GORILLA_REIMBURSEREPLACE("TOY STORE", "CUSTOM", , "Damaged due to DC/FC handling","2023-06-01", "2023-09-15")=GORILLA_REIMBURSEREPLACE("TOY STORE", "Last 30 days", , "0")Syntax description
Description:
Shows replacements issued to customers for completed orders. Amazon documentation found here.
Our improved version will show whether a replacement was also refunded which means Amazon double refunded.
Syntax:
GORILLA_REIMBURSEREPLACE(Seller ID, period, [filter], [reason_code], [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 the refunds value. 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 FNSKU to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123.
reason_code – OPTIONAL
The reason code and matching names used.
Code | Reason |
0 | Other |
1 | Was lost |
2 | Defective |
3 | Damaged in shipping |
4 | Shipped wrong item |
5 | Item missing from shipment |
6 | Lost by shipper |
7 | Catalog error/wrong item ordered |
8 | Shipped to wrong address |
9 | Delivery problem (correct address) |
10 | Damaged due to DC/FC handling |
11 | Shipment in cleanup: item not received |
12 | Policy exception/customer error |
start_date – OPTIONAL
Starting date for when period is custom. To use custom dates, specify the period as “CUSTOM”.
end_date – OPTIONAL
Ending date for 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_REIMBURSEREPLACE("TOY STORE", "Last 60 Days")Returns a detailed list of all issued replacements over the last 60 days for completed orders. Returns the values for Shipment Date, SKU, ASIN, Fulfillment Center Id, Quantity, Replacement Reason, Replacement Amazon Order Id, Original Amazon Order Id, Refund Given.
=GORILLA_REIMBURSEREPLACE("TOY STORE", "THIS YEAR", A2:A10)Supports 2 dimensional ranges. Bulk return the return reimbursement details of the SKUs listed in A2:A10. Other SKUs will not be loaded.
=GORILLA_REIMBURSEREPLACE("TOY STORE", "CUSTOM", , "Damaged due to DC/FC handling","2023-06-01", "2023-09-15")Returns all line items where the replacement reason is “Damaged due to DC/FC handling” between the two dates. You can enter a number such as “0” from 0-12 to match Amazon’s replacement reason code. See above.
=GORILLA_REIMBURSEREPLACE("TOY STORE", "Last 30 days", , "0")Returns all line items where the replacement reason is “0” which is the code for “other”. See above for the codes and names.