www.rawntech.com

info@rawntech.com

Skype: rawntech

Cell: +880-01684289486-9

Address: 2/1 Pallabi, Mirpur, Dhaka- 1216

Support: 365x24x7

Office Time: 12:00 PM to 10:00 PM (GMT+6)

Openbravo POS in Bangla

Openbravo ERP and SugarCRM

Magento Openbravo Connector

Description

The Magento Openbravo Connector is a module for integrating Openbravo and Magento eCommerce systems. With this module you can synchronize customers, products and sales order from Magento into Openbravo ERP. Each synchronization process can be scheduled by time and frequency to be executed.

Background

Magento is an open source eCommerce system providing an excellent foundation for managing an online shopping websites. While Magento offers excellent capabilities for merchandising, online shopping and payment processing… Magento does not offer the more advanced ERP features like inventory control, manufacturing and financial management.

These features can be provided in Magento environments using Openbravo ERP software. Here are scenarios where you may be interested in this capability:

You have a Magento environment and want to add Openbravo ERP
You have Openbravo ERP and want to add an open source eStore
You want to add an eStore and ERP backend to your existing website
The basic concept behind the RAWN Openbravo / Magento integration is that online customers and products can be managed in the Magento environment and the relevant product, customer and order information will be pulled into Openbravo for order fulfillment, consolidated reporting and inventory management. This allows independent management of your Magento eStore and Openbravo ERP environments.

Some additional characteristics include:

You can have products and customers in Openbravo that are not in Magento. For example, this could include products that you do not offer through your eStore or subassemblies.
There is no inventory checking from Magento into Openbravo. When an item is available in Magento, it is assumed to be “in stock”. The management of delivery exceptions and credits is a manual process in the Openbravo environment.
Each system uses its own database (Magento uses MySQL and Openbravo uses PostgreSQL or Oracle 10/11g). Transactional objects (i.e. orders), products and customers are kept synchronized between the two systems. We will have a plan of upgrade to inventory sync.
Implementation Details

ERP / Openbravo Data Requirement

For any ERP system to fully track financial transactions, it needs a core set of transactional and subordinate objects defined and kept current in that system.

In general, Accounts Receivable works against invoices generated from a sales order. In Openbravo, this is modified slightly in that each invoiced sales order also has a shipment object representing the pending or successful shipment of that order. In addition, each sales order references a customer business partner as well as a set of products. Moreover, specific inventory items for each selected product are also referenced.

For this integration, Openbravo will be set up just as it would for any ordinary / stand alone implementation as necessary to order and ship a product. You will also need to create a default sales price list and purchase price list. Actual prices and costs will then be synchronized from Magento.

Data Synchronization Approach

In this RAWN implementation, data between Magento and Openbravo is synchronized periodically rather than instantaneous and may lag by several minutes. This was done by choice to avoid a performance and/or integrity impact on the eStore end user if Openbravo was unavailable for any reason.

Products, sales orders and customers are synchronized as follows:

Products are synchronized in a comparison approach: periodically looking for products existing in Magento that do not exist in Openbravo, and then defining that set of products in Openbravo.
Sales order synchronization is accomplished by first finding all sales orders created in Magento since the last synchronization process was executed. Once this list is determined, a Sales order (and optionally the related shipment and invoice objects) are created for each Magento sales order. This supports syncing of both stocked and non-stocked (e.g., downloadable) items.
Customer synchronization is accomplished in a similar fashion to products: periodically looking for customers defined in Magento that do not exist in Openbravo, and then defining those customers in Openbravo.
Both Product and Customer synchronization can take place with Sales order synchronization, where each order creation will be preceded by verification that the customer exists as a business partner in Openbravo and the product is defined as well. In the event that it is a new customer, the customer business partner will be defined before proceeding with the sales order creation in Openbravo. Products are synchronized in a similar fashion, if the order contains a product that would be new to Openbravo. For existing customers the billing & shipping addresses are compared to existing. If there are differences the new address is added.
Magento APIs / Web Services

In order to successfully synchronize Sales orders, the following APIs or Web services have been added to Magento using the XML-RPC protocol already available in the Magento framework. Proper user authentication is utilized to prevent unauthorized access to the services.

GetListOfSalesOrders

A service that returns a list of sales Order IDs, qualified by an optional date / time parameter. This service is used to get the list of Sales orders created SINCE the supplied date and time.

GetOrderDetail

This service returns the full details of a specified order ID. These details include a customer ID, order date/time and some number of order lines where each line includes a product ID, quantity, unit of measure and price. Ship-to and Bill-to addresses for the customer are also provided.

UpdateSalesOrderId

This service is used to save the Openbravo generated sale order id # into the Magento order for audit trail and verification that the order was successfully synchronized.

GetProduct

This service returns the name and description of a product from a specified product ID.

GetProductList

