|
Hostgreen has made bridge, a connection, between Openbravo POS and Zen-Cart, a script called "Conector POS-Zen".
In this project as a basis for innovation we had two solutions that until now had not been integrated together - Openbravo POS and Zen-Cart. To do this, we made a script that will run at a frequent pace to synchronize and determine the definition of the product offering and stock.
These two solutions (Openbravo POS and Zen-Cart) function completely autonomous and the synchronization point in the supply of products is run through our script, so that all stock and POS products which are available are automatically uploaded to the online store. This is the fundamental task of our script "Connector POS-Zen".
On a technical level there is integration with tables’ categories and products in both applications. Master data is in POS database.
The synchronization process will automatically upload all categories, articles, photos that illustrate items and stock available to the Zen-Cart solution avoiding duplicates to keep the offer in the online store effortlessly, here is where optimization lies to achieve this project. For example as a product runs out at the POS after a sale, this will be reflected in the online store with a sign "product not available" and prevent the online purchase at that time from the web.
The "Connector POS-Zen" script basically makes a sweep in the product tables that exist in Openbravo POS and proceeds to update this information on the basis of Zen-Cart MySQL data which is available online. All existing categories, new products released, stock available would be updated at the time for these products.
This script requires having an open port on hosting of MySQL server on the Internet to access the database dump of Zen-Cart and all information remotely. The script was developed on Java platform, which is platform of Openbravo POS. Our script resides on the machine or PC which runs Openbravo POS. There is a possibility in the Openbravo POS for each product that discharged a mark to indicate whether the product is uploaded or not to the Internet, it covers the needs for power control which products are finally published in its online store. So we can easily check and uncheck from Openbravo POS product if it is sold on the Internet or not.
In the local PC, where the POS system will have a windows scheduled task (cron in Linux case) will call our script for automatic upload in product offering and the photographs illustrating these within the Openbravo POS to be viewed in the online store. Photo upload is carried out via FTP, where our "Connector POS-Zen" moves through each product protocol, uploads this file via FTP to the server of the online store and then moves the image linked to the item recorded in the database.
Configuration parameters required for our script: the data connection to local and remote MySQL database, FTP server account and file path, where the images in the shop are, the local path where the POS is installed. The call rate remains as our script configuration parameter within the task scheduler that invokes cron or scheduled tasks.
Openbravo POS will be used as a POS software for trade http://www.openbravo.com/es/product/pos/
Zen-Cart platform will be used as e-commerce solution, which is available from http://www.zen-cart.com/
|
