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
The Lock Column
What is this?
The narrow column headed * on the main grid — usually sitting just to the right of Future
Price — shows a small orange padlock on any item whose Future Price was set by a specific rule
rather than by an ordinary strategy step. The symbol inside the padlock tells you which kind of
rule did it.
The padlock is a label, not a switch. You cannot click it to lock or unlock anything, and it does not stop a later strategy run from repricing the item. It is there so that when you look at a price and think "why is this one different?", the answer is one glance away.
Hover any padlock and Margin Master will tell you what it means.
The icons
| Icon | Means | Where it comes from |
|---|---|---|
| Priced from a margin rule — the price was calculated to hit a target margin. | A SKU-level exception or a rule set to a margin. | |
| Priced to a fixed retail — you typed the exact price you wanted. | A SKU-level exception or a rule set to a fixed retail. | |
| Priced from a cost break — the price came off a quantity cost break. | Any rule set to a Cost Break, including an ordinary strategy step. | |
| Priced from another price level — Retail, Level 1 through Level 5, a competitor price, List, a zone price, and so on. This is the catch-all, so it covers most of the price levels you can pick from. | A SKU-level exception or a rule set to any price level not covered above. | |
| Priced from another SKU — this item takes its price from a different item. | A SKU-level exception set to a SKU. | |
| Priced by a Custom Group — the item belongs to a custom group, and the group priced it. | Any custom group. Group members always get this icon, whatever the group prices to. |
The icon tells you what the rule did, not what kind of rule it was. A SKU-level exception set to a margin shows the percent padlock, the same as any other margin rule — see the questions below.
When the column appears

If you price Ace Hardware, Emery Jensen, or Do it Best products, Margin Master adds the * column
for you the first time a strategy run produces any locks, and slots it immediately to the right of
Future Price.
Once the column is part of your saved column view, it is yours: Margin Master will not move it or turn it back on, so you can position it wherever you like, or remove it entirely, through Edit Columns. Removing the column removes only the display — the locks themselves are unaffected.
Blank cells
Most rows have no padlock, which simply means no special rule touched that item — an ordinary strategy step priced it, or nothing did. On some point of sale systems every freshly imported row carries a placeholder value that also shows as blank. Either way, a blank cell means "nothing to explain here."
The Z column is a different thing
The equally narrow Z column that often sits nearby is unrelated. It shows a vendor logo, not a
padlock, on items that have zone pricing — the vendor pricing that varies by geographic zone rather
than being the same everywhere. Which zones your stores use is set under
the Store Manager (zones are assigned by Ace corporate; a store can override its zone there); see
Main Window Orientation.
Tips
If you are looking at a surprising price, check the padlock first. It narrows the search from "somewhere in my strategy" to one specific rule type in seconds.
A screen full of padlocks usually means a strategy leans heavily on custom groups or SKU-level exceptions. Both are meant to be the exception rather than the rule — see SKU-Level Exceptions for why keeping them to a minimum matters.
Sort or group by the
*column to pull every specially-priced item together for review.
Common Questions
Q: Can I click the lock to unlock an item? A: No. The padlock is purely informational — it reports what happened, it does not control anything. To change how an item is priced, change the rule that priced it: edit or deactivate the SKU-level exception, or remove the item from the custom group, then run the strategy again.
Q: My item has a SKU-level exception, so why does it show a percent sign instead of an S?
A: Because the icon describes the action. Your exception is set to a margin, so it shows the
margin padlock. The S padlock is reserved for the narrower case of an item priced from another
SKU. If you want to see which items have exceptions, open
SKU-Level Exceptions instead — that is the authoritative list.
Q: Why did this column appear on its own? A: The first strategy run that produces locks adds it, so that the locks are actually visible rather than silently recorded. From then on your column layout is respected.
Q: The lock is on the row but the Future Price looks unchanged. A: A Future Price of zero means no change, not a price of $0.00. The rule ran and marked the row, but produced no new price — usually because the rule had nothing to price from. Run the strategy again and read the Strategy Pre-flight Check dialog, which lists rules that cannot price.
Q: Two items are in the same custom group but priced differently. A: Groups run in sequence, and an item can belong to more than one group — the last group to run wins. Use Find Duplicate SKUs... in the Manage Custom Groups menu to find items that belong to more than one group.
