Using formulas

A guide on how to use formulas in Omnia

In Omnia you can add formulas to the mapping fields.

If you would like to transform the data you feed to your shop before importing it, you can change these fields in the mapping section. You can also change the value from a field before exporting it via a report.

The list below shows all available formulas that can be used in Omnia. 

Logic

If

And

Or

Nested if-statements

In

Booleans

Date and time

Dateformat

Now

Today

Subtracttoday

Strings

Combine strings

Firstuppercase

Replace

Tostring

Trim

Urlcode

Stringcase

Stringclean

Strinclear

Stringcut

Stringfit

Stringlength

Stringnull

Stringphrase

Stringstriptags

Substring

Numbers

Abs

Ceiling

Convertnumber

Floor

Round

Truncate

Sign

EANs

IsEAN

MakeEAN

Calculations

Ieeeremainder

Max

Min

Pow

Sin

Sqrt