SubmitOrderAdjustmentFeed
The Order Adjustment feed allows you to issue a refund (adjustment) for an order. You must provide a reason for the adjustment, such as Customer Return, and the adjustment amount, broken down by price component (principle, shipping, tax, and so on).
Execute
The Driver Uses #TEMP tables as fields for aggregate information entered
You must include in your query :
INSERT INTO ItemPriceAdjustmentsAggregate#TEMP (ItemPriceAdjustmentsComponentType,ItemPriceAdjustmentsComponentAmount,ItemPriceAdjustmentsComponentAmountCurrency) VALUES ('Shipping','150','JPY')
INSERT INTO AdjustedItemAggregate#TEMP (AdjustedItemAmazonOrderItemCode,AdjustedItemAdjustmentReason,ItemPriceAdjustmentsAggregate) VALUES ('25959136016214','CustomerReturn','ItemPriceAdjustmentsAggregate#TEMP')
INSERT INTO OrderAdjustmentFeedAggregate#TEMP (AmazonOrderID,OperationType,AdjustedItemAggregate) VALUES ('249-6070298-2783041','Update','AdjustedItemAggregate#TEMP')
Then you execute the procedure by specifying the value of OrderAdjustmentFeedAggregate with the name of #TEMP table used OrderAdjustmentFeedAggregate#TEMP.
EXEC SubmitOrderAdjustmentFeed OrderAdjustmentFeedAggregate = 'OrderAdjustmentFeedAggregate#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. |
| OperationType | String | False | Required. Used to specify the type of operation (Update or Delete) to be performed on the data. |
| 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. |
| AdjustedItemQuantityCancelled | Integer | False | Quantity of items being canceled. Used only for partial cancellations. |
| AdjustedItemAmazonOrderItemCode | String | False | Amazon's unique ID for an item in an order. |
| AdjustedItemMerchantOrderItemID | String | False | Optional seller-supplied ID for an item in an order. It can be used in order processing if the pairing was established in the acknowledgment feed. |
| AdjustedItemMerchantAdjustmentItemID | String | False | Optional seller-supplied unique ID for the adjustment (not used by Amazon). |
| AdjustedItemAdjustmentReason | String | False | Reason for the adjustment. |
| ItemPriceAdjustmentsComponentType | String | False | The Type of price adjustment for the item. Values include: Principal, Shipping, Tax, ShippingTax, RestockingFee, RestockingFeeTax, GiftWrap, GiftWrapTax, Surcharge, ReturnShipping, Goodwill, ExportCharge, COD, CODTax, Other, FreeReplacementReturnShipping |
| ItemPriceAdjustmentsComponentAmount | Decimal | False | The Amount of the adjustment. |
| ItemPriceAdjustmentsComponentAmountCurrency | String | False | The Currency for the Amount. |
| ItemPriceAdjustmentsAggregate | String | False | An aggregate representing the Amount the buyer is to be refunded for the item. Can be in the form of XML, JSON, or a #TEMP table. Use this field if multiple item price adjustments need to be applied. |
| PromotionAdjustmentsPromotionClaimCode | String | False | The ClaimCode for the Promotion Adjustment. |
| PromotionAdjustmentsMerchantPromotionID | String | False | The Promotion Id for the Promotion Adjustment. |
| PromotionAdjustmentsComponentType | String | False | The Type of price adjustment for the promotion. |
| PromotionAdjustmentsComponentAmount | Decimal | False | The Amount of price adjustment for the promotion. |
| PromotionAdjustmentsComponentAmountCurrency | String | False | The Currency for the Amount. |
| PromotionAdjustmentsComponentAggregate | String | False | An aggregate representing the Amount the buyer is to be refunded for the promotion, broken down by type. Can be in the form of XML, JSON, or a #TEMP table. Use this field if multiple promotion price adjustments need to be applied. |
| PromotionAdjustmentsAggregate | String | False | An aggregate representing the promotion. Child Elements include PromotionClaimCode, MerchantPromotionID, ComponentAggregate (Type, Amount and Amount@Currency). Use this field if multiple promotions need to be applied. |
| AdjustedItemAggregate | String | False | An aggregate representing order adjustment information for a specific item. Can be in the form of XML, JSON, or a #TEMP table. Use this field if multiple items need adjusting in 1 order. |
| OrderAdjustmentFeedAggregate | 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. |