Alliance Partner

NetSuite Woocommerce integration

NetSuite ERP – A popular cloud ERP, encompasses ERP/Financials, Ecommerce and CRM for a number of organizations. WooCommerce transforms WordPress website to an Ecommerce store. It is a plugin for WordPress Ecommerce and it acts like a website shopping cart app. We have done Netsuite woocommerce integration.

Our client is a US based musical instrument wholesale and retail distributor with multi-location service which uses NetSuite  ERP as backend and Woocommerce for its front end support. They require an integration of NetSuite ERP with one of the open source e-Commerce plugin WooCommerce. The NetSuite WooCommerce integration helps them to have a real time view of the inventory.

Inventory management is a major component in any organization and it helps a company with a myriad of tasks. Our client needs an effective inventory management solution for their business in order to streamline stock levels. Through this, they can monitor their business features while also getting a clearer view of their stock analysis as derived from the inventory.

On approaching us, our client requires a detailed report on the possibilities of pushing the orders that were being made via their site to their NetSuite account. What they ultimately required was a feasible solution to help synchronize the information from NetSuite with WooCommerce. Additionally, they sought to synchronize customers and order information to and from NetSuite ERP and WooCommerce. For Synchronizing the software choices of our client we are using REST API. REST technology is a more robust technology which is a renowned standard in the creation of APIs.

Requirement

The requirements of our client entailed a solution for the efficient management of their inventory. This involves inventory update between Woocommerce and Netsuite ERP platform. Inventory management is an easy, accurate,  and profitable method to manage inventory records. Through inventory management, any transaction for items that take place will automatically update the corresponding quantity details. The advantage is that they do not need to re-enter the amounts for those items.

There is also a  need to synchronize all the data between Woocommerce and Netsuite ERP as well as effect synthesis between sales orders and customers. This is one of the ways to make their online business more proficient and convenient.

Furthermore,  Client requires to create login forms and two other types of registration forms. One Registration form is for wholesale users and the other is for retailers. The differentiation of these forms is based on a pricing level. There is also a need to push their existing users and the orders related to those users to their Netsuite. The products of the subsequent orders are identifying through their SKU(Stock Keeping Unit).

Integration of NetSuite with WooCommerce should perform automatic updates of inventory as this will result in the updating of customers and orders on both platforms.

Challenges of the NetSuite Woocommerce integration

Matching the items with NetSuite and WooCommerce is one of the major implementation difficulties we face during the development. Collecting SKU ID from both platforms was time-consuming. While from WooCommerce they collected the SKU name, in NetSuite it was the item ID that was obtained.

Another herculean task was encountered in the updating of the inventory count. The number of items in Netsuite inventory was so high thus taking the count became somewhat difficult. There was a need to take all the items from the NetSuite and compare it with those from the  WooCommerce site.

Our unique solution for the integration of WooCommerce with NetSuite

Our development team proposed a solution for integrating NetSuite ERP with WooCommerce through the use of REST API. This allows WooCommerce data to be updated with Netsuite by using JSON format with REST API as the connector between both platforms. REST API provides a great deal of flexibility. By using this API, developers need not install additional plugins as it supports the various data formats.

Steps of Integration

The first step for this integration process is to fetch all products from Woocommerce by using API. An authorization key is using for the fetching of data from our client’s site. Then we parse the data using JSON. After this, the SKU ID is taken for each item so that the corresponding SKU on Netsuite can be found. The SKU is then mapped from Netsuite to ID on Woocommerce for the update to finally take place.  The saved search is the tool for fetching data from Netsuite and the fetching is based on item id and quantities available.

Our team is also implementing the fetching of orders from Woocommerce so that checks are made of the existence of corresponding customers in Netsuite. If the customer exists then the sales orders for the customers with the updated addresses are creating.  This syncs both the platforms.

For matching the items our development team uses saved search, suitescript functionalities of Netsuite . They help to take a large quantity of data from Netsuite. By using saved searches and suitescripts, we can make any update in the future. The saved search is a re-usable search definition of Netsuite in which different criteria and results are taking from searches. Huge amount data are populating through suitescript so that our team can take a large number of data from Netsuite to compare it with Woocommerce.

For this integration, a Suitelet script is using as well as the creation of a saved search. REST API connector is then calling to connect both the platforms. Secure authentication keys are using for assured API connection. Implementation is doing with the use of different types of APIs like coupon API, customer API, order APIs etc.

Results

Our development team provides a solution that integrates Netsuite ERP with WooCommerce to know inventory details from both the platforms. We provide a live integration platform to connect Netsuite and Woocommerce. Our client can expand the business and can have flexibility between NetSuite and Woocommerce through this integration. Our team successfully implemented the inventory item quantity update. We also successfully synced the sales orders within these platforms so that with our solution they can create a better experience for their customers.

Success can also be see through the fetching of data from Woocommerce site to match it with the products from Netsuite. We also take the users from Woocommerce and check them with Netsuite customers. If the customers exist in Netsuite then only sales orders are creating, otherwise, both customers and sales orders create thus duplicating the customer’s database.

Our team developed synchronization between Netsuite and Woocommerce. By syncing data, it provides uniformity and consistency between the two platforms.

When any transaction occurs it will also reflect in inventory with the quantity updated according to the transaction data. That is to say that the inventory count is updating automatically. This integration performs pushing the users to Netsuite. In consequence, this will also update the sales orders and customers.

Netsuite -Woocommerce Integration works smoothly.  REST API connector specializes in the successful secure pushing of customers and orders in this integration.

Schedule
A Free Consultation

NetSuite consulting or development services when you need it as you need it.