Sorting Sale Items

Shopify Plus

Topic summary

A user seeks to automatically sort sale items to the end of collections when products are marked down using the compare-at price field. Their collections are currently smart collections based on various store factors.

Proposed Solution:

  • Use Shopify Flow with trigger “Product Variant Compare at Price Updated”
  • Add condition to verify price is lower than compare-at price
  • Apply an “on-sale” tag to qualifying products
  • Convert collections to manual sorting
  • Use Shopify API or script to periodically reposition tagged sale items to collection end

Current Status:
The discussion remains open with one proposed workflow. Implementation would require converting smart collections to manual sorting, which may impact the original collection logic based on various store factors.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
1

Hi all!

I’m hoping to get some help setting up a flow to sort Sale Items to the end of each collection when they are added. I have the collections setup as Smart collections based on various different factors within the store. Ideally as an item is marked down using the compare at price field, it could trigger a Flow that would move it to the end of the collection.

Has anyone figured out a way to make this work?

2

Hey @aevispa ,

You can achieve this using Shopify Flow by following these steps:

  1. Trigger: “Product Variant Compare at Price Updated” – Detects when a product is marked down.

  2. Condition: Check if “Price” is lower than “Compare at Price” to confirm it’s on sale.

  3. Action: Add a tag like on-sale to the product.

  4. Sorting: Set the collection to “Manual” and periodically move sale items to the end using Shopify’s API or a simple script.

This ensures sale items are automatically pushed to the end of collections. If you want to help with this, please feel free to reach out.

Thanks!

Best,

Rajat