How can I add a "Sale Price" field to my Shopify product feed?

Shopify doesn't have a "Sale Price" field in the backend. It instead uses a field called "Compare At Price" which basically makes the regular "Price" as the sale price if the "Compare At Price" is specified.

EZ Exporter supports conditional logic in Calculated Fields, so you can use these formulas to add a "Price" and "Sale Price" column where the values depend on whether a "Compare At Price" is set:


{{ variants.compare_at_price }} if {{ variants.compare_at_price }} else {{ variants.price }}

Sale Price

{{ variants.price }} if {{ variants.compare_at_price }} else ""

App: EZ Exporter

Tags: advanced features, product feeds, shopify product export