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

=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_REIMBURSERETURNS() – Display reimbursement returns data 1

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.

Custom

This Month

Last 12 Months

Today This Quarter Last 7 Days Week Ago
Yesterday This Year Last 7 Days Year Ago
Same day last week This Year-to-Last-Month Last 30 Days Month Ago
Same day last month Last Week Last 30 Days Year Ago
Same day last year Last Month Last Week Year Ago
Last 7 Days Last Quarter Last Month Year Ago
Last 14 Days Last Year YYYY-MM (change format to text)
Last 30 Days Last 60 Days YYYYQ1… YYYYQ4
This Week YYYY

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:A100) in your formula wherever possible for quicker results and to prevent Google 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”)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?