Customising collection rules

Shopify Discussion
,

Topic summary

A user seeks to customize Shopify collection rules to automatically populate a ‘Sale’ collection based on a dynamic comparison: products where ‘Compare-at price’ is greater than ‘Price’.

Current Limitation:
Shopify’s native collection rules only allow comparisons against fixed values (e.g., greater than $50), not between two product fields.

Business Context:

  • All products need a populated compare-at price for a pricing app to function correctly
  • The pricing app can only modify the ‘Price’ field
  • Without this dynamic rule, sale items won’t display strikethrough pricing properly when reduced from full RRP

Status: The question remains unanswered, with no solutions or workarounds proposed yet. The user has included screenshots showing Shopify’s current collection rule interface.

Summarized with AI on November 2. AI used: claude-sonnet-4-5-20250929.
1

Hello,

Has anyone had any experience with customising collection rules? I need our ‘Sale’ collection to populate from the rule ‘Compare-at price’ is greater than ‘Price’.

The options at the moment are only to show if the field is empty/not empty or less than or greater than a specific value.

The reason for this, is I need the compare-at price to be populated in all products so that our pricing app can function correctly. Currently it can only change the price field so if something is being reduced from being at full RRP and not having a value in the compare-at price field, it will show as the reduced price but with no strike through/full price shown.

Thank you in advance!

Screenshot 2025-01-20 at 10.36.24.png
Screenshot 2025-01-20 at 10.36.24.png642×274 19.4 KB

Screenshot 2025-01-20 at 10.35.50.png
Screenshot 2025-01-20 at 10.35.50.png649×452 34 KB