 ## EZ Exporter Calculated Fields - Conditional Expressions

Conditional expressions allow you to include logic when generating your report.

AVAILABLE OPERATORS

• if ("this value" if "condition" else "", must be used with "else")
• else ("this value" if "condition" else "this other value", must be used with "if")
• not (if not "condition")
• and (both conditions must be True, if "condition1" and "condition2", if 1 == 1 and 1==2 -> False)
• or (either condition can be True, if "condition1" or "condition2", if 1 == 1 or 1 == 2 -> True)
• > (greater than, if 3 > 1 -> True)
• < (less than, if 1 < 3 -> True)
• >= (greater than or equal to, if 3 >=3 -> True)
• <= (less than or equal to, if 3 <= 3 -> True)
• == (equals, if 5 == 5 -> True)
• in (contains, if "shop" in "shopify" -> True)
• {{ text_field }}.startswith() (text starts with characters, "hello".startswith("he") -> True)
• {{ text_field }}.endswith() (text ends with characters, "hello".endswith("h") -> False)

EXAMPLES

I want to categorize my orders based on total_price.

```"High" if {{ total_price }} >= 1000 else "Medium" if {{ total_price }} >= 100 else "Low"
```

This will assign the value "High" if the order's total_price is greater than or equal to 1000, "Medium" between 100-1000, and "Low" if below 100.

I want an additional field for the destination's region.

```"North America" if {{ shipping_address.country_code }} in "US, CA, MX" else "Other"
```

If the shipping address' country code is US, CA, or MX, assign the value "North America", otherwise, use "Other".

I want an additional field to set an order's priority based on price or weight.

```"High" if {{ total_price }} > 500 or {{ total_weight }} > 1000 else "Normal"
```

If the order's total price is above 500 or if the total weight is over 1000, mark this order as high priority.

App: EZ Exporter