A service that returns all products that have changed since a specified date.

GetCustomer

This service returns the name and description of a customer from a specified customer ID.

Openbravo Job Services

In order to successfully synchronize Sales orders, the following Openbravo Process Scheduler (Quartz) Jobs are provided in Openbravo. These processes utilize the Openbravo Data Access Layer provided in the Openbravo 2.50 release.

ProductBatchSyncJob

This job gets a list of products that need to be defined or updated in Openbravo via the Magento GetProductList web service. It then defines a new product in Openbravo, or updates an existing product, for each Magento product retrieved.
This job can be scheduled to run periodically to ensure all Magento products available in the Webstore are defined in Openbravo as Products. For example, you could run this process ‘ad-hoc’ after a major update to your Magento product catalog.

SalesOrderBatchSyncJob

This job looks for Sales Orders in Magento that have not yet been synchronized to Openbravo.
For all such orders, it will create either a Standard Order or a POS order in Openbravo, based upon the type of product on the order.
Payment information is also synchronized with each order, using the Advanced Payables and Receivables module in Openbravo.
If there is detected a product or customer on a given Sales Order that has not yet been synced, that product and/or customer will be synchronized first before completing the Sales Order in Openbravo.
This job should be scheduled to run quite frequently in order to ensure that sales orders are synchronized over to Openbravo in a timely manner.
Further detail on the Sales Order Job Processes is included below in the Sales Order Synchronization Details section.

CustomerBatchSyncJob

This job gets a list of customers that need to be defined or updated in Openbravo via the Magento web services. It then defines a new customer (business Partner) in Openbravo, or updates an existing business partner.
This job can be scheduled to run periodically to ensure all Magento registered customers are defined as business partners in Openbravo.

Sales Order Synchronization Details

The integration ships with three defined Processes that can be scheduled for one-time or recurring execution by the OB Process Scheduler: Sales Order synchronization, Product Synchronization and Customer Synchronization.

The Sales Order Synchronization process is performed in two steps.

The first step is to poll the Magento system for new orders periodically. This is done with the SalesOrderBatchSyncJob class. The job should be scheduled to run periodically (i.e. every 10 minutes). The purpose of this job is to dispatch SalesOrderSyncJob jobs for each new order in Magento. RAWN’s implementation ensures no single order is assigned to more than one SalesOrderSyncJob.
The SalesOrderSyncJob gets the order details from Magento; validates the data and if valid creates the necessary Openbravo objects and notifies Magento that the order was synchronized.
How to download the Magento Integration

The Magento Integration System is a module, which you can access via the central repository. It consists of a file called com.RAWN.openbravo.magento-1.0.0.obx (.obx is the standard file extension for Openbravo ERP extension modules).

Log into Openbravo ERP in the System Administrator role.
From the Application Menu, select General Setup > Application > Module Management.
Click Add Modules. The list of modules available to install appears.
Navigate to the Magento Integration Pack.
Click Install Now.
A confirmation box appears. Click Continue to proceed with the installation. The license agreement appears.
Click I accept the license agreement.
Click Continue. Your selected module appears in the list of installed modules.
Click Rebuild now. A new window appears showing the rebuild in progress.
When the rebuild is complete, you must choose an option for how to restart Openbravo ERP. You can choose from the following:
Restart the servelet container: restarts Tomcat and reloads the application.
Reload the context: reloads only the contexts that have changed.
Take no action: does not reload any part of the application. Select this option if you want to manually restart Openbravo ERP later.
Click Continue.
Configuring the Magento Integration System

This document describes step by step the installation & configuration process of the Openbravo ERP – Magento Integration system. The installation process requires to install two additional modules, one on the Openbravo ERP and the other one on the Magento side and to configure settings required by those modules.

ERP-Magento Installation Guide

Source Tree Navigation: ${tomcat}/webapps/magento/config/magento

Specifications

Package Name: Magento Openbravo Connector

Contract Type: Perpetual

Price: $3,500

Module ID: MOD10008

Commercial Dependencies: Professional Subscription

Works For: Openbravo ERP 3.0 MP1 Professional Editions and later

Module Footprint:

Screens: 0
Reports: 0
Tables: 1
Databases Supported: PostgreSQL

Languages Included: English

Expertise Required: Integration of this module assumes sufficient technical expertise and understanding of the Openbravo and Magento systems. If required, implementation technical support services are available based on pre-paid support services purchased from the Our website. Optional “turn key” integrations are available on a custom quote basis.

Brought To You By

We are Gold implementation partner for Openbravo, the leading open source ERP platform. We offers a range of services to accelerate the deployment of web based enterprise applications using open source and “best-of-need” components.

Our services include:

