Data transformation

How to exclude products with prices outside an allowed range

2026-06-20
Task

Only products within an allowed price range should be exported, for example from 100 to 50000.

Short answer

Add row export conditions to the price column: the price must be greater than or equal to the minimum and less than or equal to the maximum.

How to do it in Eofferix

  1. Open the price column in the table editor.
    Product export filtered by price range
    The output table keeps only products with an allowed price.
  2. Add an export condition >= 100.
    Row export condition for the minimum price
    The conditions work at row level: if the price fails the range, the row is not exported.
  3. Add a second condition <= 50000.
  4. Run a demo result and confirm that rows outside the range are excluded.

Before / after

The data below is a training example and does not belong to real user files.

Before

source data
skuprice
SKU-LOW50
SKU-OK1290
SKU-HIGH150000

After

result
skuprice
SKU-OK1290

Process data faster with Eofferix

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

Sign up