How to Extract Product Color from the Product Name

Task

The color is written in the product name, for example Basic T-shirt XL black. The catalog needs a separate color column.

Short answer

Create color from name and add a small dictionary: when the name contains a color, replace the value with the normalized color.

How to Do It in Eofferix

1. Open the settings of the output color column.

   

2. In Transformations, add substring rules: black → black, white → white.

   

3. Save the column settings and go to the Export step.

Before / After