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

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

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:

=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”)

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?