Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INVENTORYRESTOCK() – Get inventory restock data based on the restock reports

GORILLA_INVENTORYRESTOCK() – Get inventory restock data based on the restock reports

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

GORILLA INVENTORYRESTOCK 1 Gorilla ROI

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.

How can we help?