
If you’re selling print-on-demand products on Amazon using the low-hanging style, you will normally have thousands of products on your account.
I have over 100,000 products including coffee mugs, shot glasses, travel mugs, tumblers, pillowcases, and much more on my Amazon account, and I have gotten many sales from several different products.
Looks good, right? We’ve made many sales using the low-hanging style, after all.
But I recently discovered a problem; it’s quite difficult for me to pick up some niches to scale up my business.
Okay, for the top 10 or 50 selling products, I will know what niches are selling well.
But what about the rest?
My team has uploaded tons of products in over 1,000 niches, but I know only a few niches that are actually selling well.
There are many other niches that could sell well also, but I missed the chance to create more products in those niches and make more sales.
Check this out. This is my sales stats for products that are out of the top 100:

You can see that I have made sales from many different niches, such as personal trainer, veteran, lawyer, firefighter, mom, bodybuilding, chemistry teacher, etc.
These are just the stats from 15 products; there are so many other products that have made sales but I never scaled.
I never sent them to the Amazon Warehouse to gain the Unfair Advantage.
If I could find those undiscovered winning niches and try to scale them up or send some of them to the Amazon FBA, I could make a lot more sales than I do now.
So in this article, I’m going to show you the method I have just implemented last week to discover the undiscovered winning niches from my Amazon sales stats.
After reading and following what I write in this article, you’ll be able to extract your own sales stats and discover the undiscovered winning niches that may surprise you.
CAUTION: This article contains a basic programming script that you might not be understand, but you can follow the steps, copy and paste the script, and use it with your own report.
Okay, let’s get started!
The Concept
Last week, I realized that I have scaled up only a few niches, and there are so many other niches left that I need to scale.
I want to know how many sales I’ve made from each niche in the past years so that I can let my team create more products in those niches.
But it’s quite difficult to check this statistic in the Business Report provided by Amazon.
I may go to the “Detail Page Sales and Traffic”, scroll down to the end, try to CTRL+F the niche (find the keyword in the page), and check the number of the search results that way.
But that’s not effective and it’s difficult to scroll through the report to the end when you have over 100,000 products in your account.
Given that I’m a veteran programmer (who hasn’t written a code in such a long time), I tried to create a small script to read the CSV report file from Amazon and count the sales from each niche.
Luckily, it didn’t take long to finish this code.

If you’re a great programmer, please don’t judge the way I write this code, lol. It’s definitely not well-written, but I just made it quick to visualize my sales stats.
With this code, it will read the report from Amazon row by row and count the units sold from each product. It will then categorize them with the niches and show them in an easy-to-read report like this.

It will show the niche with the number of the units sold.
Now I can learn which niches sold well during the past years, and I can now create more products from these niches with optimized and specific keywords.
The Results
Well, after I ran the script, I was very surprised.
What I found is that from the 500 professional niches my team has been creating products for years, there are only around 100 niches that have produced at least 20 sales during the past two years.
This means that the other 400 niches are not performing well at all.
That’s 80% of my listing!!!
That means from the 100,000 products I have in the niches, 80% of them, or 80,000 products, have not sold well.
Many of them have made ZERO sales, and that’s not worth the investment if I still do create new products for all 500 niches.
It would be better if I created new products for only those top 100 niches.
Also, the top-10 niches are the ones that I sent them to Amazon FBA.
There are many other products from other 90 winning niches that I have never done the Amazon FBA.
If I do it, I could make a lot more sales.
I have already selected some products in my FBA list and I’ll start sending them to the Amazon Warehouse soon.
With these undiscovered winning niches, I can scale my print-on-demand business using the right products. I’m very satisfied with the results from this script.
The Code
Okay, now it’s showtime.
You can follow what I do by downloading this ZIP file and uploading it to your web server.
[Opt in Msg: Yes! Send me the code! I’ll send you the code with the CSV files to your email. You can enter your name and email here.
This form collects information that we will use to send you updates, promotions, and special offers. For more information about our privacy practices, please Click Here. By clicking below, you agree that we may process your information in accordance with these terms.
MSG: You can download the script here. Make sure to read and follow this post to properly install and run the script.]
If you don’t have a host, you can install the XAMPP (for Windows) or MAMP (for Mac) on your computer. It’s free, but it requires a bit of technical skills. Anyway, it’s not very difficult. Give it a try.
I don’t want to upload it to my own server and let you use it there, because the CSV file contains your sales stats. I don’t want to store those files on my server since it is unethical to do such a thing.
So, use it on your own server.
Now extract the ZIP file on your server. The files will look like this:

There are BusinessReport-example.csv, index.php, profession.csv, dogbreeds.csv, and catbreeds.csv in the AmazonReport folder.
The index.php is the main script. You will have to access this page when you want to run the report. The other CSV files are the niche info files, including the professions, dog breeds, and cat breeds.
If you want to check the stats on the other niches, just create the CSV file with the niches inside and upload it to the server and change the filename in the index.php.
It will be like this:

This is what’s inside the niche CSV file.

Next, download the sales report from Amazon.
Log in to your Amazon Seller account, go to “Reports” >“Business Reports” menu, and select “Detail Page Sales and Traffic”.

Set the date range. Amazon allows you to check the report for the past two years.
Then click “Download” >“CSV”. You will get the file called “BusinessReport-X-XX-XX.CSV”.
Upload it to the same folder as the script, like this:

And change the Business Report filename to be yours here.

Now you can read the sales stats for each niche in the beautiful way by accessing the URL: [YOUR URL]/AmazonReport.
If you use the XAMPP or MAMP on your computer, just enter localhost:8888/AmazonReport in the web browser. (Change the port number to yours.)
The total unit sales for each niche will be shown in order so we will know what niche we should create more products for or find some winning products and send them to Amazon FBA.
So that’s the recent method I used to discover the undiscovered top-selling niches of my print-on-demand products from the Amazon report.
You can now try the script yourself and extract the winning niches from your own report to scale up your print-on-demand business to the next level!
Let me know if you have any problem or questions about the script 🙂
—Bank K.
