Understanding Amazon Order Report Fields: A Complete Reference for Sellers
A comprehensive reference guide to all fields available in Amazon Seller Central's order report, covering order IDs, pricing, shipping details, business order flags, and promotional data. Essential for sellers who download and process order data for fulfillment, accounting, or system integrations.
Overview
Amazon's order report is one of the most important data exports available to sellers, providing detailed information about every transaction processed through your account. Understanding each field in this report is essential for accurate bookkeeping, efficient order fulfillment, and resolving customer service issues. This reference breaks down the key fields you'll encounter when downloading and working with order reports from Seller Central.
Key Points / What Sellers Need to Know
- Order ID and Order Item ID are distinct identifiers — The order ID (e.g., 058-3563777-5518068) identifies the entire order, while the order item ID identifies a specific product within that order. Both are required for shipping confirmation and post-order processing.
- Prices are aggregated, not per-unit — Item price, shipping price, gift wrap price, and tax fields all reflect the total amount for the quantity purchased, not the unit price. For example, if a buyer orders 2 units at $10 each, the item price field will show $20.
- Purchase date triggers your shipping obligation — Unless you've configured a different shipping lead time, you are expected to ship within two business days of the purchase date shown in the report.
- Business order fields are region-specific — Several fields related to Amazon Business customers, such as buyer company name and price designation, are only available in certain marketplaces.
- Ship-to address data spans multiple columns — The shipping address is broken across several fields including three address lines, city, state, postal code, and a two-letter ISO 3166-2 country code.
Order Identification and Dates
Every order report entry begins with core identification fields. The order ID is Amazon's unique reference number for the entire transaction, while the order item ID drills down to a specific line item within that order. The purchase date records when the buyer placed the order in yyyy-mm-dd format and serves as the starting point for your fulfillment timeline. The payments date indicates when the buyer's credit card was actually charged and order processing was completed, which may differ slightly from the purchase date. Together, these fields form the backbone of your order tracking and are essential for correlating transactions with your financial records.
Analysis & Recommendations
Why This Matters
Order reports are central to fulfillment, bookkeeping, and customer service. Misunderstanding fields — especially aggregate pricing — can lead to financial errors, missed shipping deadlines, or compliance issues with Amazon Business PO requirements.
Key Takeaways
- Item prices, shipping prices, and tax fields reflect aggregate totals for the quantity purchased, not per-unit amounts
- The purchase date triggers your shipping obligation — default is two business days unless a custom lead time is set
- Amazon Business order fields like buyer company name and price designation are only available in certain marketplaces
- Ship-to address data is spread across multiple columns with format variations by country
Recommended Actions
- →Audit your order report processing to ensure you are dividing aggregate price fields by quantity when calculating per-unit revenue
- →If you fulfill Amazon Business orders, verify that purchase order numbers are appearing on your packing slips and shipping labels as required
- →Review your default ship-from address in Seller Central shipping settings to ensure it accurately reflects in your order reports
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!