Elbuz remembers your columns and filters in every list: product, contact and document grids open as you left them, and colleagues aren't affected.
When you need this:
- The grid has 200 fields, you need ten — find a field, turn it on with one click, hide the rest.
- You check last month's products daily — a filter button above the grid counts the date from today.
- The team needs your filter — one button copies it to every employee.
- Customers need to see your field — a checkbox sends it to your site's product page and search.
Where to start: the menu in the list toolbar → “Set up grid”.
What grid settings can do
- Columns — turn on, hide, reorder, pin to the left, show on the side panel.
- Field name and properties — header, default sorting, pick from a list; everyone sees these changes.
- Field on the site and in search — any field of the product grid can go to the product page and into the search index.
- Filter buttons — a list of values or a condition, with dates relative to today.
- Sharing a filter — a copy for every employee with one button.
How to keep only the columns you need
The “Grid column settings” window decides which columns your grid has at all, in what order and how wide. It is the same for every list in the app: products, contacts, documents, price lists.
1
All / Enabled / Disabled2
Drag handle3
Tech names- All / Enabled / Disabled — switch between the full list of columns, only the columns shown in the grid, and the hidden ones.
- Drag handle on the left of a row — drag the row with the mouse to change the column order.
- Tech names — shows the field macro and its system name.
At the top there's a field search and three views with counters: “All”, “Enabled”, “Disabled”. The product grid has over 200 fields, usually a few dozen on, so start with search, not scrolling. On the right you can see which grid the settings belong to: “Products from the base catalog”, “Contacts” and so on.
The window has three tabs.
| Tab | What it's for |
|---|---|
| “Order and visibility” | everyday work: turn on, turn off, reorder. Drag a row by the handle on the left; on the keyboard, Alt+↑↓ moves a row and Space turns a column on or off. Each row has three icons: the eye shows the column in the grid, the pin fixes it on the left, the panel icon also shows the field on the side panel. On the right you see the field type: “Text”, “Flag”, “Date / Time” |
| “All settings” | a table with all properties of every field |
| “Additional” | three switches for the grid as a whole: “Highlight entire row”, “Disable editing”, “Show filter row” |
What each property does:
| Property | What it does |
|---|---|
| “Display in grid” | the column is there or it isn't |
| “Column name” | the header. A change applies to all employees |
| “Width”, “Order” | the same as dragging a column border or a header in the grid itself |
| “Pinned” | the column always stays on the left and doesn't move when you scroll horizontally |
| “Show on panel” | the field is also shown on the side panel to the right of the selected row |
| “Sort by value” | the field is part of the default row order. The direction is set by the next column, “Sort ascending”, and the sequence among several such fields by the “Order” column beside it |
| “Pick from list” | the cell offers a list of values instead of free input |
| “Field type”, “Macro substitution”, “Field ID” | technical details: data type, macro for formulas and exports, field name in the database |
The “Tech names” switch shows the macro and the system name right in the list — handy when you're building a formula or an export template and need the exact macro. Search finds a field by these names either way.
The layout is personal: enabled columns, their order, width, pinning and panel display are saved to your user account. A new employee gets a copy of the account owner's layout and then adjusts it. Renaming a column and the properties of the field itself, however, are shared: everyone will see them.
The “Actions on found rows” button turns all columns that matched the search on or off at once. Disabled columns aren't gone for good — they sit in the “Disabled” view. A hidden column disappears only from your grid: if the field is in an export template, it is still exported.
The “Add new field” button in the same window creates your own catalog field — a number, line, text, flag, date, image, file, price or list. Such a field becomes a full column: you see it in the grid, and formulas and export templates can use it.
How to show your own field on the site and in search
Whether a field goes to your site and whether a product can be found by its value is decided by checkboxes on that field in the “All settings” tab of the “Set up grid” window of the base catalog product grid.
This works for any grid field — a standard one or a custom field you created. You don't need to create an attribute instead, and there's nothing to map in the export template: a field with the checkbox is passed by the Elbuz Tunnel export on its own.
1
Use for search index2
Display on the site in the product card3
Name on the site in the product card- Use for search index — the field value goes into the site search.
- Display on the site in the product card — the field goes to the product card on the OpenCart 3 site through Elbuz Tunnel.
- Name on the site in the product card — the label the customer sees.
- Open the base catalog product grid, choose “Set up grid” in the grid menu and go to the “All settings” tab.
- Find your field's row with the search at the top.
- To send the field to the product page on your site, turn on “Display on the site in the product card”. Its position among such fields is set by “Product card display order on the site”, and the label customers see by “Name on the site in the product card”; if it's empty, the column name is used. The field goes only through the Elbuz Tunnel export to an OpenCart 3 site. On a storefront built by Elbuz itself, the product page doesn't show custom fields, even with the checkbox on.
- To make the product findable by the field's value, turn on “Use for search index”. After the next reindex, the value is added to the text that smart search on the site searches. “Search priority” only sets the field order in the index, not match weight; the SKU and go to the priority part anyway.
These checkboxes are properties of the field itself, not of your layout: they apply to all employees at once.
How to create your own filters above the grid
Above every grid there's a row of filter buttons with counters: “Not matched”, “No photos”, “Overdue”. They aren't hard-coded — the set is yours and you can add to it.
The gear at the end of the row opens the “Filters” window: a list of your saved filters for this grid with name, description, order and active status. The pencil edits a filter, the “plus” adds a new one. This window has no menu item of its own; it opens only from the gear above the grid.
Two filter types
The first decision in the filter form is what it will be above the grid.
| Type | What it looks like and does |
|---|---|
| “List of values” | a dropdown with checkboxes. Values come from the selected field, and rows are filtered by the ticked ones. Good for manufacturer, warehouse, status |
| “Condition” | a toggle button. When it's on, the rule you built is added to the selection |
You build a condition in the condition builder: field, operator, value. Several conditions are joined with “and”/“or”, and nested groups set the priority — just like in other rules in the app.
Date fields accept placeholders — they are what keeps a filter “live”:
{TODAY}— today;{TODAY-30}— thirty days ago;{TODAY+7}— a week from now;{NOW}— the current moment.
They are resolved on every run, so a “created in the last month” filter never needs rewriting. A filter for a relative period — “orders from the last 7 days”, “products from the last month” — is the date created field, the “greater than or equal to” operator and the value {TODAY-7} or {TODAY-30} instead of “from” and “to” dates.
Other fields in the form: name — the text on the button; description — a tooltip on hover; order — the position among other filters; how many filters to show above the grid — after which button the rest go under “More”. The form has no “Save” button: everything saves automatically, and “Saved” lights up next to the title.
Every employee has their own set of filters. If a filter works well, the “Copy for all users” button shares it with the team; anyone who already has a filter with that name is left unchanged. Filters from the standard set are marked “Built-in”: their names come with the interface translation, but if you rename one, your name stays.
Scenarios
A buyer needs prices and stock in the product grid, colleagues need something else
What to do. In the product grid, open the menu in the toolbar → “Set up grid”, the “Order and visibility” tab. Turn on the price and stock columns, turn off the ones you don't need, drag the price closer to the start and, if needed, pin it.
What you get. Visibility, order, width and pinning are saved to the layout of your user account. Next time the grid opens the way you left it.
What won't happen. Your colleagues' grid won't change — everyone sets up their own. And a column you hid doesn't restrict anyone: you can close a field to a department only with group permissions.
The whole team checks products added in the last month every day
What to do. The gear in the filter row → “Filter settings” → “plus”. Type — “Condition”; in the rule, a date field and the value {TODAY-30}. Then click “Copy for all users” in the filter form and confirm.
What you get. {TODAY-30} is recalculated on every run, so the filter never goes stale. Every employee gets their own copy of the filter.
What won't happen. Anyone who already has a filter with the same name in this grid is left unchanged.
The copies are separate: later edits to your filter won't reach your colleagues, and sharing again won't update them, because they already have a filter with that name. Employees added later won't get this filter: new ones get the standard set. Only employees in the administrators group see the sharing button.
Customers should see your field on the site and search by it
What to do. In the base catalog product grid → “Set up grid” → the “All settings” tab, find your field. Turn on “Display on the site in the product card”, fill in “Name on the site in the product card” and turn on “Use for search index”.
What you get. With the next Elbuz Tunnel export, the field appears on the product page of your OpenCart 3 site, and after a reindex the product can be found by its value. You don't need to create an attribute or map it in the template.
What won't happen. On a storefront built by Elbuz itself, the field won't appear on the product page.
What to do when a grid or filter doesn't behave as expected
| What you see | Why | What to do |
|---|---|---|
| The grid opened completely empty | the employee has no personal layout for this grid | open “Set up grid” and turn on the columns you need — the layout will be created |
| The field you need isn't in the column list | the “Enabled” view is on | switch to “All” and use search |
| A colleague has different columns | the layout is personal | that's by design; only a column rename is shared |
| I renamed a column and it changed for everyone | the column name is shared | restore the previous name; to stop seeing the column yourself, just turn it off |
| I created a filter, but it isn't above the grid | display above the grid is off, or it's behind the “More” button | turn on display in the filter form and move it up in the order |
| A date filter selects the wrong rows a month later | the rule has a fixed date | replace it with the {TODAY-30} placeholder |
| “The field registry for this grid is empty — there is nothing to build a condition from” | the grid isn't registered in the app's field registry | contact support and name the window (your own filters) |
| The field is in the grid, but not on the product page on the site | “Display on the site in the product card” is off, or the site is an Elbuz storefront, which doesn't show custom fields | turn on the checkbox in the “All settings” tab and export via Elbuz Tunnel to an OpenCart 3 site (field on the site) |
FAQ
Will I mess up my colleagues' grid if I remove a column?
No. Visibility, order, width, pinning and panel display are saved for you personally. Only the column name and the properties of the field itself are shared.
Where does a new employee's grid come from?
The app copies the account owner's layout for them the first time they open the grid. After that they adjust it, and it no longer affects the owner.
Can I hide a field from an employee by removing the column?
No: the layout is personal, and everyone turns on their own columns. You can close data to a department only with group permissions.
How do I create a saved filter for “orders from the last 7 days”?
In the order list: the gear above the grid → “plus”, type “Condition”, the date created field, the “greater than or equal to” operator, value {TODAY-7}. The date is counted from today on every run. More in your own filters.
Can I share my filter with the whole team?
Yes, with the “Copy for all users” button in the filter form. Employees who already have a filter with that name are left unchanged.
Where can I see a field's macro for a formula or export?
In the “Set up grid” window, turn on the “Tech names” switch — the macro and system name appear next to the column name, and you can copy them with a click.
Where to find it and who has access
- Grid columns
- the menu in the toolbar of any list → “Set up grid”
- Your own filters
- the gear at the end of the filter row above the grid; there is no menu item
- Access right
- “Copy for all users” — administrators group only
Related topics
- If you need the big picture of what's personal and what's shared — Setting up Elbuz your way.
- If you filter products in the grid every day — Finding and filtering products.
- If you need a field macro for a formula — Formulas for catalog fields.
- If the field you need isn't in the catalog yet — Custom product fields.
- If you next want to declutter the menu — Menu, shortcuts and windows.
