Overview#

Flow name: MoveData_Commerce_Order_Item_Mapping Label: [MoveData] Commerce: Order Item - Mapping Type: Auto-Launched Flow Template API version: 56.0 Status: Active

This flow manages the transformation of commerce order item data from external platforms into Salesforce OpportunityLineItem records, handling price book entry relationships, pricing logic, and configurable fee handling.

Purpose#

The flow processes incoming order item data and maps it to appropriate Salesforce fields while managing:

• Fee type filtering with configurable exclusion of platform fees
• Currency determination for multi-currency environments
• Price book entry lookup and assignment for product relationships with enhanced error handling
• Opportunity relationship management for order items
• Pricing logic with support for both unit price and total price models
• Platform key assignment for external system tracking
• Quantity and pricing calculations

Salesforce fields#

Input variables#

Core order item data#

Related records#

Platform integration#

Configuration variables#

Output variables#

Flow logic#

1. Pre-processing validation#

Fee type filtering:

• Checks if item type is "fee" and Config_OrderTotalSubtractFeePlatform is true
• Sets Continue flag and skips processing for excluded fee items
• Allows configurable exclusion of platform fee line items

2. Product relationship management#

Product assignment:

• Proceeds only if CatalogRecord (Product2) is provided
• Ensures proper product relationship for line item creation

Currency determination:

• Uses CurrencyCodeComponent to determine appropriate currency
• Processes OrderCurrencyType input to standardise currency handling
• Supports multi-currency organisations

Price book entry lookup:

• Uses GetPriceBookEntryFlowComponent with currency support
• Passes CurrencyCode, Pricebook2Id, and Product2Id parameters
• Enhanced error handling for missing price book entries
• Sets PricebookEntryId on the line item record when found
• Adds error to Errors collection if price book entry not found

3. Opportunity relationship processing#

Order assignment:

• Sets OpportunityId when OrderRecord is provided
• Links line item to parent opportunity/order
• Maintains order-item relationship structure

4. Pricing logic processing#

The flow handles two distinct pricing models:

Unit price model#

Condition: UnitPrice is provided and not null

• Sets Quantity field from input
• Sets UnitPrice field from input
• Allows Salesforce to calculate TotalPrice automatically

Total price model#

Condition: Total is provided and not null

• Sets Quantity field from input
• Sets TotalPrice field from input
• Allows Salesforce to calculate UnitPrice automatically

Default behaviour:

• If neither UnitPrice nor Total is provided, proceeds without price assignment
• Maintains flexibility for different pricing scenarios

5. Platform key assignment#

• Sets md_comm_pack__Platform_Key__c field with provided platform key
• Enables future matching and duplicate detection
• Supports external system integration

Error handling#

Missing data scenarios#

• No product: Flow skips price book entry lookup and proceeds to opportunity assignment
• No price book entry: Flow adds error message to Errors collection instead of failing
• No opportunity: Flow proceeds without setting OpportunityId
• Fee items: Flow can skip processing based on configuration settings

Data quality validation#

• Null values: Graceful handling of missing optional parameters
• Pricing flexibility: Supports different pricing models from external platforms
• Relationship integrity: Ensures proper product-price book relationships
• Currency handling: Processes multi-currency scenarios through dedicated components
• Error collection: Accumulates errors for batch reporting instead of failing immediately

Dependencies#

• movedata__CurrencyCodeComponent (Apex action)
• GetPriceBookEntryFlowComponent (Apex action)

Related articles#

• Order item platform key flow
• Order item record match flow
• Order mapping flow
• Order item mapping flow (Non-Profit Cloud)
• Commerce Metadata Reference