Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INVENTORYRECEIVED() – Get inventory received and check shipment data

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

Syntax Description

inventory received

Description:

Get inventory received and check shipment data

Syntax:

GORILLA_INVENTORYRECEIVED(period, [filter], [shipmentid], [center], [received], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_INVENTORYRECEIVED(sellerID, period, [filter], [shipmentid], [center], [received], [start_date], [end_date])

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(“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(“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(“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.

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

=GORILLA_INVENTORYRECEIVED(“SELLER3382”, “THIS YEAR”)
=GORILLA_INVENTORYRECEIVED(“SELLER3382”, “THIS MONTH”, , , “MX”,”ALL”)
=GORILLA_INVENTORYRECEIVED(“SELLER3382”, “custom”, “SKU12345”, “FBA12XYZ34”, “US”, “Missing”, “2021-01-01”, “2021-02-01”)

How can we help?