ASINSTATUS shows if your ASIN is active or inactive

written by GORILLA ROI

A new function has been released: ASINSTATUS() will quickly and easily show you whether your listing is currently active or inactive.

As always, we update documentation consistently and in multiple locations to make it easy to find.

  1. Official page of all the functions we support
  2. Google Docs version
  3. Website documentation for easier navigation
  4. On any Google sheet > menu > addons > Gorilla > 2.See Supported Functions and examples

ASINSTATUS shows if your ASIN is active or inactive 1

Find out if your ASIN(s) or SKU(s) are active or inactive

In seller central, you can easily filter and see which ASIN or SKU are active or inactive.

ASIN status from <a href=

But what happens if one of your ASINs suddenly get deactivated and become inactive?

Amazon does not always send you a notification or email unless it was due to a Negative Customer Experience (NCX) or performance shut down.

If your item goes out of stock or a keyword or review triggers a red flag and your ASIN becomes suppressed, it is up to you to find out and address it.

This is where GORILLA_ASINSTATUS() will help.

How to use ASINSTATUS

Find the status of your ASIN. Returns "active" or "inactive".
Find the status of your ASIN. Returns “active” or “inactive”.

Easiest example:

=GORILLA_ASINSTATUS("US", A1:A100)

This simple example will display “active” or “inactive” for each of the SKUs or ASINs listed from A1 to A100 for the US marketplace.

If no marketplace is entered, it will use your default marketplace.

=GORILLA_ASINSTATUS( , A1:A100)

asin status active inactive results

Best use case to stay on top of your listings

The best and easiest way is to add it to a column where you list your entire product list.

We maintain a separate product list with SKU, ASIN, FNSKU, Title, Image and the required basics that you find inside the manage inventory section of Seller Central.

This ASINSTATUS() function can now go right alongside it.

Here’s an example.

Basic product tracking template idea to stay on top of your listings and know when something is active or inactive.
Basic product tracking template idea to stay on top of your listings and know when something is active or inactive.

A very easy, but convenient and powerful way to stay on top of your listings and operations directly within Google Sheets.

To see other functions and examples, visit the functions page for all the features we support.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

5 × 3 =