Sell on Amazon Sign In
This article applies to selling in: Germany

Issue multiple refunds at once

Note:

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.


  1. Download the template

    Download the Adjustments Template. Select a destination folder on your computer and click Save.

  2. Enter your order refund information


    1. Open the Adjustments template you saved to your computer.
    2. 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.
    3. 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, and the feed will not process successfully without them.

    Excel formatting suggestions

    • Format your number columns as text to keep Excel from removing leading zeroes.
    • 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.
  3. Save the spreadsheet as a text file


    1. 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.
    2. In your saved Excel file, if the BatchRefunds tab containing your data is not displayed, click that tab.
    3. On the File menu (or the Office Button menu), click Save As.
    4. 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.
    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 the text file
    1. On the Orders tab in your seller account, click Upload Order Related Files, and then click the Adjustments link.
    2. Under Upload Your Adjustments File, click Browse.
    3. Browse to where you saved the tab-delimited text file and then select the file.
    4. Click Upload now.
  5. Review upload status and diagnose errors
    1. 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.

    2. 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.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

Sign in to use the tool and get personalized help (desktop browser required). Sign In


Reach hundreds of millions of customers

Start selling on Amazon


© 1999-2021, Amazon.com, Inc. or its affiliates