The supplier provides product condition in condition_raw, for example brand new, second hand, or factory refurbished. Google Merchant needs the output attribute condition to contain new, used, or refurbished.
Trim the value, convert it to lowercase, map only exact confirmed labels, and clear anything that is not new, used, or refurbished after the transformations.
How to Do It in Eofferix
Add or open the target
conditioncolumn and selectcondition_rawas its source.condition_rawis an example name; use the actual column, node, or path from your source.
Open the settings of the column that will be exported as the condition attribute. Under Transformations, add Any → Trim spaces at edges, followed by Any → Lowercase. These rules remove surrounding spaces and convert the current value to lowercase.
Add exact Equals rules:
brand new→ Replace with →new;second hand→ Replace with →used;factory refurbished→ Replace with →refurbished. Do not use substring matching.
Surrounding whitespace is removed and the value is converted to lowercase first; three exact dictionary rules then produce supported values, and the final guard clears everything else. Finish with Not a regular expression using
^(?:new|used|refurbished)$→ Do not export field. Apply the settings and inspect all five example rows, includingunusedandunknown.
condition_raw and the dictionary labels are only an example. Use the actual field name and exact supplier codes. Map brand new to new only when the item is unused and its original packaging is unopened; map factory refurbished to refurbished only when professional restoration to working order, an as-new appearance, and a warranty are confirmed. The Do not export field action clears the field but does not remove the product row.Expected Result
condition_raw | condition | Why |
|---|---|---|
BRAND NEW | new | Spaces and case are normalized before the exact match. |
second hand | used | Exact confirmed dictionary value. |
factory refurbished | refurbished | Valid only when the supplier meaning matches Google's definition. |
unused | blank | It is not equal to used; the false substring match is prevented. |
unknown | blank | The value is absent from the confirmed dictionary. |
Checks Before Export
- Keep all six rules in the documented order and apply them to the current value.
- Use Equals for all three exact dictionary rules, not Contains substring.
- The result contains only
new,used, orrefurbished; both negative rows are blank. - If rows with a blank result must not be exported, add a separate row-export condition requiring the final
conditionto be non-empty.
Requirements and Limits
- Google accepts only
new,used, andrefurbished, submitted in English.conditionis required for used and refurbished products and optional for new products. newmeans unused in unopened original packaging;refurbishedrequires professional restoration, an as-new appearance, and a warranty.- Do not export field clears only the output field. It does not remove the product row or infer the product's real condition.
- Current definitions and formatting are documented in the official Google Merchant specification. The landing page and the rest of the feed must also comply with Google's rules.