Sell on Amazon Sign in
This article applies to selling in: India

Download an Order Report

Watch this video to know about order reports.

Watch this video in other language: Hindi

Overview

An Order Report is a tab-delimited text file that provides a summary of your orders. There are two ways to generate an order report: you can schedule reports or you can generate them manually.

Scheduled reports include the seller-fulfilled new orders received since your last scheduled report was run. By default, the order report runs automatically every 24 hours after 11:00 p.m. GMT, but you can reschedule it to run more often or at a more convenient time.

Reports that you request manually will include a summary of all seller-fulfilled orders that you have received for the number of days you select, including orders you have cancelled or confirmed as shipped.

Note that an order may take up several lines in your report. When all of the order information will not fit on one line, such as when several promotions were applied to an order, we split the information over several lines. We indicate that the extra lines are a continuation of the same order information by leaving most of the columns blank.

Note: Sellers who receive their scheduled Order Reports via XML cannot schedule a text-file order report.

Schedule an Order Report

  1. On the Orders tab, click the Order Reports link.
  2. In the Scheduled Order Report Settings section, you can review your current settings. Click the Edit button to change your settings. The Scheduled Order Reports page appears.
  3. In the New Schedule box, you can select from several frequency options:
    • None
    • Every 4 hours
    • Every 8 hours
    • Daily (Choose your preferred time of day from the drop-down list.)
  4. Click Submit to return to the Order Reports page. Your new settings display in the Scheduled Order Report Settings section.

Manual request

  1. On the Order Reports page, select New Orders.
  2. In the Request an Order Report section, select the number of days you would like to include.
  3. Click the Request Report button. A status box appears at the top of the page to confirm your request. The report and its production status appear in the Check Report Status & Download section.
    Note: If no reports are generated, then your reports list will be blank. You must generate a report to download a report.

Download the Order Report

After you generate a report, you can pick up the report from a list of generated reports.

  1. On the Download Order Report page, in the Check Report Status & Download section, find the report you wish to download. If it is ready, a Download button will be available.
  2. Click the Download button. The Save As dialogue box appears.
  3. Pick a folder location and click Save.

How to read an Order Report

After you download the order report, you can open it in any database or spreadsheet programme, such as Microsoft Access or Microsoft Excel. The scheduled order report contains all new orders since the last scheduled order report ran.

There may be several rows for an individual order in your report. If all of the order information does not fit on one row (such as when multiple promotions are applied to an order), the information is split over multiple rows.

If you use Amazon’s optional services, item tax, gift wrap tax and shipping tax amounts collected by you will be shown in the Order Report. Additional information regarding taxes collected by you can be found in the Sales Tax report in the Tax Document Library.

Note:

A manually-generated order report contains all orders in the time range requested, even if the order was reported on a previous order report.

The order report does not include your customer's address or credit card information. The only customer information contained in the Order Report are the ship-to address, billing name and billing e-mail.

Amazon passes on the address as your customer supplied it when the order is submitted and does not perform address correction for your customer's address.

See the following table for the most important fields in your order report with definitions and examples.

Field name Definition Example
order-id Amazon's unique identifying number for an order. This important number is a reference for shipping confirmation and post-order processing. 736-3563777-5518068
order-item-id Amazon's unique identifying number for an item in an order. This important number is used as a reference for shipping confirmation and post-order processing. 0583563777345
purchase-date The date the order was placed. Unless you specify a different shipping lead time, you have agreed to ship the order within two days (excluding Sundays and Public Holidays) from this date. 19-11-2012
payments-date The date that your buyer's credit card was charged and order processing was completed. 19-11-2012
buyer-name The full name of the buyer of your item. Ramesh Patil
buyer-email The e-mail address of your buyer. ramesh@somecompany.in
sku Your seller-defined unique identifier for the product. sku123
item-name The short title for the product, displayed in bold on the product's detail page and in the title bar of the browser window. Snowboard
quantity-purchased The quantity of the item purchased 1
currency The currency used for the transaction. INR
item-price The amount that your buyer paid for the item. All amounts are aggregates of the quantity, not unit prices. 349.99
shipping-price The amount that your buyer paid for shipping. All amounts are aggregates of the quantity, not unit prices. 19.99
ship-service-level The fulfilment service level that your buyer selected when ordering the item – can be "standard" or "expedited" (expedited shipping option will be added soon). standard
recipient-name Name field of the "Ship to" address. Ramesh Patil
gift-wrap-price Price your buyer paid for gift wrap. All amounts are aggregates of the quantity, not unit prices.
item-tax Tax calculated on the item sold by you .All amounts are aggregates of the quantity, not unit prices.
gift-wrap-tax Tax calculated on the monetary amount charged for gift wrap price collected by you. All amounts are aggregates of the quantity, not unit prices.
shipping-tax Tax calculated on the monetary amount charged for shipping of goods sold by you. All buyer amounts are aggregates of the quantity, not unit prices.
ship-phone-number Your buyer's telephone number.
gift-wrap-type Type of gift wrap selected by your buyer.
gift-message-text Your buyer's gift message.
sales-channel The marketplace in which the order was placed. Amazon.in
item-promotion-discount Promotion discount applied to the order item.
item-promotion-id Promotion ID associated with money-off or percent-off promotion.
ship-promotion-discount Promotion discount applied to shipping.
ship-promotion-id Promotion ID associated with free shipping promotion.
delivery-start-date Earliest possible delivery date.
delivery-end-date Latest possible delivery date. 11 Main St
delivery-time-zone Time zone for the delivery start and end dates. For example, PST or CDT.
delivery-Instructions Additional delivery instructions.
order-channel The sub channel through which a sale was made for CBA/WBA orders
order-channel-instance Information about how an order was placed.
ship-address-1 The first line of the "Ship to" address.
ship-address-2 The second line of the "Ship to" address. Apt. 12
ship-address-3 The third line of the "Ship to" address. c/o Ramesh's Company
ship-city The city for the "Ship to" address. Bangalore
ship-state The state or region of the "Ship to" address. The value depends on the country of origin. Note: the state abbreviation can vary depending on how it was entered by your customer KA
ship-postal-code The post code of the "Ship to" address. The value depends on the country of origin. 560055
ship-country The international standard two-letter country code (ISO 3166 compliant). IN
fulfilled-by Identifies Easy Ship orders from all other orders. It contains the value "Easy Ship" across all the Easy Ship orders

Shipment Status Identifies Easy Ship order status. Completed orders will show final order status like Delivered to buyer, Rejected by buyer, Returned to seller, Undeliverable etc. Pending Orders which have been scheduled for pick up will show Waiting for pickup or Picked up status Waiting for pickup

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-2022, Amazon.com, Inc. or its affiliates