JDBC Driver for Amazon Marketplace

Build 22.0.8538

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8538