MCS Utilities for RMH
Utilities that keep your RMH database running smoothly
We support Retail Management Hero stores every day. When the same database problem shows up again and again, we build a tool to fix it properly. These utilities come straight out of that real store support work.
Every MCS utility:
- Starts with a free preview that changes nothing
- Takes a backup before it makes any change
- Is licensed to your specific SQL server and database
- Is included with the RMH Yearly Support Contract
Your RMH database is your store
Items, customers, sales history, purchase orders – it all lives in SQL. Small problems pile up over time, and you feel them at the register, in your reports and at inventory time.
Duplicate records
The same item or customer entered twice splits sales history and throws off quantities and reports.
Slow lookups
Old codes and clutter make it harder for cashiers to scan and find the right item quickly.
Bad imports
Messy scan files and vendor imports can bring in errors that are hard to undo by hand.
Outdated SQL
Older SQL Server Express versions fall behind on support and size limits as your data grows.
Available utilities
Each one solves a specific problem we have fixed many times for RMH stores.
DCD Duplicate Fix
For comic shops
Cleans up the old Diamond DCD item codes and the duplicates they create alongside Manage Comics items.
- Swaps old Diamond DCD item codes to the real barcodes
- Merges DCD and Manage Comics duplicate items into one
- Keeps sales, purchase order and item history
- Keeps the old code as an alias so it still scans
- Retires old items instead of deleting them
- Backs up the database first
- Optional overnight / ongoing check after new imports
Physical Inventory Cleaner
For any RMH store doing Physical Inventory
Gets your Physical Inventory scan files ready for a clean RMH import.
- Cleans Physical Inventory scan files for RMH import
- Merges duplicate scans of the same item
- Helps avoid import errors and miscounts
SQL Express 2025 Upgrade Kit
For stores on older SQL Server Express
Our tested process for moving your RMH database to SQL Express 2025. MCS runs the kit for you.
- Pre-check of your server, SQL instance and database
- Verified backups before anything changes
- In-place upgrade of SQL Server Express
- Post-check with database integrity check and record count verification
MCS RMH Backup
For any RMH store
Automated, scheduled backups of your RMH SQL databases, zipped and sent off-site to Dropbox.
- Backs up your RMH SQL databases on a schedule
- Zips each backup and uploads it off-site to Dropbox
- Email alerts and a morning summary email
- Licensed per machine with an MCS license file
In development
These are being built now. Contact us if you’d like to know when they are ready.
Item Duplicate Merge
Finds duplicate items in any RMH store by barcode, alias or item code and merges their sales history and stock into one item, with a preview and a backup before any merge.
Customer Duplicate Merge
Find duplicate customer records, preview the matches, and merge them so each customer has one account and one history.
Central AR Cleanup
Accounts receivable cleanup for multi-store owners running RMH Central.
Watch: DCD Duplicate Fix explained
Built to be careful with your data
Your database is too important for guesswork. Every utility follows the same rules.
Free preview first
Every utility has a preview mode that changes nothing. You see what will happen before you decide.
Licensed to your database
Each license is tied to a specific SQL server and database, so it only runs where it is meant to.
Backup before changes
A backup is taken before any change is made, so there is always a way back.
Two simple ways to get them
RMH Yearly Support Contract
All MCS Utilities for RMH are included with the contract, along with:
- Phone, email and remote support
- Off-site database backup
- PC Matic
- RMH updates (if you are on an Enhancement Plan / EP)
- All RMH support included, plus $125/hour for non-RMH IT help (network, Outlook, other programs)
Without a support contract
Not on a support contract? Buy just the utility you need.
| Utility | One-time (30-day license) |
Yearly | Monthly |
|---|---|---|---|
| DCD Duplicate Fix | $129 | $99/yr | $9/mo |
| Item Duplicate Merge Coming soon | $129 | $99/yr | $9/mo |
| Customer Duplicate Merge Coming soon | $129 | $99/yr | $9/mo |
| Physical Inventory Cleaner | $49 | $79/yr | $7/mo |
| Central AR Cleanup Coming soon | $199 | $149/yr | $15/mo |
| MCS RMH Backup | Support Contract customers only | ||
| SQL Express 2025 Upgrade Kit Performed by MCS | $299 flat | — | — |
All utilities are included with the RMH Yearly Support Contract.
One-time is a single cleanup within 30 days. Yearly or monthly keeps the utility running after each import or overnight. The free preview and offline PI duplicate removal cost nothing.
How to get started
Contact MCS or purchase
Reach out, or buy the support contract or a one-time license.
Run Get-ServerInfo
We send you a small Get-ServerInfo script to run on your RMH server.
Send us the three values
Email us the three values it shows so we can build your license.
Receive your license file
We send a license file tied to your SQL server and database.
Run the utility
Preview first, then run. We’re a phone call away if you want help.
Not sure which utility you need?
Tell us what you’re seeing in RMH. We’ll look at it with you and let you know what will fix it – and whether a free preview is the right first step.