GORILLA_SALESCOUNTHIST() – Gets the historical number of units ordered between any period.

Sample Usage =GORILLA_SALESCOUNTHIST(“TOY STORE”) =GORILLA_SALESCOUNTHIST(“TOY STORE”, “B00YD545CC”) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A20) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60, , ,”YES”) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A10, “DE”, “CANCELED”, “EXCLUDE”, , “2022-01-01”, “2022-03-15”) Syntax Description Description: Gets the historical number of units ordered between any period. Syntax: GORILLA_SALESCOUNTHIST(Seller ID, [sku], [marketplace], [status], [mcf],…

GORILLA_SALESCOUNT() – Gets the quantity of orders sold between any period

Sample Usage =GORILLA_SALESCOUNT(“TOY STORE”, “Custom”, “US”, “B00YD545CC”, “Shipped”, “NO”, “2021-01-01”, “2021-01-21”) =GORILLA_SALESCOUNT(“TOY STORE”, “This Week”,”ALL”,A2:A10,”ALL”) =GORILLA_SALESCOUNT(“TOY STORE”, “This Month”, “ALL”, “IPHN3724”, “Canceled”) =GORILLA_SALESCOUNT(“TOY STORE”, “Same Day Last Month”, “ALL”, “IPHN3724”, “ALL”) =GORILLA_SALESCOUNT(“TOY STORE”, “This Year”) Syntax Description: Description: Gets the quantity of orders sold between any period. Syntax: GORILLA_SALESCOUNT(Seller ID, period, [marketplace], [sku], [status], [mcf],…

GORILLA_REMOVALSDETAILS() – Get details from Removal Orders.

Sample Usage =GORILLA_REMOVALSDETAILS(“TOY STORE”, “LAST YEAR”) =GORILLA_REMOVALSDETAILS(“TOY STORE”, “LAST YEAR”, “B10K320E35”) =GORILLA_REMOVALSDETAILS(“TOY STORE”, “LAST MONTH”, “B10K320E35”) Syntax Description Description: Get details from Removal Orders. Syntax: GORILLA_REMOVALSDETAILS(sellerId, period, [filter], [marketplace], [orderid], [type], [status], [disposition], [datapoint], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. Period –…

GORILLA_REFUNDSORDER() – Display orders that were refunded across any time period

Sample Usage =GORILLA_REFUNDSORDER(“TOY STORE”, “LAST 30 DAYS”) =GORILLA_REFUNDSORDER(“TOY STORE”, “THIS MONTH” ,”SKU111,SKU222,SKU333″, “DE”) =GORILLA_REFUNDSORDER(“TOY STORE”, “THIS MONTH” , A1:A34, “DE”) =GORILLA_REFUNDSORDER(“TOY STORE”, “CUSTOM”, A2:A34, “FR”, “ALL”, “2022-01-01”, “2022-01-15”) Syntax description Description: Gets the list of all orders that were refunded. Filter by SKU to track your refunded order IDs. This is a dump of the…

GORILLA_ORDERSCOUNT() – Get the number of orders sold between any time period

Sample Usage =GORILLA_ORDERSCOUNT(“TOY STORE”, “LAST WEEK”, “US”, $A$3:$A$10, “SHIPPED”, “EXCLUDE”) =GORILLA_ORDERSCOUNT(“TOY STORE”, “LAST WEEK”) Syntax Description Description: Get number of orders for any product for any specified time period. Only the period attribute is required. Other attributes are optional. Syntax: =GORILLA_ORDERSCOUNT(Seller ID, period, [marketplace], [sku], [status], [mcf], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller…

GORILLA_ORDERSCOUNTHIST() – Get daily historical orders sold

Sample Usage =GORILLA_ORDERSCOUNTHIST(“TOY STORE”) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, “B00YD545CC”) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A20) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60, , ,”Yes”) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2022-01-01”, “2022-03-12”) Syntax Description Description: Get number of orders history for a given period or number of days going back. =GORILLA_ORDERSCOUNTHIST(Seller ID,…

GORILLA_PROFITLOSSORDERS() – See the profit per orders

Sample Usage =GORILLA_PROFITLOSSORDERS(“MyShoeStore”, “last 7 days”) =GORILLA_PROFITLOSSORDERS(“MyShoeStore”, “last month”, “IPHONE10SYX”) =GORILLA_PROFITLOSSORDERS(“MyShoeStore”, “yesterday”, , , “SHIPPED”) Syntax Description Description: Get the profit of each order. Like the manageorder() function, but other fees such as commission and FBA fees are included to calculate the profit per order. WARNING: For large sellers, do NOT use this function for…

GORILLA_MANAGEORDER() – Get list of orders and order details for SKU or ASIN

Sample Usage =GORILLA_MANAGEORDER(“TOY STORE”, “last 7 days”) =GORILLA_MANAGEORDER(“TOY STORE”, “last month”, “U378-JEKD-423D”, “US”) =GORILLA_MANAGEORDER(“TOY STORE”, “last 30 days”,C49,”US”,”SHIPPED”) =GORILLA_MANAGEORDER(“TOY STORE”, “custom”, , “US”, “canceled”, “2020-09-01”, “2020-09-15”) Syntax Description Description: Get the detailed list of orders and the order details for a SKU or ASIN. ManageOrder is a dump of the order IDs where the sales…