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
GORILLA_INVENTORYAGE() – Get the inventory age for a given SKU or ASIN 1

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”)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?