Individual sellers: This feature is for Professional sellers only. Learn more.
You can upload an adjustments file to issue full or partial refunds, or miscellaneous adjustments for multiple orders at the same time. If you prefer, you can issue refunds one at a time in Manage Orders. Learn more.
Make sure you confirm dispatch of orders before including them in an adjustments file. Refunds uploaded before dispatches are confirmed will stay in pending status until the dispatches are confirmed. Learn more.
Follow these steps to prepare and upload an adjustments file, and to review the upload status and processing report.
Download the Adjustments Template. Select a destination folder on your computer and click Save.
Excel formatting suggestions
After the file has been processed, "Status: Done" appears in the Status/Results column along with the number of errors, if any.
Field name | Definition | Accepted Values | Example |
order-id | Amazon.co.uk's unique identifying number for an order; this is provided in your orders report. | Alphanumeric text, 19 characters, in the format 3-7-7. Note: order-id must include the hyphens. | 058-3563777-5518068 |
order-item-id | Amazon.co.uk's unique identifying number for an item in an order; this is provided in your orders report. | Alphanumeric text, 14 characters. | 0583563777345 |
adjustment-reason-code | The reason for the refund/adjustment. | Select one of the following: NoInventory, CustomerReturn, GeneralAdjustment, CouldNotShip, DifferentItem | CustomerReturn |
item-price-adj | The amount to be refunded to the buyer. If the adjustment is at the the product level (the Amazon.co.uk order-item-id), then the amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer (for example, restocking fees). The sum of the adjustment amount must be zero and less than or equal to the amount credited in the order report. | A number with up to 20 digits to the left of the decimal point and 2 digits (required) to the right of the decimal point. Do not use commas. |
1322.49 23.52 -42.00 |
shipping-price-adj | The amount to be refunded to the buyer for the item's shipment. If the adjustment is at the the product level (the Amazon.co.uk order-item-id), then the amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. The sum of the adjustment amount must be zero and less than or equal to the amount credited in the order report. | A number with up to 20 digits to the left of the decimal point and 2 digits (required) to the right of the decimal point. Do not use commas. |
1322.49 23.52 -42.00 |