GORILLA_INVENTORY() – Get quantity and status of inventory

Sample Usage =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 Description: Get inventory data, quantities and status. Syntax: GORILLA_INVENTORY(sellerID, sku, [marketplace], [status], [fulfillment], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU…

GORILLA_INVENTORYHEALTH() – Get detailed inventory metrics

INVENTORY HEALTH is now replacing INVENTORY AGE.Amazon is discontinuing the INVENTORY AGE report. Once discontinued, we will be removing it from our system also. Sample Usage =GORILLA_INVENTORYHEALTH(“TOY STORE”, A1:A100) =GORILLA_INVENTORYHEALTH(“TOY STORE”, A1:A100, , , , , TRUE) =GORILLA_INVENTORYHEALTH(“TOY STORE”, A1:A100, “US”, “NEW”, “sales-rank”, TRUE) Syntax Description Description: Get inventory health data for a given sku…

GORILLA_INVENTORYHIST() – Show inventory history of products.

Sample Usage =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: Show inventory history of products. Syntax: GORILLA_INVENTORYHIST(Seller ID, period, sku, [marketplace], [status], [start date], [end date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID…

GORILLA_INVENTORYLEDGER() – Dump end-to-end inventory reconciliation capability

Sample Usage =GORILLA_INVENTORYLEDGER(“TOY STORE”, “THIS MONTH”) =GORILLA_INVENTORYLEDGER(“TOY STORE”, “THIS MONTH”, “A1:A274”) =GORILLA_INVENTORYLEDGER(“TOY STORE”, “THIS MONTH”, “A1:A274”, “US”) Syntax Description Description: Dump end-to-end inventory reconciliation capability. Syntax: GORILLA_INVENTORYLEDGER(sellerID, period, [filter], [marketplace], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – REQUIREDPredefined period to get data or use…

GORILLA_INVENTORYRECEIVED() – Get inventory received and check shipment data

Sample Usage =GORILLA_INVENTORYRECEIVED(“TOY STORE”, “THIS YEAR”) =GORILLA_INVENTORYRECEIVED(“TOY STORE”, “THIS MONTH”, , , “MX”,”ALL”) =GORILLA_INVENTORYRECEIVED(“TOY STORE”, “custom”, “SKU12345”, “FBA12XYZ34”, “US”, “Missing”, “2021-01-01”, “2021-02-01”) Syntax Description Description: Get inventory received and check shipment data Syntax: GORILLA_INVENTORYRECEIVED(Seller ID, period, [filter], [shipmentid], [center], [received], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_INVENTORYRESTOCK() – Get inventory restock data based on the restock reports

Sample Usage =GORILLA_INVENTORYRESTOCK(“TOY STORE”, A1:A100, “US”, , , ,TRUE) =GORILLA_INVENTORYRESTOCK(“TOY STORE”, A1:A100) =GORILLA_INVENTORYRESTOCK(“TOY STORE”, A1:A100, “US”, “NEW”, “MaxShipmentQTY”) Syntax Description Description: Get inventory restock data for a given sku or asin. Syntax: GORILLA_INVENTORYRESTOCK(Seller ID, sku, [marketplace], [condition], [datapoint], [totaldayssupply], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account….