Sample Usage
=GORILLA_INBOUNDSHIP("TOY STORE")
=GORILLA_INBOUNDSHIP("TOY STORE", "FBA16FZYHNDU", "ALL", 50)
=GORILLA_INBOUNDSHIP("TOY STORE", A1:A100, "ALL", 50)
Syntax Description
Description:
Get the full inventory shipment data of the shipments created in the seller central account.
Syntax:
🚨 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_INBOUNDSHIP(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 “FBA16FV6TKG3, FBA16FV5D2MW, FBA16FLJ360X”
status – OPTIONAL
The shipment status.
Valid values:
- Closed
- Receiving
- Deleted
- Delivered
- Shipped
- In_Transit
- Canceled
- All
count – OPTIONAL
The 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
Ending date for the returning range when period is ‘custom’.
end_date – OPTIONAL
Starting 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_INBOUNDSHIP("TOY STORE")
The default and easiest formula to use that will load the last 50 shipments located in your seller central account.
=GORILLA_INBOUNDSHIP("TOY STORE", "FBA16FZYHNDU", "ALL", 50)
Will output the 50 of the last shipments where the shipment ID is FBA16FZYHNDU
=GORILLA_INBOUNDSHIP("TOY STORE", A1:A100, "ALL", 50)
Will output the last 50 shipments where the shipment ID is listed in A1:A100.
=GORILLA_INBOUNDSHIP("TOY STORE", A1:A100, "ALL", 50)