How to run a sale on specific product variants?

Hey y’all, have a unique ask that I haven’t seen a great answer for yet.

We sell new and used board games and RPG books on our Shopify site. I’d like to be able to possibly run a sale of some sort on used product. The way we have it set up is a single product page for a game (like “Catan”) and then a variant of “Condition” with the options of “New”, “Used - Good Condition”, “Open Box / Unplayed”, etc.

Couple thoughts I had:

  1. You can actually run a sale on specific variants, but you have to manually select them and it caps out at 100 items :confused: we currently have over 1000 games listed on the website, most of which are of the previously owned variety so this option won’t really work for us

  2. Been looking at apps that deal with the way collections integrate with variants, the idea being to create a collection based off the options and then run the sale on that collection. Everything I’ve seen seems to have the functionality built in to display these variants on pages, but I really just need to make a “back-of-house” collection that I can reference for the sale.

Any thoughts, or have an app that’ll do this?

Thanks!

Anders (https://allsystemsgo.games for reference)

I am looking for the same kind of thing. Let me now if you find a solution. I have been looking for a long time.