How to remove Total and Subtotal rows from an export

2026-06-20

Task

Supplier tables can contain service rows such as Subtotal or Total. They should not be exported as product rows.

Short Answer

In sku, add row export conditions: SKU is not empty, and name does not match the service marker.

How to Do It in Eofferix

Open the sku column settings in the table editor.
The red frame shows where to open the required column settings.
In Export conditions, add: Current value, Before transformations, Not empty.
Rows without SKU are not exported.
Add the second condition on name: Not a regular expression, value ^(Subtotal|Total)$.
A row stays only if name is not a service marker.
Save the column settings.

source data

sku	name	amount
SKU-1001	Winter jacket	1200
	Subtotal	1200

result

sku	name	amount
SKU-1001	Winter jacket	1200