Sell on Amazon Sign in
This article applies to selling in: Brazil

Issue Multiple Refunds

Note: Individual sellers: This feature is available for Professional selling plans only. Learn more

To issue full or partial refunds, or to make miscellaneous adjustments, for multiple orders at one time, submit refunds with the Adjustments Template.

If you prefer, you can issue refunds one at a time in Manage Orders. For more information, see Refunding Orders.

Download and save the Adjustments Template.

To prepare and upload the Adjustments file, follow these steps:

  1. 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.
  2. 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.
    • The hyphens in order numbers (order-id) are required. The feed will not process successfully without them.
    • Format your number columns as text to keep Excel from removing leading zeros.
    • Format the date columns as yyyy-mm-dd.
  3. Select the BatchRefunds tab.
  4. On the Excel File menu, select Save As.
  5. In the Save as type drop-down list, select Text (Tab delimited) (*.txt).
  6. 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.
  7. On the Orders link in your seller account, select Upload Order Related Files, and then click the Adjustments link.
  8. Under Upload Your Adjustments File, click Browse to locate your Adjustments file.
  9. 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

Note: Field names must include the hyphens.


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.

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), 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-2022, Amazon.com, Inc. or its affiliates