UpdateShipmentStatus
Update the shipment status for a specific order. Intended to be used with sellers who are participating in the In-store Pickup program.
Execute
The Driver uses #TEMP tables as fields for aggregate information entered.
First, create an OrderItems temporary table for the OrderItems input:
INSERT INTO orderItems#TEMP (OrderItemId, Quantity) VALUES ('123-1234567-1234567', 1);
INSERT INTO orderItems#TEMP (OrderItemId, Quantity) VALUES ('321-1234567-1234567', 2)
After the necessary temporary table has been created, execute the stored procedure as shown in the example below:
EXECUTE UpdateShipmentStatus
OrderId = '123-1234567-1234567',
ShipmentStatus = 'PickedUp',
OrderItems = 'orderItems#TEMP';
*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.
OrderItems temporary table schema info:
| Column Name | Type | Required |
| OrderItemId | string | true |
| Quantity | integer | true |
Input
| Name | Type | Required | Description |
| OrderId | String | True | An Amazon-defined order identifier, in 3-7-7 format. |
| ShipmentStatus | String | True | The shipment status to apply.
The allowed values are ReadyForPickup, PickedUp, RefusedPickup. |
| MarketplaceId | String | False | The unobfuscated marketplace identifier. |
| OrderItems | String | False | For partial shipment status updates, the list of order items and quantities to be updated. Aggregate field. |
Result Set Columns
| Name | Type | Description |
| Success | String |