Amazon Seller Central Business Value
Amazon Seller Central Inventory Reports
Section 5: Open Listings Report
The Open Listings Report Overview
• The Open Listings 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 as explained in the Seller Central Catalog Management Course.
• The Open Listings Report is similar to the Active Listings Report, however, an important difference is that the Open Listings Report does not show listings with a quantity of zero (0), whereas the Active Listings Report does, therefore, if you need to see your SKUs with out-of-stock inventory, you should use the full Active Listings Report instead.
• The Active Listings Report also shows which SKUs are seller fulfilled and which are Amazon fulfilled so, if you are enrolled in the Fulfillment by Amazon program, note that Open Listings Report does not show the Fulfillment Channel.
Creating an Open Listings Report
• In order to Create the Open Listings Report, select “Inventory Reports” from the Drop-Down Menu of the “Inventory” tab on the top menu of Seller Central.
• On the next page, select “Open Listings Report” from the “Select Report Type” Drop-Down Menu provided.
• Should you wish to customize your report first, click the “Customize the columns for this report” link.
• On the following page, select your Report Type from the Drop-Down Menu provided.
• Select the Group you wish to run the report for from the available Drop-Down Menu.
• Select the field you wish to add from the table of Available Attributes to the left of the page and click the “Add” button in between the two tables.
• This field will then appear in the table to the right of the page.
• You can opt to remove one of the fields you have added by clicking on it in the right table and clicking the “Remove” button in between the two tables.
• The field you removed will then appear in the left side table.
• You can also choose to add all the available attributes by clicking the “Add all” button in between the two tables.
• You can choose to start over by clicking the “reset” button at the bottom right side of the page.
• Once you are happy with your column selections, click the “Save” button at the bottom right of the page.
• Return to your Inventory Reports page by clicking the “Inventory Reports” link at the top left of the page.
• Here you will now see the word “Custom” in brackets alongside your “Open Listings Report” from the Drop-Down Menu alongside the Report Type.
• You can now click the “Request Report” button.
• Your report will appear in the table below with a “Pending” status.
• Once it is ready to be downloaded, the status will change to “Ready” and you will see the “Download” link has become live.
• Click on this “Download” link and download your report to your computer as needed.
Understanding the Open Listings Report
• Once you have downloaded and opened your Open Listings Report, you will see the following fields or columns: item-name, item-description, listing-id, seller-sku, price, quantity, open-date, image-url, item-is-marketplace, product-id-type, zshop-shipping-fee, item-note, item-condition, zshop-category1, zshop-browse-path, zshop-storefront-feature, asin1, asin2, asin3, will-ship-internationally, expedited-shipping, zshop-boldface, product-id, bid-for-featured-placement, add-delete and pending-quantity.
• The unused fields are provided for backwards compatibility to allow sellers who originally integrated their business using these fields to continue with their current software programs.
• If you do not need any of these fields, you may simply delete the columns from your downloaded report.
• The “item-name” Column refers to the title of the item listed. This will be populated with Amazon catalog data.
• The “item-description” Column is used for backwards compatibility only.
• The “listing-id” Column refers to an identifier created by Amazon when you create a listing. It normally consists of 4 digits, a capital letter, and 6 more digits.
• The “seller-sku” Column refers to the Stock Keeping Units (SKUs), which are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller.
• The “price” Column refers to the price you are asking for the product.
• The “quantity” Column refers to the quantity of the product available for purchase and this will never be a zero value so do not rely on this report to show you out-of- stock inventory.
• The “open-date” Column refers to the date the listing was created.
• The “image-url” Column refers to the specific URL where the main image is kept.
• The “item-is-marketplace” Column refers to whether the product is in the Amazon Marketplace and will obviously always be “y” for “Yes” or “n” for “No”.
• The “product-id-type” Column refers to a numeric entry that indicates if the product-id is an ASIN, ISBN, UPC, or EAN code/number. When uploading files in Standard Book format, this field value will default to 2 (ISBN) unless otherwise specified. You would need to be familiar with which numeric entry pertains to which product ID type, namely:
* 1 = ASIN
* 2 = ISBN
* 3 = UPC
* 4 = EAN
• The “zshop-shipping-fee” Column is used for backwards compatibility only.
• The “item-note” Column refers to your description of the listing.
• The “item-condition” Column refers to your condition code for the listing and you would need to be familiar with which numeric entry pertains to which condition, namely.
* 1 = Used; Like New
* 2 = Used; Very Good
* 3 = Used; Good
* 4 = Used; Acceptable
* 5 = Collectible; Like New
* 6 = Collectible; Very Good
* 7 = Collectible; Good
* 8 = Collectible; Acceptable
* 10 = Refurbished
* 11 = New
• The “zshop-category1” Column is used for backwards compatibility only.
• The “zshop-browse-path” Column is used for backwards compatibility only.
• The “zshop-storefront-feature” Column is used for backwards compatibility only.
• The “asin1” Column is not used and the field is populated with the product-id.
• The “asin2” Column is used for backwards compatibility only.
• The “asin3” Column is used for backwards compatibility only.
• The “will-ship-internationally” Column refers to whether your product is available to customers outside of the current country and you would need to be familiar with which numeric entry pertains to which type of shipping, namely:
* 1 = listings that are available only to customers in the U.S.
* 2 = listings that are available to customers outside of the U.S.
• The “expedited-shipping” Column refers to types of shipping available for your product and you would need to be familiar with which term or letter refers to which type of expedited shipping, namely:
* Second = listings that are available for second day shipping to U.S. domestic addresses
* Next = listings that are available for next day shipping to U.S. domestic addresses
* Same = listings that are available for same day shipping to U.S. domestic addresses
* n = not offered
• The “zshop-boldface” Column is used for backwards compatibility only.
• The “product-id” Column refers to the ASIN, ISBN, UPC, or EAN for the item.
• The “bid-for-featured-placement” Column is used for backwards compatibility only. The “add-delete” Column will be empty in the report as it enables you to use an Open Listings Report to update online inventory.
• The “pending-quantity” Column refers to the quantity of the item that is pending purchase at the time of the report.
Uses of the Open Listings Report
• You can use the Open Listings Report if you have up to 50,000 listings.
• If you have more than 50,000 listings, you must use the Inventory Report as mentioned previously.
• This report is a more comprehensive report for those wishing to look at shipping and condition for each currently active and in-stock SKU, especially if you are looking to discontinue some SKUs and need to see how many are still in stock without being hampered by the “0” value fields you would find in the Active Listing Report.