How to remove sold products from a collection in Prestige theme?

Please can someone tell me how I can remove the sold products within a collection which has conditions set.

I would like the collection to include products that match the product tags selected however I do not want to display sold products within the collection. I am using PRESTIGE theme.

As you can see in this screenshot I have included products with the relevant tags but it is showing sold products in the collection which I do not want. The reason I have sold products active in my store is for an Archive collection.

Hi @Ellibelle ,

You can add another condition to the collection[Inventory > 0]. This way if any of the product is soldout it will not display

Thanks for your reply.

I have tried this but then the collection will be filled with all products in my store because the products will match any condition not all conditions.

Hi @Ellibelle ,

You are correct. This seems to be an issue with the shopify collection. They dont allow us to combile “And” and “OR” condition together.

However i have comeup with another workaround. We can use Shopify Flow app to move product to draft when inventory to 0. I have done this on my test store. You can test the feature here https://mangit.myshopify.com/collections/all. The first product “4G CAT SUNGLASSES IN BLACK” has 1 inventory. If you purchase this product using test card, the status of the product will be draft and it will be removed from the collection page.

Collection:https://mangit.myshopify.com/collections/all

Product: https://mangit.myshopify.com/collections/all

Test card details:

Card number: 1

Date: 12/25

CVV: 123

If you are comfertable using Shopify Flows, you can create similar flow. Else you can let me know to create such flows.