ASINSTATUS shows if your ASIN is active or inactive

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
see supported functions gorillaroi Gorilla ROI

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 manage inventory seller central Gorilla ROI

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.

Comments

Leave a Reply

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

Related Posts

Ready to unlock the power of your Amazon data?

Automatically sync your Amazon data to Google Sheets 24/7.
Reduce operating costs, scale easier and work smarter.