Google Sheets Functions

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

GORILLA_ORDERSCOUNTHIST() – Get daily historical orders sold

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_ORDERSCOUNTHIST("TOY STORE")
=GORILLA_ORDERSCOUNTHIST("TOY STORE", "B00YD545CC")
=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A20)
=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60)
=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"Yes")
=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A10, "DE", "Canceled", "EXCLUDE", , "2022-01-01", "2022-03-12")

Syntax Description

image 8 Gorilla ROI

Description:

Get number of orders history for a given period or number of days going back.

=GORILLA_ORDERSCOUNTHIST(Seller ID, [sku], [marketplace], [status], [mcf], [days], [start_date], [end_date], [transpose])

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

sku – OPTIONAL
SKU or ASIN. Select or enter a range of values.  

marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.

status – OPTIONAL
Order Status. Valid values are:

  • AllButCanceled (default)
  • AllPendingAvailability (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.)

days – OPTIONAL
By default, the last 30 days is pulled. Enter the number of days to display in the results.

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. 

transpose – OPTIONAL
Default is set to “NO”. It will display the SKUs on the top row horizontally.
“YES” will display the SKUs in a column. Vertically down. 

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_ORDERSCOUNTHIST("TOY STORE")

When no attributes are entered into the formula, it will create a table of the number of orders over the last 30 days of the entire account. 

=GORILLA_ORDERSCOUNTHIST("TOY STORE", "B00YD545CC")

Pulls in the number of orders over the last 30 days of ASIN B00YD545CC into a table. 

=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A20)

Pulls in the number of orders over the last 30 days for the SKUs or ASINs listed in cell A1 to A20.

=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A10, “US”, “ALL”, “EXCLUDE”, 60)

Returns a table of daily historical orders for all SKUs in cell A1 to A10, in the US marketplace only, the order status includes all, excludes MCF (Merchant Fulfilled) orders for the last 60 days. 

=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"Yes")

This returns the same table as above, but is transposed where the SKU is displayed vertically.

=GORILLA_ORDERSCOUNTHIST("TOY STORE", A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2020-01-01”, “2020-03-12”)

Returns a table of daily historical orders for all SKUs in cell A1 to A10, in the German marketplace only, the order status is canceled, excludes MCF (Merchant Fulfilled) orders, between the two dates in the formula. The “days” field is blank so that the start and end date will activate. If days value is entered, then the start and end date won’t work.

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.