Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INVENTORYHIST() – Shows historical inventory levels of past dates

GORILLA_INVENTORYHIST() – Shows historical inventory levels of past dates

Sample Usage

=GORILLA_INVENTORYHIST("last 14 days", D2, "US", "instock")
=GORILLA_INVENTORYHIST("SELLER ID", "last 3 months", "B00YD545CC", "UK", "transfer")
=GORILLA_INVENTORYHIST("SELLER ID", "custom", A1:A10, "ALL", "inbound", "2019-12-01", "2019-12-12)

Syntax Description

Shows historical inventory levels of past dates. Works like GORILLA_INVENTORY. Only works on going-forward basis. Historical data before using Gorilla ROI cannot be retrieved.

GORILLA_INVENTORYHIST(period, sku, [marketplace], [status], [start date], [end date])

For Gorilla Agency, the syntax is

GORILLA_INVENTORYHIST(sellerID, period, sku, [marketplace], [status], [start date], [end date])

Examples:

=GORILLA_INVENTORYHIST("last 14 days", D2, "US", "instock")

Uses the ASIN or SKU entered in cell D2 and shows the total number of instock units over the last 14 days in the US marketplace.

=GORILLA_INVENTORYHIST("last 3 months", "B00YD545CC", "UK", "transfer")

Displays in a list, the transfer inventory for each day of the last 3 months for ASIN B00YD545CC from the UK marketplace.

=GORILLA_INVENTORYHIST("custom", A1:A10, "ALL", "inbound", "2019-12-01", "2019-12-12")

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A1:A10 and returns all values at once.

inventory_history
inventory_history_array

For Gorilla Agency, the formulas will start with the seller ID:

=GORILLA_INVENTORYHIST("SELLER ID", "last 14 days", D2, "US", "instock")
=GORILLA_INVENTORYHIST("SELLER ID", "last 3 months", "B00YD545CC", "UK", "transfer")
=GORILLA_INVENTORYHIST("SELLER ID", "custom", A1:A10, "ALL", "inbound", "2019-12-01", "2019-12-12)

GORILLA_Inventory Attributes

    • All
    • InStock
    • Inbound
    • Transfer

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?