How to Fill Google Merchant gender from Category or Product Name

2026-06-21

Task

The source table stores gender inside the product name or category. Google Merchant needs male, female, or unisex.

Short answer

Create gender: use unisex by default, map men to male, and map women to female.

How to Do It in Eofferix

Open the settings of the output gender column.
The click is on the settings icon of the output gender column.
In Transformations, add the unisex default and two dictionary rules by category: men items to male, women items to female.
The Transformations block shows the full rule chain for this case.
Save the column settings and go to the Export step.

source data

result