Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_INVENTORYHEALTH() – Get detailed inventory metrics

GORILLA_INVENTORYHEALTH() – Get detailed inventory metrics

INVENTORY HEALTH is now replacing INVENTORY AGE.
Amazon is discontinuing the INVENTORY AGE report. Once discontinued, we will be removing it from our system also.

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_INVENTORYHEALTH("TOY STORE", A1:A100)
=GORILLA_INVENTORYHEALTH("TOY STORE", A1:A100, , , , , TRUE)
=GORILLA_INVENTORYHEALTH("TOY STORE", A1:A100, "US", "NEW", "sales-rank", TRUE)

Syntax Description

INVENTORYHEALTH Gorilla ROI

Description:

Get inventory health data for a given sku or asin.

Syntax:

GORILLA_INVENTORYHEALTH(Seller ID, sku, [marketplace], [condition], [datapoint], [header])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – REQUIRED
Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123. If point is also specified, only single value or a column of SKUs can be provided.

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, BE, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP. Use ‘DEFAULT’ for seller default. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.

condition – OPTIONAL
Return only data for specific product condition. Default is empty value for any condition type. Other Valid values are: New, Used.

datapoint – OPTIONAL
Return data for specific data points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points. Other Valid values are:

  • snapshot-date
  • product-name
  • condition
  • available
  • pending-removal-quantity
  • inv-age-0-to-90-days
  • inv-age-91-to-180-days
  • inv-age-181-to-270-days
  • inv-age-271-to-365-days
  • inv-age-365-plus-days
  • currency
  • qty-to-be-charged-ltsf-6-mo
  • projected-ltsf-6-mo
  • qty-to-be-charged-ltsf-12-mo
  • estimated-ltsf-next-charge
  • alert
  • your-price
  • sales-price
  • lowest-price-new-plus-shipping
  • lowest-price-used
  • recommended-action
  • healthy-inventory-level
  • recommended-sales-price
  • recommended-sale-duration-days
  • recommended-removal-quantity
  • estimated-cost-savings-of-recommended-actions
  • sell-through
  • item-volume
  • volume-unit-measurement
  • storage-type
  • storage-volume
  • marketplace
  • product-group
  • sales-rank
  • days-of-supply
  • estimated-excess-quantity
  • weeks-of-cover-t30
  • weeks-of-cover-t90
  • featuredoffer-price
  • inv-age-0-to-30-days
  • inv-age-31-to-60-days
  • inv-age-61-to-90-days
  • inv-age-181-to-330-days
  • inv-age-331-to-365-days
  • estimated-storage-cost-next-month
  • inbound-quantity
  • inbound-working
  • inbound-shipped
  • inbound-received
  • no-sale-last-6-months

header – OPTIONAL
Show column header when the data point is not specified, TRUE to show header, FALSE (default) to not show it.

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_INVENTORYHEALTH("TOY STORE", A1:A100)

The most basic table format where the SKUs or ASINs are listed from A1 to A100.

It will list all the “datapoints” in the previous section above, without a header.

=GORILLA_INVENTORYHEALTH("TOY STORE", A1:A100, "US", , , , TRUE)

Returns a full table of results. All datapoints will be listed for SKUs or ASINs listed in A1:A100 for the US market. The TRUE condition will display a table header.

=GORILLA_INVENTORYHEALTH("TOY STORE", A1:A100, "US", "NEW", "sales-rank")

Returns a per ASIN or per SKU value of the “sales-rank” for the US market, in new condition

How can we help?