Sample Usage
=GORILLA_INBOUNDSHIPAWD("TOY STORE")=GORILLA_INBOUNDSHIPAWD("TOY STORE", "FBA16FZYHNDU", "ALL", 50)=GORILLA_INBOUNDSHIPAWD("TOY STORE", A1:A100, "ALL", 50)
Syntax Description
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])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
ShipmentID – OPTIONAL
FBA Shipment ID filter. Can be a range of values like A1:A100 where A1 to A100 consists of values like Ship111, Ship222, Ship333.
Status – OPTIONAL
The shipment status.
Valid values:
AllButDeleted (default)
Closed
Receiving
Deleted
Delivered
Shipped
In_Transit
Cancelled
Working
Checked_In
All
Count – OPTIONAL
Number of shipments to retrieve (default value is 50).
Period – OPTIONAL
Predefined period to get returns or use 'custom' to specify a start and end date.Default "Last 60 days".
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_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:
