发放多笔退款

注意: 个人卖家: 此功能仅适用于专业销售计划。了解更多信息。


要同时为多个订单发放全部或部分退款或进行杂费盘点,请使用盘点模板提交退款。

如果您愿意,可在管理订单中一次性发放退款。有关更多信息,请参阅发放退款。

下载并保存盘点模板。

要准备并上传盘点文件,请按下列步骤操作:

  1. 打开盘点模板并查看【说明】和【定义】选项卡,尤其是重要备注和格式要求。另请参阅下列术语表。此模板包含验证宏,可帮助您正确填写模板。您可以关闭验证宏。但我们建议您在学会如何使用模板之前保持开启。

  2. 在 Excel 文件中选择【盘点】选项卡。


  3. 为要退款的每个订单输入信息:

    • 除促销相关字段外,盘点文件中的所有字段为必填字段。如果您未提供促销,请从文件中删除促销字段,否则文件无法成功上传。

    • 订单编号(订单-编号)中须包含连字符。若不含连字符,上传数据无法成功处理。

    • 将数字列的格式设为文本,以防止 Excel 删除前置零。

    • 将日期列的格式设为 yyyy-mm-dd。


  4. 在 Excel 文件菜单上选择【另存为】。

  5. 在【保存类型】下拉菜单中,选择【文本文件(制表符分隔)(*.txt)】。

  6. 浏览至您想要将文件保存至电脑上的位置,然后点击【保存】。

    • 如果您看到一条警告,提示所选文件格式(以制表符分隔的文件类型)不支持包含多个工作表的工作簿,请点击【是】。

    • 如果您看到一条警告,提示您的文件含有与所选文本(制表符分隔)文件格式不兼容的功能,请点击【是】。


  7. 在卖家平台上,转至【订单】,然后选择上传订单相关文件。

  8. 在 2.上传盘点文件中,选择【浏览】找到您的盘点文件。

  9. 点击【上传】,将您的盘点文件上传至亚马逊。


检查【上传订单相关文件】页面的【查看文件状态和历史记录】部分,监控您的上传状态。点击【刷新】按钮查看最新状态。上传完成后,状态: 已完成以及错误数量(如有)将出现在【状态/结果】列中。

如果出现任何错误,点击【查看处理报告】,诊断和纠正上传文件中的错误。了解如何查看处理报告


注意: 字段名必须包含连字符。

字段名定义可接受值示例
order-id亚马逊在订单报告中为订单提供的唯一可显示编号。字母数字文本,格式为 ###-#######-#######。123-1234567-1234567
订单商品编号亚马逊在订单报告中为订单提供的唯一可显示编号。字母数字文本,14 个字符。12345678901234
盘点原因代码退款或盘点的原因。从右侧的枚举列表中选择。从以下选项中选择一项:
  • NoInventory

  • CustomerReturn

  • GeneralAdjustment

  • CouldNotShip

  • DifferentItem

  • Abandoned

  • CustomerCancel

  • PriceError

CustomerReturn
商品价格盘点退还给买家的商品金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额(如重新入库费)。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。22.49
运费盘点针对商品配送而退给买家的金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。4.99
商品税费盘点退还给买家的商品税费金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。2.25
运费税盘点退还给买家的商品运费税的金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。0.50
礼品包装价格盘点针对商品礼品包装而退给买家的金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。4.99
礼品包装税费盘点退还给买家的商品礼品包装税的金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。0.45
商品促销盘点商品促销要退还的金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。2.25
商品促销编号卖家指定的促销编号。字母数字文本,最多 80 个字符。FREESHIPHOLIDAY
配送促销盘点商品配送促销要退还的金额。所有金额均为相应数量商品的费用总和,而非单价。金额已签收:向买家退还正数金额,收取负数金额。您可以在买家批准的金额内进行盘点,但任何盘点都不得超过授权金额。一个数值,小数点前最多 20 位,小数点后最多 2 位(必须)。请勿使用逗号,而且小数点后必须包含 2 位数。1.75
配送促销编号卖家指定的促销编号。字母数字文本,最多 80 个字符。DOLLAROFFPROMO
已取消数量正在盘点订单商品的取消数量。正整数。1
货币盘点时使用的货币代码。这必须与盘点订单的货币代码相同。从以下选项中选择一项: USD、GBP、EUR、JPY、CADUSD


亚马逊官网原文详情:  

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 Issue a refund.

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. Select the Adjustments tab in the excel file.


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


  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 Seller Central, go to Orders and select Upload Order Related Files.

  8. Under 2. Upload Your Adjustments File, select 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 Upload Order Related Files page. Click the Refresh button 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 nameDefinitionAccepted ValuesExample
order-idAmazon's unique, displayable identifier for an order, provided in your OrderReport.Alphanumeric text formatted as ###-#######-#######.123-1234567-1234567
order-item-idAmazon's unique, displayable identifier for an item within an order, provided in your OrderReport.Alphanumeric text, 14 characters.12345678901234
adjustment-reason-codeThe reason for the refund or adjustment. Select from the enumerated list at right.Select one of the following:
  • NoInventory

  • CustomerReturn

  • GeneralAdjustment

  • CouldNotShip

  • DifferentItem

  • Abandoned

  • CustomerCancel

  • PriceError

CustomerReturn
item-price-adjThe amount refunded to the buyer for the item. All 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 (e.g., restocking fees). Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.22.49
shipping-price-adjThe amount refunded to the buyer for the item's shipment. All 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. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.4.99
item-tax-adjThe amount refunded to the buyer for the item tax. All 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. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.2.25
shipping-tax-adjThe amount refunded to the buyer for the item's shipment tax. All 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. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.0.50
gift-wrap-price-adjThe amount refunded to the buyer for the item's gift wrap. All 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. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.4.99
gift-wrap-tax-adjThe amount refunded to the buyer for the item's gift wrap tax. All 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. Adjustments can be made within the amount authorized by the customer but, no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.0.45
item-promotion-adjThe amount to be refunded for the item's promotion. All 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. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.2.25
item-promotion-idMerchant-specified promotion ID.Alphanumeric text, up to 80 characters.FREESHIPHOLIDAY
ship-promotion-adjThe amount to be refunded for the item's shipping promotion. All 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. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.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. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.1.75
ship-promotion-idMerchant-specified promotion ID.Alphanumeric text, up to 80 characters.DOLLAROFFPROMO
quantity-cancelledQuantity cancelled of the order-item being adjusted.A positive integer.1
currencyThe currency code for the adjustments. This must be the same as the currency code for the adjusted order.Select one of the following: USD, GBP, EUR, JPY, CADUSD

 文章来源:亚马逊官方网站