Convert inconsistent supplier data into a supported energy_efficiency_class value without exporting an invalid class.
Read the source value, remove spaces, convert it to uppercase, and clear the result when it is not in Google’s supported list.
How to Do It in Eofferix
Add or open the target
energy_efficiency_classcolumn in the table editor.
Open the rules for the target energy_efficiency_class column. Select the source column
energy_raw. Add Remove spaces, then Uppercase, then Not a regular expression with^(A\+\+\+|A\+\+|A\+|A|B|C|D|E|F|G)$. Choose Replace with and leave the result empty.
Normalize first, then clear anything outside Google’s supported list. Apply the rules. Confirm that a value such as
a ++becomesA++and arbitrary text becomes blank.Include the attribute only for supported target countries and compare the result with the product’s actual energy label.
energy_raw is an example. Select your actual source column. These rules normalize text and validate the allowed list; Eofferix cannot establish whether a supplier has assigned the factually correct class to a product.Expected Result
| Source value | Feed result | Why |
|---|---|---|
| a ++ | A++ | Spaces are removed and the letter is uppercased. |
| A +++ | A+++ | Cleaning restores a supported value. |
| class unavailable | blank | The value is not in the supported list. |
Checks Before Export
- The regular expression checks the entire value because it starts with
^and ends with$. - An invalid value is cleared instead of being replaced with a guessed class.
- The rule order remains: Remove spaces, Uppercase, then validate.
Google Merchant Requirements
Supported values are A+++, A++, A+, A, B, C, D, E, F, and G.
Since April 2025, these energy-class attributes are available for Switzerland, Norway, and the United Kingdom. For graphical energy labels in the EU, Google directs merchants to the certification attribute and EPREL data.
When an energy-efficiency class is used, the minimum and maximum classes are also needed to build the scale.