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("TOY STORE", A1:A100)=GORILLA_INVENTORYHEALTH("TOY STORE", A1:A100, , , , , TRUE)=GORILLA_INVENTORYHEALTH("TOY STORE", A1:A100, "US", "NEW", "sales-rank", TRUE)Syntax Description
Description:
Get inventory health data for a given sku or asin.
Syntax:
GORILLA_INVENTORYHEALTH(Seller ID, sku, [marketplace], [condition], [datapoint], [header])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
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, BE, 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 points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points. Other Valid values are:
snapshot-date
product-name
condition
available
pending-removal-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
currency
qty-to-be-charged-ltsf-6-mo
projected-ltsf-6-mo
alert
your-price
sales-price
lowest-price-new-plus-shipping
lowest-price-used
recommended-action
healthy-inventory-level
fba-minimum-inventory-level
fba-inventory-level-health-status
recommended-sales-price
recommended-sale-duration-days
recommended-removal-quantity
recommended-ship-in-quantity
recommended-ship-in-date
estimated-cost-savings-of-recommended-actions
sell-through
item-volume
volume-unit-measurement
storage-type
storage-volume
marketplace
product-group
sales-rank
days-of-supply
historical-days-of-supply
estimated-excess-quantity
weeks-of-cover-t30
weeks-of-cover-t90
featuredoffer-price
inv-age-0-to-30-days
inv-age-31-to-60-days
inv-age-61-to-90-days
inv-age-181-to-330-days
inv-age-331-to-365-days
estimated-storage-cost-next-month
inbound-quantity
inbound-working
inbound-shipped
inbound-received
quantity-to-be-charged-ais-181-210-days
estimated-ais-181-210-days
quantity-to-be-charged-ais-211-240-days
estimated-ais-211-240-days
quantity-to-be-charged-ais-241-270-days
estimated-ais-241-270-days
quantity-to-be-charged-ais-271-300-days
estimated-ais-271-300-days
quantity-to-be-charged-ais-301-330-days
estimated-ais-301-330-days
quantity-to-be-charged-ais-331-365-days
estimated-ais-331-365-days
quantity-to-be-charged-ais-365-PLUS-days
estimated-ais-365-plus-days
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("TOY STORE", 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("TOY STORE", 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("TOY STORE", 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