1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SALESCOUNT() – Get total number of sales between any time period

GORILLA_SALESCOUNT() – Get total number of sales between any time period

GORILLA_SALESCOUNT( ) Function

Description:
Gets total number of sales for a product between any time period. Only period is required. Other attributes are optional.

Syntax:
GORILLA_SALESCOUNT(period, [marketplace], [sku], [status], [start_date], [end_date])

period
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. or Amazon Marketplace ID like ATVPDKIKX0DER.

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

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.

Examples:
Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SALESCOUNT(“Custom”, “US”, “B00YD545CC”, “Shipped”, “2018-01-01”, “2018-01-21”)
Gets total number of units sold for B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018.

=GORILLA_SALESCOUNT(“This Week”,”ALL”,A2:A10),”ALL”)
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_SALESCOUNT(“This Month”, “ALL”, “IPHN3724”, “Canceled”)
Gets the total number of units for SKU IPHN3724 from all marketplaces that were canceled this month.

=GORILLA_SALESCOUNT(“Same Day Last Month”, “ALL”, “IPHN3724”, “ALL”)
Gets the total number of units for SKU IPHN3724 from all marketplaces that are sold and pending.

=GORILLA_SALESCOUNT(“This Year”)
Gets the total number of units sold for all products, account across all marketplaces.

GORILLA_SALESCOUNT Attributes

Period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago

Status Attributes:

  • AllButCanceled (default)
  • All
  • Unshipped
  • InvoiceUnconfirmed
  • PendingAvailability (JP marketplace only)
  • Pending
  • Canceled
  • Shipped
  • Unfulfillable
  • PartiallyShipped
Was this article helpful to you? Yes No

How can we help?