Supplier catalogs

How to extract color from YML param name="Color"

2026-06-29
Task

YML product characteristics are stored in repeated param nodes: Color, Material, and others. The import needs a separate color field.

Short answer

Open the param value and add a condition on attribute @name: regular expression ^Color$ (matches a value that is exactly Color).

How to do it in Eofferix

  1. In the XML/YML snapshot, select the param value.

  2. Open the value settings.

    Opening value settings
    The animation shows opening settings for the selected value.
  3. Add an export condition on @name: @name ^Color$.

    Value condition
    This makes Eofferix take the value only from the needed repeated block.

Before / after

Before

source data
<yml_catalog date="2026-06-29 10:00">
  <shop>
    <offers>
      <offer id="YML-11001"><name>Hudson lamp</name><param name="Color">white</param><param name="Material">steel</param></offer>
      <offer id="YML-11002"><name>Parker chair</name><param name="Color">black</param><param name="Material">wood</param></offer>
    </offers>
  </shop>
</yml_catalog>

After

result
<offers>
  <offer id="YML-11001"><name>Hudson lamp</name><color>white</color></offer>
  <offer id="YML-11002"><name>Parker chair</name><color>black</color></offer>
</offers>

What to keep in mind

  • Place the condition on the param value, not on the whole offer; otherwise you will filter products instead of selecting a characteristic.
  • If the supplier writes colour or Product color, replace the expression with the actual name.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up