Tag Shopify Products as “On Sale” Based on Compare-at Price

This step automatically detects when any product in your Shopify store gets updated, whether that's pricing changes, inventory adjustments, or other product modifications. The trigger captures the complete product data and passes it to the next step for analysis. No configuration is needed since MESA connects directly to your Shopify store's product update events. This ensures every product change gets evaluated for sale pricing without missing any updates.

This step automatically pulls all variants for the updated product using Shopify's API. It gathers variant-specific pricing data including regular price and compare-at price for each option. The system uses the product ID from the trigger to fetch comprehensive variant details. This data gets passed to the loop step so each variant can be individually evaluated for sale pricing conditions.

The loop step takes the list of variants from the previous step and processes them one at a time. Each iteration examines an individual variant's pricing data and passes it through the remaining workflow steps. This allows products with multiple variants to have each option checked separately for sale conditions. The loop ensures no variant gets missed when determining if the overall product should be tagged as "On Sale."

The filter step applies two conditions to each variant: first, it checks that a compare-at price exists (is not empty), and second, it verifies that the current price is less than the compare-at price. Only variants that meet both conditions proceed to the tagging action. This ensures products only get tagged as "On Sale" when they have legitimate sale pricing with a proper discount from the original price. Variants that don't meet these criteria stop here and don't trigger the tag addition.

When a variant passes the filter, this step adds the "On Sale" tag to the parent product (not the individual variant). The tag name is preset to "On Sale" but you can customize this to match your store's tagging convention—change it to "SALE", "Discounted", "Clearance", or any tag name you prefer. Find the tag field in this step and enter your desired tag name. The tag appears immediately in your Shopify admin under the product's tags section.