Margin Master Handbook
- Prerequisites
- Firewall and Network Requirements
- Microsoft Edge Download Block
- SQL Server Authentication Setup for IT Administrators
- Antivirus and Endpoint Security Exclusions
- SQL Server Tools
- Install or Upgrade SQL Server Express
- Install or Upgrade SQL Server Management Studio
- A Tour of the Main Window
- The Menus
- The Button Row
- The Main Data Grid
- The Summary Section
- Banners and Badges
- The Options Window
- Store Configuration
- Miscellaneous
- Export Options
- Vendor Settings
- POS / Connections Tabs
- Background Service
- AI Assistant (Experimental)
- How POS Import Works
- Supported Point-of-Sale Systems
- Data Import Workflows
- RockSolid POS Import
- Epicor Eagle FTP Import
- Epicor MySQL Compass Import
- Transact POS Import
- Paladin POS Import
- Falcon POS Import
- Spruce POS Import
- Bistrack POS Import
- RockSolid Max POS Import
- ECS POS Import
- Prosperity POS Import
- Catalyst POS Import
- Westlake POS Import
- MI9 POS Import
- AS/400 POS Import
- CounterWorks POS Import
- Dimension POS Import
- PacSoft POS Import
- ProStix POS Import
- Sympac POS Import
- Propello POS Import
- EagleVision POS Import
- MySQL/Compass Connection Configuration
- ECI VPN Requirement (Spruce, RockSolid MAX)
- Propello POS Integration Guide
- MI9 Data Pipeline — Import to Main Table
- Troubleshooting: Epicor Import Brought In 0 SKUs
- PACE POS Import
- Advantage POS Import
- General Store POS Import
- J-3 POS Import
- KeyStroke POS Import
- AutBusSystem POS Import
- Tomax POS Import
- Enterprise POS Import
- Computakey POS Import
- Redisell POS Import
- DART POS Import
- MIB POS Import
- Substruct POS Import
- DMAS POS Import
- RODS POS Import
- Procom POS Import
- Agility POS Import
- Acumen POS Import
- Cruise POS Import
- LSandE POS Import
- Retalix POS Import
- DIBCorp POS Import
- GMROI POS Import
- ECi Advantage POS Import
- Sunray POS Import
- ActivantAutomotive POS Import
- IBS POS Import
- Versys POS Import
- RMS POS Import
- TAMS POS Import
- Integrasoft POS Import
- Dynamic POS Import
- Microsoft ARS POS Import
- CDS POS Import
- Spartan POS Import
- Nitterhouse POS Import
- Jeds POS Import
- Theisens POS Import
- Emery Jensen POS Import
- SMS Pro POS Import
- Burdens POS Import
- Intact POS Import
- Bloom Retail POS Import
- NCR Counterpoint POS Import
- Horizon POS Import
- Cloud Vendor Data Sync
- Data Aging and Freshness Warnings
- Resetting Vendor and POS Data
- Rebuild Data and Rebuild Selection Lists
- Troubleshooting Vendor Sync
- Understanding the Strategy Hierarchy
- Pricing Strategies
- Creating a Strategy Step
- Updating and Deleting Steps
- Reviewing a Strategy and Running It
- Shared (Premade) Strategies
- SKU-Level Exceptions
- Manage Custom Groups
- Strategy Execution Cloud Tracking
- Importing from Excel
- Cost Break Analysis
- Cost Break Strategies
- Min/Max Strategies
- Strategy Backup & Restore
- Add Items from Catalog
- Store Grouping
- Data Diagnostics and Missing Index Recommendations
- System Diagnostics
- Margin Master Cannot Save Settings
- SQL Server 2025 Express vs. Full License
- Support Issue Management
- Catalog Lookup
- What's New After an Update
- Version History
- Documentation and the Help Buttons
- CTLD — Do It Best Catalog File
- MARGIN_MASTER — Ace Catalog File
- PCDITEMXREF — Do It Best SKU Classification File
- SAP_ZONE_PRICE_MARGIN_MASTER — Ace Zone Pricing File
- PCDPRODCLASS — Do It Best Product Classification Hierarchy File
- SAP_STORE_DEPT_ZONE_MARGIN_MASTER — Ace Store Zone Assignment File
- Taxonomy — Ace Product Classification File
- Mapp_Pricing — Ace MAP & IMAP Pricing File
- margin_mstr_plano — Ace Planogram File
On This Page
Edit Columns
What is this?
Edit Columns controls which columns are visible in the main data grid and in what order they appear. You can create multiple named column views and switch between them to see different sets of data columns.
Walk through it in the app: lesson 1019 — When your columns change or disappear. Margin Master can walk you through these steps live: turn on Training / Guide Mode from the Help menu, then type 1019 into the Lessons & Guides box — or ask Margin Master support to run it with you.
How to Access
- Menu: View > Edit Columns
Window Layout

