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

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

Syntax description

GORILLA_ASINSTATUS() - Get the active or inactive status of the ASIN 1

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

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 closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google 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)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?