Google Sheets Functions

⌘K
  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 1.Seller Central Data/Fun...
  5. 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 for a given sku or asin.

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

  • Condition
  • Working
  • Shipped
  • Receiving
  • TotalDaysOfSupply
  • Alert
  • RecommReplenishmentQty
  • RecommShipDate
  • Utilization
  • MaxShipmentQty

totaldayssupply – OPTIONAL
Return restock data with ‘Total Days of Supply’ less than or equal specified days. Valid value: numbers under 365 or ‘all’ (default).

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_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.

Tags