Solutions architecture and systems design
Software development
ERP deployments, configuration and customization
Data migrations
Custom integration and connectors with legacy systems
Cloud and conventional deployments including 24/7 remote monitoring and technical operations services
We also offers Openbravo starter kits and basic support packages from our own Magento store at info@rawntech.com

Magento Openbravo Connector

Description

The Magento Openbravo Connector is a module for integrating Openbravo and Magento eCommerce systems. With this module you can synchronize customers, products and sales order from Magento into Openbravo ERP. Each synchronization process can be scheduled by time and frequency to be executed.

Background

Magento is an open source eCommerce system providing an excellent foundation for managing an online shopping websites. While Magento offers excellent capabilities for merchandising, online shopping and payment processing… Magento does not offer the more advanced ERP features like inventory control, manufacturing and financial management.

These features can be provided in Magento environments using Openbravo ERP software. Here are scenarios where you may be interested in this capability:

You have a Magento environment and want to add Openbravo ERP
You have Openbravo ERP and want to add an open source eStore
You want to add an eStore and ERP backend to your existing website
The basic concept behind the RAWN Openbravo / Magento integration is that online customers and products can be managed in the Magento environment and the relevant product, customer and order information will be pulled into Openbravo for order fulfillment, consolidated reporting and inventory management. This allows independent management of your Magento eStore and Openbravo ERP environments.

Some additional characteristics include:

You can have products and customers in Openbravo that are not in Magento. For example, this could include products that you do not offer through your eStore or subassemblies.
There is no inventory checking from Magento into Openbravo. When an item is available in Magento, it is assumed to be “in stock”. The management of delivery exceptions and credits is a manual process in the Openbravo environment.
Each system uses its own database (Magento uses MySQL and Openbravo uses PostgreSQL or Oracle 10/11g). Transactional objects (i.e. orders), products and customers are kept synchronized between the two systems. We will have a plan of upgrade to inventory sync.
Implementation Details

ERP / Openbravo Data Requirement

For any ERP system to fully track financial transactions, it needs a core set of transactional and subordinate objects defined and kept current in that system.

In general, Accounts Receivable works against invoices generated from a sales order. In Openbravo, this is modified slightly in that each invoiced sales order also has a shipment object representing the pending or successful shipment of that order. In addition, each sales order references a customer business partner as well as a set of products. Moreover, specific inventory items for each selected product are also referenced.

For this integration, Openbravo will be set up just as it would for any ordinary / stand alone implementation as necessary to order and ship a product. You will also need to create a default sales price list and purchase price list. Actual prices and costs will then be synchronized from Magento.

Data Synchronization Approach

In this RAWN implementation, data between Magento and Openbravo is synchronized periodically rather than instantaneous and may lag by several minutes. This was done by choice to avoid a performance and/or integrity impact on the eStore end user if Openbravo was unavailable for any reason.

Products, sales orders and customers are synchronized as follows:

Products are synchronized in a comparison approach: periodically looking for products existing in Magento that do not exist in Openbravo, and then defining that set of products in Openbravo.
Sales order synchronization is accomplished by first finding all sales orders created in Magento since the last synchronization process was executed. Once this list is determined, a Sales order (and optionally the related shipment and invoice objects) are created for each Magento sales order. This supports syncing of both stocked and non-stocked (e.g., downloadable) items.
Customer synchronization is accomplished in a similar fashion to products: periodically looking for customers defined in Magento that do not exist in Openbravo, and then defining those customers in Openbravo.
Both Product and Customer synchronization can take place with Sales order synchronization, where each order creation will be preceded by verification that the customer exists as a business partner in Openbravo and the product is defined as well. In the event that it is a new customer, the customer business partner will be defined before proceeding with the sales order creation in Openbravo. Products are synchronized in a similar fashion, if the order contains a product that would be new to Openbravo. For existing customers the billing & shipping addresses are compared to existing. If there are differences the new address is added.
Magento APIs / Web Services

In order to successfully synchronize Sales orders, the following APIs or Web services have been added to Magento using the XML-RPC protocol already available in the Magento framework. Proper user authentication is utilized to prevent unauthorized access to the services.

GetListOfSalesOrders

A service that returns a list of sales Order IDs, qualified by an optional date / time parameter. This service is used to get the list of Sales orders created SINCE the supplied date and time.

GetOrderDetail

This service returns the full details of a specified order ID. These details include a customer ID, order date/time and some number of order lines where each line includes a product ID, quantity, unit of measure and price. Ship-to and Bill-to addresses for the customer are also provided.

UpdateSalesOrderId

This service is used to save the Openbravo generated sale order id # into the Magento order for audit trail and verification that the order was successfully synchronized.

GetProduct

This service returns the name and description of a product from a specified product ID.

GetProductList

A service that returns all products that have changed since a specified date.

GetCustomer

This service returns the name and description of a customer from a specified customer ID.

Openbravo Job Services

