POS-X ION Installation with uniCenta

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

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 beagle@localhost 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 beagle@localhost ;
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

Installing uniCenta

1. Download and install the Java JRE runtime from www.java.com
2. Go to the UniCenta website www.unicenta.com
3. Download the program under the Community menu
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 mySQL.com

Installing Asulpunto uniCenta Magento Integration

Asulpunto is a Magento extension that watches for new products created in uniCenta to then update Magento  and updates uniCenta stock levels when sales are made on the online Magento store. It requires that your uniCenta store have an active connection for updates.

Get Extension key

Get an extension key from the Magento Community:

Magento uniCenta oPOS Integration Extension Version 0.0.5 Page 3

https://www.magentocommerce.com/magento-connect/unicenta-opos-integration.html

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.

Open up the Configuration Section under Asulpunto

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

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 beagle@magento identified by 'beaglepasswd';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on unicentadb.* to beagle@magento ;
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.

More information:

• Software integration - Installation Outline

• Mag POS - POS/eCommerce Integration

• uniCenta Software

• POS-X Touch Terminals

• How to connect printers and cash drawers to terminals

For More Information:

POS-X Ion Terminal

uniCenta POS software