POS-X ION Installation with uniCenta

The ION TP2 by POS-X is part of the cost-effective, high performance POS-X ION Series Terminal. uniCenta is a full featured Open Source POS software application. Magento is an Open Source ecommerce application.
Complete POS System

The following details the step in setting up the terminal, loading the software and configuring the software. It assumes you are loading uniCenta POS software on Windows 7 terminal. It also discusses configuring integration with an on-line web store running Magento software.

Integration Objectives

Integration between your physical store means that product, sales and stock information can be current and exchanged between your physical and online store.

Add a web store to an existing physical store

  1. Create a Magento based Ecommerce store
  2. Integrate with uniCenta

Add a physical store to an existing web store

  1. Create a uniCenta POS store with mySQL database
  2. Integrate with Magento

Terminal Hardware Setup

  1. Unpack the monitor and cords
  2. Install peripherals such as the credit card reader
  3. Plug in the power and Ethernet connection
  4. The power button is located in the center of the bottom edge of the screen
  5. Start Windows and allow to driver installation and  install updates

Tip: In windows 7 you can open an on-screen keyboard by by clicking the Start button , clicking All Programs, clicking Accessories, clicking Ease of Access, and then clicking On-Screen Keyboard.

Creating a DataBase in mySQL in Workbench

  1. After installing mySQL launch MySQL Workbench.
  2. On the left pane of the welcome window or under Database->Manage Connections, choose a database to connect to under "Open Connection to Start Querying".
  3. The query window will open. On its left pane, there is a section titled "Object Browser", which shows the list of databases. (Side note: The terms "schema" and "database" are synonymous in this program.)
  4. Right-click on one of the existing databases and click "Create Schema...". This will launch a wizard that will help you create a database.

If you'd prefer to do it in SQL, enter this query into the query window:

mysql> CREATE database unicentadb;
Query OK, 1 row affected (0.00 sec)

We allow user beagle to connect to the server from localhost using the password beaglepasswd:

mysql> grant usage on *.* to [email protected] identified by 'beaglepasswd';
Query OK, 0 rows affected (0.00 sec)

And finally we grant all privileges on the unicentadb database to this user:

mysql> grant all privileges on unicentadb.* to [email protected] ;
Query OK, 0 rows affected (0.00 sec)

And that's it. You can now check that you can connect to the MySQL server using this command:

$ mysql -u beagle -p'beaglepasswd' unicentadb


Configuring mySQL for use by uniCenta

uniCemtra defaults to a different database for internal use. You must configure uniCenta to use mySQL if any of the external integration options are desired now or in the future. For setting uniCenta to use mySQL as its database:
  1. Download uniCenta oPOS from SourceForge. I used version 2.80 as it includes the mysql.jar.
  2. mySQL will also install the Microsoft Visual Studio runtimes required for use.
  3. Before installing you’ll need to create a mySQL database and user for unicenta.
  4. Run the installation .exe for uniCenta
  5. Open the configuration screen and choose MySQL as the database under the Database Setup tab
  6. enter the following for the database information:
    - Driver Library: mysql--connector.....jar (Select this from the uniCenta library directory)
    - Driver Class: com.mysql.jdbc.Driver
    - URL: jdbc:mysql://localhost:3306/unicentadb (assumes local db named unicentadb, connecting on port 3306)
    - User: beagle [user created in Step 2]
    - Password: beaglepasswd [password used in Step 2]
  7. Run uniCenta oPOS. The first time you run the program it will create the default database
  8. Check that the mySQL database tables have been created.



Installing uniCenta

  1. Go to the UniCenta website
  2. Download the program under the Community menu
  3. Download and install the Java JRE runtime from
  4. Install the uniCenta program
  5. It will look for a database, say yes to creating a new one.
  6. You must use a mySQL database for uniCenta to interface with Magento.
  7. mySQL can be downloaded from


Installing Asulpunto uniCenta Magento Integration

Installation of the Extension

Get Extension key

Get an extension key from the Magento Community:

Magento uniCenta oPOS Integration Extension Version 0.0.5 Page 3

Magento Admin

→ Login to the Magento Admin.

→ System / Magento Connect / Magento Connect Manager.

→ Login again using your login and password.

→ In the Install New Extensions paste the key you obtained.

→ Click on Install.

Configuring Magento to Integrate with uniCenta

Open up the Configuration Section under Asulpunto

uniCenta Connection Configuration
uniCenta Connection Configuration
uniCenta oPOS Database Password [STORE VIEW]  

IMPORTANT! Please, press on 'Save Config'

In this example the Unicentadb is running on a host with the IP address of

If the test fails you may have to add the domain you are running Magento from ie if the computer name is magento then:

mysql> grant usage on *.* to [email protected] identified by 'beaglepasswd';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on unicentadb.* to [email protected] ;
Query OK, 0 rows affected (0.00 sec)

Updating Magento from uniCenta

With Asulpunto installed you can update Magento from uniCenta. For instance if you have created a new product in uniCentra, the integration will create the product in Magento.

Updating uniCenta from Magento

With Asulpunto installed you can update uniCenta stock status. For instance if you have sold a product online, the integration will update the stock status in uniCenta.

Loading Products into uniCenta from Magento

Products can exported out of Magento and loaded into uniCenta. If you have many products you may want to load products by individual category.

  1. Export products from Magento (System -> Export) into a csv file
  2. Open up the Import from CSV file (Tools -> Import CSV File)
  3. Select the file exported in step 1
  4. Read the header
  5. Map  each field to the corresponding field in Magento
  6. If loading a single category product choose that as the default category.
  7. Press the Import CSV button and the products will be imported.
  8. Note any problems in import. The import file can be edited and resubmitted.



For More Information:

POS-X Ion Terminal

uniCenta POS software



Home |  printers |  Accessories |  Service |  Support |  About Us |  Contact

30-day guarantee on everything we sell

E-Mail: [email protected]


Copyrightę 2014 Beagle Hardware

Beagle Hardware is a BBB Accredited Business. Click for the BBB Business Review of this Computers Software & Services in Minneapolis MN