⭐ 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_REIMBURSEDETAILS("TOY STORE", "LAST 7 DAYS")
=GORILLA_REIMBURSEDETAILS("TOY STORE", "THIS YEAR", A2:A10)
=GORILLA_REIMBURSEDETAILS("TOY STORE", "CUSTOM", , "WAREHOUSE_DAMAGED", "2022-01-01",
"2022-01-15")
=GORILLA_REIMBURSEDETAILS("TOY STORE", "2022", B7:B27, "LOST_INBOUND")
Syntax description
Description:
Dump the reimbursement details data
Syntax:
GORILLA_REIMBURSEDETAILS(Seller ID, period, [filter], [reason], [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 reimburse details or use ‘custom’ to specify a start and end date.
| 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 – OPTIONAL
Reason for adjustment. Can be a range of values. Valid values:
- ALL (default)
- CustomerReturn
- Damaged_Warehouse
- CustomerServiceIssue
- Lost_Warehouse
- Lost_Inbound
- Reimbursement_Reversal
- FeeCorrection
- Lost_Outbound
- ReturnAdjustment
- Damaged_Inbound
- Damaged_Outbound
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_REIMBURSEDETAILS("TOY STORE", "LAST 7 DAYS")
Returns a details list of all reimbursed transactions and SKU over the last 7 days. No SKUs are specified which will show all transactions across the entire account.
=GORILLA_REIMBURSEDETAILS("TOY STORE", "THIS YEAR", A2:A10)
Supports 2-dimensional ranges. Bulk return the reimbursement details of the SKUs listed in A2:A10. Other SKUs will not be loaded.
=GORILLA_REIMBURSEDETAILS("TOY STORE", "CUSTOM", , "WAREHOUSE_DAMAGED", "2022-01-01", “2022-01-15”)
Returns all warehouse damaged-related reimbursements for all the SKUs in the account. Data is loaded for the custom date period.
=GORILLA_REIMBURSEDETAILS("TOY STORE", "2022", B7:B27, "LOST_INBOUND")
Returns data for Lost Inbound SKUs listed in B7:B27 for 2022.