Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_INVENTORY() – Get quantity and status of inventory

GORILLA_INVENTORY() – Get quantity and status of inventory

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_INVENTORY("TOY STORE", D2, "ALL", "fulfillable")
=GORILLA_INVENTORY("TOY STORE", A1:A100, "US", "​inbound_receiving")
=GORILLA_INVENTORY("TOY STORE", "B00YD545CC", "UK", "transfer")
=GORILLA_INVENTORY("TOY STORE", A2:A10, "ALL", "inbound")

Syntax Description

INVENTORY Gorilla ROI

Description:

Get inventory movement status of a product such as how many is in stock, at the warehouse, fulfillable, unsellable, transfer or inbound.

Syntax:

GORILLA_INVENTORY("TOY STORE", sku, [marketplace], [status])

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

sku – REQUIRED
SKU or ASIN of the product. Can be an array of strings like {“SKU12345”,“ASIN12345”} or a string.

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 – OPTIONAL
Supply status. Valid values are:

  • Total (or ALL) = fulfillable + inbound_working + inbound_shipped + inbound_receiving +reserved + unsellable
  • ​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.

Check inventory values in UK marketplace

What you will see when using this is how Amazon provides inventory numbers across marketplaces.

For example, if you have 100 units in Germany, it is technically available in DE, UK, ES, FR, IT.

So Amazon enters your inventory as 100×5 = 500 inventory available.

So to get the number you want only for Germany, you have to enter the formula to be specific for the marketplace.

=GORILLA_INVENTORY("TOY STORE", ASIN,"DE","inbound_shipped")

In any spreadsheet, try

=GORILLA_INVENTORY("TOY STORE", ASIN123123,"DE","fulfillable")
=GORILLA_INVENTORY("TOY STORE", ASIN321321,"DE","researching")
=GORILLA_INVENTORY("TOY STORE", ASIN567856,"DE","​reserved_processing")

And you will see the numbers for each marketplace.

GORILLA_INVENTORY Attributes:

  • Total (or ALL) = fulfillable + inbound_working + inbound_shipped + inbound_receiving +reserved + unsellable
  • ​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.

FBA inventory report definitions

See seller central for their definitions.

Additional information on reserved quantities

Reserved QuantityreservedThe total number of units in reserved status.
Reserved – Customer Orderreserved_ordersThe number of units reserved for customer orders.
Reserved – FC Transferreserved_transferThe number of units being transferred from one fulfillment center to another.
Reserved – FC Processingreserved_processingThe number of units that have been sidelined at the fulfillment center for additional processing.

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_INVENTORY("TOY STORE", D2, "ALL", "instock")

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

=GORILLA_INVENTORY("TOY STORE", "B00YD545CC", "UK", "transfer")

Gets the total number of units for ASIN B00YD545CC that are in transfer status for Italy marketplace.

=GORILLA_INVENTORY("TOY STORE", A2:A10, "ALL", "inbound")

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 A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

INVENTORY.2 Gorilla ROI

How can we help?