GORILLA_REIMBURSEDETAILS() – Display reimbursement report and individual details
⭐ 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.