Automated Collection for On Sale Items - Issue after removing Compare At Price for non-sale items

Topic summary

Automated “On Sale” collection continues to list non-sale items even after removing their Compare-at price (the field Shopify uses to indicate a higher original price versus the current sale price). The original poster followed Shopify’s guide but products still appeared incorrectly.

Recent update: Shopify support acknowledges a current issue affecting automatic collections that use a Compare-at price condition, where collections are not re-syncing as expected after price changes.

Workaround (from Shopify support): Manually force a re-sync by duplicating one of the collection’s conditions, saving the collection, then deleting the duplicated condition. This triggers a refresh and should correct the product list.

Expected behavior: Collections should automatically update when prices change; historically this worked reliably.

Status: No long-term fix announced. The workaround is the interim solution, and the issue appears ongoing with unanswered questions about a permanent resolution.

Summarized with AI on December 30. AI used: gpt-5.

Hi, I followed this guide (https://help.shopify.com/en/manual/products/collections/automated-collections/auto-examples) for creating an automated collection which shows all items On Sale. I noticed there were several products incorrectly showing up because it had the regular price also entered in the compare at price (i.e. it was not on sale). So, I went ahead and deleted the compare at price figure for these items and saved each one. I then checked the collection, however the products still seem to be showing up incorrectly in this automated On Sale collection.

How do I fix this?

Thank you in advance! This is my first time posting here!

I’ve been experiencing this exact issue recently. After contacting Shopify support, the “fix” is to manually re-sync the collection by duplicating one of the collection conditions, saving the collection, and then deleting the duplicated condition. This will force the collection to re-sync.

The collection should automatically sync when prices change. Historically that’s how it functioned for years. Unfortunately Shopify appears to be experiencing issues right now with automatic collections that rely on a “compare at price” condition. The only fix I was offered by Shopify was to manually re-sync these collections as explained above. Hopefully they are working on a long term solution because this is a major hurdle for us.