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
Installation and First Launch
What is this?
This guide walks you through installing Margin Master on your computer and what to expect the first time you launch the application. Margin Master is a Windows desktop application that requires a SQL Server database and an active Margin Master license.
Walk through it in the app: lesson 1012 — Installing on the new computer, lesson 1016 — Setting up a brand-new store for the whole road map from install to first price change, or lesson 1020 — Margin Master on more than one computer. Margin Master can walk you through these steps live: turn on Training / Guide Mode from the Help menu, then type 1012 into the Lessons & Guides box — or ask Margin Master support to run it with you.
System Requirements
- Operating System: Windows 10 or later (64-bit)
- Runtime: .NET 10.0 Desktop Runtime (Windows)
- Database: Microsoft SQL Server 2022 or 2025 (Express or Standard), local or network instance. The installer sets up SQL Server 2025 Express when no instance is present. Supported versions follow Microsoft's SQL Server support lifecycle - once Microsoft ends support for a version, so does Margin Master.
- Internet: Required for license validation, cloud vendor data sync, and automatic updates
- Display: Minimum 1280x800 resolution recommended
Installation Steps
- Obtain the Margin Master installer from Margin Master support or the update distribution system.
- Run the installer and follow the on-screen prompts.
- Accept the license agreement and choose your installation directory.
- The installer will place Margin Master on your desktop and Start Menu.
First Launch
When you launch Margin Master for the first time, the application follows this sequence:
1. Splash Screen
A startup window appears displaying "Margin Master" with a progress bar and real-time status messages. The splash screen tracks four initialization steps:
| Step | Description |
|---|---|
| 1 | Initializing environment |
| 2 | Loading services |
| 3 | Checking database |
| 4 | Loading application data |
Each step displays a color-coded status indicator:
- Gray circle -- Pending
- Blue circle -- Running
- Green circle -- Completed successfully
- Red circle -- Failed
The footer shows the current step description on the left and a progress counter (e.g., "2 / 4 steps completed") on the right.
2. Single Instance Check
Margin Master uses a system-wide mutex (MarginMasterAppMutex) to enforce single-instance operation. If you try to open a second copy, the application will immediately exit with:
"Another instance is already running."
Close the existing instance before launching a new one.
When the application exits (normally or after a crash), it performs a graceful cleanup that releases database connections, flushes logs, and releases the mutex -- ensuring no orphaned locks remain.
3. Database Configuration
If no valid database connection is found, Margin Master will prompt you to configure one. See Database Connection Setup for detailed instructions.
4. Store Configuration
After connecting to a database, Margin Master will prompt you to enter your store information and validate your license. See Store Configuration for detailed instructions.
5. Main Application
Once startup completes successfully, the main Margin Master window opens. See Main Window Orientation for a tour of the interface.
Tips
Tip: If the splash screen shows a red indicator on any step, note the error message displayed. Most issues are related to database connectivity or license validation. Contact Margin Master support if the error is not self-explanatory.
Tip: Margin Master checks for updates automatically. If an update is available, a green banner will appear in the main window with the text "Click to update".
Common Questions
Q: The splash screen hangs on "Checking database" -- what do I do? A: This usually means the SQL Server instance is unreachable. Verify that SQL Server is running and that your network connection is stable. See Database Connection Setup for troubleshooting.
Q: I see "Another instance is already running" but I don't have another window open. A: A previous instance may not have shut down cleanly. Open Task Manager (Ctrl+Shift+Esc), look for "Margin Master" in the process list, and end the task. Then relaunch.
Q: Where are Margin Master's files installed? A: The default installation directory is set during setup. Application data (logs, configuration) is stored in the common application data folder for RetailerSoft.
Q: Margin Master crashes immediately on startup -- what happened? A: An earlier version had a bug where the main window's startup configuration could cause a crash before the UI appeared. This was caused by a conflict between the window's activation and maximized state settings. Update to the latest version to resolve this.
Q: Margin Master steals focus from other applications when it starts up. A: This was a known issue in earlier versions where the main window would activate and pull focus away from whatever application you were working in during startup initialization. This has been fixed -- update to the latest version.
Q: Do I need internet access to use Margin Master? A: Internet is required for initial license validation and cloud vendor data sync. After initial setup, most features work offline, but you will not be able to sync vendor data or check for updates without a connection.
