Task
Before import, several exact SKUs or brands must be removed from the file so they do not enter the catalog.
Short answer
For each excluded value, add a row export condition: the target column must be Not equal to that value.
How to Do It in Eofferix
- Open the settings of
sku, or another column where the blacklist is easiest to check.
The animation shows the click on the settings icon of the sku column. - In Export conditions, add a row condition:
sku→Not equal→SKU-200.
For a second excluded SKU, add another condition of the same type. For a brand, choose the brand column and set Not equal to the target brand. - Save the settings and export the file. The result keeps only rows that pass all conditions.
Before / After
Before
source data| sku | brand | name |
|---|---|---|
| SKU-100 | Brand A | Office chair |
| SKU-200 | Brand B | Desk lamp |
| SKU-300 | Brand A | Desk |
After
result| sku | brand | name |
|---|---|---|
| SKU-100 | Brand A | Office chair |
| SKU-300 | Brand A | Desk |