Margin Master is a software product of Retailer Soft™ (Retailer Soft, Inc.) which is used for profit analysis and price strategy planning. For more information about the Margin Master product, please visit their web site or contact them directly:

http://www.retailersoft.com/web_pages/Products/MM/Default.aspx

Using the Margin Master View

Margin Master needs some or all of your Spruce inventory data. With recent versions of Margin Master, we have provided views so that the Margin Master software can connect directly to your database. You may need to contact us to setup a vendor user name and password for database access. The MSSQL view named vw_MarginMaster was specifically intended for Margin Master; however, other views such as vw_InventoryStore and vw_InventoryCommon may also be useful. A "view" is basically a selection query that is saved for re-use. In order for Margin Master to access the data provided by this view, you may need the following information:

•The static name or IP address to be used for local access.

•The port number (if any) necessary for routing to the SQL Server.

•A SQL user name providing read-only access to your database. Please contact support for assistance if you need the login or password.

•Below is a MSSQL query that includes all the fields provided by the Margin Master view:

SELECT[STORE] --Branch ID

,[RETAILPRICE] --Store Level 0 Price

,[MFGRNAME] --Store Primary Vendor Name

,[MFGRCODE] --Store Primary Vendor Code

,[QUANTITYONHAND] --Store Quantity On-Hand

,[AVERAGE_COST] --Current Average Cost

,[REPLACE_COST] --Current Prevailing Market Cost

,[LISTPRICE] -- Suggested List Price

,[SKU] -- Item Number

,[DESCRIPTION] -- Description (Full)

,[GROUP] -- Group Number (1-255)

,[GROUPNAME] -- Group Name

,[SECTION] -- Section Number (1-255)

,[SECTIONNAME] -- Section Name

,[UNIT] -- BASE Unit of Measure Pricing Unit of Measure (Changed on 3/3/2017 - Releases 12.3.0 and later).

,[UPC] -- Barcode (0)

,[CLASS] -- Class (Merchandising)

,[DEPARTMENT] -- Department (Merchandising)

,[FINELINECODE] -- Fine Line (Merchandising)

,[PRODUCTID] -- Product ID (Merchandising)

,[VENDORNUMBER] -- Vendor-Item Number for Store Primary Vendor

,[LAST_YEAR_SALE_DOL] -- SUM of Sales for the Prior Calendar Year

,[LAST_YEAR_SALE_UNIT] -- SUM of Quantity Usage for the Prior Calendar Year

,[YTD_TRANSACTION] -- SUM of Quantity Usage for the Current Calendar Year

,[YTD_SALES_DOL] -- SUM of Sales for the Current Calendar Year

,[LocationCode0] -- First of Three Location Codes

,[LocationCode1] -- Second of Three Location Codes

,[LocationCode2] -- Third of Three Location Codes

FROM[dbo].[vw_MarginMaster]

This view combines data from a number of tables including: InventoryCommon, InventoryStore, GroupSection, StockValue, and VendorItem.