Creating Automated Collections Based on the SKU

Shopify Discussion
1

Greetings,

I want to be able to create Automated Collections based on the SKU with whilecards. e.g. ABC_DF* . Is this possible?

A little bit of background. My product feed (large number of products) has the product title, SKU, size info, price, etc. I am trying to create the automated collections to use in the Menu. Setting up a new Shopify store.

Thanks!

2

Hi there - are you looking to do this for all products in the past/present/future, or just future products? Either way this can be achieved via a custom app, or Shopify Flow.

Private message us if you need a hand.

Cheers.

WhiteWater Web

3

Hi,

Thank you for responding. I have updated the original post with a bit more information. Please let me know.

Thanks!

4

Ok, so to get all of the products into an automated collection using tags, we need to write a small script/custom app; then all future products you add to the store matching those conditions - would use a Flow to add a tag/add to that collection.

5

I have the Shopify Basic plan, and I believe Shopify Flow is not included.

6

You should be able to add Flow on that plan; have a look at the changelog announcing this:

https://changelog.shopify.com/posts/shopify-flow-now-available-to-basic-plan

7

I can build out an automation template for this. Probably the easiest way to handle the sku patterns would be using regular expressions.

Can you give me a couple examples of the types of SKU patterns you’re looking to do?

8

I believe that my Automated Collections would need to be created using a mix of solutions. Some of the products would need to be categorized based on SKU. Some would need to be categorized using the Title, etc.

9

Gotcha. I ended up knocking out a workflow template for this just in case:

https://blog.getmesa.com/automate-collections-based-on-sku-patterns-using-tags/

Hope that might help!