3PLAR: NetSuite ERP & 3PL Integration for Automated Fulfillment

About the Customer

3PL NetSuite integration became a critical need for a rapidly growing skincare brand headquartered in New York City and San Antonio, well-known for being the “Experts in SPF™.” Since its inception in 2005, the company has transformed the sunscreen market by creating high-performance, elegant formulas that consumers genuinely enjoy wearing every day. With more than 40 product variations spanning face, body, mineral, and makeup lines, the brand continues to expand its reach while maintaining its dedication to clean beauty standards. It formulates products without oxybenzone, octinoxate, or parabens, and is fully committed to cruelty-free practices. In addition to its innovative product line, the company has introduced its Ounce by Ounce® impact program, which focuses on education, advocacy, and expanding access to healthy SPF habits worldwide. As demand across wholesale, direct-to-consumer, and promotional channels grew, the brand required a seamless integration between NetSuite ERP and its System Beauty 3PL platform to unify operations and ensure efficiency at scale.

Application Requirements

The company required an automated solution capable of synchronizing sales orders, transfer orders, and fulfillment data between NetSuite and the System Beauty 3PL platform. The integration had to support three primary channels B2B, DTC, and Gratis each of which relied on separate saved searches in NetSuite but followed the same downstream processing logic. A key requirement was that the workflows be idempotent, ensuring that orders would not be duplicated across systems. The integration also needed to incorporate caching for NetSuite lots and locations to enhance performance, apply channel-specific business rules while maintaining shared error-handling capabilities, and provide complete traceability for every step in the process. To meet these objectives, the brand turned to Dell Boomi as the integration platform, leveraging its ability to manage complex workflows through reusable subprocesses.

Use Case Solution

OdiTek developed a multi-channel integration framework on Boomi that unified B2B, DTC, and Gratis order flows into a consistent, automated system. Each of these channels was implemented as a main process, linked to its own saved search in NetSuite for retrieving order data. While the entry points differed, all three channels converged on the same set of reusable subprocesses, creating a scalable and standardized integration model.

The B2B workflow was designed to capture wholesale orders, which often involve more complex validation and customer lookups. Once the orders were retrieved from NetSuite using the B2B saved search, they were transformed into canonical order formats, validated against business rules, and securely transmitted to the System Beauty 3PL for processing. The DTC workflow, by contrast, was optimized for higher transaction volumes and fast turnaround times. It relied on dynamic date ranges and caching to handle large datasets efficiently while applying consumer specific validation logic. Finally, the Gratis workflow focused on promotional or zero cost orders, which required specialized handling for discounts, free shipping, and duplicate prevention. Although the three workflows differed in entry logic and business rules, they all drew from the same core library of subprocesses to ensure consistent execution.

The subprocesses formed the backbone of this integration framework. The “Cache Inventory Details for Lots” subprocess retrieved lot-level data from NetSuite and stored it in cache for quick access during fulfillment operations. The “Process Fulfillments to NetSuite” subprocess handled the transformation and posting of fulfillment data from System Beauty back into NetSuite, ensuring that transaction statuses were always accurate and up to date. The “Process NS Item Fulfillment” subprocess carried out the actual fulfillment execution in NetSuite, supporting both sales and transfer orders through initialize and upsert operations. Another important subprocess, “Get System Beauty Orders,” connected directly to the System Beauty API, established an access token, and retrieved order information with proper error validation. Supporting these was the “Cache NS Locations” subprocess, which kept location data synchronized between the two systems, and the “Establish System Beauty Access Token” component, which managed secure authentication for all API interactions.

By structuring the integration around three main processes supported by a shared library of subprocesses, OdiTek delivered a solution that was both flexible and highly maintainable. Each sales channel maintained its own business-specific logic through NetSuite saved searches, while the shared subprocesses ensured uniform handling of caching, fulfillment, authentication, and error management.

At a Glance

The System Beauty NetSuite Multi Channel 3PL Integration provides a seamless bridge between NetSuite ERP and the System Beauty 3PL platform, enabling unified processing across B2B, DTC, and Gratis channels. Built on Dell Boomi, the solution automates the synchronization of orders and fulfillments, enforces channel specific business rules, and ensures accurate, realtime visibility across systems. By separating the channel entry points from the shared subprocesses, the design achieves a balance between flexibility for channel-specific requirements and efficiency through standardized downstream execution.

Industry

This integration serves the beauty and skincare industry, which increasingly relies on third party logistics partners to manage fulfillment across multiple sales channels. For companies operating with NetSuite ERP at the core of their back-office operations, the ability to unify wholesale, consumer, and promotional order flows into a single framework is a significant advantage. It ensures operational efficiency, reduces the risk of errors, and provides management with a single source of truth for sales and fulfillment data.

Key Results

The deployment of this integration resulted in complete automation of the order-to-fulfillment lifecycle across all sales channels. Orders from B2B, DTC, and Gratis channels are now synchronized in real time, with caching mechanisms ensuring high performance even under heavy transaction loads. The use of idempotency checks eliminated duplicate records, while the shared subprocesses reduced development overhead and ensured consistency in fulfillment handling. With robust error management and monitoring, the customer achieved full traceability of their order flows. The unified visibility of order lifecycles within NetSuite provided the finance and operations teams with greater control, enabling faster decision-making and more accurate reporting.

Technologies Used

The solution was implemented using Dell Boomi as the core integration platform. NetSuite’s Token-Based Authentication was leveraged for secure access to saved searches, transaction queries, and fulfillment operations. The System Beauty REST APIs were used for order creation, retrieval, and fulfillment synchronization. Dynamic Process Properties enabled flexible scheduling and incremental data runs, while caching was employed for inventory lots, locations, and order batches. Advanced mappings were used to transform XML and JSON data formats, with canonical data structures ensuring consistent communication between systems. Finally, Boomi’s flow control, branching, and Try Catch logic provided the conditional execution and structured error handling necessary to support complex, high volume integrations.

Result

The System Beauty, NetSuite Multi-Channel 3PL Integration successfully delivered an automated and scalable solution for synchronizing orders and fulfillments across all channels. By aligning B2B, DTC, and Gratis workflows with a shared library of subprocesses, the integration provided both flexibility and standardization. The result was faster fulfillment cycles, reduced manual intervention, and improved data accuracy across systems. With real-time operational visibility in NetSuite and a future-proof integration framework, the customer is now positioned to scale confidently as its business continues to grow.

× How can I help you?