Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_SETTLEMENTDETAILS...

GORILLA_SETTLEMENTDETAILS() – Get the details of what is included in a settlement transaction

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_SETTLEMENTDETAILS("TOY STORE", "LAST MONTH", "18044939392")
=GORILLA_SETTLEMENTDETAILS("TOY STORE", "LAST WEEK", "18044939392", "2", "SKU123")
=GORILLA_SETTLEMENTDETAILS("TOY STORE", "CUSTOM", "18044939392", , "SKU123", , , , "2022-10-01", "2022-10-10")

Syntax Description

image 10 Gorilla ROI

Description:

Get the details of what is included in a settlement transaction.

WARNING: For large sellers, do NOT use this function for a long time period, like “last year”. It will try to load thousands of orders. Google will timeout and will block your requests for the next 24hrs as it thinks you are a bot.

Syntax:

GORILLA_SETTLEMENTDETAILS(Seller ID, period, settlement_id, [page], [filter], [amount_type], [amount_description], [fulfillment_id], [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 settlements information or use custom to specify a start and end date.

settlement_id REQUIRED
A numeric valid settlement id to filter the results.

page – OPTIONAL
An integer page number to navigate through larger settlements. Each page has 20K records.

filter – OPTIONAL
SKU, or Amazon Order Id 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 ORDER111.

amount_type – OPTIONAL
A valid amount type to filter the results.Starting date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

amount_description – OPTIONAL
A valid amount description to filter the results.

fulfillment_id – OPTIONAL
Fulfillment id such as AFN or MFN

start_date – OPTIONAL
Starting date for the posted date range when period is custom.

end_date – OPTIONAL
Ending date for the posted date range when period is custom.

GORILLA_SETTLEMENTDETAILS Attributes

Period Attributes

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

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_SETTLEMENTDETAILS("TOY STORE", "LAST MONTH", "18044939392")

This will list all settlement details for the last month. You will get details such as the SKU, Marketplace Name, Settlement ID, Transaction Type, Amazon Order ID, Merchant Order ID, Adjustment ID, Shipment ID, Amount Type, Amount Description, Amount, Currency, Fulfillment ID, Posted Date Time, Order Item Code, Merchant Order Item ID, Merchant Adjustment Item ID, Quantity Purchased, Promotion ID.

=GORILLA_SETTLEMENTDETAILS("TOY STORE", "LAST WEEK", 18044939392, "2", "SKU123")

Returns details of all settlements from last week for Settlement ID 18044939392’s page 2 for SKU123.

=GORILLA_SETTLEMENTDETAILS("TOY STORE", "CUSTOM", "18044939392", , "SKU123", , , , "2022-10-01", "2022-10-10")

Custom period from Oct 1st, 2022 to Oct 10th, 2022 for Settlement ID 18044939392 for SKU123

GET YOUR SPREADSHEETS

Enter your email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.