Supplier catalogs

How to keep only YML offers with the needed currencyId

2026-06-29
Task

The supplier sent one YML feed with products in several currencies. This import needs only USD.

Short answer

Add an export condition to offer: the simple option is currencyId equals USD. If you need to exclude one foreign currency, use Not equal; regular expression ^USD$ only checks an exact full match.

How to do it in Eofferix

  1. In the XML/YML snapshot, select the repeated offer node.

  2. Open the node settings.

    Opening offer settings
    The animation shows opening settings for the repeated product node.
  3. Method 1: set currencyId Equals USD.

    Export condition
    This is one condition variant; the other variants do not need to be added.
  4. Method 2: if you only need to remove one extra currency, set currencyId Not equal EUR.

    Export condition
    This is one condition variant; the other variants do not need to be added.
  5. Method 3: for compound values, you can use currencyId Contains substring USD.

    Export condition
    This is one condition variant; the other variants do not need to be added.
  6. Method 4: keep regular expression ^USD$ (matches a value that is exactly USD) as the strict option.

    Export condition
    This is one condition variant; the other variants do not need to be added.

Before / after

Before

source data
<yml_catalog date="2026-06-29 10:00">
  <shop>
    <offers>
      <offer id="YML-7001" available="true">
        <name>Hudson lamp</name>
        <currencyId>USD</currencyId>
        <price>1290.00</price>
      </offer>
      <offer id="YML-7002" available="true">
        <name>Parker chair</name>
        <currencyId>EUR</currencyId>
        <price>92.00</price>
      </offer>
      <offer id="YML-7003" available="true">
        <name>Harbor shelf</name>
        <currencyId>USD</currencyId>
        <price>990.00</price>
      </offer>
    </offers>
  </shop>
</yml_catalog>

After

result
<yml_catalog date="2026-06-29 10:00">
  <shop>
    <offers>
      <offer id="YML-7001" available="true">
        <name>Hudson lamp</name>
        <currencyId>USD</currencyId>
        <price>1290.00</price>
      </offer>
      <offer id="YML-7003" available="true">
        <name>Harbor shelf</name>
        <currencyId>USD</currencyId>
        <price>990.00</price>
      </offer>
    </offers>
  </shop>
</yml_catalog>

Process data faster with Eofferix

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

Sign up