How to ignore a price or compare at price update based on the feed value ?
Use these formulas to stop Stock Sync from lowering your Price or Compare-at Price when the value already in your store is higher than the feed value. This is useful when you want to keep manual or higher store prices in place during sync.
How to Set Up the Price Rule
Go to App → Feed Settings → Step 2: Matching Column
- Open the feed: Open the feed you want to update and go to the Matching Column section.
- Open Smart Settings: Click Smart Settings under the Price field.
- Add the formula: Apply the formula that matches your scenario, as shown below.
any, because conditions are checked from top to bottom.Formula Examples & Detailed Breakdown
1. Compare Store Price Against Feed Price
Condition (If) | Price (Then) | What It Does |
|---|---|---|
|
| Keeps your store price unchanged when it is higher than the feed price. |
2. Compare Store Price Against a Specific Column in the Feed
Condition (If) | Price (Then) | What It Does |
|---|---|---|
|
| Keeps your store price unchanged if it is higher than the value in Column 8 of the feed file. |
col#_f to compare against any custom column, especially for numeric values or when your feed source is a Google Sheet.
Key Rules & Technical Details
- Priority sequence: ||| Priority sequence: Price Conversion → Price Condition → Price Rounding
- Store-only keywords:
current_pricerefers to the value in your Shopify store and is only available for Shopify stores. - Compare-at Price: To apply the same logic to Compare-at Price, use the same formula in the Compare-at Price field's Smart Settings.
Troubleshooting Steps
- Issue: The store price is still lowered by the sync → Solution: Check that the rule is placed above any general fallback rule such as
any, and that the comparison uses the correct column (price_forcol#_f). - Issue: The comparison column does not match the feed value → Solution: Make sure the number of the
col#_fcolumn matches the column in your feed file, and that the values are numeric.
Good Articles to Continue
- Price Field → Learn how to set up the Price field, markups, rounding, and currency conversion.
- Compare-at Price Field → Configure conditions and rules for your compare-at prices.
- Store Product Filter → Exclude specific products from updates using store filters.
Updated on: 13/11/2026
Thank you!
