SubmitOrderAcknowledgementFeed
The Order Acknowledgment feed allows you to acknowledge your success or failure with downloading an order.
Execute
The Driver Uses #TEMP tables as fields for aggregate information entered
You must include in your query :
INSERT INTO OrderAcknowledgementFeedAggregate#TEMP(AmazonOrderId,StatusCode,AmazonOrderItemCode,CancelReason) VALUES ('249-6070298-2783041','Failure','25959136016214','NoInventory')
Then you execute the procedure by specifying the value of OrderAcknowledgementFeedAggregate with the name of #TEMP table used OrderAcknowledgementFeedAggregate#TEMP.
EXEC SubmitOrderAcknowledgementFeed OrderAcknowledgementFeedAggregate = 'OrderAcknowledgementFeedAggregate#TEMP', marketplaceids = 'A1VC38T7YXB528'
The aggregate information can be entered by specifying it in this XML format
<Row>
<AmazonOrderId>249-6070298-2783041</AmazonOrderId>
<StatusCode>Failure</StatusCode>
<AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
<CancelReason>NoInventory</CancelReason>
</Row>
EXEC SubmitOrderAcknowledgementFeed OrderAcknowledgementFeedAggregate='<Row> <AmazonOrderId>249-6070298-2783041</AmazonOrderId> <StatusCode>Failure</StatusCode> <AmazonOrderItemCode>25959136016214</AmazonOrderItemCode> <CancelReason>NoInventory</CancelReason> </Row>'
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. Amazon will map the MerchantOrderID to the AmazonOrderID, and you can then use your own order ID (MerchantOrderID) for subsequent feeds relating to the order. |
| StatusCode | String | False | Allows you to acknowledge your success or failure with downloading an order. StatusCode can be either Success or Failure. |
| AmazonOrderItemCode | String | False | Amazon's unique identifier for an item in an order. |
| MerchantOrderItemID | String | False | Optional seller-supplied ID for an item in an order. If the MerchantOrderItemID is specified with the AmazonOrderItemCode, Amazon will map the two IDs and you can then use your own order item ID for subsequent feeds relating to that order item. |
| CancelReason | String | False | Used only when sending a StatusCode of Failure. |
| ItemAggregate | String | False | An aggregate representing an order Item. Can be in the form of XML or a #TEMP table. Use this field when multiple items in the order need to be acknowledged. |
| OrderAcknowledgementFeedAggregate | 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
| Name | Type | Description |
| FeedId | String | A unique identifier for the feed. |
| FeedType | String | The type of feed submitted. |
| SubmittedDate | Datetime | The date and time when the feed was submitted. |
| FeedProcessingStatus | String | The processing status of the feed submission. |