Select Page

The year-end product sales report will give you product sales volume data directly from Amazon.

This critical report gives you sales by ASIN in both both dollars and units for all the products you sold on Amazon in  the previous year.

The Product Sales Report is key to answering the following questions. that answers to the following questions about your product catalog:

  • What were my top selling products?
  • Which variations are the most popular?
  • How much revenue did they generate (both consumer and business sales)?
  • How many units did I sell?
  • What were my mid, low and no selling products?
  • What should I continue to sell?

(You can use this report at any time for specific date ranges with a lookback period of up to two years)

This data is key to deciding what products to continue selling in 2020, what to expand, and what to cut.

While the Detail Page Report does provide a lot of additional data on traffic and conversion, for the purpose of product sales, we’re going to limit the report to some specific fields.

In this tutorial I’ll show you what data to pull and how to format it for the most effective use.

TO DOWNLOAD THE DETAIL PAGE REPORT BY PARENT:

  1. Go to Seller Central > Reports > Business Reports> Detail Page Sales & Traffic by Parent Item
  2. Select the date range from 1/1/2020 – 12/31/2020
  3. Uncheck all but the blue checked boxes below to run your parent report
  4. Download the CSV file to your computer

 

 

 

 

 

 

TO DOWNLOAD THE DETAIL PAGE REPORT BY CHILD:

  1. Go to Seller Central > Reports > Business Reports> Detail Page Sales & Traffic by Child Item
  2. Select the date range from 1/1/2020 – 12/31/2020
  3. Uncheck all but the blue checked boxes below to run your parent report
  4. Download the CSV file to your computer

 

 

 

 

 

 

FORMAT THE REPORTS FOR USABILITY

Your reports must be formatted in a specific way for best use.

Follow the simple instructions below to format the CSV file and save them as Excel or Google Sheets correctly.

 

  • Open in Excel or Google Sheets 
  • Sort spreadsheet by “Ordered Product Sales” Descending. This will place your top selling products at the top of the report
  • Save file as an xlsx file or import into Google Sheets
  • Name the file “detail_page_parent_Jan-Dec2020” or “detail_page_child_Jan-Dec2020”
  • Save to a folder on your computer