Margin Master Handbook
Introduction
Part I · Installing
- 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
Part II · Introducing the Main Window
- A Tour of the Main Window
- The Menus
- The Button Row
- The Main Data Grid
- The Summary Section
- Banners and Badges
Part III · Initial Configuration
- 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
Part IV · Customizing the Workspace
Part V · Basic Application Functionality
Part VI · Learning Margin Master
- 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
Part VII · Advanced Topics
- Importing from Excel
- Cost Break Analysis
- Cost Break Strategies
- Min/Max Strategies
- Strategy Backup & Restore
- Add Items from Catalog
- Store Grouping
Part VIII · Updates, Troubleshooting & Help
- 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
Appendix
- 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
Part III · Chapter 7 — Point of Sale: Connect, Configure, Import, TroubleshootUpdated 2026-08-28
Prosperity POS Import
What is this?
The Prosperity import reads tab-delimited text files exported from the Prosperity point-of-sale system. It uses a BCP staging pipeline and includes 13 months of individual sales history fields that map to Margin Master's standard history columns.
Import File Format
| Property | Value |
|---|---|
| Delimiter | Tab (\t) |
| File pattern | *.txt |
| Header row | Yes (1 row) |
| Field count | 23 |
Fields
| # | Field | Margin Master Column | Description |
|---|---|---|---|
| 1 | Sku | SKU | Item SKU |
| 2 | Store | Store | Store identifier |
| 3 | Department | Dept | Department |
| 4 | Class | Class | Class |
| 5 | Description | Description | Item description |
| 6 | Location | Location | Bin/location (blank becomes "Blank") |
| 7 | Retail | CurrentPrice | Current retail price |
| 8 | OnHandQuantity | OnHand | Quantity on hand |
| 9 | VendorNumber | PrimeVendor | Primary vendor |
| 10 | AverageCost | COST | Average cost |
| 11 | Sales_Current_Month | History0 | Current month sales |
| 12 | Sales_1_Month_Ago | History1 | 1 month ago sales |
| 13 | Sales_2_Month_Ago | History2 | 2 months ago sales |
| 14 | Sales_3_Month_Ago | History3 | 3 months ago sales |
| 15 | Sales_4_Month_Ago | History4 | 4 months ago sales |
| 16 | Sales_5_Month_Ago | History5 | 5 months ago sales |
| 17 | Sales_6_Month_Ago | History6 | 6 months ago sales |
| 18 | Sales_7_Month_Ago | History7 | 7 months ago sales |
| 19 | Sales_8_Month_Ago | History8 | 8 months ago sales |
| 20 | Sales_9_Month_Ago | History9 | 9 months ago sales |
| 21 | Sales_10_Month_Ago | History10 | 10 months ago sales |
| 22 | Sales_11_Month_Ago | History11 | 11 months ago sales |
| 23 | Sales_12_Month_Ago | History12 | 12 months ago sales |
How Import Works
The export file is read from the Import Path set under Tools > Options > Miscellaneous:
- Export your inventory and sales data from Prosperity as a tab-delimited
.txtfile. - Place the file in the configured import folder.
- Margin Master reads the file and processes it through the BCP staging pipeline.
- The finalize step prepares the data for the
[Store]table. - The main table build joins your POS data with vendor catalog data.
Field Mapping
| Prosperity Field | Margin Master Column | Notes |
|---|---|---|
| Sku | SKU | Item SKU |
| Store | Store | Store identifier |
| Department | Dept | Department |
| Class | Class | Class |
| Description | Description | Item description |
| Location | Location | Blank values converted to "Blank" |
| Retail | CurrentPrice | Converted via HistoryConverter |
| OnHandQuantity | OnHand | Quantity on hand |
| VendorNumber | PrimeVendor | Primary vendor |
| AverageCost | COST | Average cost |
| Sales_Current_Month | History0 | Current month sales |
| Sales_1_Month_Ago through Sales_12_Month_Ago | History1 through History12 | Monthly rolling sales history |
Location Handling
If the Location field is blank or empty, it is automatically set to "Blank" during import. This ensures every record has a location value.
Troubleshooting
| Symptom | Likely cause | What to do |
|---|---|---|
| No Files Found when you choose Get POS Data | The export is not in the Import Path (Tools > Options > Miscellaneous), or its name does not match the pattern above | Check the path and the file name; Margin Master reads only the current folder, not sub-folders |
| The same file is imported again and again | The previous import's file was not renamed | After a successful import the file is renamed to NAME[ext].BAK; a file that keeps its name did not import - read the error dialog |
| 0 records or far fewer than expected | The export covers the wrong store, or the store is not matched in the Store Manager | Open Store Manager and check the store's row; re-export from the point of sale |
| Columns land in the wrong fields | The export layout changed | Compare the file's header row with Field Mapping above; contact Margin Master support with the file |
| Import finishes but the grid does not change | The rebuild was postponed (the Click to update data badge is showing) | Click the badge, or Data > Rebuild Data |
Every import failure shows one error dialog; the log under File > Utilities > Show Log Files has the detail to send to support.
Tips
Prosperity uses tab-delimited files, not comma or pipe. Make sure your export is configured for tab separation.
Blank location values are automatically converted to "Blank" -- you do not need to fill these in before importing.
The 13 monthly sales fields (Sales_Current_Month through Sales_12_Month_Ago) provide a full rolling year of sales history for Margin Master's analysis features.
Common Questions
Q: My Prosperity export has blank locations for many items. Is that a problem? A: No. Blank locations are automatically converted to the text "Blank" during import. This is normal for items that do not have assigned bin locations.
Q: How does the Retail field differ from CurrentPrice? A: They are the same value. The Prosperity export calls it "Retail" and Margin Master stores it as "CurrentPrice." A history converter is applied during import to ensure the value is in the correct numeric format.
Q: Does Prosperity support competitor pricing? A: No. The Prosperity export format does not include competitor price fields. Only the 23 fields listed above are imported.
