You can specify simple calculation for numeric fields rather that just directly importing data from .csv. Current field value defined as "x" variable, just use it in your expressions.

Examples:

=x*1.2

- value will be multiplied by 1.2 (increased by 20%) and imported into a field. Usefull when importing product prices from your wholesale .csv file. You may just put your markup.

=x*abs(x^2-34.67) + sin(x) - pi

- it is useless but may give an idea of what can be used in this field.

This expression will return 1 if field value is greater than 0 and 0 if it is 0 or smaller:

=Round((abs(x)+x)^0.0000001)

- it can be used to automatically set product status (In stock / Out of stock) depending on product quantity. You have to assign product quantity .csv column to "Product status" field and use mentioned expression. You can assign product quantity .csv column to products_quantity database field as well - one column can be assigned to two or more database fields at the same time.

Mathematical operations supported: * - multiplication; / - division; - subtraction; + addition; < less than; < more than; = equal List of functions: sqrt, div, mod, int, frac, random, trunc, round, sin, sinh, arcsin, arcsinh, cos, cosh, arccos, arccosh, tan, tanh, arctan, arctanh, cotan, cotanh, arccotan, arccotanh, sec, arcsec, sech, arcsech, csc, csch, arccsc, arccsch, abs, ln, lg, log, pi, exp, ! (factorial), ^ (degree)

Note*: Expressions are mathematical equations so they can be used only on numeric fields such as price, quantity etc. You should not use them for string, date/time and other fields.