Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_INBOUNDSHIPITEMS() – Get inbound shipment data by ASIN

GORILLA_INBOUNDSHIPITEMS() – Get inbound shipment data by 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_INBOUNDSHIPITEMS()
=GORILLA_INBOUNDSHIPITEMS("1HD-ASIN")
=GORILLA_INBOUNDSHIPITEMS(A1:A100, , 50)
=GORILLA_INBOUNDSHIPITEMS("SKU12345", "FBA12XYZ34", "All", 50, "AllButDeleted", "Custom", "2021-01-01", "2021-02-01")

Syntax Description

function inboundshipitems Gorilla ROI

Description:

Get the full inventory shipment data by item or ASIN/SKU of the shipments created in the seller central account.

Syntax:

GORILLA_INBOUNDSHIPITEMS([FILTER], [SHIPMENTID], [RECEIVED], [COUNT], [STATUS], [PERIOD], [START_DATE], [END_DATE])

For Gorilla Agency, the syntax is

GORILLA_INBOUNDSHIPITEMS(SELLER ID, [FILTER], [SHIPMENTID], [RECEIVED], [COUNT], [STATUS], [PERIOD], [START_DATE], [END_DATE])

filter – OPTIONAL
SKU to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or SKU123.

shipmentID – OPTIONAL
FBA Shipment ID filter. Can be a range of values like A1:A100 where A1 to A100 consists of values like “FBA16FV6TKG3, FBA16FV5D2MW, FBA16FLJ360X”

received – OPTIONAL
The units received. Use Mismatch to only load records where units received and shipped do not match. Valid values are: All (default) or Mismatch.

count – OPTIONAL
The number of shipments to retrieve (default value is 50).

status – OPTIONAL
The shipment status. Valid values:

  • Closed
  • Receiving
  • Deleted
  • Delivered
  • Shipped
  • In_Transit
  • Canceled
  • All

period – OPTIONAL
Predefined period to get returns or use custom to specify a start and end date. Default “Last 60 days”.

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

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

end_date – OPTIONAL
OPTIONAL – Ending date for the returning range when the period is set to “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_INBOUNDSHIPITEMS()

The default and easiest formula to use that will load the last 50 shipments lines of shipments of SKUs shipped.

=GORILLA_INBOUNDSHIPITEMS("1HD-ASIN")

This one will only show the shipment data for SKU “1HD-ASIN”.

=GORILLA_INBOUNDSHIPITEMS(A1:A100, , 50)

Will filter and only display 50 of the last shipments where the SKU is listed in A1:A100.

=GORILLA_INBOUNDSHIPITEMS("SKU12345", "FBA12XYZ34", "All", 50, "AllButDeleted", "Custom", "2021-01-01", "2021-02-01")

The full complete formula. Looks up the shipment data for SKU12345 in a particular shipment ID FBA12XYZ34. Will display all units received, display last 50 results, for status AllButDeleted

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

=GORILLA_INBOUNDSHIPITEMS("SELLER ID")
=GORILLA_INBOUNDSHIPITEMS("HOME GOODS", A1:A100, , 50)
=GORILLA_INBOUNDSHIPITEMS("MAGIC SELLER", "SKU12345", "FBA12XYZ34", "All", 50, "AllButDeleted", "Custom", "2021-01-01", "2021-02-01")

How can we help?