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 template:
Download the Adjustments Template. Select a destination folder on your computer and
click Save.
Enter your order refund information:
Open the Adjustments template you saved to your
computer.
Review the Instructions and
Definitions sheets, particularly the important notes
and formatting requirements. See the Adjustments Glossary below also. This
template has validation macros that can help you complete the template
correctly. You can turn the validation macros off, but we recommend keeping
them on until you've learned how to use the template.
Enter the information for each order you are refunding.
Note:
All fields in the Order Adjustments file are required, aside from
promotion-related fields if you are not offering promotions. In that
case, the promotion-related fields need to be deleted from the file
for the feed to be processed successfully.
The hyphens in order numbers (order-id) are required. The feed will not process
successfully without them.
Excel formatting suggestions
Format your number columns as text to keep Excel from removing leading
zeros.
Format the date columns as yyyy-mm-dd.
Wrap text or change the width of the cells so you can view all of your
data.
Save the spreadsheet as a text file
Save your file as a regular Excel spreadsheet (.xls or .xlsx). You might want
to use a naming convention such as Filename_Date. For example, an order refund
file uploaded on May 12, 2012, would be named OrderRefund_12_05-2012.
In your saved Excel file, if the BatchRefunds tab containing your data is not
displayed, click that tab.
On the File menu (or the Office Button menu), click 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.
You might see a warning that the selected file format (the tab-delimited file
type) does not support workbooks containing multiple worksheets.
Click Yes.
You might see a warning that your file contains features incompatible with the
selected text (tab-delimited) file format. Click
Yes.
Upload the text file
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.
Browse to where you saved the tab-delimited text file and then select the
file.
Click Upload now. The file is uploaded to Amazon.nl,
and a message confirms that your file was received.
Review upload status and diagnose errors
Check the Review File Status and History section of
the Adjustments page to see the status of your upload. Click
Refresh to see the latest status. After the file has
been processed, "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 More
Adjustments Glossary
Field name
Definition
Accepted Values
Example
order-id
Amazon's unique identifying number for an order. Provided in your orders
report.
Alphanumeric text, 19 characters, in the format of 3-7-7. Note:
order-id must include the hyphens.
058-3563777-5518068
order-item-id
Amazon's unique identifying number for an item in an order. Provided in your
orders report.
Alphanumeric text, 14 characters.
0583563777345
adjustment-reason-code
The reason for the refund or 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 product level
(the Amazon 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
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
Sign in to use the tool and get personalised help (desktop browser required).
Sign in