Google Sheets Functions

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

GORILLA_INVENTORYHIST() – Shows historical inventory levels of past dates

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

Syntax Description

INVENTORYHIST Gorilla ROI

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(Seller ID, period, sku, [marketplace], [status], [start date], [end date], [transpose])

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.

status (inventory) – OPTIONAL

  • Total (or ALL) = fulfillable + inbound_working + inbound_shipped + inbound_receiving +reserved_transfer
  • ​warehouse = fulfillable + unsellable + reserved
  • ​fulfillable (instock) – the number of units that can be fulfilled, NOT what is physically at the warehouse
  • Local_Stock​ (only available for EU marketplaces) – physical inventory in the warehouse
  • ​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
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:

🚨 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_INVENTORYHIST("TOY STORE", "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("TOY STORE", "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("TOY STORE", "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.

How can we help?