Google Sheets Functions

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

GORILLA_INVENTORYRECEIVED() – Get inventory received and check shipment data

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_INVENTORYRECEIVED("TOY STORE", "THIS YEAR")
=GORILLA_INVENTORYRECEIVED("TOY STORE", "THIS MONTH", , , "MX","ALL")
=GORILLA_INVENTORYRECEIVED("TOY STORE", "custom", "SKU12345", "FBA12XYZ34", "US", "Missing", "2021-01-01", "2021-02-01")

Syntax Description

INVENTORYRECEIVED 1 Gorilla ROI

Description:

Get inventory received and check shipment data

Syntax:

GORILLA_INVENTORYRECEIVED(Seller ID, period, [filter], [shipmentid], [center], [received], [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 orders or use custom to specify a start and end date.

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

filter – OPTIONAL
SKU, ASIN or FNSKU to filter the results. Can be a range of values like A1:A100 or SKU111, SKU222, SKU333 or FNSKU123.

shipmentID – OPTIONAL
Filter data using the Amazon shipment ID

center – OPTIONAL
Fulfillment center filter. Valid values: Fulfillment Center Id, Country or State of the FC location. Country codes as US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, PO, SL, SE, AU, SG, JP… States as Oregon, Ohio, Texas, Mecklar, Prague, Madrid, Leipzig… Use ALL to get values from all centers.

received – OPTIONAL
Unit quantity received. Valid values are: All or Missing as default.

start_date – OPTIONAL
Starting date for the returning range when period is “custom”.

end_date – OPTIONAL
Ending date for the returning range when period is “custom”.

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_INVENTORYRECEIVED("TOY STORE", "THIS YEAR")

Returns the full Amazon shipment and inventory received report. Auto generates a table with headers. Default settings will only show the missing or negative received quantity shipments. To see the full list, use the filter for “received”.

=GORILLA_INVENTORYRECEIVED("TOY STORE", "THIS MONTH", , , "MX", "ALL")

This will create a table showing the shipments from this month for Mexico shipments. It will display the full list of all quantities.

=GORILLA_INVENTORYRECEIVED("TOY STORE", "custom", "SKU12345", "FBA12XYZ34", "US", "Missing", "2021-01-01", "2021-02-01")

This is the most detailed version of pulling all shipments for the SKU defined, in a certain shipment ID, for the US market that are missing. Custom date period is used.

Tags ,

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.