GORILLA_BUYBOXPRICE() – Get the current winning buy box price

Sample Usage =GORILLA_BUYBOXPRICE(“TOY STORE”, “B00YD545CC”, “DEFAULT”, “NEW”, “FULL”) Syntax description Description: Get the current buy box price of the seller winning the buy box. Syntax: GORILLA_BUYBOXPRICE(Seller ID, sku, [marketplace], [condition], [returnStyle], [priceType]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN of the product….

GORILLA_BUYBOXSELLERS() – Show the number of sellers competing for buybox for a given product.

Sample Usage =GORILLA_BUYBOXSELLERS(“TOY STORE”, A1:A1000, “US”) =GORILLA_BUYBOXSELLERS(“TOY STORE”, “B00YD545CC”) =GORILLA_BUYBOXSELLERS(“TOY STORE”, A1:A1000, “FR”) Syntax description Description: Show the number of sellers competing for buybox for a given product. Syntax: GORILLA_BUYBOXSELLERS(Seller ID, sku, [marketplace]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN of the…

GORILLA_BUYBOXWINNERFULL() – Show the Buy Box winner details for the selected products.

Sample Usage =GORILLA_BUYBOXWINNERFULL(“TOY STORE”, A1:A1000, “US”) =GORILLA_BUYBOXWINNERFULL(“TOY STORE”, “B00YD545CC”) =GORILLA_BUYBOXWINNERFULL(“TOY STORE”, A1:A1000) Syntax description Description: Show the Buy Box winner details for the selected products. Syntax: GORILLA_BUYBOXWINNER(Seller ID, sku, [marketplace], [header], [transpose]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN of the product….

GORILLA_BUYBOXWINNER() – See if you are winning the buy box

Sample Usage =GORILLA_BUYBOXWINNER(“TOY STORE”, A1:A1000, “US”) =GORILLA_BUYBOXWINNER(“TOY STORE”, “B00YD545CC”) =GORILLA_BUYBOXWINNER(“TOY STORE”, A1:A1000) Syntax description Description: Returns “winner” or “loser” based on whether you are winning or losing the buy box. Syntax: GORILLA_BUYBOXWINNER(Seller ID, sku, [marketplace]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN…

GORILLA_BIZPERFORMANCE() – Percentage your offer is featured in the buy box

Sample Usage =GORILLA_BIZPERFORMANCE(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, , “2023-12-01”, “2023-12-21”) =GORILLA_BIZPERFORMANCE(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, 21) =GORILLA_BIZPERFORMANCE(“TOY STORE”, “This Week”, A2:A10, “US”, , “ALL”) =GORILLA_BIZPERFORMANCE(“TOY STORE”, “This Month”, “IPHN3724”, , , “BuyBoxPercentage”) =GORILLA_BIZPERFORMANCE(“TOY STORE”, “Same Day Last Month”, “IPHN3724”, “US”) =GORILLA_BIZPERFORMANCE(“TOY STORE”, “This Year”) Screenshot of output Syntax Description: Description: Percentage…

GORILLA_BUYBOXOFFERS() – Get list of sellers competing for the buy box

Sample Usage =GORILLA_BUYBOXOFFERS(“TOY STORE”, “B00YD545CC”, “US”, “TRUE”) =GORILLA_BUYBOXOFFERS(“TOY STORE”, “B00YD545CC”, “DE”, “FALSE”) =GORILLA_BUYBOXOFFERS(“TOY STORE”, “B00YD545CC”) Syntax description Description: Get the list of all sellers and offerings on the listing and competing for the buy box. Does not pull information for SKUs that you do not sell. Only works for SKUs and ASINs in your inventory….