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_ASINSTATUS("TECH SHOP", "US", A2:B100)
=GORILLA_ASINSTATUS("TECH SHOP", , A2:A1000)
Syntax description
Description:
Returns the status of the ASIN whether it is active or inactive.
Syntax:
GORILLA_ASINSTATUS(Seller ID, [marketplace], ASIN/SKU)
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
MARKETPLACE – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.
ASIN/SKU – REQUIRED
The ASINs or SKUs to get the status of.
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_ASINSTATUS("TECH SHOP", "US", A2:B100)
This will return “active” or “inactive” for all the ASINs or SKUs listed from A2 to B100 for the US marketplace. The function supports 2D arrays such as a set of values in column A and column B.
=GORILLA_ASINSTATUS("TECH SHOP", , A1:A1000)
If the marketplace is left out, it will get the listing status of the ASIN/SKUs from the default marketplace associated with your account. Use ranges in your formula to get the results in bulk.