Download an inventory report
Inventory reports are snapshots of your listing information on Amazon. The reports show the items that you have listed on Amazon at the time the report is run.
Since customers can purchase your products at any time, the quantities in an inventory report are at best a spot check of your saleable inventory. It may be out of date almost as soon you request it. To reconcile your inventory levels, compare your Amazon orders and inventory reports to your own inventory records.
Inventory reports
Sellers with Professional selling accounts can download inventory reports.
Request and download an inventory report
To request an inventory report, follow these steps:
- Go to Inventory and select Inventory Reports.
- Select the report type from the drop-down menu. See the list of report types below.
- Click the Request Report button.
Reports generally take 15 to 45 minutes to generate. You can return to this page later to access your completed report.
- Under Check Report Status & Download, when the report status is "Ready", click the Download button.
- Save the file to your local computer in text (tab delimited, *.txt) format.
- Open the report in a spreadsheet or database program, such as Microsoft Excel or Microsoft Access.
Types of reports
Inventory Report
This report is a summary of the products that you have available for sale to buyers on Amazon. The report provides the SKU, price, quantity and ASIN for each of your current offers.
You can use the Inventory Report to reconcile your Amazon listings with your available stock and your own records. This is a good way to check the accuracy of your own systems.
Use the Inventory Report if you have more than 50,000 open listings. To maintain fair usage of Amazon's system, do not request more than four Inventory Reports per day. If you have more than 500,000 listings, do not request more than one inventory report per day.
For more information, see How to read an inventory report.
Open Listings Report
This report contains any current merchant-fulfilled open listings available for purchase at the time you request the report. Amazon-fulfilled listings are not included in this report. You can modify and update listings in the spreadsheet, and then upload it using the Inventory Loader.
Open Listings Lite and Open Listings Liter Reports
These are scaled-down versions of the standard Open Listings Reports, for quickly updating your inventory. 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
Active Listings Report
This report provides a snapshot of all the products you have listed on Amazon at the time the report is run. This report includes all of your product listings, including those with zero (0) quantity. It also provides you with information about the products your listings are matched to on Amazon, including the product title and product identifier.
In most cases, the ASIN is returned as the product-ID for the listing, but the product-ID may also be the industry standard identifier, such as the ISBN, UPC or EAN.
The Active Listings Report includes details about each listing, including condition, item-note, and BMVD shipping settings. If you are enrolled in Fulfilment by Amazon (FBA), the report includes an additional column for the fulfilment channel: seller fulfilled or Amazon fulfilled.
This report allows for easy restocking by showing SKUs with zero (0) inventory. If you continue to sell those items, you can restock your listings without resubmitting product data for the SKU or creating a new SKU. If you don't expect to offer the item again and want to eliminate the SKU from your report, you can delete it via the Manage Inventory tool or by using an inventory file upload.
You can use the Active Listings Report if you have up to 50,000 listings. If you have more than 50,000 listings, you must use the Inventory Report.
For more information, see How to Read an Active Listings Report.
Inactive Listings Report
This report is similar to the Active Listings Report, except it provides a snapshot of all products that are inactive. This includes listings that have zero (0) quantity, listings that are blocked, listings that are suppressed, listings that are not yet opened, and listings that are past their sale end date.
The columns included are the same as the Active Listings Report, as referenced here: How to Read an Active Listings Report.
All Listings Report
This report is similar to the Active Listings Report, except it provides a snapshot of all products for a specific merchant. This report includes listings that are active, inactive and incomplete.
The columns included are the same as the Active Listings Report, as referenced here: How to Read an Active Listings Report.
Referral Fee Preview Report
This report contains information about listings available for purchase at the time you request the report. For each listing, the report provides the estimated referral fee based on your current listed item price. It does not account for shipping or gift wrap charges applied at the time of purchase.
For more information, see How to Read a Referral Fee Preview Report.
Cancelled Listings Report
This report contains all listings that Amazon has cancelled. It does not include items that are sold out, purged with Inventory Loader or cancelled by the seller.
Sold Listings Report
This report contains any items sold on Amazon.
Amazon Fulfilled Inventory Report
You will see this report option only if you use Fulfilment by Amazon (FBA). The report provides a near-real-time snapshot of your FBA inventory. If you offer items on multiple sales channels, it can help you make quick decisions about updating inventory quantities or removing listings from Amazon.
Listing Quality and Suppressed Listing Report
This report covers those of your listings that have listing quality errors. If the errors are sufficiently severe, the listing will be suppressed (hidden) from search and browse until you fix it. For more information, see Enhance your Listings and Suppressed Listings.
To view a list your inventory, you first generate, then download, the report. This report must be generated manually; it is not scheduled to run automatically.
- On the Reportstab, use the drop-down to select the Inventory Reports page.
- On the Inventory Reports page, click Request a Report to initiate a new request.
A status box appears confirming your request and begins processing your inventory information to produce the report. Please note that this can take up to 45 minutes to complete.
- Under Check Report Status & Download you can view the status and availability. Reports are not generated immediately. Typically, report requests take 15-45 minutes to complete. If you have a very large number of listings, your report could take longer. You will need to return to this page later to pick up your completed report.
You can use the Refresh button in the bar of the Check Report Status & Download section to get the most recent status of your request.
How to download an Inventory Report
On the Download Inventory File page, in the Check Report Status & Download section, click the Download button to retrieve a report.
Your browser will typically give you a choice of opening the file directly in an application, or saving it to disk. We recommend you save the file to disk for viewing offline. Give the file a meaningful name. If you add a ".csv" file type to the name, it will open automatically from Excel or other spreadsheet programmes when you open it.
Download Advertised Inventory Report
The Advertised Inventory Report is a downloadable tab-delimited .txt file that provides a list of Product Ads that were uploaded successfully. To access the Advertised Inventory Report, follow the steps below:
- From the Inventory tab in Seller Central, click Download Inventory File.
- From the Select Report Type: drop-down menu, select Advertised Inventory Report.
Request Report
Click the "Request Report" button. The Check Report Status & Download table below will display the type of report requested and the status.
Note: Generating an Inventory Report can take as long as 45 minutes depending on the number of Product Ads you have listed.
Once the report has been generated, the status will display "Processing Complete." Click the "Download" button and select a location on your hard drive the file as a tab-delimited text file.
Product Report in Excel
You can now open the file in Excel or similar spreadsheet application. It includes a list with the ASIN, name, description, and Product Ads category for each successfully uploaded product. In addition, the report lists the product SKU, price, listing date, URL, and condition. If you need to make any changes just update your Product Ads feed and re-upload.
