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_INVENTORYRESTOCK("TOY STORE", A1:A100, "US", , , ,TRUE)
=GORILLA_INVENTORYRESTOCK("TOY STORE", A1:A100)
=GORILLA_INVENTORYRESTOCK("TOY STORE", A1:A100, "US", "NEW", "MaxShipmentQTY")
Syntax Description

Description:
Get inventory restock data based on the restock report for a list of SKUs or ASINs
Syntax:
GORILLA_INVENTORYRESTOCK(Seller ID, sku, [marketplace], [condition], [datapoint], [totaldayssupply], [header])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
sku – REQUIRED
SKU or ASIN. Select or enter a range of values.
marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.
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
Data points supported by the function. Default value is an empty value. This will return all the data points.
- Condition
- DaysOfSupply
- Alert
- RecommReplenishmentQty
- RecommShipDate
- CurrMonthMaxInvThreshold
- Utilization
- MaxShipmentQty
totaldayssupply – OPTIONAL
Default is set to “ALL”.
Returns restock data with ‘Total Days of Supply’ less than or equal specified days. Valid value: numbers under 365 or all (default).
header – OPTIONAL
default is set to “FALSE”.
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_INVENTORYRESTOCK("TOY STORE", A1:A100, "US", , , ,TRUE)
Returns the full restock report for the SKUs or ASINs listed in A1:A100 for the US market.
The TRUE parameter generates a table header.
=GORILLA_INVENTORYRESTOCK("TOY STORE", A1:A100)
The simplest form where the SKUs or ASINs are listed in A1:A100. This will display the full table with all the data points. No table header is generated. Only the raw data.
=GORILLA_INVENTORYRESTOCK("TOY STORE", A1:A100, "US", "NEW", "MaxShipmentQTY")
This loads the data only for “MaxShipmentQTY” for the SKUs in A1:A100. Enter the datapoint manually to define which datapoint you wish to see.