↑↓ selectEnter openEsc close

    1. Elbuz

    How to work with categories as a table

    2 min readUpdated

    Elbuz shows the tree's categories as a grid: sort hundreds of rows, apply a preset filter, edit in the cell, and export to a file.

    When you need this:

    • Find categories without a photo, description, or SEO URL — nine preset filters, no setup.
    • Fix one field in dozens of categories — double-click the cell.
    • Get the category list in a file — XLSX with the visible columns, in tree order.
    • Check marketplace codes — ROZETKA, PROM.UA, epicentrk.ua, Google, Ceneo columns are turned on in the grid settings.

    Where to start: the “Table view” button above the tree in the “Categories” window.

    What it can do

    What you can do in the category table

    The “Table view” button above the tree opens the same categories as a grid. The tree is handy when you work with the structure; the table is for seeing many categories at once, sorting them, filtering them, and fixing the same field in dozens of rows.

    The grid has 51 columns, about ten shown; each user adds the rest with “Set up grid, add new fields”. Besides the obvious ones (name, full name, parent category, sort order, activity, level, number of products), there are descriptions, SEO fields, search synonyms and priority, shipping cost, template file, export flags, and marketplace category codes: ROZETKA, PROM.UA, epicentrk.ua, Google, Ceneo.

    The «Categories as a table» window: button bar, filter bar and the category grid
    1Set up grid
    2Delete
    3Export to file
    4Full name
    5Number of products
    1. Set up grid, add new fields — opens the column settings of the grid.
    2. Delete — removes the selected categories.
    3. Export to file — saves the grid contents to a file.
    4. Full name — the category name together with its parent path.
    5. Number of products — how many products the category contains.

    What you can do in this window:

    • edit values right in the cell — by double-clicking. Not every field is editable: calculated and system fields (category , parent category, level, full name, number of products, ) are read-only;
    • delete rows with the trash button — with the same cascade as in the tree: together with products and subcategories. Before deleting, Elbuz shows a list of what will be removed and asks you to confirm;
    • export to a file with the “Export to file” button;
    • refresh the list and clear the filter — in the “Additional Operations” menu;
    • filter categories with the preset filters above the grid.

    The “Active” column in the grid behaves differently from the toggle in the card. Editing the cell turns off exactly one row: its subcategories and products stay active, and the section stays on the site. Only the card cascades, so to switch off a whole branch, select the category in the tree and switch “Category activity” in the card.

    Which preset filters are above the grid

    The panel above the table has nine ready-made filters: “Source”, “Disabled”, “Without products”, “Without photo”, “Without description”, “Without SEO title”, “Without SEO URL”, “Top level”, “Not exported”. For catalog cleanup, “Without products” is the most useful: it shows categories you can remove without losing anything.

    “Without products” counts the same way as the badge in the tree: the whole branch, by the products' main category. The number is stored, so check the counter in the category card before deleting. How to delete what you find: how to remove empty categories.

    How to export categories to a file

    The button builds an file and gives you a link to it after the “Processing data, please wait...” message. Three things to know in advance:

    • the file gets only the columns currently visible in the grid, in the same order you arranged them. Need a field in the file? Turn on its column in the grid first;
    • the current grid filter is applied: filter a branch, and the branch is exported;
    • rows are sorted by the full category name, so the tree reads top to bottom in the file.

    On a demo account, export is limited to a hundred rows — this is a demo limit, not a file limit.

    Scenarios

    Find categories without an SEO title and add one

    What to do. Turn on the “Without SEO title” filter, add the SEO title column with the “Set up grid, add new fields” button, and edit by double-clicking the cell.

    What you get. The grid keeps only categories without a title, and you type the title right in the cell, without opening the card.

    Hand over the category list as a file

    What to do. Turn on and arrange the columns you need, filter the branch, and click “Export to file”.

    What you get. An XLSX with the visible columns in the same order; rows follow the full name, so the tree reads top to bottom.

    FAQ

    Why is a column I need missing from the file?

    Only the columns currently visible in the grid go into the file, in their order. Turn on the column in the grid and export again. More: exporting to a file.

    Why does the file have only a hundred rows?

    That's the export limit on a demo account; it's a demo limit, not a file limit.

    Why didn't “Active” in the table turn off the subcategories?

    The cell turns off exactly one row. Only the “Category activity” toggle in the card cascades to subcategories and products — turning off a category.

    Why can't I edit the “Full name” column?

    Calculated and system fields — ID, parent category, level, full name, number of products, UUID — are read-only. The full name updates on its own after you rename or move a category.

    How do I change a category name in the table?

    Double-click the cell in the “Name” column. This edits only the name in the main language; other languages are edited in the category card. More: renaming.

    Where to find it and who has access

    Menu
    Directories → Categories → “Table view” button
    Other entry points
    Base product catalog → Products → “Additional Operations” → “Category list”
    Access right
    same as for the “Categories” window; “Add” and “Delete” are separate rights

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free