GORILLA_INVENTORYAWD() – Get inventory data from AWD for given sku
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_INVENTORYAWD("TOY STORE", D2, "ALL")=GORILLA_INVENTORYAWD("TOY STORE", A1:A100, "ALL" ,"AvailableDistributableQty")=GORILLA_INVENTORYAWD("TOY STORE", "B00YD545CC", , "ReservedDistributableQty")=GORILLA_INVENTORYAWD("TOY STORE", A2:A10, "ALL", "TotalInboundQty", "True")
Syntax Description
Description:
Get inventory data from AWD for given sku
Syntax:
GORILLA_INVENTORYAWD(sellerID, sku, [available], [datapoint], [header])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
SKU – REQUIRED
SKU 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... If datapoint is also specified, only single sku or a column of skus can be provided.
DATAPOINT – OPTIONAL
Return data for specific data points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points. Other Valid values are: 'AvailableDistributableQty', 'ReservedDistributableQty', 'TotalInboundQty', 'TotalOnhandQty', 'ReplenishmentQuantity', 'Expiration', 'ExpOnhandQty', and 'updateDate'.
HEADER – OPTIONAL
Show column header when data point is not specified, TRUE to show header, FALSE (default) to not show it.
Screenshot:
Examples:
=GORILLA_INVENTORYAWD("TOY STORE", A2:A10,)Get a complete(dump) data for all data points related to the SKUs listed in the range A2:A10.
=GORILLA_INVENTORYAWD("TOY STORE", "SKU2345", "ALL", "AvailableDistributableQty")Gets the total number of units for SKU 'SKU2345' that are Available in Distributable Qty