Article Summary (TL;DR)
✅ ASINSTATUS() function introduced to quickly determine listing activity status.
✅ GORILLA_ASINSTATUS() aids in identifying and addressing inactive ASINs or SKUs without relying solely on Amazon notifications.
✅ Consistent documentation updates across various platforms for easy reference.
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.
- Official page of all the functions we support
- Google Docs version
- Website documentation for easier navigation
- On any Google sheet > menu > addons > Gorilla > 2.See Supported Functions and examples
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.
![ASINSTATUS shows if your ASIN is active or inactive 2 asin status manage inventory seller central Gorilla ROI](https://gorillaroi.b-cdn.net/wp-content/uploads/asin-status-manage-inventory-seller-central.webp)
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
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)
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.
![ASINSTATUS shows if your ASIN is active or inactive 5 Basic product tracking template idea to stay on top of your listings and know when something is active or inactive.](https://gorillaroi.b-cdn.net/wp-content/uploads/product-tracking-template-asin-status-active-inactive-results.webp)
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
Related Posts
![Shopify eBay Integration for Busy Sellers: Sell Like Crazy Across 2 Channels 11 shopify ebay integration](https://gorillaroi.b-cdn.net/wp-content/uploads/shopify-ebay-integration.jpg)
Shopify eBay Integration for Busy Sellers: Sell Like Crazy Across 2 Channels
Using an omnichannel sales strategy can help your business reach…
![Understanding Shopify COGS: A Comprehensive Guide for Business Owners 12 Understanding Shopify COGS: A Comprehensive Guide for Business Owners](https://gorillaroi.b-cdn.net/wp-content/uploads/shopify-COGS.jpg)
Understanding Shopify COGS: A Comprehensive Guide for Business Owners
Knowing your Cost of Goods Sold, or COGS, is essential…
![Boost Sales With Shopify Automation - BONUS: Our 3 Best Shopify Automation Apps 13 Boost Sales With Shopify Automation – BONUS: Our 3 Best Shopify Automation Apps](https://gorillaroi.b-cdn.net/wp-content/uploads/GROI-YT-Thumbnail-10.jpg.webp)
Boost Sales With Shopify Automation – BONUS: Our 3 Best Shopify Automation Apps
Being an e-commerce company, in particular, means that you have…
Leave a Reply