NetSuite integration

Online fashion store use case

Ricston enabled an e-commerce solution with near real-time integration between back-end system for inventory management, sales processing and invoicing. Using the power of Mule runtime and SaaS connectors simplified the process of extracting and synchronising data between NetSuite ERP and Magento e-commerce systems.

Benefits of our integration solution included:

  • Improved product data consistency
  • Increased successful order fulfilment
  • Rationalised ERP view of the customer
  • Digital invoice and receipt availability
  • Enhanced customer web experience with more fine-grained order tracking

Ricston rapidly delivered an end-to-end solution that enabled boutique fashion houses with geographically distributed physical stores, to offer online direct sales to customers in the region.

The Problem – Use Case

Our Client, a leading online fashion store, uses two different Business Management Software Systems to manage Sales Order requests:

  • Cloud Business Software (ERP), NetSuite &
  • E-Commerce platform Magento.

The Client is scaling the business rapidly and the Company wished to have an automated process that would sync information from one system to another while reconciling any data conflicts that might arise throughout the process. The process of synchronizing sales orders between the two systems would be very time consuming if done manually.

  • E-Commerce application Magento is not updated with item/product data and inventory levels recorded in ERP NetSuite.
  • Item master and inventory levels are maintained in NetSuite only.
  • There is no synchronization of Sales Orders data between NetSuite and Magento. This involves:
    • Sales effected through Magento need to be created in NetSuite.
    • Inventory Items have to be synchronised.
    • Invoices created in NetSuite have to be loaded into Magento.
    • Customer details recorded in Magento have to be migrated over and tracked in NetSuite.

Our Solution – Magento and NetSuite Integration

Ricston proposed a solution using Mule. Mule provides both a NetSuite connector and Magento connector – that simplifies the process of extracting and delivering information between these ERP and E-Commerce systems.

In a nutshell

We have built an application that runs in an automated fashion using Mule poller. It is split into three separate processes, set to run one after the other:

  • The first process uses both the NetSuite connector and Magento connector to retrieve the current list of Inventory items from NetSuite and syncs this over to Magento.
  • The second process is responsible for creating sales orders in NetSuite that have been effected in Magento.
  • The third process kicks off a script that calls a NetSuite Custom Search Procedure that also handles the creation of the NetSuite invoice. This invoice is then downloaded and uploaded to the client’s FTP server. The last step is to update Magento and set the status of the order to completed.

Whilst creating a sales order in NetSuite is a simple affair, we faced a couple of problems.

  • The first problem related to customers that have not yet been created on NetSuite – the solution was to have a separate sub-process that would handle the creation of new customers if needed.
  • The second problem was to ensure that the right ID’s were used to link the individual system records – to do this it was necessary to ensure that custom ID’s were set on NetSuite that relate directly to those used by Magento.

Ricston has built a system that achieves the synchronization of data flows between NetSuite and Magento at predefined intervals on specific days without any human intervention.

Contact Us

Ricston Ltd.
Triq G.F. Agius De Soldanis,
Birkirkara, BKR 4850,
MT: +356 2133 4457
UK: +44 (0)2071935107

Send Ryan a message

Ryan Delia
Services Director