Welcome to Softhard Solutions Softhard Solutions ShopMate Logo

ShopMate Desktop Software Database System Module Screen Shot
Business Accounting Database Management Software

Become a new user of ShopMate Desktop business accounting application.

ShopMateWeb Online and ShopMate Desktop - Best Business Accounting Database Software.
ShopMate Software System - Desktop Business Accounting Database Application

ShopMate Desktop System - Main Database System Module Screen Shot

Welcome to Softhard Solutions ShopMate Main Database System Module Screen Shot page.
Read Detailed Description of Database System Module...

In the Database System Module you keep track of various aspects of correct running of the ShopMate Database System and the correct storage, retrieval and backup of the data from your Sql Server's ShopMate Database. This module also allows you to set password for your database backup procedures so to avoid theft of your data. You can also make different connections to Sql Server in a Cloud Data Services or on your premises.

Important Note
ShopMate uses stored procedures and triggers of your SQL server's ShopMate Database for its data retrieval. If you change any of these stored procedures in your Sql Server externally, the ShopMate's forms and reports referencing them may not work properly if at all. This is also the case for the database and table triggers. If you change any triggers the forms may not be getting the data they expect and fail to operate correctly.

Following is a screen shot picture of ShopMate Main Database System Module.

Screen shot of ShopMate Database System Module

By default, at start up, each employee is marked as present at work, except for employees marked as Inactive and entries made on Saturdays and Sundays. It is your responsibility to see that the entries, employee attendance and wage Approval, are correct for each day of employee operations.

All your labour products should have the ItemsInUnit property set to a number greater than one. If we assume that the Items are minutes of a Unit (one hour), you can set the ItemsInUnit to 60 (minutes). Then in an invoice you can enter e.g. 2.3 (hours) into Units and the Items (minutes) will be correctly calculated in this invoice item.

The updatable grids may contain one or more fields that are too short to display fully. You can click into these fields and the editor will display all words fully below it, formatted (even if a field is not normally updatable - if you try to update such field the editor will simply return the previous data).

Before a product is being pulled into the invoices or orders via a bar code scanning device, make sure the designated bar code field receiving the number is in focus.

Although you may, it is advisable NOT to use dot (.) character as a first letter of the product names you yourself create.

What Next
Install 64 or 32 bit ShopMate Desktop Application (for Windows 7, 8, 10 or higher) for 30 Days Operations Free Trial. After this period, register your installed copy of ShopMate and subscribe or pay one time price. Any updates and new releases of ShopMate will come to you free automatically.

ShopMate free trial

Go ahead, download, install and try ShopMate and see what it can do for your business management. Try ShopMate Desktop Application Software operations free of any charge for 30 Days. Before you install ShopMate, please read our Terms and Conditions of Use of our websites and also our Privacy Policy Statement.

After clicking any of these buttons, ShopMateSetup.exe installer file is downloaded to your system. Depending on your browser (some only allow saving a file, some both, saving or running it), any installation involves downloading the ShopMateSetup.exe installer file and running it on your system to CHECK for any prerequisites and if any are missing, attempt to install them first, and complete the installation. If your browser allows you to run the file, use it as you do not need it saved, most save the file in your user Downloads folder from where you can run it.