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.