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
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:
Today | This month | Last 3 Months |
Yesterday | This quarter | Last 12 Months |
Same day last week | This year | Last 7 Days Week Ago |
Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
Same day last year | Last Week | Last 30 Days Month Ago |
Last 7 Days | Last Month | Last 30 Days Year Ago |
Last 14 Days | Last Quarter | Last Week Year Ago |
Last 30 Days | Last Year | Last Month Year Ago |
Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
This week | YYYY | YYYYQ1… YYYYQ4 |
Custom |
Status Attribute:
All | PendingAvailability (JP marketplace only) |
Pending | Unshipped |
PartiallyShipped | Shipped |
InvoiceUnconfirmed | Canceled |
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.