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

=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.

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

  • Today
  • This month
  • Last 12 Months
  • Yesterday
  • This quarter
  • Last 7 Days
  • Week Ago
  • Same day last week
  • This year
  • Last 7 Days
  • Year Ago
  • Same day last month
  • This Year-to-Last-Month
  • Last 30 Days
  • Month Ago
  • Same day last year
  • Last Week
  • Last 30 Days
  • Year Ago
  • Last 7 Days
  • Last Month
  • Last Week
  • Year Ago
  • Last 14 Days
  • Last Quarter
  • Last Month
  • Year Ago
  • Last 30 Days
  • Last Year
  • YYYY-MM (change format to text)
  • This week
  • Last 60 Days
  • YYYYQ1… YYYYQ4
  • YYYY

Status Attributes

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

Examples:

Use closed 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_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") 

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?