Google Sheets Functions

⌘K
  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 1.Seller Central Data/Fun...
  5. GORILLA_ORDERSCOUNT() – Get the number of orders sold between any time period

GORILLA_ORDERSCOUNT() – Get the number of orders sold between any time period

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_ORDERSCOUNT("TOY STORE", "LAST WEEK", "US", $A$3:$A$10, "SHIPPED", "EXCLUDE")
=GORILLA_ORDERSCOUNT("TOY STORE", "LAST WEEK")

Syntax Description

ORDERSCOUNT Gorilla ROI

Description:

Get number of orders for any product for any specified time period. Only the period attribute is required. Other attributes are optional.

Syntax:

=GORILLA_ORDERSCOUNT(Seller ID, period, [marketplace], [sku], [status], [mcf], [start_date], [end_date])

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

PERIOD – REQUIRED
Predefined period to get sales. See full list of predefined periods below.

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 – OPTIONAL
Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

STATUS – OPTIONAL
Order Status. Valid values are:

  • AllButCanceled(default)
  • All
  • PendingAvailability (JP only)
  • Pending
  • Unshipped
  • PartiallyShipped
  • Shipped
  • InvoiceUnconfirmed
  • Canceled
  • Unfulfillable

mcf – OPTIONAL
Whether to display, include or exclude MCF orders.

  • Exclude (default option is not specified)
  • Include
  • Only (only displays data for MCF orders. Does not show data for FBA.)

start_date – OPTIONAL
Starting date to get sales from when period is custom.

end_date – OPTIONAL
Ending date to get sales from when period is custom.

GORILLA_ORDERSCOUNT 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

Status Attribute:

AllPendingAvailability (JP marketplace only)
PendingUnshipped
PartiallyShippedShipped
InvoiceUnconfirmedCanceled
Unfulfillable 

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_ORDERSCOUNT("TOY STORE", "Custom", "US", "B00YD545CC", "SHIPPED", "EXCLUDE", "2018-01-01", "2018-01-21")

Returns number of orders for unit B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018. Excludes MCF orders from the data.

=GORILLA_ORDERSCOUNT("TOY STORE", "This Week","ALL",A2:A10)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_ORDERSCOUNT("TOY STORE", "This Month", "ALL", "IPHN3724", "Canceled")

Gets the number of orders for SKU IPHN3724 from all marketplaces that were canceled this month.

=GORILLA_ORDERSCOUNT("TOY STORE", "Same Day Last Month", "ALL", "IPHN3724", "pending")

Gets the number of orders for SKU IPHN3724 from all marketplaces that are sold and pending.

=GORILLA_ORDERSCOUNT("TOY STORE", "This Year")

Gets the number of orders for all products, across all marketplaces, so far year to date.

=GORILLA_ORDERSCOUNT("TOY STORE", "2022Q1", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

=GORILLA_ORDERSCOUNT("TOY STORE", "2019-05", "US", "B00YD545CC", "All")

To get monthly data, use the format YYYY-MM as the preset period.

Tags ,