Vous voulez voir cette page en français ? Cliquez ici.
Search Help:

Orders Report

Individual sellers: This feature is for Professional sellers only. Learn more

An Orders Report is a tab-delimited text file that lists all items sold within a selected time period. It includes the buyer information you need to fulfill orders. (It does not include the buyer's billing address or credit card information.)

There are two ways to generate an Orders Report:

  • Scheduled reports provide you with new orders received since your last scheduled report. By default, the Order Report runs automatically every 24 hours after 11:00 p.m. Pacific Time. You can reschedule it to run more often or at a more convenient time.
    Note: Sellers who receive scheduled Order Reports via XML cannot schedule a text-file order report.
  • Manual reports include a summary of all orders received for the number of days you select, including orders you have canceled or confirmed as shipped.

Scheduled Orders Reports

A scheduled order report contains only new orders received since the last scheduled order report.

  1. Go to Orders and select Order Reports.
  2. In the Scheduled Order Report Settings section, review your current settings.
    If you are not currently received scheduled reports, this section will say so.
  3. To schedule a report or change your current settings, click the Edit button.
  4. On the Schedule Order Reports page, review your current schedule or create a new schedule If you choose Daily, select the time of day from the drop-down list.
  5. Click the Submit button.

Your new settings will be displayed in the Scheduled Order Report Settings section at the bottom of the Order Reports page.

Manual Orders Reports

Manual order reports include a summary of all orders you have received for the number of days you select, including orders you have canceled or confirmed as shipped.

  1. Go to Orders and select Order Reports.
  2. In the Request an Order Report section, from the Select Days drop-down list, select the number of days that you want to include in your report.
    Note: The days are determined working backward in 24-hour increments beginning the minute you request the report. For example, if it is 2:32 p.m. on Monday and you select "1" from the drop-down menu, you will receive a report for orders received at 2:32 p.m. Monday through 2:32 p.m. Sunday.
  3. Click the Request Report button.
    Your report will be listed in the Check Report Status & Download section at the bottom of the Order Reports page.

Downloading an Orders Report

An Order Report is formatted as a tab-delimited text file.

  1. On the Order Reports page, in the Check Report Status & Download section, click the Refresh button (on the far right) to check the status of your report.
    When your report is ready, a Download button will appear in the Download column.
  2. Click the Download button.
    A dialog box appears, giving you the option to Open or Save the file.
  3. Select Save File and select a folder location. Click OK.

Reading an Orders Report

After you download your Order Report, open it in a database or spreadsheet program, such as Microsoft Access or Microsoft Excel.

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

Information about taxes collected is included in your Order Report in the item-tax and shipping-tax fields. In some instances, your Order Report might include other tax fields, depending on your setup with Amazon Services.

The following table lists the fields contained in the Order Report. This table includes field definitions and examples.

Note: Sellers using the "Order Report (Old Version)" will see a limited number of fields.

If you have enabled reduced shipping times for Standard and Expedited shipping for your Books, Music, Video, and DVD products, four new columns will appear permanently on your Order Report: earliest ship date, latest ship date, earliest delivery date, and latest delivery date. Learn more

Field name Definition Example
order-id Amazon's unique identifying number for the order. Used for shipping confirmation and post-order processing. 058-3563777-5518068
order-item-id Amazon's unique identifying number for the item in an order. Used for shipping confirmation and post-order processing. 0583563777345
purchase-date Date the order was placed.
Note: Unless you specify a different shipping lead time, you have agreed to ship the order within 2 business days of this date.
2002-11-19
payments-date Date that the buyer's credit card was charged and order processing completed. 2002-11-19
buyer-email Buyer's e-mail address. JoeSmith@somecompany.com
buyer-name Buyer's full name. Joe Smith
sku Stock Keeping Unit. Seller-defined unique identifier for a product. sku123
product-name Short title for the product, displayed on the product detail page and in the browser title bar. Snowboard
quantity-purchased Quantity purchased. 1
item-price Price a buyer paid for the item. All amounts are aggregates of the quantity, not unit prices. 349.99
gift-wrap-price Price a buyer paid for gift wrap. All amounts are aggregates of the quantity, not unit prices.  
shipping-price Price a buyer paid for shipping. All amounts are aggregates of the quantity, not unit prices. 19.99
item-tax Tax a buyer paid connected to the item. All amounts are aggregates of the quantity, not unit prices. 9.99
gift-wrap-tax Tax a buyer paid connected to the gift wrap. All amounts are aggregates of the quantity, not unit prices.  
shipping-tax Tax a buyer connected to the shipping. All amounts are aggregates of the quantity, not unit prices. 1.99
ship-service-level Fulfillment service level paid for by the buyer when ordering the item. For example, standard or expedited. standard
recipient-name Name field of "Ship To" address. Joe Smith
ship-address-1 First line of "Ship To" address. 11 Main St
ship-address-2 Second line of "Ship To" address. Apt. 12
ship-address-3 Third line of "Ship To" address. c/o Joe's Company
ship-city City of "Ship To" address. Springfield
ship-state State or region of "Ship To" address, depending on the country of origin.
Note: U.S. state abbreviation can vary depending on how it was entered by the customer
WA
Wash.
ship-postal-code Postal code of "Ship To" address. Value depends on country of origin. 10101
ship-country International Standards Organization 2-letter country code (ISO 3166-2 compliant). US
gift-wrap-type
Type of gift wrap selected by the buyer. Christmas trees
gift-message-text Buyer's gift message. Merry Christmas!
sales-channel Website on which the buyer placed the order. Amazon.com
tax-location-code Vertex Geocode associated with the taxed location. 480330650
tax-location-city City jurisdiction in which the tax was calculated. Seattle
tax-location-county County jurisdiction in which the tax was calculated. King
tax-location-state State jurisdiction in which the tax was calculated. WA
per-unit-item-taxable-district By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-item-taxable-city By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-item-taxable-county By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-item-taxable-state By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-item-non-taxable-district By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-item-non-taxable-city By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-item-non-taxable-county By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-item-non-taxable-state By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-item-zero-rated-district By jurisdiction level, amount associated with a tax location with 0% tax.  
per-unit-item-zero-rated-city By jurisdiction level, amount associated with a tax location with 0% tax.  
per-unit-item-zero-rated-county By jurisdiction level, amount associated with a tax location with 0% tax.  
per-unit-item-zero-rated-state By jurisdiction level, amount associated with a tax location with 0% tax.  
per-unit-item-tax-collected-district By jurisdiction level, total tax collected.  
per-unit-item-tax-collected-city By jurisdiction level, total tax collected.  
per-unit-item-tax-collected-county By jurisdiction level, total tax collected.  
per-unit-item-tax-collected-state By jurisdiction level, total tax collected.  
per-unit-shipping-taxable-district By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-shipping-taxable-city By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-shipping-taxable-county By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-shipping-taxable-state By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-shipping-non-taxable-district By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-shipping-non-taxable-city By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-shipping-non-taxable-county By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-shipping-non-taxable-state By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-shipping-zero-rated-district By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-shipping-zero-rated-city By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-shipping-zero-rated-county By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-shipping-zero-rated-state By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-shipping-tax-collected-district Broken down by the jurisdiction level, total amount of tax collected.  
per-unit-shipping-tax-collected-city Broken down by the jurisdiction level, total amount of tax collected.  
per-unit-shipping-tax-collected-county Broken down by the jurisdiction level, total amount of tax collected.  
per-unit-shipping-tax-collected-state Broken down by the jurisdiction level, total amount of tax collected.  
per-unit-giftwrap-taxable-district By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-giftwrap-taxable-city By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-giftwrap-taxable-county By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-giftwrap-taxable-state By jurisdiction level, amount deemed taxable by Vertex per product/nexus setup.  
per-unit-giftwrap-non-taxable-district By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-giftwrap-non-taxable-city By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-giftwrap-non-taxable-county By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-giftwrap-non-taxable-state By jurisdiction level, amount deemed not taxable according to Vertex per product/nexus setup.  
per-unit-giftwrap-zero-rated-district By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-giftwrap-zero-rated-city By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-giftwrap-zero-rated-county By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-giftwrap-zero-rated-state By jurisdiction level, amount that is associated with a tax location with 0% tax.  
per-unit-giftwrap-tax-collected-district By jurisdiction level, total amount of tax collected.  
per-unit-giftwrap-tax-collected-city By jurisdiction level, total amount of tax collected.  
per-unit-giftwrap-tax-collected-county By jurisdiction level, total amount of tax collected.  
per-unit-giftwrap-tax-collected-state By jurisdiction level, total amount of tax collected.  
item-promotion-discount Dollar amount discounted from orders that qualify for either a dollar-off or a percent-off promotion.  
item-promotion-id Promotion ID associated with dollar-off or percent-off promotion.  
shipping-promotion-discount Dollar amount discounted from orders that qualify for free shipping.  
shipping-promotion-id Promotion ID associated with free shipping promotion.  
delivery-start-date Earliest possible delivery date.  
delivery-end-date Latest possible delivery date.  
delivery-time-zone Time zone for the delivery start and end dates.  
delivery-instructions Additional instructions for delivering to a specific location.  
order-channel Information about how an order was placed.  
order-channel-instance Information about how an order was placed.  

Seller Support

Please use the e-mail address associated with your Amazon.ca Seller account.