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
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. Valid amount types are ItemPrice, ItemWithheldTax, ItemFees, Promotion, other-transaction, FBA Inventory Reimbursement, Cost of Advertising.
amount_description – OPTIONAL
A valid amount description to filter the results. Valid amount descriptions are Principal, Tax, MarketplaceFacilitatorTax-Principal, FBAPerUnitFulfillmentFee, Commission, Shipping, ShippingTax, MarketplaceFacilitatorTax-Shipping, ShippingChargeback, RefundCommission, Subscription Fee, Compensated_Clawback, TransactionTotalAmount.
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
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 |
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