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

Sample Usage

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

Syntax Description

Description:

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:A100) in your formula wherever possible for quicker results and to prevent Google 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?