Configure Grid

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.

​

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. You can also use Hide All if you want to rebuild the layout from scratch

​

Best practice:

Keep only what you need for the task.
Example for pricing work:

• Product Name
• Price
• Unit Cost
• Margin
• Competitor Price
• Status

Cleaner grid = faster decisions.

​

Visible columns

​

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

​

Recommended layout:

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. Choose:
   • 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.

​

Pin column

​

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.

​

Sorting

​

5. Group products

Grouping lets you analyze structured segments.

​

How to group:

1. Drag a column into the grouping area (if enabled)
   OR
2. Use the Group column (if preconfigured)

Example groupings:

• Group by Product Group
• Group by Brand
• Group by Category

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.

​

Group

​

6. Filter columns

Filtering allows you to narrow down products based on specific criteria — instantly focusing on what matters. You can filter any column (numeric, text, status, etc.).

​

How to apply a filter

1. Click the filter icon in the column header
2. Choose 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

​

Filtering

​

7. Save view as default or create your own view

Once your layout is configured, save it.

​

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.

​

Reset layout

If needed, click Reset to restore the default configuration.