Issue Multiple Refunds at Once

As a seller you might encounter situations, such as customer returns or service problems, where you must issue a refund for all or part of a customer's order.

You can process full refunds, partial refunds, or miscellaneous adjustments for multiple orders by using either an Order Adjustments Template or the Manage Orders feature. If you want to refund one or two orders, you'll find it easier to use the Manage Orders Feature. However, when you want to refund multiple orders at the same time, use the Order Adjustments Template.

Download the Order Adjustments Template (a Microsoft Excel file) from the Order Cancellation Template page, edit the spreadsheet, save it as a tab-delimited text file, and then upload it on the Order Adjustments page.

There are five basic steps to managing your adjustments file:

1. Download the template

Click the link below to download a template. Select a destination folder on your computer and click Save.

Order Adjustments Template

2. Enter the information into the Adjustments template

1. Open the Adjustments template (a Microsoft Excel spreadsheet) from the location where you saved the file. The three Sheets in the file are accessible with the tabs at the bottom of the window: Instructions, Definitions and Adjustments.
2. Review the Instructions and Definitions sheets, particularly the important notes and formatting requirements.
3. Enter the information into the worksheet. For each product on the order, enter the appropriate information.

Please note

• All fields in the Adjustments file are required fields.
• You must include hyphens in your order-id. Omitting hyphens will cause your feed to fail.
• If you do not plan to offer promotions, delete the promotion-related fields from the file. If you leave the field blank (or enter a place-holder number such as "0.00"), your template will not process successfully.

Tips for using Excel

• Reformat your number columns to "text" keep Excel from removing leading zeros.
• Format the date columns to yyyy-mm-dd before you save.
• Wrap text or change the width of your cells to view all your data.

3. Save your Adjustments file

After you have entered your information, you save the file.

1. Save your file. You might want to use a different name for each upload, such as AdjustmentsUpload-2010-05-12 for an upload you make on 12th May 2010.
2. If necessary, click the Adjustments tab to display the adjustments worksheet that contains your data.
3. On the File menu, click Save As. The Save As dialog box appears.
4. In the Save As Type list Text (Tab-delimited) (*.txt). Browse to where you would like to save the file, rename the file, and click Save.
5. You might see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets. Click Yes.
6. You might see a warning that your file contains features incompatible with the selected Text (Tab delimited) file format. Click Yes.

4. Upload your Adjustments file

1. On the Orders tab, click Upload Order Related Files.
2. Click the Adjustments page link, if it not already selected (and not a link).
3. Under Upload Your Adjustments File, click Browse. The Choose File dialogue box appears.
4. Browse to the location where you saved the tab-delimited text file; then, select the file.
5. Click Open. The file path and file name appear in the Browse box.
6. Click Upload now The file is uploaded to Amazon.co.uk, and a status box confirmations your file was received.

5. Review the status of your Ajustments File upload

1. In the File Upload Status section of this page you can view the status of your upload. If you need to access your report later, the last 10 Uploads are available on the Upload Order Related Files page, in the Review File Status and History section.
2. Click the Refresh button in the bar to see the most recent status of your upload.
3. After your file is processed, the Status/Results column shows updated information, along with the actions available.

If any items are not activated due to errors, click the View Processing Report link to download the associated processing report. Use this report to diagnose and correct errors in the file you uploaded. The Troubleshoot Errors link provides a reference for error codes used. When you are ready to upload the edited file, click the Return to Upload page link, and re-upload your file. Learn More about using a Processing Report.