EZ Exporter Calculated Fields - Arithmetic Operations

Arithmetic operations provide a way to generate new values from one or more number fields (e.g. total_weight, total_price, line_items.quantity, etc.).

AVAILABLE OPERATORS

  • + (add, 1 + 1 = 2)
  • - (subtract, 5 -1 = 4)
  • / (divide, 10 / 2 = 5)
  • * (multiply, 3 * 2 = 6)
  • ** (exponent, 2 ** 3 = 8)
  • % (modulus/remainder, 15 % 4 = 3)

EXAMPLES

I want an additional column that will give me the order's total_weight in pounds as the default weight is in grams.

{{ total_weight }} * 0.0022046

I want an additional column showing the order's total_price with 40% off before taxes.

({{ total_price }} - {{ total_tax }}) * 0.60

I want a column showing the Lineitem Unit Price after Discounts.

({{ line_items.total_price }} - {{ line_items.discount_allocations.total_amount }}) / {{ line_items.quantity }}

The product variant prices in my Shopify store includes a 7.7% VAT, I want a column for the price in my product export that excludes this VAT.

{{ variants.price }} / 1.077

I want a column in my product export which adds 10% to the variant price and a fixed $5 fee.

({{ variants.price }} * 1.10) + 5

Related Articles:


App: EZ Exporter

Tags: advanced features, calculated fields