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