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