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