- Hamburger menu — Copy Current View, Create New View, Delete Current View
- View Name dropdown — switch between saved column views
- Search box — filter the field list by name
- Column grid — every field, visible ones first in display order
- Sequence arrows — move the selected column up or down
- Cancel / Save
Select View (Top)
| Element | Purpose |
|---|---|
| Hamburger menu | Copy Current View, Create New View, Delete Current View |
| View Name dropdown | Switch between saved column views |
| Lock icon | Shown for default views (read-only) |
Column Grid (Center)
The grid lists every available field in two sections:
| Section | Description |
|---|---|
| Visible columns (top) | Checked fields, shown in your configured order |
| Hidden columns (bottom) | Unchecked fields, sorted alphabetically |
Each row has three columns:
| Column | Editable | Purpose |
|---|---|---|
| Field Name | No | Internal field identifier |
| Display Name | No | Human-readable label (reflects Field Manager customizations) |
| Column Visible | Yes | Checkbox to show or hide the column in the main grid |
Sequence Arrows (Right)
Use the up/down arrow buttons on the right side to reorder visible columns. Moving a hidden column up promotes it to visible.
Search Box
Type in the search box above the grid to filter fields by name.
Save / Cancel (Bottom)
Click Save to apply your changes, or Cancel to discard them. If you have unsaved changes and click Cancel or close the window, you will be prompted to save.
Working with Column Views
Default Views
Each vendor type comes with a pre-configured default column view. Default views are read-only -- you cannot change which columns are visible or their order. A lock icon appears next to the view name.
Creating a New View
Click the hamburger menu and choose one of:
- Copy Current View -- creates a copy of the selected view with all its columns and order preserved. You will be prompted for a name.
- Create New View -- creates a blank view with no columns selected. You will be prompted for a name.
Editing a View
- Select your custom view from the View Name dropdown.
- Check or uncheck the Column Visible checkbox for each field.
- Use the up/down arrows to reorder visible columns.
- Click Save.
Deleting a View
Click the hamburger menu and choose Delete Current View. Default views cannot be deleted. If you delete the active view, the application switches to the first remaining view.
Tips
- Use Copy Current View to start from a default view and customize it, rather than building a view from scratch.
- The sequence arrows only affect visible columns. Hidden columns are always sorted alphabetically.
- Column views work together with Field Manager customizations -- if you rename a field in Field Manager, the new name appears in the Display Name column here.
- Use View > Reset Columns in the main menu to reload the current column view, restoring the stored sequence and widths.
Common Questions
Q: Why can't I check or uncheck columns? A: You have a default view selected (indicated by the lock icon). Copy the view first to create an editable version.
Q: I rearranged columns by dragging in the main grid. Does that save automatically? A: No. Dragging columns in the main grid is temporary. To permanently change column order, use Edit Columns and save the view.
Q: What does "Reset Columns" do vs. Edit Columns? A: Reset Columns (View > Reset Columns) reloads the current view's stored column sequence, widths, and visibility. Edit Columns lets you change which columns are in the view and their permanent order.
Q: Can I have different column views for different stores? A: Column views are saved per database. If multiple stores share the same database, they share the same column views.
