Amazon Seller Central Business Value
Amazon Seller Central Inventory Reports
Section 6: Cancelled Listings Report
Cheat Sheet
The Cancelled Listings Report Overview
• The Cancelled Listings Report contains all listings that were cancelled by Amazon within the past 30 days.
• It does not include items that were sold out, cancelled by you, the seller, or purged using the Inventory Loader or other inventory files.
• Amazon may have a number of reasons for cancelling listings but you won’t be able to investigate these reasons unless you know which listings Amazon has cancelled and this report will help you do just that!
Creating a Cancelled Listings Report
• To create a Cancelled 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 “Cancelled 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 “Cancelled 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 Cancelled Listings Report
• Once you have downloaded and opened your Cancelled Listings Report, you will see the following fields or columns for each SKU that has been cancelled by Amazon in the past 30 days: item-name, item-description, seller-sku, price, quantity, 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, and add-delete.
• 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 “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.
• 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 now be “n” for “No” on this report as it has been cancelled by Amazon.
• 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 “add-delete” Column will be empty in the report as it enables you to use an Open Listings Report to update online inventory.
Uses of the Cancelled Listings Report
• As mentioned in a previous video, this report is the ideal snapshot of which items or listings Amazon has cancelled from your catalog.
• It wouldn’t help you if you thought you were selling something on Amazon but meanwhile Amazon has cancelled it for whatever reason.
• Using this report, you can track which products Amazon has cancelled and then know exactly which listings to open a case with Amazon for on why these listings or SKUs were cancelled in order for you to remedy them and have them reinstated.