1/ write formula into “Calculated Field x”

2/ click “Calculated Field x” button to add into export

3/ in “Calculated Field x” use same field name like XML tags (same name is displayed on mouse over button). Of course in you can use mathematical operators like + – * /  brackets etc. Important – from version 2.3 all text fields should be enclosed in single quotes!!!

Examples:

 

// invoice number with prefix and six digits

'invoice_prefix'.sprintf('%06d', 'invoice_number')

 

//export delivery company, if delivery company is empty will be exported first name + last name

('delivery_company' <> '') ? 'delivery_company' :  'first_name last_name'

 

// product price with tax per one product

product_price*(1+taxtaxrate/100)

 

// product price with tax for all same ID products  in one order

product_price*(1+taxtaxrate/100) * product_quantity

 

// invoice date + 10 days

date('Y-m-d H:i:s',strtotime('invoice_date')+60*60*24*10)

 

// wholesale price * 1.18 (included wholesale price of combination)

(combination_wholesale>0) ? combination_wholesale*1.18 : wholesale_price*1.18

 

//  first name last name, all chars to upper case

strtoupper('first_name last_name')

 

//  first name last name email, user format

'first_name'.', '.'last_name'.' ('.'email'.')'

(all text text fields and chars should be in single quotes and concatenated by dot)

or simplified:

'first_name, last_name (email)'

for this is Excel exist trick how forces the data to be text for example =”1.65″
Because double quotes are problem in calculated field, use this calculated field: chr(61).chr(34).’1.65′.chr(34)

For text fields can be used as well multiline field (without single quotes)