Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_MANAGEORDER() – Get list of orders and order details for SKU or ASIN

GORILLA_MANAGEORDER() – Get list of orders and order details for SKU or ASIN

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_MANAGEORDER("last 7 days")
=GORILLA_MANAGEORDER("last month", "U378-JEKD-423D", "US")
=GORILLA_MANAGEORDER("last 30 days",C49,"US","SHIPPED")
=GORILLA_MANAGEORDER("custom", , "US", "canceled", "2020-09-01", "2020-09-15")

Syntax Description

manageorder amazon gorilla function

Description:

Get the detailed list of orders and the order details for a SKU or ASIN. ManageOrder is a dump of the order IDs where the sales occurred.

WARNING: For large sellers, do NOT use this function for a long time period, like “last year”. It will try to load thousands of orders. Google will timeout and will block your requests for the next 24hrs as it thinks you are a bot.

Syntax:

GORILLA_MANAGEORDER(period, [filter], [marketplace], [status], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_MANAGEORDER(sellerID, period, [filter], [marketplace], [status], [start_date], [end_date]) 

period

Predefined period to get refunded units. See full list of predefined periods below.

filter

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. If no SKUs are specified, it will load the total number across the account.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

status

OPTIONAL – Order status. Valid values are:

  • All
  • Canceled
  • Pending
  • PartiallyShipped
  • Unshipped
  • Shipped
  • Shipping

start_date

OPTIONAL – Starting date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date

OPTIONAL – Ending date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

GORILLA_MANAGEORDER 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 Attributes

  • All
  • Allbutcanceled
  • Canceled
  • Pending
  • PartiallyShipped
  • Unshipped
  • Shipped
  • Shipping

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_MANAGEORDER("last 7 days")

This will list all orders over the last 7 days include all statuses of the orders. You will get details such as the order ID, purchase date, order status, fulfillment channel, quantity shipped, price, taxes and more.

 =GORILLA_MANAGEORDER("last month", "U378-JEKD-423D", "US")

Returns a list of all order from last month for the SKU in the US marketplace. You can also reference a cell instead of manually entering it into the formula.

 =GORILLA_MANAGEORDER("last 30 days",C49,"US","SHIPPED")

Returns a filtered list of only shipped orders over the last 30 days for the ASIN or SKU in cell C49 from the US marketplace only.

=GORILLA_MANAGEORDER("custom", , "US", "canceled", "2020-09-01", "2020-09-15")

Use custom date ranges to extract data. Between Sep 1st, 2020 and Sep 15th, 2020. Listing all canceled orders in the US marketplace.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_MANAGEORDER("last 7 days")
=GORILLA_MANAGEORDER("last month", "U378-JEKD-423D", "US")
=GORILLA_MANAGEORDER("last 30 days",C49,"US","SHIPPED")
=GORILLA_MANAGEORDER("custom", , "US", "canceled", "2020-09-01", "2020-09-15") 

How can we help?