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
RockSolid Max POS Import
What is this?
RockSolid Max imports your store's inventory and sales data from pipe-delimited text files exported by the RockSolid Max POS system. Note: RockSolid Max is completely separate from the standard RockSolid POS -- they use different file formats, different field layouts, and different import pipelines.
VPN tunnel required for direct database connections. When RockSolid Max (RSMax) is configured to pull data directly from the ECI-hosted database instead of a local export file, ECI requires an active site-to-site VPN tunnel between the store and ECI. There are no work-arounds — without the tunnel, Margin Master cannot connect even with valid credentials. This does not apply to file-based imports. See ECI VPN Requirement for setup details.
Import File Format
| Property | Value |
|---|---|
| Delimiter | Pipe (\|) |
| File pattern | *Data.txt |
| Header row | Yes (1 row) |
| Field count | 28 |
Fields
| # | Field | Description |
|---|---|---|
| 1 | STORE | Store identifier |
| 2 | RETAILPRICE | Current retail price |
| 3 | MFGRNAME | Manufacturer name |
| 4 | MFGRCODE | Manufacturer code |
| 5 | QUANTITYONHAND | Inventory on hand |
| 6 | AVERAGE_COST | Average cost |
| 7 | REPLACE_COST | Replacement cost |
| 8 | LISTPRICE | List price |
| 9 | SKU | Item SKU |
| 10 | DESCRIPTION | Item description |
| 11 | GROUP | Group code |
| 12 | GROUPNAME | Group name |
| 13 | SECTION | Section code |
| 14 | SECTIONNAME | Section name |
| 15 | UNIT | Unit of measure |
| 16 | UPC | Universal Product Code |
| 17 | CLASS | Class code |
| 18 | DEPARTMENT | Department code |
| 19 | FINELINECODE | Fineline code |
| 20 | PRODUCTID | Product ID |
| 21 | VENDORNUMBER | Vendor number |
| 22 | LAST_YEAR_SALE_DOL | Last year sales dollars |
| 23 | LAST_YEAR_SALE_UNIT | Last year sales units |
| 24 | YTD_TRANSACTION | Year-to-date transactions |
| 25 | YTD_SALES_DOL | Year-to-date sales dollars |
| 26 | LocationCode0 | Location code 0 |
| 27 | LocationCode1 | Location code 1 |
| 28 | LocationCode2 | Location code 2 |
How Import Works
Add Connection - one card per store database.
Restore from Cloud...
Open Store Manager...
The connection card - Store #, Host/IP, Database, Username, Password, Active, Use Group/Section for Dept/Class, Exclude Stores.
Test / Delete.
Export your data from RockSolid Max. The file should be named with a
Data.txtsuffix (e.g.,StoreData.txt).Place the file in the configured import folder.
Margin Master reads the pipe-delimited file, cleaning descriptions by removing tabs and newlines.
Data is loaded via the BCP staging pipeline into a staging table.
The finalize step trims leading zeros from store numbers and removes duplicate records.
Data is inserted into the
[Store]table for main table building.
Field Mapping
| RockSolid Max Field | Margin Master Column | Notes |
|---|---|---|
| STORE | Store | Store identifier |
| SKU | SKU | Item SKU |
| RETAILPRICE | CurrentPrice | Current retail price |
| DESCRIPTION | Description | Cleaned (tabs/newlines removed) |
| QUANTITYONHAND | OnHand | Inventory quantity |
| AVERAGE_COST | COST | Average cost |
| VENDORNUMBER | PrimeVendor | Primary vendor |
| UPC | AltSku | Alternate SKU |
| GROUP:GROUPNAME | Class | Group code and name concatenated |
| SECTION:SECTIONNAME | Dept | Section code and name concatenated |
| FINELINECODE | ProductGroup | Fineline code |
GROUP and SECTION Concatenation
RockSolid Max concatenates GROUP with GROUPNAME (separated by a colon) to produce the Class field, and SECTION with SECTIONNAME to produce the Dept field. For example, a GROUP of 10 with GROUPNAME of Hardware becomes 10:Hardware in the Class column.
Tips
Make sure your export file ends with
Data.txt(e.g.,MyStoreData.txt). Margin Master looks for this pattern when scanning for import files.
Descriptions are automatically cleaned during import -- any tab characters or newline characters in the DESCRIPTION field are stripped out.
Leading zeros in store numbers are trimmed automatically. Store
00123becomes123.
Do not confuse RockSolid Max with the standard RockSolid POS import. They are completely different systems with different file formats.
Common Questions
Q: Is RockSolid Max the same as RockSolid? A: No. RockSolid Max and RockSolid are completely separate POS systems. They have different file formats (RockSolid Max uses 28 pipe-delimited fields; standard RockSolid has a different layout), different import pipelines, and different configuration options. Make sure you select the correct POS type in your store settings.
Q: My file has GROUP and SECTION but I want to use CLASS and DEPARTMENT instead. A: RockSolid Max always concatenates GROUP:GROUPNAME into Class and SECTION:SECTIONNAME into Dept. If you need different mapping, contact Margin Master support.
Q: Why are there duplicate records being removed? A: The finalize step deduplicates records by key fields. This handles cases where the RockSolid Max export contains the same item multiple times.
