Google Sheets Functions

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

GORILLA_ISFBA() – Check if a SKU or ASIN is FBA or FBM or both

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_ISFBA("TOY STORE", D2)
=GORILLA_ISFBA("TOY STORE", A1:A1000, "US")
=GORILLA_ISFBA("TOY STORE", A1:E10)

Syntax Description

ISFBA Gorilla ROI

Description:

Check if a SKU or ASIN is FBA or FBM or both

Syntax:

GORILLA_ISFBA(Seller ID, sku, [marketplace])

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

sku – REQUIRED
SKU or ASIN to filter the results. Can be a range of values like A1:A100 or SKU111, SKU222, SKU333 or ASIN123.

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, SE, AU, SG, JP. Use DEFAULT for seller default.

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_ISFBA("TOY STORE", D2)

Uses the ASIN or SKU entered in cell D2 and returns the result of whether it is FBA or FBM

=GORILLA_ISFBA("TOY STORE", A1:A1000, "US")

Bulk method to check whether the SKUs or ASINs listed in A1:A1000 are FBA, FBM or both.

=GORILLA_ISFBA("TOY STORE", A1:E10)

Formula supports 2D directions. Not just a single row or column.

GET THE EBOOK PACKAGE

Enter your name and email for the full download package now.

GET YOUR SPREADSHEETS

Enter your name and email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.