How can I filter out specific product types in the backend?

Technical Q&A
1

Hi,

I want to be able to create and save a filter of my products as “Product type is not XXXX”, but as far as I can tell I can only filter by “Product type is XXXX”.

FG_Adamson_Will_0-1641373309752.png
FG_Adamson_Will_0-1641373309752.png382×257 5.27 KB

Does anyone know of a way to do this?

Thanks

2

Hi,

Shopify’s product filter function works by finding and listing products according to certain terms or parameters - like “product type”. In other words, it cannot list products according to “product type is not”.

06-10-60788-90045
06-10-60788-900451107×648 34 KB

Can I ask you to tell me a little more about why you’re looking to do that so that I can better help you with a workaround?

3

Hi Hyde,

Thanks for your answer, I’ll happily share some more information in the hope we can find a workaround.

We have a custom search function in the website which allows a user to search our entire inventory using an API to our ERP system. When a user searches for a product that doesn’t exist in Shopify, our system creates a product for it using the data from our ERP system and sets it’s product type as “Unassigned”

FG_Adamson_Will_0-1641461581806.png
FG_Adamson_Will_0-1641461581806.png1625×561 37.2 KB

By nature there are many “Unassigned” products so what I want to do is to be able to filter out these “Unassigned” products to be able to more easily view our manually created products.

I’ve created a saved filter to view all “Unassigned” products using “Product type is Unassigned”, but it would be helpful to be able to do the inverse.

Many thanks,

Will

4

I suppose the simplest and quickest way would be to always add a specific tag to each manual product so that you could then search for all manual products by tag:

07-46-28172-90865
07-46-28172-908651891×748 113 KB

So you could add a tag to every manual product like “manual” and then find relevant products by filtering by “tagged with”.

The good news is that you can search by individual tags, even if you have multiple tags for each product.

If this seemed a suitable solution for you, then the way it would work is:

  1. You’d need to export your products as a CSV file
  2. Open the CSV file in Google Docs, edit the tags in the relevant column (remember that the list of tags must be wrapped in quotation marks - for example, “tag1,tag2,tag3”)
  3. and then import the CSV file again.

I hope this helps!

5

Hi Hyde,

Thank you for your suggestion, I will look into this if I can’t find anything else.

Thanks