SSIS Components for Amazon Marketplace

Build 23.0.8839


Update the shipment status for a specific order. Intended to be used with sellers who are participating in the In-store Pickup program.


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 NameTypeRequired
OrderItemId string true
Quantity integer true


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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839