ASULPUNTO
Table of Contents
Requirements...3
A working copy of uniCenta oPOS on Mysql database...3
Magento 1.7, Magento 1.8, Magento 1.9 ...3
Valid Mysql connection between Magento database and uniCenta oPOS database...3
Magento server's cron service active...3
Installation of the Extension...4
Get Extension key...4
Magento Admin...4
Clear the Magento Cache...4
Logoff from the Admin and login again...4
Configuration...5
Test the integraton...8
Test 1 Product Creation:...8
Test 2 Stock change in uniCenta oPOS: ...8
Requirements
A working copy of uniCenta oPOS on Mysql database
Install uniCenta oPOS from http://www.unicenta.com
Important: The uniCenta table names must be all in uppercase
It is very important that uniCenta oPOS is installed on Mysql database or the Magento extension will not work.
Magento 1.7, Magento 1.8, Magento 1.9
The extension has been tested on these versions of Magento. It might work on 1.5 or 1.6 but it was never tested.
The extension has also been tested on the Enterprise editions, 1.12 and 1.13
Valid Mysql connection between Magento database and uniCenta oPOS
database
Magento should be able to connect to the uniCenta oPOS database. Make sure the connection is working. All installation problems are always due to an invalid connection. Possible reasons for the connection to fail are:
• Using invalid credentials
• Invalid user permissions on uniCenta oPOS database. Example: The user is set as
[email protected] and Magento requires the user to be unicenta@%
• Using internal IP for a remote uniCenta oPOS database. Example, Magento is on Shared Hosting while uniCenta oPOS is installed on a shop's computer.
• Firewall or security on the servers where Magento or uniCenta oPOS Mysql is installed • Unicenta database table names must be in Uppercase. Sometimes when transferring a database
only suggested on small catalog as the server might time-out or run out of memory. The
synchronisation support resume, so if it fails during the transfer, it will resume from the next record when it is activated again.
Installation of the Extension
Get Extension key
Get an extension key from the Magento Community:
http://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.
If there are any errors, it is a problem with the installation of Magento. Most likely there are problems with php version or with folder permissions. These problems have to be solved before attempting to install the extension.
Clear the Magento Cache
This can be done easily from the Magento Admin console.
Logoff from the Admin and login again
Configuration
→ Login to Magento Admin → System / Configuration → Asulpunto / uniCenta oPOS
Unicenta Connection Configuration Section
uniCenta oPOS Hostname: This is the host name of the uniCenta oPOS database. If uniCenta oPOS
→ Once database details are configured, → Click on Save
→ Click on Test Connection
→ If you cannot 'Save' the details, probably there is an error with a required field. Normally this is “Default Product Attribute Set” in the Configuration section
→ If there is an error try to troubleshoot using the following log file: [magentoinstallation]/var/log/asulpunto_unicentaopos.log
Hint: After entering new connection details, press the Save button. The Test Connection button picks
up only saved connection details.
→ If the connection is successful, proceed to change the other configuration details and press on save.
Configuration Section
Stock Location: The location of the stock Magento will synchronise with. Currently this extension
supports a single uniCenta location, you have to select the location from the configuration of the extension.
Default Product Attribute Set: The attribute set Magento product will be created in. Currently the
Order Status for Stock Synchronisation: Only orders with this status will have stock deducted in
uniCenta. This prevents unpaid and unshipped orders from deducting stock from uniCenta automatically.
Synchronisation Section
These buttons are useful if you want to trigger product or stock updated immediately without waiting for cron jobs to run.
Note that the functionality of these buttons depends on you server configuration, you might get errors if you have low timeout / low memory and have a large catalog. Initially it is suggested to let the cron job import the products by itself as it has auto-resume functionality. You can use these buttons safely with a small test catalog.
Advanced Section
Last Order No: By default, the last order id from Magento is picked up. Only order ids larger than this
saved number will be deduct stock from uniCenta. This will prevent orders prior to the installation from reducing stock immediately when the extension is installed.
Attribute Settings Section:
In this section you select the behavior of the Name, Description, Short Description, Price. Update & Create: Will always update Magento whenever these attributes change in uniCenta.
Create Only: The attribute will change only when the product is created in uniCenta. This is useful if you want to have a richer name / description / price in Magento from uniCenta but you want it to be created with the uniCenta defaults the first time.
Never Transfer: Will leave the attribute blank and never update them.
Test the integraton
If the Test Connection was successful, you can proceed to test uniCenta oPOS extension.
Test 1 Product Creation:
On uniCenta oPOS, create a new product. Wait 10 minutes. Assuming cron is working properly, the product will created in Magento. Beware that Magento sometime takes longer to schedule new jobs, so the first time it might take longer than 10 minutes.
Test 2 Stock change in uniCenta oPOS:
On uniCenta oPOS Stock Diary, update the products stock. Assuming cron is working properly, the stock for the product will be reduced from Magento.
