Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INVENTORYAGE() – Get the inventory age for a given SKU or ASIN

GORILLA_INVENTORYAGE() – Get the inventory age for a given SKU or ASIN

The Inventory Age report will be discontinued in 2022.
Use the new INVENTORY HEALTH function.
The Inventory Age report will be discontinued in 2022 and is being replaced by the new Manage Inventory Health report. The Manage Inventory Health report is the former Inventory Age report but now combines the best of the Inventory Age, Inventory Health, and Excess Inventory report metrics across sales, shipment statuses, estimated fees, storage volume and type, and aged and excess inventory. To learn more, go to Manage Inventory Health overview. You’ll still be able to access and download the Inventory Health report through 2021.

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_INVENTORYAGE(A1:A100)
=GORILLA_INVENTORYAGE(A1:A100, “US”, “NEW”, ,TRUE)
=GORILLA_INVENTORYAGE(A1:A100, , , “InvAge91to180Days”)

Syntax Description
gorilla inventory age function 1 Gorilla ROIDescription:

Gets the inventory age as shown in your seller central reports.

Syntax:

GORILLA_INVENTORYAGE(sku, [marketplace], [condition], [datapoint], [header])

for Gorilla AGENCY, the syntax is

GORILLA_INVENTORYAGE(sellerID, sku, [marketplace], [condition], [datapoint], [header])

sku – REQUIRED

Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. If a datapoint is also specified in the formula, only single value or a column of skus can be provided.

marketplace – OPTIONAL

Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

condition – OPTIONAL

Return only data for specific product condition. Default is empty value for any condition type.

Valid values are: New, Used.

datapoint – OPTIONAL

Return data for specific data point. Default is empty value which will load the data for all the following data points.

  • Condition
  • InvAge0to90Days
  • InvAge91to180Days
  • InvAge181to270Days
  • InvAge271to365Days
  • InvAge365PlusDays
  • QtyToBeChargedLtsf6Mo
  • ProjectedLtsf6Mo
  • QtyToBeChargedLtsf12Mo
  • ProjectedLtsf12Mo
  • RecommendedAction
  • HealthyInventoryLevel
  • SellThrough
  • ItemVolume
  • VolumeUnits
  • StorageType
  • yourPrice
  • salesPrice
  • unitsShippedLast7Days
  • unitsShippedLast30Days
  • unitsShippedLast60Days
  • unitsShippedLast90Days
  • alert

header – OPTIONAL

Show column header when 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_INVENTORYAGE(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_INVENTORYAGE(A1:A100, “US”, “NEW”, ,TRUE)

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

=GORILLA_INVENTORYAGE(A1:A100, , , “InvAge91to180Days”)

Bulk returns a list of results for SKUs listed in A1:A100 showing how many units of each sku is aged InvAge91to180Days.

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

=GORILLA_INVENTORYAGE(“SELLER63DJ3”, A1:A100)
=GORILLA_INVENTORYAGE(“SELLER63DJ3”, A1:A100, “US”, “NEW”, ,TRUE)
=GORILLA_INVENTORYAGE(“SELLER63DJ3”, A1:A100, , , “InvAge91to180Days”)

How can we help?