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
Finding SKUs
What is this?
Quick Find lets you search for a SKU across all of your loaded main tables by SKU number or description. Once you find the item you are looking for, you can navigate directly to it in the center grid or open its SKU Detail screen.
How to Access
- Keyboard shortcut:
Ctrl+F - Menu: Tools > Find Sku
Using Quick Find
- Sku Search · 2. Search Target · 3. Results · 4. Show / Cancel
SKU Search
Type at least 3 characters into the SKU Search field (letters, digits, space, _ and -).
Quick Find searches by itself after a short pause - there is no need to press Enter.
What is matched, in order:
- SKU - any SKU that starts with or contains what you typed. Matches that start with your
text are listed first, so
1000finds1000123before50100045. - Description - only when no SKU matched at all: any description that contains the text, so
broomorHARPERfinds items by name.
UPC codes and alternate SKUs are not searched; use the selection boxes or the grid's own search panel for those (see Working with the Grid).
Results are highlighted in yellow where the text matched. Up to 10 results are shown; if more exist you see 10+ matches found - type more characters to narrow it. A single result is selected automatically.
Store Filter
When your database contains data for multiple stores, a Store dropdown appears next to the search field. Select a specific store to narrow results, or leave it set to "ALL" to search across all stores.
Search Target
Choose where the selected SKU should be shown:
| Option | What it does |
|---|---|
| Center Grid | Navigates to the SKU in the main data grid and highlights the row |
| Sku Detail Screen | Opens the full SKU Detail window for the selected item |
Your search target preference is saved automatically and remembered between sessions.
Show and Cancel
- Show - goes to the selected SKU using your chosen target. Enabled once a result is selected.
- Cancel - closes the dialog without action.
What Show does to your selections
Showing a SKU in the Center Grid clears every selection box and shows just that SKU (and just the chosen store, if you picked one). The SKU-type drop-down on the button row is ignored so the item is found whether it is a vendor SKU or not.
There is no "back" - the previous selection is gone. If you want to return to it afterwards, use Strategy > Save Current Selection before you search, then Load Saved Selection (Ctrl+L) after; or press F12 to clear the single-SKU filter and start again.
Tips
Tip: Quick Find searches across all loaded main tables. If you have multiple stores, the store filter helps narrow down which store's data you want to browse.
Tip: You can search by partial SKU or partial description. For example, typing "hammer" will find items with "hammer" anywhere in the description.
Common Questions
Q: Why does Quick Find say "No Matches Found"? A: Make sure you have typed at least 3 characters. Also verify that your data has been loaded — Quick Find searches the main tables that are currently built in your database.
Q: Can I search by UPC or barcode? A: Quick Find searches the SKU and Description columns only. UPC/barcode searches require using the main grid's filter or column search features.
