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", "fulfillable")
=GORILLA_INVENTORYHIST("last 3 months", "B00YD545CC", "UK", "transfer")
=GORILLA_INVENTORYHIST("custom", A1:A10, "ALL", "inbound", "2019-12-01", "2019-12-12", "yes")

Syntax Description

GORILLA_INVENTORYHIST() – Shows historical inventory levels of past dates 1

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.

Syntax:

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

For Gorilla Agency, the syntax is

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

GORILLA_INVENTORY Attributes:

  • Total (or ALL) = fulfillable + inbound_working + inbound_shipped + inbound_receiving +reserved_transfer
  • warehouse = fulfillable + unsellable + reserved
  • fulfillable (instock)
  • Local_Stock​ (only available for EU marketplaces)
  • unsellable
  • reserved = reserved_orders + reserved_transfer + reserved_processing​
  • ​inbound_working
  • inbound_shipped (or “inbound”)
  • ​inbound_receiving
  • researching
  • reserved_orders
  • reserved_transfer (or “transfer”)
  • reserved_processing

Refer to the seller central page for more details on the manage FBA inventory report.

sku

OPTIONAL – 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. or Amazon Marketplace ID like ATVPDKIKX0DER.

status (inventory)

OPTIONAL

  • Total (or ALL) = fulfillable + inbound_working + inbound_shipped + inbound_receiving +reserved_transfer
  • warehouse = fulfillable + unsellable + reserved
  • fulfillable (instock)
  • Local_Stock​ (only available for EU marketplaces)
  • unsellable
  • reserved = reserved_orders + reserved_transfer + reserved_processing​
  • ​inbound_working
  • inbound_shipped (or “inbound”)
  • ​inbound_receiving
  • researching
  • reserved_orders
  • reserved_transfer (or “transfer”)
  • reserved_processing

Refer to the seller central page for more details on the manage FBA inventory report.

start_date

OPTIONAL – Only works if “days” is left blank.
Starting date to get sales between any two periods. Date format should be in YYYY-MM-DD.

end_date

OPTIONAL – Only works if “days” is left blank.
End date to get sales between any two periods. Date format should be in YYYY-MM-DD.

transpose

OPTIONAL – default is set to “YES”.
It will display the SKUs on the left side and the dates horizontally.
“NO” will display the SKUs in a horizontal row at the time. Dates vertically down.

Examples:

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

Uses the ASIN or SKU entered in cell D2 and shows the total number of fulfillable units across all marketplaces.

=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", "yes")

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.

Using the “yes” parameter to transpose will list the SKUs in a vertical column and the values going horizontal.

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

=GORILLA_INVENTORYHIST(“SELLER ID”, “last 14 days”, D2, “US”, “reserved”)
=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, “yes”)

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?