GORILLA_MYPRICE()

Description:
Get the lowest seller price for the SKU or ASIN.

Syntax:
GORILLA_MYPRICE(sku, [marketplace], [condition], [subcondition], [priceType])

Examples:

=GORILLA_MYPRICE(D2)
Uses the ASIN or SKU entered in cell D2 and shows price being offered by the seller.

=GORILLA_MYPRICE("B03H39FJ32", "US", "New", "mint", "ListingPrice")
Filtering formula to get the price of ASIN B03H39FJ32 that is sold in the US, in new and mint condition. Returns the listing price.

=GORILLA_INVENTORY(A2:C10)
Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

GORILLA_MYPRICE Attributes

Condition Attributes:

• New
• Used
• Collectible
• Refurbished
• Club

SubCondition Attributes:

• Mint
• Very Good
• Good
• Acceptable
• Poor
• Club
• OEM
• Warranty
• Refurbished Warranty
• Refurbished
• Open Box
• Other

priceType Attributes:

• LandedPrice
• ListingPrice
• ShippingPrice
• RegularPrice