Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 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("US", A2:B100)
=GORILLA_ASINSTATUS( , A1:A1000)

Syntax description

asinstatus function menu 1 Gorilla ROI

Description:

Returns the status of the ASIN whether it is active or inactive.

Syntax:

GORILLA_ASINSTATUS([marketplace], ASIN/SKU)

for Gorilla AGENCY, the syntax is

GORILLA_ASINLIST(sellerID, [marketplace], ASIN/SKU)

MARKETPLACE

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

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("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( , 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.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_ASINSTATUS("SELLER ID", "US", A2:B100)
=GORILLA_ASINSTATUS("SELLER ID", A1:A1000)

How can we help?