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.
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.
There are five basic steps to manage your Cancellation file:
-
Download the template
Click the link below to download a template. Select a destination folder on your computer and click Save.
Order Cancellation template
-
Enter the information into the Order Cancellation template
-
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.
-
Review the Instructions and Definitions sheets, particularly the important notes and
formatting requirements. The Cancellation Glossary below also contains
explanations.
-
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.
-
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.
-
Save your Order Cancellation file
After you have entered your information, save the
file.
-
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.
-
If necessary, click the Cancellation tab to display the
Cancellation worksheet that contains your data.
-
On the File menu, click Save As. The Save As dialogue box
appears.
-
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.
-
You might see a warning that the selected file format (the tab-delimited file type)
does not support workbooks containing multiple worksheets. Click
Yes.
-
You might see a warning that your file contains features, incompatible with the
selected Text (Tab delimited) file format. Click Yes.
-
Upload your Cancellation file
-
On the Orders tab, click Advanced
Features and then click the Upload Order Related
Files link.
-
Click the Order Cancellation page link, if not
already selected (and not a link).
-
Under Upload Your Cancellation File, click Browse. The
Choose File dialogue box appears.
-
Browse to the location where you saved the tab-delimited text file; then, select the
file.
-
Click Open. The file path and file name appear in the Browse
box.
-
Click Upload now. The file is uploaded to
Amazon.nl, and a status box confirms your file was received.
-
Review the status of your Adjustments File upload
-
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.
-
Click the Refresh button in the bar to see the most recent
status of your upload.
-
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.