Watch this video to know about order reports.
Watch this video in other language: Hindi
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.
After you generate a report, you can pick up the report from a list of generated reports.
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.
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.
|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 firstname.lastname@example.org|
|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|