Login / Sign up
Google Merchant

How to Normalize Energy Efficiency Classes A+++, A++, A+

2026-06-21
Task

Energy class arrives with spaces and mixed case, such as a ++ or A +++. The feed needs a clean value.

Short answer

Create energy_efficiency_class from energy_raw and apply Trim spaces, Remove spaces, then Uppercase.

How to Do It in Eofferix

  1. Open the settings of the output energy_efficiency_class column.
    Animation showing how to open the energy_efficiency_class column settings in Eofferix
    The click is on the settings icon of the output energy_efficiency_class column.
  2. In Transformations, add three cleanup rules: edges, all spaces, and uppercase.
    Screenshot of transformation rules for the energy_efficiency_class column
    The Transformations block shows the full rule chain for this case.
  3. Save the column settings and go to the Export step.

Before / After

Before

source data
idtitleenergy_raw
GM-180Arctic fridge a ++
GM-181Wave washerA +++

After

result
idenergy_efficiency_class
GM-180A++
GM-181A+++

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up