Margin Master
Documentation
Guides and reference for Margin Master
Categories
Getting Started
Automatic Updates & Snooze Options
Margin Master automatically checks for new versions in the background so you always know when an update is available. When a new version is found, you are shown a notification with the option to install immediately or **snooze** the reminder for a period of time. You can also check for updates manua...
Cloud Vendor Data Sync
Margin Master keeps your local database up to date with the latest product catalog and pricing information from your vendor. This process -- called **Cloud Vendor Data Sync** -- downloads new and changed records from the RetailerSoft cloud servers to your local SQL Server. It is incremental, meaning...
Data Import Workflows
Margin Master supports several ways to bring data into the system from your POS (Point of Sale) system, vendor files, FTP servers, and Excel spreadsheets. This guide covers each import method and when to use it.
Database Creation
Database Creation is a guided setup feature that walks you through creating a new Margin Master database from within the application. Instead of manually configuring SQL Server, creating tables, and entering seed data, this feature handles it all in a single dialog -- from naming your database and e...
Database Connection Setup
Margin Master stores all pricing data, strategies, and configuration in a Microsoft SQL Server database. Before you can use the application, you need to either create a new database or connect to an existing one. This screen appears automatically on first launch or whenever a valid database connecti...
Installation and First Launch
This guide walks you through installing Margin Master on your computer and what to expect the first time you launch the application. Margin Master is a Windows desktop application that requires a SQL Server database and an active license from RetailerSoft.
Main Window Orientation
This guide gives you a tour of the Margin Master main window -- where everything is, what the menus do, and how to navigate the application. Once you are comfortable with the layout, you will be able to find any feature quickly.
Transfer Settings from Database
Margin Master lets you copy your configuration -- pricing strategies, rounding schemes, views, and other settings -- directly from one database to another. When you create a new database or migrate to a new server, you do not need to re-enter all your settings by hand. The transfer reads settings st...
Store Configuration
After connecting to a database, Margin Master needs to know which store you are managing. This screen collects your store details and validates your software license with RetailerSoft. You will see this screen on first launch, or if store information has not yet been configured for your database.
Pricing & Analysis
Cost Break Analysis
Cost Break Analysis divides your products into cost ranges (brackets) and shows you the profitability of each range. This helps you set **target margins** by cost level -- for example, you might want a higher margin on low-cost items and a lower margin on expensive items. Cost break models can be re...
Future Pricing
The Future Price Panel is where you define what the future price of a product (or group of products) should be. It appears within pricing strategy steps and SKU-level exceptions. You select a base price level, optionally add a plus/minus adjustment, apply rounding, and configure advanced options lik...
Min/Max Strategies
A Min/Max strategy sets price guardrails -- a minimum floor or maximum ceiling -- that constrain the future price calculated by your pricing strategy. For example, you might say "the future price should be the **maximum** of the calculated price and **Level 1 plus 5%**" to ensure no item is priced b...
Price Sensitivity & Awareness Codes
Every product in your vendor's catalog carries a classification code that reflects how price-sensitive that item is to consumers. Vendors assign these codes based on market research, consumer shopping behavior, and competitive analysis. In Margin Master, these codes appear in the **Pricing Strategy*...
Pricing Strategies
A pricing strategy is the core of Margin Master. It defines a set of ordered rules (called **steps**) that determine how future prices are calculated for your products. Each step targets a specific group of SKUs based on conditions (department, class, vendor, etc.) and sets a future price using a pr...
Profit Analyzer
The Profit Analyzer breaks down your profitability across different dimensions -- by price range, vendor vs. non-vendor SKUs, department, class, or velocity code. It shows you where your margins are strong and where they need attention, helping you make informed pricing decisions.
Rounding Schemes
A rounding scheme determines how calculated prices are rounded to consumer-friendly values. For example, instead of pricing an item at $4.37, a rounding scheme might round it to $4.49 or $4.39. Margin Master provides flexible rounding with multiple methods that can be combined.
SKU-Level Exceptions
SKU-level exceptions let you override the pricing strategy for individual products. While the strategy handles pricing in bulk by department, class, or vendor, exceptions let you set specific pricing rules for individual SKUs -- a plugged retail price, a fixed margin, or a cost deviation.
Strategy Backup & Restore
Strategy Backup & Restore lets you save all of your critical Margin Master configuration -- pricing strategies, rounding schemes, custom groups, SKU-level exceptions, application settings, and more -- to a single file and restore it to any Margin Master database. This is useful for transferring sett...
Strategy Execution Cloud Tracking
Every time you execute a pricing strategy in Margin Master (Strategy > Execute Strategy), the application automatically sends a detailed record of the execution to the cloud. This includes a snapshot of each step's configuration and its results -- how many SKUs were affected, what price changes were...
Vendor-Specific
Ace Critical Retail Pricing
Ace Hardware's Critical Retail Pricing program identifies items in your store where prices fall outside acceptable thresholds. Margin Master gives you a dedicated tool -- **Strategy > Ace Critical Pricing** -- that lets you find these items instantly and either review them on the spot or save the an...
Ace Hardware MAP & IMAP Pricing
Margin Master provides built-in support for Ace Hardware's **Minimum Advertised Price Policy (MAPP)** pricing data. This includes two price types:
POS Systems
Propello POS Integration Guide
MarginMaster integrates with the **Propello** point-of-sale system via file-based Excel import and CSV/Excel export. Propello is supported for both **Ace Hardware** and **Do it Best** vendor types, with vendor-specific field mappings and post-import enrichment.
Database
SQL Optimization Tools
Margin Master includes a suite of built-in database optimization tools that help keep your SQL Server database running efficiently. Over time, as data is imported, strategies are executed, and tables are rebuilt, database performance can degrade due to fragmented indexes, outdated statistics, and ac...
SQL Server Express Install & Upgrade
Margin Master includes a built-in guided installer for SQL Server Express. This feature lives on the Database Configuration tab and handles everything from detecting your current SQL Server installation to downloading, installing, backing up, restoring, and verifying -- all without leaving the app.
Support
Issue Submission Wizard
The Issue Submission Wizard lets you report bugs, request features, or ask for support directly from within Margin Master. It walks you through three steps: identifying who is submitting the issue, choosing whether to create a new issue or update an existing one, and entering the issue details with ...
