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