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.
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.