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
Printing and Exporting
What is this?
Print/Export - the printer button on the button row or File > Print - opens one dialog that does two jobs: it prints or exports the rows currently displayed in the grid, and it sends future prices to your point of sale. Sending is how a future price in the green column becomes a real price on the shelf.
Walk through it in the app: guides 2003 — Sending the changes and printing tags, 2004 — Finalizing in your point of sale, lessons 2005 — Why the counts differ and 2017 — When tags print wrong, lesson 2019 — When price changes come back, and for Paladin and RockSolid stores guides 4003 and 4004. Margin Master can walk you through these steps live: turn on Training / Guide Mode from the Help menu, then type the number into the Lessons & Guides box — or ask Margin Master support to run it with you.
This page is being expanded. The destinations and file layouts for each point-of-sale system are documented today in the system's own guide (for example Propello §3, Exporting price changes back to Propello).
The two kinds of output
| Output | What it produces | Typical use |
|---|---|---|
| Print / Excel | A printed report or Excel workbook of the displayed rows and columns | Reviewing a proposed change with staff; keeping a record |
| Send to point of sale | A price-change file, or a direct upload, in the format your POS imports | Making the future prices live |
For file exports, only the rows displayed in the grid are included. Label Master printing works from the loaded selection instead, so a filter typed into the grid columns narrows exports but not tags. Either way, set your selections first - and, for price changes, use the button row's Future Price greater than $0.00 so only changed items are sent (it narrows both).
Effective date
When sending price changes you are asked for the effective date the point of sale should apply them. Most stores choose the next morning so the change goes in overnight.
Tips
Send price changes only after reading the Summary for the same selection - it is the last check before the prices leave Margin Master.
Keep the exported file: Margin Master keeps a history folder for exports, and the file is the audit trail of what changed and when.
Common Questions
Q: I sent prices but the POS still shows the old ones. A: Check the effective date, and whether your point of sale needs its own import step to pick the file up - see your POS guide in Part III.
Q: Can I export just the columns I see? A: Yes. The export uses the current column view - choose the columns in Edit Columns first.
