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
Epicor MySQL Compass Import
What is this?
The Epicor MySQL Compass import reads inventory data from a MySQL Compass data warehouse running on your local network and loads it into Margin Master for pricing analysis. This is an alternative to the Epicor FTP import for stores that have a Compass data warehouse available. It supports both Ace Hardware/Emery Jensen and Do it Best vendor pairing.
Import File Format
MySQL Compass does not use a file. Margin Master connects directly to the MySQL database on your local network.
- Database: MySQL (typically on your local network)
- Default server: Usually
10.192.255.xon port3306 - Database name:
EAGLEDW - Source table:
IN(inside the EAGLEDW database) - User:
dbread(read-only access) - Total columns: 78 fields read from the IN table
Key Fields
| Field | Description |
|---|---|
| in_sku | Item SKU number |
| in_store | Store identifier (single character) |
| in_dept | Department code |
| in_class | Class code |
| in_desc | Primary item description |
| in_desc2 | Secondary item description |
| in_retail | Current retail price |
| in_cost | Item cost |
| in_repl_cost | Replacement cost |
| in_oh | Current inventory quantity |
| in_pgrp | Product group code |
| in_h0 through in_h12 | Monthly sales history (13 periods) |
| in_velo | Sales velocity code |
| in_pvend | Primary vendor code |
| in_avend | Alternate vendor code |
| in_db_update_datetime | Last update timestamp (used for incremental sync) |
How Import Works
Connect via MySQL / Compass - checked.
MySQL Connection - Server, Port, Database, Username, Password, Auth/SSL and Prime Vendor.
Compass Options.
Test & Save Connection / Troubleshoot Connection...
Restore from Cloud... / Reset to Defaults.
Open Store Manager...
Margin Master connects to the MySQL Compass data warehouse on your local network using the server, port, database, and credentials configured in Options.
On the first import, all rows are downloaded. On subsequent imports, only rows changed since the last sync are downloaded (incremental sync based on
in_db_update_datetime).Downloaded rows are bulk-merged into the local
Compass_INstaging table.Store filtering matches each store's character to the Vendor Store # you assigned in Store Manager, using the store character's ordinal (
WHERE ORD(in_store) = <store ordinal>).For each store, a SQL MERGE operation updates the per-store main table with the latest data.
Vendor-specific enrichment is applied based on your vendor configuration:
- Ace Hardware / Emery Jensen: Catalog data, zone pricing, and MAP pricing from Ace cloud data.
- Do it Best: Vendor data, RSC codes, and unit-of-measure scaling from Do it Best cloud data.
Ace Direct SKU handling: items with SKU numbers ending in "D" have the suffix stripped to match Ace catalog records.
SKU reconciliation removes any local rows for items that no longer exist in the MySQL source (if enabled).
Field Mapping
| MySQL Compass Field | Margin Master Field |
|---|---|
| in_sku | SKU |
| in_store | StoreNumber (character to numeric) |
| in_dept | Dept |
| in_class | Class |
| in_desc | Description |
| in_desc2 | Description2 |
| in_retail | CurrentPrice |
| in_cost | COST |
| in_repl_cost | ReplacementCost |
| in_oh | OnHand |
| in_pgrp | ProductGroup |
| in_h0 through in_h12 | History0-History12 |
| in_velo | sVelocity |
| in_pvend | PrimeVendor |
| in_avend | AVendor |
Tips
Incremental sync saves time. After the first full import, only changed rows are downloaded. This makes subsequent imports much faster, especially for large inventories.
MySQL connection settings are in Options. Go to Options, then the Epicor tab and check Connect via MySQL / Compass to configure your MySQL server address, port, database name, and credentials.
Store configuration is required. Each store must be matched to a Vendor Store # in Store Manager before its data can be imported. A store with no Vendor Store # (a Needs Setup badge) imports 0 SKUs. If a store imports nothing, see Troubleshooting: Epicor Import Brought In 0 SKUs.
SKU reconciliation is optional. The
ReconcileMySqlDeletedSkussetting controls whether Margin Master removes local rows for items deleted from the MySQL source. Enable this to keep your data clean, but be aware it will remove any locally-added items.
Works with both Ace and Do it Best. Unlike the FTP import (Ace only), MySQL Compass import supports both Ace Hardware/Emery Jensen and Do it Best vendor data, depending on your store configuration.
Common Questions
Q: What is the difference between FTP and MySQL Compass import? A: FTP downloads a binary file directly from the Eagle server. MySQL Compass reads from a local MySQL data warehouse. Both provide the same inventory data. Use MySQL Compass if your store has a Compass data warehouse on the local network.
Q: Why does the first import take longer? A: The first import downloads all rows from the MySQL database. Subsequent imports only download rows that have changed since the last sync, making them much faster.
Q: What vendor data can I use with MySQL Compass? A: MySQL Compass supports both Ace Hardware/Emery Jensen and Do it Best vendor pairing. The vendor enrichment applied depends on your store's vendor configuration.
Q: What happens if an item is deleted from Epicor?
A: If the ReconcileMySqlDeletedSkus setting is enabled, Margin Master will detect items that no longer exist in the MySQL source and remove them from your local main tables during reconciliation.
Q: What are the key settings for MySQL Compass?
A: The main settings are UseMySqlCompass (enable/disable), MySqlServer (server address), MySqlPort (default 3306), and MySqlDatabase (default EAGLEDW). These are configured in the Options window.
