Streamlining Shipment Creation | Case Study

Celigo integration with Bol.com and Netsuite that streamlines processes for efficient order management, inventory synchronization, and customer data handling

Shipment Creation Made Easy with Celigo Integration

About Customer

The customer is a rapidly growing online beauty retailer and brand owner based in the UK. With a diverse portfolio of market-leading personal care and beauty products, they distribute to over 20 countries worldwide. Committed to staying ahead of beauty trends, their small yet dynamic team of passionate individuals thrives on innovation and challenges conventions. Leveraging their agility and ownership of supply chains, they deliver cutting-edge products swiftly to market, enriching the lives of their customers with premium designs.

Application Requirements

Our project with Celigo aimed to streamline shipment Creation and data synchronization between Netsuite and Bol.com for our customer, a leading e-commerce platform. Leveraging Celigo’s integration platform, we developed a tailored solution to automate the transfer of order details, inventory information, and shipment updates between the two systems. By configuring export and import flows, setting up authentication tokens, and mapping fields, we optimized our customer’s e-commerce operations, ensuring seamless order processing and enhancing operational efficiency to drive business growth in the competitive online retail market.

The Business Case Challenge

During the execution of the integration flow between Netsuite and Bol.com, we encountered two significant challenges. Firstly, only the shipment for the first OrderItemID (line item) was successfully created, while subsequent shipments failed to be generated. This issue stemmed from the initial assumption that shipments could be created solely based on the OrderID. However, upon analysis, it became apparent that shipments needed to be generated based on the unique OrderItemID associated with each line item, rather than the OrderID itself.

The second challenge arose from the uniformity of shipment details, specifically the TrackAndTrace code, for every OrderItemID under a single OrderID. Initially, it was assumed that each line item would have a distinct TrackAndTrace code associated with its shipment. However, it was discovered that all OrderItemIDs under one OrderID shared the same TrackAndTrace code. This posed a complication as it undermined the ability to accurately track and trace individual shipments.

Addressing these challenges required a comprehensive review of the integration logic and the implementation of custom handling procedures. By refining the integration flow to create shipments based on the unique OrderItemID and resolving the issue of uniform shipment details, we ensured the successful transfer of data between Netsuite and Bol.com, optimizing the efficiency and accuracy of the integration process.

OdiTek’s Solution

To address the challenge of facilitating seamless data integration between Netsuite and Bol.com, OdiTek devised a robust solution leveraging the Celigo platform. Firstly, we ensured smooth access to the Celigo platform by configuring user credentials and navigating to the “My Integrations” tab to select the Bol.com Integration.

Our solution architecture began with the creation of the “Netsuite-Bol.com” flow, meticulously designed to streamline the data transfer process. The flow commences with the “Netsuite Export

Bubble,” which extracts relevant data from Netsuite’s production environment using specific search criteria from the “itemfulfillment” record type.

Subsequently, we implemented the “HTTP Lookup Bubble (Generate Token)” to authenticate access to Bol.com’s API. This bubble sends a POST request to the designated endpoint, utilizing the Bol.com API documentation for reference.

Result mapping techniques were employed to merge data returned by the HTTP lookup back into the source record, enabling field customization and creation. The “Second HTTP Lookup Bubble” then accesses the generated token to retrieve OrderItemIDs for each order from Netsuite, employing GET methods and handlebars expressions for efficient filtering.

After filtering out the necessary data, the “HTTP Import Bubble” orchestrates the creation of shipments for OrderItemIDs using the appropriate endpoint, as specified in the Bol.com API documentation. Mapper 2.0 facilitates the mapping of source fields from Netsuite to destination fields for shipment creation, while response mapping captures relevant status codes for further processing.

The solution incorporates an input filter mechanism to ensure the flow continues only if the status code is 200, enhancing data integrity and reliability. Upon successful data posting to Bol.com, the “Netsuite Import Bubble” updates Netsuite saved search status, while the “Import Mapping” triggers an action to update the custom field “eTail Order Fulfillment Exported” in Netsuite. This ensures accurate tracking and synchronization of order fulfillment status between Netsuite and Bol.com systems.

In summary, OdiTek’s comprehensive solution automates the transfer of data between Netsuite and Bol.com, ensuring seamless integration and efficient order fulfillment processes. Our solution is designed for scalability and can be easily modified to accommodate future adjustments or enhancements as required.

At a Glance

The “Netsuite-Bol.com” flow is meticulously designed to streamline data integration between Netsuite and Bol.com, leveraging Celigo’s robust platform. By automating the transfer of data, this flow facilitates seamless integration and efficient order fulfillment processes, enhancing operational efficiency for businesses utilizing Netsuite and Bol.com.

Industry

This integration solution caters to the e-commerce industry, particularly for businesses operating on Netsuite and Bol.com platforms. By bridging the gap between these two systems, it enables smoother data synchronization, which is crucial for businesses engaged in online retailing and order management.

Key Results

The “Netsuite-Bol.com” flow delivers a range of key results, including automated data transfer between Netsuite and Bol.com, streamlined order fulfillment processes, and enhanced operational efficiency. It ensures that businesses can effectively manage their online sales channels and optimize their e-commerce operations.

Technologies Used

The implementation of the “Netsuite-Bol.com Final” flow involves a blend of cutting-edge technologies and tools. This includes Celigo’s platform for integration, HTTP endpoints for authentication and data retrieval, and Bol.com API documentation for endpoint reference, look-ups to filter data and Handle bar expressions. Additionally, the flow utilizes advanced mapping techniques, HTTP requests, and status code validation to ensure smooth data transfer and synchronization between Netsuite and Bol.com.

NetSuite

Celigo

Bol.com

HIGH LEVEL ARCHITECTURE

Result

The integration project required 3 months for the deployment of the solution, which immediately replaced the manual effort of our customer’s customer support & logistics team. All sub-systems were successfully deployed and seamlessly interacted with each other, effectively delivering all intended business functions in a centralized automated manner. Within a month of deployment and system handover, the manual errors or omissions of any missing order turned to zero. The success of this project led to another series of similar digital transformation projects from the customer as they saw value in automation and integration. .

LIKE TO KNOW MORE ABOUT OUR TELECOM SERVICES?
Case Studies

× How can I help you?