Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_SKUSTATUS() ̵...

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.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.