In order to successfully synchronize Sales orders, the following Openbravo Process Scheduler (Quartz) Jobs are provided in Openbravo. These processes utilize the Openbravo Data Access Layer provided in the Openbravo 2.50 release.

ProductBatchSyncJob

This job gets a list of products that need to be defined or updated in Openbravo via the Magento GetProductList web service. It then defines a new product in Openbravo, or updates an existing product, for each Magento product retrieved.
This job can be scheduled to run periodically to ensure all Magento products available in the Webstore are defined in Openbravo as Products. For example, you could run this process ‘ad-hoc’ after a major update to your Magento product catalog.

SalesOrderBatchSyncJob

This job looks for Sales Orders in Magento that have not yet been synchronized to Openbravo.
For all such orders, it will create either a Standard Order or a POS order in Openbravo, based upon the type of product on the order.
Payment information is also synchronized with each order, using the Advanced Payables and Receivables module in Openbravo.
If there is detected a product or customer on a given Sales Order that has not yet been synced, that product and/or customer will be synchronized first before completing the Sales Order in Openbravo.
This job should be scheduled to run quite frequently in order to ensure that sales orders are synchronized over to Openbravo in a timely manner.
Further detail on the Sales Order Job Processes is included below in the Sales Order Synchronization Details section.

CustomerBatchSyncJob

This job gets a list of customers that need to be defined or updated in Openbravo via the Magento web services. It then defines a new customer (business Partner) in Openbravo, or updates an existing business partner.
This job can be scheduled to run periodically to ensure all Magento registered customers are defined as business partners in Openbravo.

Sales Order Synchronization Details

The integration ships with three defined Processes that can be scheduled for one-time or recurring execution by the OB Process Scheduler: Sales Order synchronization, Product Synchronization and Customer Synchronization.

The Sales Order Synchronization process is performed in two steps.

The first step is to poll the Magento system for new orders periodically. This is done with the SalesOrderBatchSyncJob class. The job should be scheduled to run periodically (i.e. every 10 minutes). The purpose of this job is to dispatch SalesOrderSyncJob jobs for each new order in Magento. RAWN’s implementation ensures no single order is assigned to more than one SalesOrderSyncJob.
The SalesOrderSyncJob gets the order details from Magento; validates the data and if valid creates the necessary Openbravo objects and notifies Magento that the order was synchronized.
How to download the Magento Integration

The Magento Integration System is a module, which you can access via the central repository. It consists of a file called com.RAWN.openbravo.magento-1.0.0.obx (.obx is the standard file extension for Openbravo ERP extension modules).

Log into Openbravo ERP in the System Administrator role.
From the Application Menu, select General Setup > Application > Module Management.
Click Add Modules. The list of modules available to install appears.
Navigate to the Magento Integration Pack.
Click Install Now.
A confirmation box appears. Click Continue to proceed with the installation. The license agreement appears.
Click I accept the license agreement.
Click Continue. Your selected module appears in the list of installed modules.
Click Rebuild now. A new window appears showing the rebuild in progress.
When the rebuild is complete, you must choose an option for how to restart Openbravo ERP. You can choose from the following:
Restart the servelet container: restarts Tomcat and reloads the application.
Reload the context: reloads only the contexts that have changed.
Take no action: does not reload any part of the application. Select this option if you want to manually restart Openbravo ERP later.
Click Continue.
Configuring the Magento Integration System

This document describes step by step the installation & configuration process of the Openbravo ERP – Magento Integration system. The installation process requires to install two additional modules, one on the Openbravo ERP and the other one on the Magento side and to configure settings required by those modules.

ERP-Magento Installation Guide

Source Tree Navigation: ${tomcat}/webapps/magento/config/magento

Specifications

Package Name: Magento Openbravo Connector

Contract Type: Perpetual

Price: $3,500

Module ID: MOD10008

Commercial Dependencies: Professional Subscription

Works For: Openbravo ERP 3.0 MP1 Professional Editions and later

Module Footprint:

Screens: 0
Reports: 0
Tables: 1
Databases Supported: PostgreSQL

Languages Included: English

Expertise Required: Integration of this module assumes sufficient technical expertise and understanding of the Openbravo and Magento systems. If required, implementation technical support services are available based on pre-paid support services purchased from the Our website. Optional “turn key” integrations are available on a custom quote basis.

Brought To You By

We are Gold implementation partner for Openbravo, the leading open source ERP platform. We offers a range of services to accelerate the deployment of web based enterprise applications using open source and “best-of-need” components.

Our services include:

Solutions architecture and systems design
Software development
ERP deployments, configuration and customization
Data migrations
Custom integration and connectors with legacy systems
Cloud and conventional deployments including 24/7 remote monitoring and technical operations services
We also offers Openbravo starter kits and basic support packages from our own Magento store at info@rawntech.com

Thank you. Your order has been received.

• Invalid order.