Task
A source sends prices in minor units: 129990 cents. The export needs a normal price such as 1299.90.
Short answer
Create the output price column and add a math rule that divides the value by 100.
How to do it in Eofferix
- Create
pricefromprice_cents.
The output price column is calculated from cents or another minor unit. - Add a math divide rule with
100.
The math rule divides the source value by 100. - If the target system needs exactly two decimals, format it in the target or add a rounding rule.
- Check zero and empty prices.
Before / after
The data below is a training example and does not belong to real user files.
Before
source data| sku | price_cents |
|---|---|
| SKU-1001 | 129990 |
| SKU-1002 | 4500 |
After
result| sku | price |
|---|---|
| SKU-1001 | 1299.9 |
| SKU-1002 | 45 |