To issue full or
partial refunds, or to make miscellaneous adjustments, for multiple orders at one time, submit
refunds with the Adjustments
Template.
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
successfully.
-
Format your number columns as
text to keep Excel from removing leading zeros.
-
Format the date columns as
yyyy-mm-dd.
-
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 Reports.