A Shopify trick to count how many products there are in the store and in the collection
In the Shopify dashboard, there is no display that shows you the total number of products you have in the store, or the number of products in each collection. I think this is a pretty important feature, especially in big stores, but right now Shopify doesn't reveal this information to us.
I've seen some people recommend exporting the products in the store to a CSV file to check the number - but I think that's too slow. So here are some ways to get the number of products in your store quickly.
First I will show you how to check the number of products in the entire store, and later I will show you how to check each collection.
![]()
This can be useful at times, but it won't show you unlisted or out-of-stock products. So if you really need to know the total number of products in your store, whether they are available or not, then you should use the above method to change the URL with /count.json.
I've seen some people recommend exporting the products in the store to a CSV file to check the number - but I think that's too slow. So here are some ways to get the number of products in your store quickly.
First I will show you how to check the number of products in the entire store, and later I will show you how to check each collection.
For small stores with less than 50 products
If you have less than 50 products in the store it is quite easy. You can simply go into admin/products and click on everyone's checkbox and it will tell you how many have been selected. All this provided that your store has no more than one page about products. If there are several pages, we will not receive the total number of products in the store.
How do we check the amount of products in a large store?
So if you have a bigger store just add this to the end of your URL at .myshopify.com - /admin/products/count.json
This will bring up a page with the product count. Very convenient isn't it?
This will bring up a page with the product count. Very convenient isn't it?
Another way to do this, which is easier to remember, is to switch to all product < product So your URL now shows /admin/products?selectedView=all. Then remove the trailing part after the question mark, and instead just add /count.json.
How will we check the amount of products in the collection?
You can also do the same for collections. It's even simpler. Go to the collection in the Shopify dashboard by going to product > collection , and then switch to a single collection . The URL should now be something like "/admin/collections/270966948036".
Now just add .json to the end of the URL.
It shows you the collection information as a javascript object. But don't worry, you don't have to understand everything, just look for a line that says products_count. The number after it is the number of products in this collection.
Now just add .json to the end of the URL.
It shows you the collection information as a javascript object. But don't worry, you don't have to understand everything, just look for a line that says products_count. The number after it is the number of products in this collection.
How do we check only the products available in the store?
Another common way to check all the products in the store is to go through Settings > Sales. It shows you the number of products available. available is the key word here.This can be useful at times, but it won't show you unlisted or out-of-stock products. So if you really need to know the total number of products in your store, whether they are available or not, then you should use the above method to change the URL with /count.json.
