NetSuite DSCO Integration

img

One of our US-based customers required the integration of DSCO with NetSuite. DSCO, part of CommerceHub, is an eCommerce platform connecting retailers and sellers to promote, sell and deliver their products. DSCO creates networked supply chains to simplify and standardize the exchange of inventory, order, and catalogue data between retailers and sellers. Our customer is one of the pet products major in the UK. We used scheduled scripts to enhance the customer’s business efficiency in inventory management, shipping methods, and invoice generation.

NetSuite DSCO Integration Requirements

Our NetSuite Integration experts conducted an analysis to understand the requirements of our customers. The major requirements identified are:

1. Importing items and inventory from NetSuite to DSCO.

2. Sales Order Creation in NetSuite and order acknowledgement.

3. Shipment creation in DSCO.

4. Invoice creation in DSCO.

Steps Involved

The initial phase of the integration is the creation of a customer card in  NetSuite to sync inventory details from NetSuite to DSCO based on the provided catalogue. In the SKU mapping, it creates an item record, in the DSCO customer card for new items from NetSuite. For the items that already exist in DSCO, only the inventory count is updated. This occurs at regular intervals of time from NetSuite to DSCO with scheduled scripts. 

When an order reflects in DSCO, NetSuite creates a sales order for that particular order at a regular interval and creates an acknowledgement for DSCO.  When the item fulfilment status for the DSCO order changes to ‘ship’ status, using the details of shipment method and carrier provided by the customer, it creates item fulfilment details in DSCO with tracking number. This is a real-time integration process i.e, whenever items fulfilment status alters to ‘ship’ status, tracking details automatically creates in DSCO from NetSuite.

The next step is to generate invoices for the sales orders. When there is an invoice creation in NetSuite for DSCO created orders, the sales order status is checked in NetSuite. If the sales order status is ‘billed’, then it leads to the creation of an invoice for that order in DSCO. In addition, the ‘INVOICE CREATED’  checkbox is flagged in the sales order.

Challenges and Solutions

One of the major challenges in NetSuite with DSCO integration is the lack of kit item concept in DSCO, which lead to the creation of items in DSCO individually. We resolved this issue.  

Additionally, the developers faced issues with mapping, duplicate items creations and the generation of shipment details. With dedication and experience, our development team managed the issues and resolved them to deliver a result that satisfied the customer 100%.

Result

The DSCO-NetSuite integration reaped maximum benefits to our customers. The integration has made our customers have enhanced efficiency in e-commerce sales and completely automate the process of inventory management, shipment creation, and invoice generation. Our development team delivered the project within the timeframe without compromising quality in the integration. 

Want to streamline your business processes with NetSuite integration? Jobin & Jismi can help. Our experts provide customized NetSuite integration solutions that can help you get the most out of your NetSuite system. Contact us at contactus@jobinandjismi.com.