Google Sheets Functions

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

GORILLA_OOSRATE() – Show Out Of Stock days as a percentage

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_OOSRATE("TOY STORE", "This Month", "IPHONE13", "US")
=GORILLA_OOSRATE("TOY STORE", "Last 30 days", A1:A1320)
=GORILLA_OOSRATE("TOY STORE", "CUSTOM", A1:A1032, "UK", "2022-04-02", "2022-06-30")

Syntax Description

OOSRATE Gorilla ROI

Description:

Show the number of days out of stock for a list of products during a period.

Syntax:

GORILLA_OOSRATE(Seller ID, period, sku, [marketplace], [start_date], [end_date])

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 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123.

PERIOD – REQUIRED
Predefined period to get stock data or use custom to specify a start and end date.

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

start_date – OPTIONAL
Starting date for the returning range when the period is “custom”.

end_date – OPTIONAL
Ending date for the returning range when the period is “custom”.

GORILLA_OOS Attributes:

Period attributes:

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

Marketplace attributes:

AllDEPLSG
USFRTRIN
CAESSAEG
MXITAEEU (only for specific functions)
BRNLJPEURO (only for specific functions)
UKSEAU

start_date & end_date attributes:

Enter full date period in USA date format YYYY-MM-DD such as 2022-12-23

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_OOSRATE("TOY STORE", "This Month", "IPHONE13", "US")

This formula will display the number of days out of stock for this month for the US market and product SKU IPHONE13.

=GORILLA_OOSRATE("TOY STORE", "Last 3 months", A1:A1320)

Displays the number of days out of stock during the last 3 months for all the per SKU listed from A1:A1320.

This is the output for a formula as shown below.

OOSRATE.2 Gorilla ROI
Results for GORILLA_OOSRATE()

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.