Skip to main content

GORILLA_INBOUNDSHIPAWD() - Dump AWD inbound shipments data

Updated over 8 months ago

⚠️ IMPORTANT NOTICE

Optimize Your Formula Usage

Use ranges (e.g., A2:A1000) in your formula whenever possible to ensure faster results and to prevent Google from blocking your account for 24 hours due to excessive resource usage.

Syntax Screenshot

Description

Get the AWD inbound shipment data of the shipments created in the seller central account.

Syntax

=GORILLA_INBOUNDSHIPAWD(Seller ID, [shipmentid], [status], [count], [period], [start_date], [end_date])

Parameter Descriptions

Seller ID – (REQUIRED)

Seller ID or Nickname found within the Gorilla App to work with.

shipmentid – (OPTIONAL)
OPTIONAL - Shipment IDs to filter the results. Can be a string like 'SHIP123', or a range like A1:A100 where A1 to A100 consist of inputs like Ship111, Ship222, Ship333.

status – (OPTIONAL)

Shipment status.

If left blank, the default input will be used.

Valid inputs:

  • all but canceled (DEFAULT)

  • all

  • pending availability (JP only)

  • pending

  • unshipped

  • partially shipped

  • shipped

  • shipping

  • invoice unconfirmed

  • canceled

  • unfulfillable

count – (OPTIONAL)

Specifies the number of data rows to display when using the output filter in 'DUMP' mode (not 'TOTAL'). Recommended for sellers with tens of thousands of products

Period – (REQUIRED)
Predefined period to get sales information or use ‘custom’ to specify a start and end date.

Valid inputs:

  • Today

  • Yesterday

  • This Week

  • This Month

  • This Quarter

  • This Year

  • This Year-to-Last-Month

  • Last 7 Days

  • Last 14 Days

  • Last 30 Days

  • Last 60 Days

  • Last 90 Days

  • Last Week

  • Last Month

  • Last Quarter

  • Last Year

  • Last 3 Months

  • Last 12 Months

  • Same Day Last Week

  • Same Day Last Month

  • Same Day Last Year

  • Last 7 Days Week Ago

  • Last 7 Days Year Ago

  • Last 30 Days Month Ago

  • Last 30 Days Year Ago

  • Last Week Year Ago

  • Last Month Year Ago

  • YYYY-MM (change format to text)

  • YYYY

  • YYYYQ1

  • YYYYQ2

  • YYYYQ3

  • YYYYQ4

Start Date – (OPTIONAL)

Starting date for the data when the 'Period' is set to "CUSTOM". This only applies if the 'Days' filter is left empty.

End Date – (OPTIONAL)
Ending date for the data when the 'Period' is set to "CUSTOM". This only applies if the 'Days' filter is left empty.

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_INBOUNDSHIPAWD("TOY STORE")

This is the default and easiest formula to use. It will load the last 50 shipments located in your Amazon Seller Central account.

=GORILLA_INBOUNDSHIPAWD("TOY STORE", "FBA16FZYHNDU", "ALL", 50)

Will output the last 50 shipments where the shipment ID is FBA16FZYHNDU.

=GORILLA_INBOUNDSHIPAWD("TOY STORE", A1:A100, "ALL", 50)

Will output the last 50 shipments where the shipment IDs are listed in A1:A100.

Output Screenshot

Did this answer your question?