I have around 3000 collections with a metafield value “ktype”. Ktype is a single line text field that contains a comma separated list of numbers.
What’s the best way to find the one collection that contains a single number within that metafield?
I was using the storefront API to get the collections and then find the correct one but that’s quite intensive and requires it to be done in batches no bigger than 250 collections at a time. Is there a way to do this without having to get all collections? Is there a way of using the API so that Shopify does the filtering and then just returns the one collection I need?