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
Understanding the Strategy Hierarchy
What is this?
A pricing strategy is a list of steps. When the strategy runs, the steps execute from the top down, one after another, and each step sets a future price on every SKU its selection matches. Because a later step can price a SKU an earlier step already priced, the last step to touch a SKU wins. That single rule is the whole hierarchy - and it is why order is the first thing to get right.
Strategies are hierarchical. General rules first, specific rules below them. The general rules give every SKU a price; the specific rules below override it wherever they apply. That keeps pricing consistent while still allowing exceptions.
The rule, precisely
- Steps run in the order shown in the Strategy Manager, top to bottom. Inactive steps are skipped.
- Each step selects SKUs (its saved selection) and applies its action (Set Future Price to ... plus rounding, No Decreases, Min/Max).
- If a SKU matches several steps, each one sets its price in turn; the last matching step's price is the one that stays. The grid's PSRule column shows that final step; PS Rule History keeps the whole trail.
- Custom Groups run after every standard step, and SKU Level Exceptions always run last - so an exception beats everything.
A worked example
A hardware store wants: everything at the vendor's retail; the paint department at a 42% margin; one competitive-sensitive line held to the vendor's Level 1; and three SKUs at fixed prices.
| # | Step | Selection | Action |
|---|---|---|---|
| 1 | Everything at retail | ALL | Set Future Price to Retail |
| 2 | Paint margin | Department = PAINT | Set Future Price to Margin: 42% |
| 3 | Sensitive lines | Price Sensitivity = S | Set Future Price to Level 1 |
| 4 | (SKU Level Exceptions) | three SKUs | Fixed retail |
A paint SKU is priced by step 1 (retail), then re-priced by step 2 (42% margin) - step 2 wins. A sensitive paint SKU goes through 1, 2 and 3 - Level 1 wins, because step 3 is lower in the list. Put step 3 above step 2 and the sensitive paint SKU would end at the 42% margin instead: same steps, different prices, purely because of order.
Step 1 is broad on purpose. It guarantees every SKU gets a price, so a SKU no specific rule covers is never left blank - and the run's summary can tell you how many SKUs each step finally priced versus merely touched.
Reading order in the manager
- The step list has no sorting - what you see is the execution order.
- Skus shows how many SKUs a step's selection matched on the last run.
- A step high in the list that matches many SKUs but finally prices few is a broad rule doing little more than setting defaults - usually right for step 1, usually wrong anywhere else.
Tips
Name steps for what they decide, not what they select: Paint 42% margin rather than Dept 10.
When a SKU's price surprises you, look at PSRule first - it names the step that set it - then PS Rule History for the steps that were overridden.
Common Questions
Q: Can two steps price the same SKU on purpose? A: Yes - that is how specific rules refine general ones. Just make sure the specific step is below the general one.
Q: Does an inactive step still take part? A: No. Toggle Act off to take a step out of the run without deleting it.
Q: Where do custom groups and exceptions fit? A: After all standard steps; exceptions last of all. See Custom Groups and SKU-Level Exceptions.
