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

Syntax Description

inventoryhealth function 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(sku, [marketplace], [condition], [datapoint], [header])

for Gorilla AGENCY, the syntax is

GORILLA_INVENTORYHEALTH(seller name, sku, [marketplace], [condition], [datapoint], [header])

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

  • product-name
  • condition
  • sales-rank
  • product-group
  • total-quantity
  • sellable-quantity
  • unsellable-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
  • units-shipped-last-24-hrs
  • units-shipped-last-7-days
  • units-shipped-last-30-days
  • units-shipped-last-90-days
  • units-shipped-last-180-days
  • units-shipped-last-365-days
  • weeks-of-cover-t7
  • weeks-of-cover-t30
  • weeks-of-cover-t90
  • weeks-of-cover-t180
  • weeks-of-cover-t365
  • num-afn-new-sellers
  • num-afn-used-sellers
  • currency
  • your-price
  • sales-price
  • lowest-afn-new-price
  • lowest-afn-used-price
  • lowest-mfn-new-price
  • lowest-mfn-used-price
  • qty-to-be-charged-ltsf-12-mo
  • qty-in-long-term-storage-program
  • qty-with-removals-in-progress
  • projected-ltsf-12-mo
  • per-unit-volume
  • is-hazmat
  • in-bound-quantity
  • asin-limit
  • inbound-recommend-quantity
  • qty-to-be-charged-ltsf-6-mo
  • projected-ltsf-6-mo

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(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(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(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

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_INVENTORYHEALTH("James Store", A1:A100)
=GORILLA_INVENTORYHEALTH("BALL SELLER", A1:A100, "US", , , , TRUE)
=GORILLA_INVENTORYHEALTH("SHOES USE", A1:A100, "US", "NEW", "sales-rank")

How can we help?