Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SKUSTATUS() – Get the active or inactive status of the SKU

GORILLA_SKUSTATUS() – Get the active or inactive status of the SKU

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_SKUSTATUS("US", A2:B100)
=GORILLA_SKUSTATUS( , A1:A1000)

Syntax description

sku status function Gorilla ROI

Description:

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

Syntax:

GORILLA_SKUSTATUS([marketplace], ASIN/SKU)

for Gorilla AGENCY, the syntax is

GORILLA_SKUSTATUS(seller name, [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.

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_SKUSTATUS("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_SKUSTATUS( , 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_SKUSTATUS("SELLER ID", "US", A2:B100)
=GORILLA_SKUSTATUS("SELLER ID", A1:A1000)

How can we help?