Sell on Amazon Sign In
This article applies to selling in: Saudi Arabia

Additional Inventory Report Formats

While the information you need to manage your inventory is also available through the standard reports as well as in your Manage Inventory section, the reports described below may be necessary for backwards compatibility to the systems you are using to manage your business.

Amazon may make the following reports available to sellers on request. While the information you need to manage your inventory is also available through the standard reports as well as in your Manage Inventory section, the reports described below may be necessary for backwards compatibility to the systems you are using to manage your business.

These reports are provided as tab-delimited text files. You can open them in any spreadsheet or database program, such as Microsoft Access or Microsoft Excel. Listing data and file columns can then be modified within the spreadsheet, and uploaded at any time using the Inventory Loader.

Note: If you have book listings, the product-id field in the below files will contain ISBNs. If you open the report in Microsoft Excel, the leading zeroes for ISBNs in the product-id column will be dropped by Excel. You can prevent this by using the import wizard and forcing the product-id column to be imported as text. See Microsoft Excel Help for more information.

Open Listings Report

The Open Listings Report contains detailed information about current open listings available for purchase at the time the report is generated. The report is similar to the Active Listings Report. An important difference is that the Open Listings Report does not show listings with a quantity of zero (0). If you need to see your SKUs with out-of-stock inventory, you should use the full Active Listings Report instead.

If you are enrolled in the Fulfillment by Amazon program, note that this report does not show the Fulfillment Channel.

Open Listings Lite and Liter Reports

These simplified versions of the Open Listings Report are useful for reconciling the price and quantity of the inventory you have for sale on the website with your own records. Because these reports are less detailed than the full report, they generate more quickly and allow you to turn around price and quantity updates faster.

The fields for each report are as follows:

Open Listings Lite Report

  • seller-sku
  • quantity
  • price
  • product ID

Open Listings Liter Report

  • seller-sku
  • quantity

Canceled Listings Report

The Canceled Listings Report contains all listings that were canceled by Amazon within the past 30 days. It does not include items that were sold out, canceled by the seller, or purged using the Inventory Loader or other inventory files.

Sold Listings Report

The Sold Listings Report contains any items sold via the Amazon website (orders fulfilled by the seller and not Fulfillment by Amazon). You can request a report for listings sold in the past 7, 15, 30, or 60 days.

Data Fields for additional inventory reports

Below is a list of fields that appear in the Open Listings Report, Canceled Listings Report, and Sold Listings Report.

Open Listings Report Canceled Listings Report Sold Listings Report
item-name item-name item-name
item-description item-description listing-id
listing-id seller-sku sku
seller-sku price price
price quantity shipping-fee
quantity image-url purchase-date
open-date item-is-marketplace buyer-email
image-url product-id-type buyer-nickname
item-is-marketplace zshop-shipping-fee date-listed
product-id-type item-note item-is-marketplace
zshop-shipping-fee item-condition quantity
item-note zshop-category1

item-condition zshop-browse-path

zshop-category1 zshop-storefront-feature

zshop-browse-path asin1

zshop-storefront-feature asin2

asin1 asin3

asin2 will-ship-internationally

asin3 expedited-shipping

will-ship-internationally zshop-boldface

expedited-shipping product-id

zshop-boldface add-delete

product-id

bid-for-featured-placement

add-delete

pending-quantity

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