If you need to generate collections of products based on patterns in your SKUs, here is a workflow you can use.
You set up the SKU patterns in the Transform step. They are using a pattern called “regular expressions”, which can get somewhat complicated, but for most use cases, you just need to use .* whenever you want a wildcard in there.
You can then use the tags that are added to the products in your automated collections.
Preview of workflow steps
Watch the demo
Learn how to make Shopify work easier with your business processes.