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

Syntax description

SKUSTATUS Gorilla ROI

Description:

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

Syntax:

GORILLA_SKUSTATUS(Seller ID, [marketplace], sku)

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.

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("TOY STORE", "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("TOY STORE", , 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.

How can we help?