Google Sheets Functions

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

GORILLA_REIMBURSERETURNS() – Display reimbursement returns data

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(“LAST 7 DAYS”)
=GORILLA_REIMBURSERETURNS(“THIS YEAR”, A2:A10)
=GORILLA_REIMBURSERETURNS(“CUSTOM”, , “Unit Returned to Inventory”, , “2022-01-01”, “2022-01-15”)
=GORILLA_REIMBURSERETURNS(“2022”, , “ALL”, “ALL”)

Syntax description

gorilla reimburse returns function 0617 1 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(period, [filter], [status], [disposition], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_REIMBURSERETURNS(sellerID, period, [filter], [status], [disposition], [start_date], [end_date])

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

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

OPTIONAL – Product status.

Valid values:

  • ALL (default)
  • Unit returned to inventory
  • Reimburseddisposition – OPTIONAL
    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
OPTIONAL – Starting date for when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date – OPTIONAL
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(“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(“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(“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(“2022”, , “ALL”, “ALL”)

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

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_REIMBURSERETURNS(“SELLERID38”, “LAST 7 DAYS”)
=GORILLA_REIMBURSERETURNS(“SELLERID38”, “THIS YEAR”, A2:A10)
=GORILLA_REIMBURSERETURNS(“SELLERID38”, “CUSTOM”, , “Unit Returned to Inventory”, , “2022-01-01”, “2022-01-15”)
=GORILLA_REIMBURSERETURNS(“SELLERID38”, “2022”, , “ALL”, “ALL”)

How can we help?