Skip to main content
Once your Grid is created, you can configure the grid to match your pricing workflow. Retailgrid gives you full control over:
  • Visible columns
  • Column order
  • Pinned columns
  • Sorting
  • Grouping
  • Saved views
Below is how to configure your grid efficiently.
Your grid layout — visible columns, order, sizes, sorting, grouping, and filters — saves automatically to one durable configuration per grid, stored in the backend rather than your browser. A confirmation shows in the status line at the top of the grid, and there’s no “Leave site? Changes you made may not be saved” prompt to worry about. Views (see step 7) are for naming and switching between distinct saved layouts, not for avoiding lost work.

Default columns and saved configuration

A brand-new grid opens with a lean default column set aimed at price review, not every column at once. When the data exists, you start with about 15 columns - Image URL, SKU, Product Name, Brand, Price, Unit Cost; Unit Margin %, Sales Units (30d), Sales Value (30d); Price range, Competitor CPI (min); Proposed Price, Price Change %, New Unit Margin %, and Actions. Everything else starts hidden but is one click away in Columns (step 1). Before metrics or agent outputs exist, only the available subset shows, and the rest appear as they’re produced. Your configuration is saved as one durable record per grid in the backend, so it follows the grid everywhere: it survives a reload, a scope change, and opening the grid in another browser, and a shared grid shows the same saved layout. Duplicating a grid copies its configuration as an independent starting point. Agent runs only set defaults for the new columns they add - they never reset columns you’ve shown, hidden, or reordered.

Search the grid

Use the grid search box to find a product by any attribute — SKU, name, brand, EAN, supplier, category, or any custom field — without building a filter. Type a value and the grid narrows to matching rows instantly. Clear the search to return to the full set.

1. Select visible columns

You can show or hide any column.

How to do it

  1. Click Columns in the top toolbar
  2. Use the search field to find a column
  3. Click the eye icon to:
    • Show column
    • Hide column
  4. Toggle a whole section at once with the eye icon on its section header
The Columns panel groups related columns into expandable sections, supports search, and lets you expand, collapse, and toggle each section. A visible-count indicator (e.g. “15 / 239 visible”) shows how many columns are on, so you can keep the grid lean.

Column type icons

Each column header shows a small icon indicating its type:
  • Editable — manually entered values you can change row by row.
  • Formula — calculated from other columns; values update automatically.
  • AI-generated — populated by a Retailgrid AI action (e.g. enrichment, classification).

Best practice

Keep only what you need for the task.
Example for pricing work:
  • Product Name
  • Price
  • Unit Cost
  • Margin
  • Competitor Price
  • Status
Columns panel with grouped sections, search, and bulk show/hide controls

2. Order columns by drag and drop

You can rearrange columns freely.

How to do it

  • Click and hold a column header
  • Drag it left or right
  • Drop it where you want it
Left (fixed reference):
  • Product Name
  • Product ID
Middle (analysis):
  • Price
  • Unit Cost
  • Margin
  • Elasticity
Right (attributes):
  • Brand
  • Category
  • Manufacturer
Organize based on your workflow.

3. Pin columns

Pinning keeps important columns visible while scrolling.

How to pin

  1. Click the three-dot menu on a column header
  2. Select Pin Column
  3. Select:
    • Pin Left
    • Pin Right

When to use

Pin Left:
  • Product Name
  • SKU
Pin Right:
  • Status
  • Actions
Pinning is essential when working with many pricing metrics.

4. Sort values

You can sort any column.

How to sort

  • Click column header to toggle ascending / descending
    OR
  • Use the column menu → Sort Ascending / Descending

Example use cases

  • Sort by Price Descending → find premium items
  • Sort by Unit Cost Descending → detect cost risk
  • Sort by Margin Ascending → identify weak SKUs
You can also Clear Sort from the column menu. The image column is sortable and filterable like any other column; products without an image show a placeholder so missing imagery is easy to spot.

5. Group products

Grouping lets you analyze structured segments.

How to group

  1. Drag a column into the grouping area
    OR
  2. Use the Group column
You can group by any column — the loaded-data attributes stored in the grid and dynamic, AI-derived columns alike. Example groupings:
  • Group by Product Group
  • Group by Brand
  • Group by Category
  • Group by Product Role (or any other dynamic column)
You’ll see collapsible sections:
  • Oranges (2)
  • Blueberries (2)
  • Romaine (2)

Why grouping matters

  • Compare pricing inside category
  • Spot inconsistencies
  • Review margin distribution by group
Grouping turns a flat list into a structured analysis tool.

Value aggregation per column

When grouping is active, each numeric column rolls up to a single value per group. Retailgrid picks a sensible default based on the column’s semantic type — Sales sums, Price and Margin average, Product ID counts. Aggregation runs on the backend so the rolled-up values stay correct and consistent across any grid size. To override the default, open the column header’s three-dot menu → Value Aggregation and pick from None, Sum, Average, Min, Max, Count. Your override is per-column and persists with the grid view.

6. Filter columns

Filtering allows you to narrow down products based on specific criteria — instantly focusing on what matters. The Filters button in the grid toolbar shows a count badge whenever one or more column filters are active, so you can tell at a glance that you’re looking at a filtered subset rather than the whole grid. You can filter any column (numeric, text, status, etc.).

How to apply a filter

  1. Click the filter icon in the column header
  2. Select a condition from the dropdown
  3. Enter your filter value
  4. The grid updates immediately

Numeric filters (price, cost, margin, etc.)

For numeric columns, you can use:
  • Greater than
  • Less than
  • Equals
  • Not equal
  • Between

Example

  • Price Greater than 2
  • Unit Cost Less than 3
  • Margin Below 20%
You can also combine conditions using:
  • AND
  • OR
Example:
  • Price > 2 AND Price < 5
This helps you isolate specific price corridors.

Text filters (brand, product name, SKU, etc.)

For text columns, you can filter by:
  • Contains
  • Equals
  • Starts with
  • Ends with

Example

  • Brand equals Arla
  • Product Name contains Greek

7. Save view as default or create your own view

Once your layout is configured, save it as a named view to switch back to later. (Your working layout already autosaves — named views are for keeping several distinct setups side by side.)

How to save

  1. Click Views in the toolbar
  2. Enter a name (e.g., “Margin Analysis”)
  3. Click Add
You can:
  • Keep Default view
  • Create multiple custom views
  • Switch between them instantly

Example saved views

Saved views allow different teams (pricing, category, operations) to work in the same grid with different layouts.
The Views panel, with the saved view list and the field for naming a new one

Reset layout

If needed, click Reset to restore the default configuration.