Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 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:

The Manage Inventory Health report provides data to help you manage your inventory. It gives you a consolidated view of your inventory metrics across sales, shipment statuses, fees, and aged and excess units to help you identify and take action on your overstocked inventory.

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, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP. Use DEFAULT for seller default.

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 point. Default is an empty value to display all data points. Or you manually select one of the following.

  • 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?