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.
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.
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:
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.
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.
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 |