I am having an issue with a saved search and hopin...
# general
e
I am having an issue with a saved search and hoping someone has an idea. When I add a column for commerce category, it is not including items that do not have a commerce category, its filtering those out, even though I do not have it set up as a filter. Any ideas? The goal is to find our display on webstore items that are not in a category. Thank you!
m
It's because the commerce category is acting like a sub record. It is not recorded directly on the item. The item is assigned to the commerce category. I don't have time to test now, but a CASE WHEN might help. I did help a client copy commerce categories up to a field on the item header once. That helped with the kind of issue you are experiencing.
k
have you tried to set criteria “Category is any of none”?