If you have inventory to operate and want an inventory management tool, StockControl is a good choice for your business.
In this tutorial, you will learn and know the installation and configuration of StockControl.
StockControl is actually a client software, it must work with database engines together. It supports both MYSQL AND Microsoft SQL Server. Here is an ideal business architecture for StockControl.
![](https://www.mxsku.com/wp-content/uploads/2020/12/architecture.png)
The translation of the above diagram is you can install as many StockControl clients as you like on many computers, but the database server should be one only, the data is shared among the clients. But if you are a one-man business, you can of course install both the client and the database on the same computer.
The database used for this tutorial is the free MYSQL database. After MySQL server installed. Run StockControl, click Register, Database Configuration window will pop up
![](https://www.mxsku.com/wp-content/uploads/2020/12/database_setup.png)
- Choose TCP/IP authentication
- Enter your database server ip address (localhost and 127.0.0.1 for local database, a public IP for the remote database)
- Enter database port (The default is OK)
- Enter the database name (you can specify any name you like unless the name already existed in the database)
- Enter your database user name (normally it’s ‘root’ unless you specify a different one during MySQL installation)
- Enter your password of the database user(it’s the one you set on MySQL installation)
Then Click OK, StockControl will then configure the database and then pop up a successful dialog, then you can register you account as an admin (a founder).
After login your account, you will see a general settings window pops up. If this’s your first login after installation, you need set your company information, reports page settings, barcode and POS settings. It’s very simple and intuitive, just follow the description and complete all the form and save, Finally click the close icon. The operation window will be displayed.
![](https://www.mxsku.com/wp-content/uploads/2020/12/Snap18.png)
Here is a short installation and configuration video of StockControl. If you have any issues, you can leave your questions in the comment section.