Amazon Seller Central Business Value
Amazon Seller Central Inventory Reports
Section 9: Sold Listings Report
The Sold Listings Report Overview
• The Sold Listings Report contains any items sold via the Amazon website.
• These are orders fulfilled by the seller or merchant, by you.
• They are not items fulfilled by Amazon.
• This is your best report to see which items you have sold and shipped yourself recently.
Creating a Sold Listings Report
• To download the 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 “Sold Listings Report” from the “Select Report Type” Drop-Down Menu provided.
• Select the number of days for your report from the Drop-Down Menu provided, namely 7, 15, 30 or 60 days.
• 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 Sold Listings Report
• Once you have downloaded and opened your Sold Listings Report, you will see the following fields or columns for each SKU that has been sold: item-name, listing-id, sku, price, shipping-fee, purchase-date, buyer-email, buyer-nickname, date-listed, item-is-marketplace and quantity.
• The “item-name” Column refers to the title of the item listed. This will be populated with Amazon catalog data.
• 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 “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 “shipping-fee” Column refers to the fee charged for shipping and this could be “0” if you offer free shipping on a listing.
• The “purchase-date” Column refers to the date the product was purchased.
• The “buyer-email” Column refers to the buyer’s email address in case you wish to contact them with regards to your listing.
• The “buyer-nickname” Column refers to the buyer’s name on the Marketplace.
• The “date-listed” Column refers to the date the product was first listed on the Markeplace.
• The “item-is-marketplace” Column refers to whether the product is in the Amazon Marketplace and will now be “y” for “Yes” on this report.
• The “quantity” Column refers to the quantity of the product that was purchased or sold.
Uses of the Sold Listings Report
• As a Fulfilled by Merchant or FBM seller, this is a great report to see which of your products you have sold and shipped from your own facilities.
• You can run a variety of reports from this report, including some planning and replenishment reports as well in order to ensure you always remain in stock for future orders, or on the other side, don’t need to order in any additional products of a certain SKU as they have not been selling.
• You can also use this report against your stock-on-hand report at the start of the month to the current one to ensure that your inventory numbers are tracking correctly.