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
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.
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 |
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.
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")