Streamlining Shipment Creation | Case Study

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.

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.

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.

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.