GORILLA_REVIEW() – Get full review details of a product

Sample Usage =GORILLA_REVIEW(“TOY STORE”, “B00YD545CC”, “US”, 5) =GORILLA_REVIEW(“TOY STORE”, A2:A10) Syntax Description Description: Get the full reviews and details of a product based on SKU or ASIN. Only works for single marketplaces at a time. Not “ALL”. Syntax GORILLA_REVIEW(Seller ID, sku, [marketplace], [count]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in…

GORILLA_REVIEWCOUNT() – Get number of reviews of a product

Sample Usage =GORILLA_REVIEWCOUNT(“TOY STORE”, “B00YD545CC”, “CA”) =GORILLA_REVIEWCOUNT(“TOY STORE”, A2:A10) Syntax Description Description: Get the number of reviews for a given product based on SKU or ASIN. Only works for single marketplaces at a time. Not “ALL”. Syntax: GORILLA_REVIEWCOUNT(Seller ID, sku, [marketplace]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla…

GORILLA_REVIEWSFILTER() – Get number of reviews between any time period

Sample Usage =GORILLA_REVIEWSFILTER(“TOY STORE”, “Custom”, “US”, “B00YD545CC”, “5”, “2021-01-01”, “2021-01-21”) =GORILLA_REVIEWSFILTER(“TOY STORE”, “This Week”,”ALL”,A2:A10,”ALL”) Syntax Description Description: Show reviews count for products. Syntax: GORILLA_REVIEWSFILTER(Seller ID, period, [marketplace], [sku], [stars], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. period – REQUIREDPredefined period to get reviews or use…

GORILLA_RANKING() – Get BSR for products

Sample Usage =GORILLA_RANKING(“TOY STORE”, “B00YD545CC”, “US”, “top”, “r_cat”) =GORILLA_RANKING(“TOY STORE”, “A2:A10”, , “top”, “rank”) Syntax Description Description: Get Best Sellers Rank (BSR) for the broadest top level category or deepest child category. Only works for single marketplaces at a time. Not “ALL”. Syntax GORILLA_RANKING(Seller ID, sku, [marketplace], [queryType], [returnStyle]) Seller ID – REQUIREDEnter the seller…

GORILLA_RATINGS() – Get average review rating for product

Sample Usage =GORILLA_RATINGS(“TOY STORE”, “B00YD545CC”, “CA”) =GORILLA_RATINGS(“TOY STORE”, A2:A10) Syntax description Description: Get the average review rating of a product. Only works for single marketplaces at a time. Not “ALL”. Syntax: GORILLA_RATINGS(Seller ID, sku, [marketplace]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN…

GORILLA_RATINGSCOUNT() – Get number of ratings for product

Sample Usage =GORILLA_RATINGSCOUNT(“TOY STORE”, “B00YD545CC”, “CA”) =GORILLA_RATINGSCOUNT(“TOY STORE”, A2:A10) Syntax Description Description: Get the total number of ratings of a product. Includes local and global ratings. Syntax: GORILLA_RATINGSCOUNT(Seller ID, sku, [marketplace]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN to filter the results….

GORILLA_RANKHIST() – Get historical BSR for products

Sample Usage =GORILLA_RANKHIST(“TOY STORE”, “last 30 days”, A2:A100) =GORILLA_RANKHIST(“TOY STORE”, “custom”, A2:A5, “US”, “top”, “2022-06-01”, “2022-06-30”) =GORILLA_RANKHIST(“TOY STORE”, “this month”, “B00YD545CC”, “JP”, “child”) Syntax Description Description: Get the daily historical BSR (Best Seller Rank) over any time period for a single or range of sku’s. Only works for single marketplaces at a time. Not “ALL”….

GORILLA_PRODIDCONV() – Convert between any product ID to another product ID in the Amazon system

Sample Usage =GORILLA_PRODIDCONV($A$1, $D$5:$D$20) =GORILLA_PRODIDCONV(“MY TOY STORE”, “GR-LE-JA”) =GORILLA_PRODIDCONV(“MY TOY STORE”, “B0722TZNZZ”, “asin2upc”) =GORILLA_PRODIDCONV(“MY TOY STORE”, “X001BAWNEZ”, “FNSKU2SKU”, “US”, “FBA”) Syntax Description Description: Convert between any product ID to another product ID in the Amazon system. Syntax: GORILLA_PRODIDCONV(sellerId, sku, [type], [marketplace], [fulfillment]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_PRODUCT() – Get product info such as title, brand, weight, color

As explained in the tutorial video, the GORILLA_PRODUCT() function did not include a ‘fulfillment’ filter back then. We have now added this filter, allowing you to easily retrieve fulfillment status (FBA/FBM) information Sample Usage =GORILLA_PRODUCT(“TOY STORE”, “IPHONE7382”, “Size”, “US”) =GORILLA_PRODUCT(“TOY STORE”, “IPHONE7382”, “PackageDimensions_Height_value”, “US”, “METRIC”) =GORILLA_PRODUCT(“TOY STORE”, “B03H39FJ32”, “Scent”) Syntax Description Description: Get product information…

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…