Boomi Lazada Market Overview

Documentation for process: Orders\Lazada\stores\to\Netsuite

Overview

This process Integrates order data from Lazada e-commerce stores into the NetSuite ERP system. It starts by retrieving the latest order data from Lazada, maps the order details to the NetSuite sales order format, and then creates or updates the corresponding sales orders in NetSuite. The process includes robust error handling, business rule validations, and notifications to ensure the seamless synchronization of Lazada orders with the NetSuite system. It also leverages caching mechanisms and parallel processing to optimize performance and scalability. This integration enables organizations to streamline their order-to-cash processes, improve inventory visibility, and enhance customer experience by aligning their e-commerce and ERP systems.



Process Diagram

Branch 1:\

Branch 2 MY and SG:

\

SG Market:\

Business Context

Source Application: Lazada
Target Application: NetSuite
Application Info:

  Lazada: Lazada is a leading e-commerce platform in Southeast Asia, offering a wide range of products across various categories. It provides a robust order management system that enables merchants to sell their products online and reach a large customer base.
  NetSuite: NetSuite is a comprehensive cloud-based ERP system that integrates core business functions such as accounting, finance, inventory management, order fulfillment, and customer relationship management. It helps organizations streamline their operations, improve visibility, and make data-driven decisions.



Process Steps and Functions



Start\[stepname= "Start"]: Initiates the process by retrieving the latest order data from the Lazada e-commerce platform.
Branch 1:
  Connector, connectorname= "NetSuite", actionType= "GET"]: Retrieves a file from the NetSuite system, potentially containing reference data or configurations required for the integration.
  Splits the process flow into two parallel paths - one to retrieve the file contents from NetSuite and the other to fetch the Lazada order data.
  Data Process: Decodes the file content from Base64 encoding.
  Map Transforms the item-level data from the Lazada order by converting the SKU values to uppercase.
  Add to Cache: Caches the processed Lazada order data for efficient retrieval and reuse in subsequent steps.
Branch 2:
  Connector "HTTP Client", actionType= "Get": Fetches the latest order data from the Lazada e-commerce platform.
  Decision – Checks if Order ID is not Empty
  If Empty: Processing Stops
  If Not: Processing Continues.
  Data Process Shape: Performs split data processing ton the Lazada order data.
  Flow Control: To run each document individually.
Route based on the Location: MY or SG:
MY Market and SG Market - Performs intermediate mapping and transformation of the Lazada order data, potentially handling tasks like item count calculations.
  Map Transforms the Lazada order data from a CSV-like format to a JSON structure, preparing it for further processing.
  Try/Catch\[stepname= "Try/Catch"]: Establishes an error handling mechanism to capture and manage any exceptions that may occur during the mapping and transformation steps.
  Mapping Shape: This critical mapping step transforms the Lazada order data into the format required for creating or updating sales orders in the NetSuite system. It handles various transformations, including date formatting, cross-reference lookups, price mapping, document property setting, and shipping calculations.
  Notify\[stepname= "Notify"]: Sends notifications or alerts regarding the successful processing of the Lazada order data.
Try
  Splits the process flow into two parallel paths - one for error handling and the other for setting document properties.
  Connector "NetSuite", actionType= "UPSERT" Leverages the NetSuite connector to create or update sales orders in the NetSuite system based on the transformed Lazada order data.
Catch will route per Market \singapore or \malaysia
Business Rules: Validates Lazada orders to decide if they should be accepted or rejected.
 If Reject:
   Message: Sends error or rejection messages for orders that fail validation.
  Decision: Determines the next steps based on validation and processing results.
  Message: Notifies if items are unavailable in NetSuite.
   Connector (Slack): Sends Slack notifications for failed order processing.
   Data Process: Processes accepted orders further.
If Accepted:
  Connector (HTTP Client): Updates order status or tags.



Lazada\Stock\Sync

Overview

The "Lazada\Stock\Sync" process updates product stock levels between NetSuite and Lazada. It first gets product quantities from NetSuite, then fetches current data from Lazada. It maps and updates stock levels on Lazada, including a specific category (Beaba). This ensures that inventory is accurate and consistent across both systems.

Process Diagram




Process Steps and Functions



Start\[stepname= "Start"]: Initiates the stock synchronization process.
Document Properties\[stepname= "Document Properties"]: Sets the necessary document properties, such as the DPP\Store and DDP saved searches, to be used throughout the process.
Branch\[stepname= "Branch", numBranches= "3", 1= "Process Call", 2= "Connector", 3= "Connector"]: Splits the process flow into three parallel branches to handle different aspects of the stock synchronization.
Process Call\[stepname= "Process Call", sub\process\name= ]: Calls a subprocess to retrieve the latest product quantity information from the NetSuite ERP system.
Connector\[stepname= "Connector", connectorname= "HTTP Client", actionType= "Get"]: Fetches the current product data from the Lazada e-commerce platform.
Connector\[stepname= "Connector", connectorname= "HTTP Client", actionType= "Get"]: Fetches the current product data for the Beaba product category from the Lazada e-commerce platform.
Data Process\[stepname= "Data Process"]: Performs any necessary data processing or transformation on the retrieved Lazada product data.
Decision\[stepname= "Decision", true= "Data Process2", false= "Stop"]: Evaluates the data processing results and determines whether to proceed with the stock update or stop the process.
Data Process2\[stepname= "Data Process"]: Executes additional data processing or transformation tasks on the Lazada product data.
Stop\[stepname= "Stop"]: Marks the successful completion of the stock synchronization process.
Map\[stepname= "Map", mapname= ,

of mappings= 4]: This mapping step aligns the product stock levels retrieved from NetSuite with the corresponding Lazada product records. It utilizes a custom function, 'SKU\LocationQuantityAvailable', to map the stock data accurately.
Notify\[stepname= "Notify"]: Generates a notification or log entry to indicate the successful completion of the Lazada stock update.
Document Properties2\[stepname= "Document Properties"]: Sets an additional document property, 'Update\Store', to be used in the subsequent steps.
Connector\[stepname= "Connector", connectorname= "HTTP Client", actionType= "Send"]: Updates the product stock levels on the Lazada e-commerce platform based on the mapped data.
Stop\[stepname= "Stop"]: Marks the successful completion of the Lazada stock update process.