Cancel Multiple Orders

Individual sellers: This feature is for Professional sellers only. Learn more

If you want to cancel one or two orders, you can use the Manage Orders feature.

However, when you want to cancel multiple orders at the same time, you can use the Order Cancellation File.

You download the Order Cancellation File 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 Cancellation page.

There are five basic steps to manage your Cancellation file:

1. Download the template

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

   Order Cancellation template

2. Enter the information into the Order Cancellation template
   
   1. Open the Order Cancellation 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. The Cancellation Glossary below also contains explanations.
   3. Click the Order Cancellation tab.
      Note: This template contains validation macros that will help you complete the template correctly. The validations may be turned on or off at your discretion, but we urge you to keep them on until you learn how to use the template.
   4. Enter the information into the worksheet. For each product on the order, enter the appropriate information.

      Tips for using Excel:

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

   After you have entered your information, save the file.

   
   
   1. Save your file. You might want to use a different name for each upload, such as CancellationUpload-12-05-2005 for an upload you make on 12 May 2005.
   2. If necessary, click the Cancellation tab to display the Cancellation worksheet that contains your data.
   3. On the File menu, click Save As. The Save As dialogue box appears.
   4. In the Save As Type list, select 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 Cancellation file
   
   1. On the Orders tab, click Advanced Features and then click the Upload Order Related Files link.
   2. Click the Order Cancellation page link, if not already selected (and not a link).
   3. Under Upload Your Cancellation 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.nl, and a status box confirms your file was received.
5. Review the status of your Adjustments 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.