How can I automate a sales collection with a 40% sell price condition?

[Rhi2110]

Hey!

I am using collections as my shop categories.

Looking for a way to have an automated sales collection where the condition is something like the “compare at price” or RRP is more than 40% the sell price.

Any suggestions on how to do this.

Thankyou!

[Victor_5]

Hi @Rhi2110 ,

This would not be possible, I’m afraid, as you cannot set an automatic condition within a collection based on the compare at price relative to the current sale price. You can set a condition where products with a compare at price greater than a specific dollar amount appear automatically in a collection, if that is of any help to you.

Alternatively, you could manually apply a tag to products where the compare at price is 40% or more greater than the sale price, but this would require you adding the tags yourself rather than the system automatically adding a tag when this 40% price difference threshold is met.

I can see why what you’re looking for would be helpful, however, and will be sure to submit your feedback to our development team.

[Kalen_Jordan]

Here is a workflow that I’ve set up with our app MESA to automatically tag products that have this logic:

Would be happy to help you get this template installed if you were interested in checking out our app!