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
How Margin Master Thinks
What is this?
Margin Master is a pricing tool for independent retailers. Before the installation steps and the screen-by-screen chapters, it helps to know the three ideas the whole application is built around. Every later chapter leans on at least one of them, and each is repeated as a short callout where it applies.
Vendor suggested pricing is the baseline, not the answer
Your vendor's suggested retail and price levels are a great start toward what your price should be. But a single suggested price - or any one of the suggested price levels - cannot properly fit every store in every demographic in every region of the country. It does not hold true, and it does not make sense.
Margin Master starts from the vendor's price levels as the baseline, then adjusts for what only you know about your business:
- your own stores and how each one performs,
- local market conditions and the level of competition,
- the demographics you serve,
- each store's strengths and weaknesses.
The vendor data in the grid tells you where the vendor thinks the price should be. Your pricing strategy says where you want it to be. See Vendor Data, the Future Price Panel and Pricing Strategies.
Strategies are hierarchical
A pricing strategy is a list of steps that run from the top down. The general rules come first and set the tone for the whole store; the more specific sub-rules below them override the general rule wherever they apply.
That is what keeps pricing consistent - every SKU gets a price from some rule - while still allowing exceptions: a department, a product group, a single item or a competitor-matched line can be handled differently without disturbing everything else. Because the order carries meaning, the order is where most strategy mistakes live too. See Pricing Strategies.
Rounding is the quiet margin driver
Of everything Margin Master does, rounding is one of the most powerful - and least visible - ways to improve margin. Two stores can run the same strategy and end up with noticeably different margins purely because of how the final cents are set.
A rounding scheme decides where each calculated price lands: $4.97 or $4.99, $12.49 or $12.99. Done well it is transparent to the customer and worth points of margin across a store. See Rounding Schemes.
Where to go next
The handbook follows the path a new store takes: Installing (Part I), a tour of the main window (Part II), the required configuration for your point of sale and vendor (Part III), optional workspace customization (Part IV), then the basics (Part V) and, in Part VI, learning to select data, use the Future Price panel and build strategies. Advanced topics, updates, troubleshooting and getting help close the book.
Start with Prerequisites.
