GORILLA_REIMBURSEINVENTORY() – Display reimbursement inventory data
⭐ 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_REIMBURSEINVENTORY("TOY STORE", "LAST 7 DAYS")=GORILLA_REIMBURSEINVENTORY("TOY STORE", "THIS YEAR", A2:A10)=GORILLA_REIMBURSEINVENTORY("TOY STORE", "CUSTOM", , "DEFAULT", , "2022-01-01", "2022-01-15")=GORILLA_REIMBURSEINVENTORY("TOY STORE", "2022", A2:A10, A1:K10, "TRUE")Syntax description
Description:
Get full details of the inventory reimbursements applied to your account.
Syntax:
GORILLA_REIMBURSEINVENTORY(Seller ID, period, [filter], [reason], [unreconciled], [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 – OPTIONAL
Reason for adjustment. Can be a range of values like A1:A100. When empty, the default value will look up reimbursment code E, M.
Valid values:
Default
ALL
6
7
E
H
K
U
D
F
N
M
5
3
4
O
P
unreconciled – OPTIONAL
A shortcut filter to show Unreconciled transactions. Valid values are: ALL (default), TRUE qty greater than 0, FALSE shows qty equal to 0.
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_REIMBURSEINVENTORY("TOY STORE", "LAST 7 DAYS")Returns a detailed list of all inventory that was reimbursed over the last 7 days. Returns the values for SKU, FNSKU, Transaction ID, Fulfillment Center, Country, State, Quantity, Reason, Disposition, Reconciled and Unreconciled.
=GORILLA_REIMBURSEINVENTORY("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_REIMBURSEINVENTORY("TOY STORE", "CUSTOM", , "DEFAULT", , "2022-01-01", "2022-01-15")Returns all line items where the inventory reimbursement reason code is E or M between the two dates.
=GORILLA_REIMBURSEINVENTORY("TOY STORE", "2022", A2:A10, A1:K10, "TRUE")Returns the data for only the SKUs in A2:A10 and the reason codes listed in A1:K10 where the unreconciled quantity is greater than 0. This is to quickly show only the inventories that are unreconciled where you can see how much Amazon owes you.