How to Build unit_pricing_measure such as 750ml or 1.5kg

2026-06-21

Task

Package size arrives as text with a space, for example 750 ml or 1.5 kg. The feed needs a value without the space and with an accepted unit.

Short answer

Create unit_pricing_measure from package_size: lowercase, replace comma with a dot if needed, and remove spaces.

How to Do It in Eofferix

Open the settings of the output unit_pricing_measure column.
The click is on the settings icon of the output unit_pricing_measure column.
In Transformations, apply lowercase, optional comma-to-dot replacement, and space removal.
The Transformations block shows the full rule chain for this case.
Save the column settings and go to the Export step.

source data

id	title	package_size
GM-170	Family shampoo	750 ml
GM-171	Premium food	1.5 kg

result

id	unit_pricing_measure
GM-170	750ml
GM-171	1.5kg