Confirm multiple deliveries with feeds

1. Download and save a copy of the Dispatch Confirmation template. Review the instructions on the Data Definitions tab, especially the "Accepted Values" column and any "Important Notes" below the table. Also, refer to the Dispatch Confirmation Glossary below.
2. On the Dispatch Confirmation tab, enter your delivery information. Some common tips to remember are:
   • The Dispatch Confirmation template contains validation macros to help you fill out the template correctly. The macros can be turned off, but we encourage you to keep them on if you are first learning to use the template.
   • Set all of the columns to Text format (including ship-date) to prevent Excel from removing any leading zeros.
   • Enter ship-date in the following format: yyyy-mm-dd.
   • Actual ship-from-address: The actual address from which the order was dispatched.
3. When updating previously existing dispatch information, select from the following options based on the result you want:
   • Overwrite previously existing data: New data will overwrite or replace the existing data. For example: New data in the tracking-number field will overwrite the existing tracking number data.
   • Do not overwrite previously existing data: An empty (blank) field will not overwrite or nullify the existing data. For example: Leave tracking-number blank so the previously uploaded data is not overwritten or nullified.
   • Delete previously existing data: Enter ‘NULL’ (without quotation marks) and the data in that field will be deleted. For example: Type ‘NULL’ in the tracking-number field to erase previous data.
   Note: If an order includes more than one product or more than one unit of a product, and you are splitting the order into more than one delivery, then you need to include the following fields for each of the dispatch confirmation records:

   • order-id
   • order-item-id
   • quantity
   • ship-date
     • Carrier-code
     • carrier-name (only when using ‘Other’ as carrier-code)
   • ship-from-address

   If you are dispatching to customers in the UK or EU countries from a non UK or non EU country, you must dispatch each order received under a single order number from the customer in a single delivery. You must not split a single order number into multiple deliveries or combine multiple order numbers into a single delivery as that may impact customer experience (for example, through additional tax collection) which in turn may impact your product reviews.

   If you split the deliveries for the orders dispatched to the UK or EU countries, all deliveries must be dispatched from the same country as the first dispatch. If you are unable to fulfil the second package from the same country, cancel the partial dispatch. This is because the tax collection model is determined based on the ship-from address provided for the first dispatch. Further information on situations in which Amazon is required to collect and remit taxes by third-party sellers is available here.

4. Click on Save As and select Text (Tab-delimited) (*.txt) from the file type list. If you see a warning that the selected file format does not support workbooks containing multiple worksheets, click on Yes.
5. In Seller Central, from the Orders menu, select Upload Order Related Files.
6. On the Shipping Confirmation tab, under Upload Your Shipping Confirmation File, click on Browse.
7. Locate your saved template, select the file and click on Open.
8. Click on Upload Now to upload your file to Amazon.

Not all fields are required. However, it is in your best interest to provide as much information as possible.