Table editor

How to Remove Rows Without SKU from a Supplier Price List

2026-06-19
Task

A supplier file can contain section headers, totals, or technical rows together with real products. The most reliable filter is a required product column such as SKU.

Short answer

Open the sku column settings and add a row export condition: skuBefore transformationsNot empty.

How to Do It in Eofferix

  1. Open the settings of the sku column.
    Opening the sku column settings in Eofferix
    The animation shows how to open the sku settings.
  2. In Export conditions, add a row condition: skuBefore transformationsNot empty.
    Export condition for a non-empty SKU
    Rows without SKU are not exported even if other columns contain text.
  3. Save the column settings and continue to export.

Before / After

Before

source data
skuname
Category: Chairs
SKU-100Office chair
Total
SKU-200Writing desk

After

result
skuname
SKU-100Office chair
SKU-200Writing desk

Process data faster with Eofferix

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

Sign up