SubmitOrderFulfillmentFeed
The Order Fulfillment feed allows your system to update Amazon's system with order fulfillment information.
Execute
The Driver Uses #TEMP tables as fields for aggregate information entered
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'
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 | True | Required. 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. |
Result Set Columns
| Name | Type | Description |
| FeedSubmissionId | String | A unique identifier for the feed submission. |
| 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. |