Enterprise Resource Planning (ERP) systems form the backbone of many of the Omni Channel retailers, offering services in products, inventories, supply chain and resource management. In the current scenario for an Omni Channel retailer, the customer acquisition happens among the multiple channels offered by the retailers. In such situations, it is crucial that there is a seamless data exchange between the store front and the ERP.

Imagine a customer, who places an order through a mobile app and picks up the product in a store. In such cases, the order related data needs to be consistent across channels. To make this happen, a smooth synchronization between the ERP and the Magento store front is essential, so that a product which is available in ERP should reflect in the store and vice versa.

In numerous occasions, retailers face this enormous challenge of integrating the data between an ERP system and the Magento store front.  The main reason behind this hurdle is that each and every retailer follow their own unique business process, which would be customized in their ERP system. Hence, to make a defect free integration, a solid understanding of the ERP architectures and the data sets is necessary.

Let us look one of our customer stories, where we successfully integrated the data from an Oracle ERP with Magento for PDC, a major American Healthcare solutions provider. Here we needed to create a data exchange between Oracle and Magento.

We used the custom API’s in both Oracle ERP and Magento so that all the data sets were synchronized in specific time intervals. This API will be setup as a as routine job which will process the queued data and update the data in Oracle to Magento and vice-versa.

Oracle Magento Integration

The data synchronization can also be triggered based on certain events or on time intervals. This will vary depending on the business requirements of the retailer.

To capture the Data changes in Magento we need to create an event observer. The below sample explains the methodology in creating an event observer, the moment an order is placed.

To create an observer to capture order details, we need to create an order observer

<global>
<events> 
<catalog_product_save_after>
<observers>
<yourmodule>
<type>singleton</type>
<class>yourmodule/observer</class>
<method>catalog_product_save_after</method>
</yourmodule>
</observers>
</catalog_product_save_after> 
</events>
</global>

Once the order is captured the required information is sent via CURL function to Oracle ERP or store to enable consistency across channels.

class YourNamespace_YourModule_Model_Observer
{
public function catalog_product_save_after($observer)
{
$product = $observer->getProduct();
echo "<pre>"; 
print_r($product->getData());
echo "</pre>";
exit;
}
}

The only way forward for Omni Channel retailers is to maintain data consistency across warehouses, stock keeping units, physical shops and online stores. To achieve that its crucial to integrate the data between the Magento store front and ERP.

DCKAP is an Enterprise E-Commerce solutions provider specializing in Magento Oracle Integration. You can reach us at info@dckap.com (or) 1-877-872-3252 (US) (or) +44(0) 144 250 6383(UK)

Be the first to Know

Subscribe to our blog to get the latest articles directly to your inbox.

READY TO DRIVE SALES?

Request a Quote Today

Request a Quote

Leave a Reply

1 Comment on "How to Integrate Magento with Oracle ERP ?"


Guest
sree
3 years 4 months ago

Hi i am new to magento.i want to know what is the best way to integrate magento with ERP . …?