SubmitOrderFulfillmentFeed

The Order Fulfillment feed allows your system to update Amazon's system with order fulfillment information.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO ItemAggregate#TEMP (ItemAmazonOrderItemCode, ItemQuantity) VALUES ('25959136016214', '1');

INSERT INTO OrderFulfillmentFeedAggregate#TEMP (AmazonOrderID, FulfillmentDate, FulfillmentDataCarrierName, FulfillmentDataShippingMethod, FulfillmentDataShipperTrackingNumber, ItemAggregate) VALUES ('249-6070298-2783041', '2017-02-01T00:00:00Z', 'CData Delivery Company', 'Normal Delivery', '1223525345234', 'ItemAggregate#TEMP')

Then you execute the procedure by specifying the value of OrderFulfillmentFeedAggregate with the name of #TEMP table used OrderFulfillmentFeedAggregate#TEMP.

EXEC SubmitOrderFulfillmentFeed OrderFulfillmentFeedAggregate = 'OrderFulfillmentFeedAggregate#TEMP', marketplaceids = 'A1VC38T7YXB528'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/OrderFulfillment.xsd):

    <Message>
    <MessageID>1</MessageID>
    <OrderFulfillment>
        <AmazonOrderID>249-6070298-2783041</AmazonOrderID>
        <FulfillmentDate>2017-02-01T00:00:00Z</FulfillmentDate>
        <FulfillmentData>
            <CarrierName>CData Delivery Company</CarrierName>
            <ShippingMethod>Normal Delivery</ShippingMethod>
            <ShipperTrackingNumber>1223525345234</ShipperTrackingNumber>
        </FulfillmentData>
        <Item>
            <AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
            <Quantity>1</Quantity>
        </Item>
    </OrderFulfillment>
</Message>

EXEC SubmitOrderFulfillmentFeed OrderFulfillmentFeedAggregate = '...(the above XML)...', marketplaceids = 'A1VC38T7YXB528'

Input

Name	Type	Required	Description
AmazonOrderID	String	False	Amazon's unique identifier for an order, which identifies the entire order regardless of the number of individual items in the order.
MerchantOrderID	String	False	Optional seller-supplied order ID. The first step is to establish the MerchantOrderID in the acknowledgment feed. Amazon will map the MerchantOrderID to the AmazonOrderID, and you can then use your own order ID (MerchantOrderID) for subsequent feeds relating to that order. See the base XSD for the definition.
OperationType	String	False	Required if OrderFulfillmentFeedAggregate is empty. Used to specify the type of operation (Update or Delete) to be performed on the data.
MerchantFulfillmentID	Integer	False	Seller-supplied unique identifier for the shipment (not used by Amazon).
FulfillmentDate	Datetime	False	The date the item was actually shipped or picked up, depending on the fulfillment method specified in the order.
FulfillmentDataCarrierCode	String	False	The shipping carrier code.
FulfillmentDataCarrierName	String	False	The shipping carrier name.
FulfillmentDataShippingMethod	String	False	The shipping method used to deliver the item.
FulfillmentDataShipperTrackingNumber	String	False	The tracking number for the shipment.
CODCollectionMethod	String	False	Cash on delivery collection mode of an order.
ItemAmazonOrderItemCode	String	False	Amazon's unique ID for an item in an order.
ItemMerchantOrderItemID	String	False	The shipping Optional seller-supplied ID for an item in an order.
ItemMerchantFulfillmentItemID	String	False	Seller-supplied unique identifier for an item in the shipment (not used by Amazon).
ItemQuantity	Integer	False	The quantity of an item shipped.
ItemAggregate	String	False	An aggregate representing order-fulfillment information for a specific item. Can be in the form of XML, JSON, or a #TEMP table. Use this field when multiple Items need to be included in the feed.
FulfillmentDataAggregate	String	False	An aggregate representing order-fulfillment information for a specific item. Can be in the form of XML, JSON, or a #TEMP table. Use this field when multiple Items need to be included in the feed.
OrderFulfillmentFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML, JSON, or a #TEMP table.
MarketplaceIds	String	True	Required. A list of one or more marketplace IDs for the marketplace that registered the listing account.

Result Set Columns