How can I create a list of items not displayed in collections?

1 0 0

Is it possible to create a list showing items that are shown in Products but NOT showing in Collections?  I have had occasion where I am missing an item on in my Shop and when I look at the product it has no Collection assigned to it.  To save myself time and to ensure I don't miss any, a list would be so handy to have.  Any help on this would be really appreciated.  Many thanks in advance.

Replies 5 (5)

Shopify Partner
254 21 44

Hello @DaniHud , would you like to explain more about how you want to show the products that are not part of any collection? You can always visit to products tab in the Shopify dashboard and check products manually.

if you want to have a count then simply you can add every product of the store to a main collection let's say "Home Collection" and then count all other collection items. But, it has some limitations, it's only suitable if you have distinguished products in all the collections. And, if you have a product that could be in multiple collections then this will not be a suitable approach.



Osama Farooqi

Shopify Theme Developer | Contact me | Hire expert
- Was my reply helpful? Click Like 🙂 to let me know | Buy Me Coffee
- Was your question answered? Mark this as Accepted Solution
3 0 1

Not the poster...  I just want to find out what products are not in a collection so I can update the tags so that they show up in a collection.  It should be a simple canned report that shows products and collections.  I dont want to go down through over 100 products to look at each one and see if it is in a collection.

3 0 1

Even the ability to add collection column to the product list....

Shopify Partner
176 6 16

Hi @DaniHud,


Keanna here from the Better Reports support team. I would recommend our app Better Reports for this! 


We can create a custom report that shows all products which are not assigned to any collection. Our built-in 'All products' report also shows all collections each product is in so you can review product collections individually.


Better Reports offers more than 80 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. We can also help create custom reports to automate much of your daily workflows. All reports can be scheduled at a set cadence to email or Google Sheets or exported in HTML, PDF, Excel or CSV.


I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

Shopify Partner
96 13 17



Another option would be to use our Ablestar Bulk Product Editor app which can search for products with no collections:

Screenshot 2023-12-22 at 9.09.10 AM.png


Once you've identified those products you can either:


  • Click on Export to generate a CSV file of those products
  • Click on Edit Products to bulk edit the products (eg, add them all to a specific collection)
  • Click on the individual product to edit it by itself

Some apps might create Automated Collections  (a common one that we see is named "Smart Products Filter Index - Do not delete"). If you want to exclude these collections the app also has a filter for 'Not in any Manual Collection' which should work.





Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!