Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. GORILLA_INVENTORYHIST() –...

GORILLA_INVENTORYHIST() – Show inventory history of products.

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 1 Gorilla ROI

Description:

Show inventory history of products.

Syntax:

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

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

Period– REQUIRED
Predefined period to get inventory or use ‘custom’ to specify a start and end date.

SKU – REQUIRED
SKU or ASIN to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123…

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, EG, SA. Use ‘ALL’ to combine values from a single account, ‘EU’ for all Europe markets EXCEPT UK, ‘EURO’ to combine countries using EURO currency. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.

status – OPTIONAL
Supply status. If only one skus is selected it can be a range of values like A1:E1 where A1 to E1 consists of different supply status values. Default is empty value for Total status. Valid values are:

  • 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
  • Detailed

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

start_date
Starting date for the returning range when period is ‘custom’.

end_date – OPTIONAL
Ending date for the returning range when period is ‘custom’.

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.

header – OPTIONAL
Include a header line for the status when multiple selected. Possible values: TRUE/FALSE. Default: FALSE

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.