Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_ASINSTATUS() – Get the active or inactive status of the ASIN

GORILLA_ASINSTATUS() – Get the active or inactive status of the ASIN

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

ASINSTATUS Gorilla ROI

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.

How can we help?