How to Normalize Product Condition to new, used, refurbished

2026-06-21

Task

The supplier writes product condition in its own wording. Google Merchant needs fixed values: new, used, and refurbished.

Short answer

Create condition from condition_raw and add a replacement dictionary: new → new, used → used, refurbished → refurbished.

How to Do It in Eofferix

Open the settings of the output condition column.
The click is on the settings icon of the output condition column.
In Transformations, add one Contains substring → Replace with rule for each condition.
The Transformations block shows the full rule chain for this case.
Save the column settings and go to the Export step.

source data

result