Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_REIMBURSERETURNS() – Display reimbursement returns data

GORILLA_REIMBURSERETURNS() – Display reimbursement returns 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_REIMBURSERETURNS("TOY STORE", "LAST 7 DAYS")
=GORILLA_REIMBURSERETURNS("TOY STORE", "THIS YEAR", A2:A10)
=GORILLA_REIMBURSERETURNS("TOY STORE", "CUSTOM", , "Unit Returned to Inventory", , "2022-01-01", "2022-01-15")
=GORILLA_REIMBURSERETURNS("TOY STORE", "2022", , "ALL", "ALL")

Syntax description

REIMBURSERETURNS Gorilla ROI

Description:

Get the customer returns report and all the details showing what was returned, the reason, disposition, LPN and more.

Syntax:

GORILLA_REIMBURSERETURNS(Seller ID, period, [filter], [status], [disposition], [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.

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY 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.

status – OPTIONAL
Product status.
Valid values:

  • ALL (default)
  • Unit returned to inventory
  • Reimbursed

disposition – OPTIONAL
Product disposition.
Valid values:

  • All
  • Sellable
  • Nonsellable
  • Customer_damaged
  • Carrier_damaged
  • Defective
  • Damaged
  • Distributor_damaged
  • Carrier_damaged. If disposition is left empty, the default option will return all dispositions except sellable.

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_REIMBURSERETURNS("TOY STORE", "LAST 7 DAYS")

Returns a detailed list of all returns that was reimbursed over the last 7 days. Returns the values for SKU, FNSKU, ASIN, Order Id, Fulfillment Center Id, Country, State, Quantity, Reason, Disposition, Status, License Plate Number, Customer Comments.

=GORILLA_REIMBURSERETURNS("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_REIMBURSERETURNS("TOY STORE", "CUSTOM", , "Unit Returned to Inventory", , "2022-01-01", "2022-01-15")

Returns all line items where the inventory reimbursement status is “Unit Returned to Inventory” between the two dates.

=GORILLA_REIMBURSERETURNS("TOY STORE", "2022", , "ALL", "ALL")

Returns the returns data for all SKUs in 2022 for all Status and All dispositions.

How can we help?