How to Confirm Multiple Shipments Using Amazon's Shipping Confirmation Template
Amazon's Shipping Confirmation template lets Professional sellers bulk-confirm shipments for multiple orders via a single file upload, with specific formatting rules and field requirements that affect account health metrics.
Overview
Amazon provides a bulk Shipping Confirmation template that allows Professional sellers to confirm shipment details for multiple orders at once. Instead of manually confirming each order individually through Seller Central, this template lets you upload fulfillment data for numerous orders in a single file. Understanding how to use this tool correctly is essential for maintaining good account health and meeting Amazon's tracking requirements.
Key Points / What Sellers Need to Know
- Professional plan required — The bulk shipping confirmation template is only available to sellers on a Professional selling plan. Individual sellers cannot access this feature.
- Split shipment billing — When you divide an order into multiple shipments, Amazon charges the customer and marks the entire order as "Shipped" as soon as the first shipment is confirmed, even if additional packages have not yet been sent.
- Tracking numbers matter for account health — Amazon requires valid tracking IDs for most orders. Failing to meet the required tracking rate for seller-fulfilled orders can affect your eligibility to offer certain shipping options.
- Category-specific tracking rules — Sellers in certain categories are required to provide valid tracking numbers for at least 95% of US shipments.
- Template includes built-in validation — The file comes with macros that help catch errors before you upload. Amazon recommends keeping these enabled while you learn the process.
How the Template Works
To get started, download and save a copy of the Shipping Confirmation template from Seller Central. The file contains multiple tabs including an instructions tab, a data definitions tab, and the main Confirmation tab where you enter your shipment details. Before entering any data, format all columns as text to prevent spreadsheet software from stripping leading zeroes from tracking numbers or order IDs. Ship dates must follow the yyyy-mm-dd format. Once your data is complete, save the file as a tab-delimited text file with a .txt extension.
Required and Optional Fields
The template includes several fields, though not all are mandatory. The is the unique identifier for each order, formatted in a 3-7-7 pattern such as 058-3563777-5518068. The is a 14-character identifier for a specific item within an order and should not be confused with the product ASIN, as it changes from order to order. The field indicates how many units are included in the shipment. The records when you actually shipped the package. The is selected from a dropdown list of supported carriers including major providers like UPS, USPS, DHL, and FedEx. If your carrier is not listed, select "Other" and enter the carrier name in the field. The field accepts the carrier's tracking ID, and the field describes the delivery method used. There is also a field for products enrolled in Amazon's Transparency program, which requires a code for each individual unit in multi-quantity orders.
Analysis & Recommendations
Why This Matters
Properly confirming shipments protects your account health and shipping eligibility. High-volume sellers save significant time with bulk uploads, and understanding the data fields prevents costly errors that can confuse customers.
Key Takeaways
- The bulk shipping confirmation template is only available to Professional plan sellers
- Split orders are marked as Shipped and fully charged after the first shipment is confirmed
- All columns must be formatted as text to prevent data loss from leading zeroes being stripped
- Valid tracking numbers are required for most orders and at least 95% of US shipments in certain categories
Recommended Actions
- →Format all template columns as text before entering data, and always use yyyy-mm-dd for ship dates
- →Keep the template's built-in validation macros enabled until you are fully comfortable with the process
- →Monitor your tracking rate in Account Health to ensure you meet the 95% threshold for applicable categories
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!