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
🚨 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_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 such as title, size, weight, color and other supported attributes.
Syntax:
GORILLA_PRODUCT(Seller ID, sku, attributes, [marketplace], [system], [fulfillment])
SELLER ID – REQUIRED
Enter the Seller ID or Nickname you entered in your Gorilla account .
SKU – REQUIRED
SKU or ASIN 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…
ATTRIBUTE – REQUIRED
Product’s attribute to retrieve shown below.
Brand
Bullets
Classification
Color
isExpirationDatedProduct
IsHeatSensitive
ItemDimensions_Height_Units
ItemDimensions_Height_value
ItemDimensions_Length_Units
ItemDimensions_Length_value
ItemDimensions_Width_Units
ItemDimensions_Width_value
ItemTypeKeyword
Keywords
Language
ListPrice_Amount
ListPrice_CurrencyCode
Manufacturer
Model
PackageDimensions_Height_Units
PackageDimensions_Height_value
PackageDimensions_Length_Units
PackageDimensions_Length_value
PackageDimensions_Width_Units
PackageDimensions_Width_value
PackageDimensions_Weight_Units
PackageDimensions_Weight_value
PackageQuantity
PartNumber
ProductTypeName
RecommendedBrowseNodes
Scent
Size
Style
Title
UnitCount
VariationTheme
MARKETPLACE – OPTIONAL
Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc.
SYSTEM – OPTIONAL
Determines the measurement system to use when displaying sizes and weights. Valid values are: Imperial (DEFAULT), Metric.
FULFILLMENT – OPTIONAL
‘ALL’ shows any SKU matching the search criteria. ‘FBM’ displays fulfilled by merchant SKU’s only. ‘FBA’ displays fulfilled by Amazon SKU’s only. Default is set to ‘ALL’.
Examples:
🚨 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_PRODUCT("TOY STORE", "IPHONE7382", "Size", "US")This formula will pull the main Size of SKU IPHONE7382 from the US marketplace.
=GORILLA_PRODUCT("TOY STORE", "IPHONE7382", "PackageDimensions_Height_value", "US", "METRIC")This formula will pull the PackageDimensions_Height_value for IPHONE7382 in the US Marketplace, but in Metric system.
=GORILLA_PRODUCT("TOY STORE", "B03H39FJ32", "BULLETS")Displays the bullets from the listing for ASIN B03H39FJ32. It will grab the data from the main marketplace if no marketplace is assigned.
=GORILLA_PRODUCT("TOY STORE", A2:A10,"Title")Supports 2-dimensional ranges. Bulk returns an array of values by assigning the range of the SKU. In this example, the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.