@kpvw 's app does exactly this, so marked it as a recommended solution.
Topic summary
Goal: Create collections like “10%, 25%, 50% off” based on the discount percentage (derived from price vs. compare-at price).
Platform status: Shopify does not natively support collection conditions based on percent off. Compare-at price must be set as a numeric value; percentages cannot be used as a rule.
Workarounds:
- Tag products with the discount percent (manually or via bulk editor/CSV), then build automatic collections by tag.
- Export products with compare-at price, calculate discount percentages in a spreadsheet, add tags, re-import.
Third‑party solution: The “Advanced Collection” app (Voidworks) added rules to include/exclude products by discount percentage and auto-sync on product changes; offers a 7‑day trial. The original poster confirmed it meets the need and marked it as a recommended solution.
Issues noted: Initial installation returned a 500 error; the developer cited server updates, then logs showed Shopify API 423 “shop is unavailable.” Suggested retry/another shop.
Open items: Later participants asked about installing on a dev store and for a native “enter percentage” feature. No official update or timeline from Shopify; feature request noted. Images show tag-based setup and a dev-store install prompt.