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

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.