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("TOY STORE", "last 7 days")=GORILLA_MANAGEORDER("TOY STORE", "last month", "U378-JEKD-423D", "US")=GORILLA_MANAGEORDER("TOY STORE", "last 30 days",C49,"US","SHIPPED")=GORILLA_MANAGEORDER("TOY STORE", "custom", , "US", "canceled", "2020-09-01", "2020-09-15")Syntax Description
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(Seller ID, period, [filter], [marketplace], [status], [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 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.
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 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 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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "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.