Login / Sign up

Section rows in tables: how to assign products to sections

How to enable section rows in XLSX, XLS, and CSV files so group header rows are skipped and products below receive a section path.

Updated: May 22, 2026

Some price lists group products with header rows inside the table instead of a separate "Section" column. For example, a row says "Accessories", the next row says "Keychains", and product rows follow below. Eofferix handles this with the "The table has section rows" mode.

How to enable section recognition

Section recognition in rows works when a section row differs from a product row because only one column with the section name is filled and all other columns are empty. These rows will not be imported as products.

It is enabled in the interpreter profile settings in the "Preview and table setup before transformation" block (available in the profile after a table is uploaded to the service).

After saving the profile and moving to snapshot editing, Eofferix adds the system field section_path, where the assembled section path is shown. It works in XML, JSON, table exports, and app imports.

Where to enable section rows in a profile with a table input

Choose the column that contains the section name in section rows.

How it works

  1. Open a profile whose input is a table file.
  2. In the table settings block, enable "The table has section rows".
  3. Enter the section name column number. Usually this is column 1.
  4. Save the settings and continue to the next step. There you will see a node with the built section path for each item.

If several section rows go one after another, Eofferix builds a section path in that order. For example, "Accessories" and "Keychains" give the products below the path "Accessories / Keychains". When the next section row appears, the path for following products changes.

Example of product grouping with section rows and demo SKUs

Section rows are skipped, while product rows receive the section path.

Important rules

  • A row is treated as a section only when the selected column is filled and all other columns are empty.
  • If the row contains SKU, price, barcode, or any other text in another column, Eofferix treats it as a product row.
  • The "section rows" transformation is applied after the other table settings (merging table sheets, selecting the header row, skipping rows, etc.).
  • The section path is stored as the system field section_path.