To issue full or partial refunds, or to
make miscellaneous adjustments, for multiple orders at one time, submit refunds with the
To prepare and upload the Adjustments
file, follow these steps:
Open the Adjustments template and review the Instructions and Definitions tabs, especially the Important Notes and formatting requirements.
See also the Glossary below. This template has validation macros that can help you
complete the template correctly. You can turn the validation macros off. However, we
recommend keeping them on until you've learned how to use the template.
Enter the information for each order
you are refunding:
All fields in the Adjustments
file are required, except for promotion-related fields. If you are not offering
promotions, then delete the promotion fields from the file or it will not upload
The hyphens in order numbers
(order-id) are required. The feed will not process successfully
Format your number columns as
text to keep Excel from removing leading zeros.
Format the date columns as
Select the BatchRefunds tab.
On the Excel File menu, select Save As.
In the Save as type drop-down list, select Text (Tab delimited) (*.txt).
Browse to where you want to save the
file on your computer and click Save.
If you see a warning that the
selected file format (the tab-delimited file type) does not support workbooks
containing multiple worksheets, click Yes.
If you see a warning that your
file contains features incompatible with the selected text (tab-delimited) file
format, click Yes.
On the Orders link in your seller account, select Upload Order Related Files, and then click the Adjustments link.
Under Upload Your Adjustments File, click Browse to locate your Adjustments file.
Click Upload to upload your Adjustments file to Amazon.
Monitor the status of your upload by checking the Review File Status and History section of the Adjustments page. Click Refresh to see the latest status. After the upload is complete, Status: Done appears in the Status/Results column along with the number of errors, if any.
If there are any errors, click View Processing Report to diagnose and correct errors in the uploaded
file. Learn how to Review Processing