Sell on Amazon Sign in
This article applies to selling in: United States

Confirm multiple shipments with the Shipping Confirmation template

Individual sellers: This feature is only available to sellers with a Professional selling plan. Learn more by visiting Selling plan comparison.

Use the Shipping Confirmation template to create a shipping confirmation file. Amazon uses the information you provide to update a customer’s account information with your fulfillment data.

Download the Shipping Confirmation template.

Prepare your shipping confirmation file

After you receive an order notification and ship the order, you must confirm shipment. You can use the Shipping Confirmation template to upload confirmation information for multiple orders in a single file. This template includes validation macros that will help you successfully complete the template. You can choose whether to turn these macros on or off. We suggest that you keep them on until you learn how to use the template.

Note: If you split an order into multiple shipments, the entire order is charged and assigned the status "Payment Complete" as soon as the first shipment for the order is confirmed, even if there are more shipments yet to be made.

To prepare your Shipping Confirmation file:

  1. Download and save a copy of the Shipping Confirmation template.
  2. Open the file and review the Instructions and Data Definitions tab.
  3. On the ShippingConfirmation tab, enter your shipping information, referring to the Data Definitions tab when necessary, especially the Important Notes and formatting guidelines (Accepted Values).
    Note: Set all of the columns to text format (including ship-date) to prevent Excel from removing any leading zeroes. Enter ship-date in the following format: yyyy-mm-dd.
  4. When updating previously existing shipping 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.


                                 Example: New data in the tracking-number field will overwrite the existing data in tracking-number.
    • Do not overwrite previously existing data: A blank field will not overwrite or nullify the existing data.


                                 Example:  Leave the tracking-number blank so the previously uploaded data will remain and not be overwritten or nullified).
    • Delete previously existing data: Enter "NULL" without the quotation marks, or leave the field blank, and the data in that field will be deleted.


                                 Example: Enter "NULL" into the tracking-field or leave it blank to delete and nullify the previously uploaded 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 shipment, then you need to include the following fields for each of the shipping confirmation records:
    • order-id
    • order-item-id
    • quantity
    • carrier-code
    • carrier name (when using "Other" as carrier-code)
    • ship-date
  5. When you are finished, click 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 Yes.

Upload your shipping confirmation file

Once you have finished adding shipping information, upload your file on the Upload Order Related Files page.

To upload your Shipping Confirmation file:


  1. On the Orders link, select Upload Order Related Files.
  2. Select Shipping Confirmation at the top of the page.
  3. Under Upload Your Shipping Confirmation File, click Browse to locate your tab-delimited text file.
  4. Select the file and click Upload now.

Shipping confirmation fields

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

Field Name Definition Required Accepted Values Example
order-id Unique identifying number for an order. This number is provided in your Orders report and the Manage Orders tool. Yes Alphanumeric text, 3-7-7 format 058-3563777-5518068
order-item-id Unique identifying number for an item in an order. This number is provided in your Orders Report and on the Order Details page in Manage Orders.
Note: This is not the same as the product ASIN. The order-item-id differs from order to order.
 No Alphanumeric text, 14 characters 05835637773451
quantity Item quantity included in this order, if more than one unit of an item was ordered.
Note: If you split an order, you must include a quantity in the shipping confirmation for each shipment, so customers know how many items to expect in each package when it arrives.
 No A positive integer 1
ship-date Date on which you shipped the order. Yes Format: yyyy-mm-dd 2018-11-19
carrier-code Amazon's code for the shipping carrier that delivered the order, chosen from a drop-down menu.
Note: If you are using an unlisted carrier, select "Other" and then enter the carrier name in the carrier-name field
Yes 4PX, A-1, AAA Cooper, ABF, Asendia, Best Buy, Blue Package, Canada Post, CEVA, China Post, Conway, DHL, DHL eCommerce, Estes, FedEx, Fedex Freight, FedEx SmartPost, First Mile, Hongkong Post, Hunter Logistics, India Post, JCEX, Lasership, Newgistics, Old Dominion, OnTrac, OSM, Pilot Freight, R+L, Roadrunner, Royal Mail, Saia, SF Express, SFC, StreamLite, UPS, UPS Freight, UPS Mail Innovations, Urban Express, USPS, XPO Freight, Yanwen, Yellow Freight, Yun Express, Other USPS
carrier-name Shipping carrier that delivered the order. Use only if carrier-name is "Other." Yes, only if carrier-name is "Other." Alphanumeric text, 1 to 50 characters Roadway Express
tracking-number Shipping carrier's tracking ID for the order. No Alphanumeric text, 1 to 50 characters 22344455
ship-method Shipping method used to deliver the order. Best practice is to include the carrier name to ensure clarity. No Alphanumeric text, 1 to 50 characters First Class - UPS FedEx Ground
transparency_code The transparency code for the ASIN if it is enrolled in the transparency program. For orders with multiple units ("quantity" is greater than 1), you must provide transparency codes for each unit. No

Alphanumeric text, in 2 possible formats:

Format 1- Starts with AZ: or ZA: followed by 26 characters (total length is 29 characters).

Format 2- Serialized Global Trade Item Number (SGTIN) with total length is 38 character

Format 1 - AZ:QNZGH88J4RCWPF8EDY3ZACZKEE

or

Format 2 - 0100376204200301214P1OZMT7D8B81EMF4WW4
Note: For Premium Shipping, a valid tracking ID is required for most orders. Failure to meet the required tracking rate for Premium Shipping orders may affect your eligibility to offer Premium Shipping Options. If you sell in the Office Products or Shoes categories, you're required to provide valid tracking numbers for 95% of US shipments. For more information, see Requirements for Two-Day Shipping and Valid Tracking Rate.
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-2021, Amazon.com, Inc. or its affiliates