Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_STORAGEFEES() – G...

GORILLA_STORAGEFEES() – Get your Amazon storage fees report

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_STORAGEFEES("TOY STORE", "2022-08", A1:A260)
=GORILLA_STORAGEFEES("TOY STORE", "Last 90 Days","B00H9D0D4G")
=GORILLA_STORAGEFEES("TOY STORE", "last month", A1:A1000, "oversize", "US")

Syntax Description

STORAGEFEES2 Gorilla ROI

Description:

Get monthly storage fees report and details by ASIN.

Syntax:

GORILLA_STORAGEFEES(Seller ID, period, asin, [product_size_tier], [fc_location], [dangerous_goods_storage_type], [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 storage fees data or use custom to specify a start and end date. As this is a monthly report, not all time periods will be supported.

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

ASIN – REQUIRED
Must use ASIN. SKU will not work. Can be a range of values like A1:A100 where A1 to A100 consists of values like ASIN111, ASIN222, ASIN333 or ASIN123.
If more than one ASIN is entered into the formula, please enter a single month for the period.

product_size_tier – OPTIONAL
Product size tier. Can be a range of values like A1:A100 where A1 to A100 consists of values like Standard-Size, Oversize. Use ALL to get values from all sizes (default).

  • Standard-size
  • Oversize
  • All

fc_location – OPTIONAL
Fulfillment center location filter.
Valid country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP. Use ALL to get values from all centers (default).
Default value is “ALL”.

dangerous_goods_storage_type – OPTIONAL
Dangerous goods storage type.
Valid values:

  • ALL (default)
  • NONE
  • AEROSOLS
  • FLAMMABLES

start_date – OPTIONAL
Starting date for the returning range when period is “custom”.

end_date – OPTIONAL
Ending date for the returning range when period is “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_STORAGEFEES("TOY STORE", "2022-08", A1:A260)

This will load all the storage fees paid in the month of 2022-08 for the ASINs listed in column A. This function does not support looking up SKUs. Only ASINs.

=GORILLA_STORAGEFEES("TOY STORE", "Last 90 Days","B00H9D0D4G")

Returns the monthly storage fees over the last 90 days (or 3 months). The result is a table of the past 3 months like so.

image 7 Gorilla ROI

You can only use one ASIN input if you select a time period other than a single month. If you wish to display for each ASIN, you MUST select only 1 month to enter into the time period.

=GORILLA_STORAGEFEES("TOY STORE", "last month", A1:A1000, "oversize", "US")
Tags

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.