Convert an explicit source gender value into a supported Google value without guessing from a category name.
Clear the target gender column and add a separate Equals rule for each known source value.
How to Do It in Eofferix
Add or open the target
gendercolumn in the table editor.
Open the rules for the target gender column. Keep the first clearing rule. For source column
gender_raw, add exact mappings:men→male,women→female, andunisex→unisex.
Each known value is mapped separately; an unknown value stays blank. Apply the rules. A row without a known marker must remain blank; do not assign
unisexautomatically. Treat that blank as a review stop.Before export, resolve every blank value in scenarios where Google requires
gender. Then export the feed and inspect the item variants in Merchant Center.
gender_raw and the source values shown here are examples. Select your actual column and list the supplier’s real values. If you only have a category name, first create a controlled mapping for known categories and leave unknown cases blank for review.Expected Result
| Source value | Feed result | Why |
|---|---|---|
| men | male | The explicit value maps to a supported Google value. |
| women | female | The complete value is compared exactly. |
| unisex | unisex | unisex is written only when explicitly supplied. |
| blank / unknown | blank | The value is not guessed. |
Checks Before Export
- The output contains only the English values
male,female, andunisex. - Every rule uses Equals, so overlapping words cannot cause a partial match.
- Every blank is resolved before export when
genderis required for the selected destination, category, and country.
Google Merchant Requirements
Google supports exactly three gender values: male, female, and unisex.
For free listings, gender is required for products in Apparel & Accessories (Google product category ID 166). For Shopping ads, it is required for products in that category targeting Brazil, France, Germany, Japan, the United Kingdom, and the United States.
Google separately lists Apparel & Accessories subcategories for which the attribute is optional; check the current list in the official documentation below.
The attribute is not repeatable. Where it is required, a blank is not a finished result: review and correct the row before export.