Overview#

Flow name: MoveData_Commerce_Catalog_Mapping Label: [MoveData] Commerce: Catalog - Mapping Type: Auto-Launched Flow Template API version: 56.0 Status: Active

This flow handles the mapping and transformation of catalog data from external commerce platforms into Salesforce Product2 records, with configurable field mapping and replacement rules.

Purpose#

The flow processes incoming catalog data and maps it to appropriate Salesforce Product2 fields while handling:

• Product name mapping with protection rules
• Product code assignment with conditional replacement
• SKU (Stock Keeping Unit) mapping with flexible source options
• Product description handling
• Status mapping for active/inactive products
• Currency code determination and assignment
• Platform key assignment for external system tracking
• Configurable field replacement policies

Salesforce fields#

Input variables#

Core product data#

Configuration variables#

Output variables#

Flow logic#

1. Name processing#

The flow first determines if the product name should be updated:

• Protection check: If md_npc_pack__Protect_Name__c is true, skips name processing
• Name assignment: Sets Name field from ProductName input if provided and not protected

2. Product code mapping#

Product code assignment follows conditional logic:

Assignment conditions:

Config_CatalogSetProductCode = true  AND (
    Config_CatalogReplaceProductCode = true
    OR (Config_CatalogReplaceProductCode = false AND ProductCode is null)
)

Logic:

• If replacement is enabled: Always sets the product code
• If replacement is disabled: Only sets if existing ProductCode is null

3. SKU processing#

SKU assignment uses a formula to determine the source value:

SKU source formula:

CatalogProductSku = IF(Config_CatalogProductSkuUseCode == TRUE, Code, PlatformKey)

Assignment conditions:

Config_CatalogSetProductSku = true  AND (
    Config_CatalogReplaceProductSku = true
    OR (Config_CatalogReplaceProductSku = false AND StockKeepingUnit is null)
)

Examples:

• If Config_CatalogProductSkuUseCode = true: SKU = Code value
• If Config_CatalogProductSkuUseCode = false: SKU = PlatformKey value

4. Description mapping#

Description assignment follows the same conditional pattern:

Assignment conditions:

Config_CatalogSetProductDesc = true  AND (
    Config_CatalogReplaceProductDesc = true
    OR (Config_CatalogReplaceProductDesc = false AND Description is null)
)

5. Status mapping#

External platform statuses are mapped to the Salesforce IsActive field:

Default behaviour: Any status other than "active" sets IsActive to false.

6. Currency processing#

The flow handles currency code assignment through action calls:

• Determine currency: Calls movedata__CurrencyCodeComponent to validate and process currency code
• Currency assignment: Uses movedata__SetValueComponent to set CurrencyIsoCode if valid currency provided
• Length check: Uses CurrencyTypeLen formula to verify currency code exists before assignment

7. Platform key assignment#

• Sets md_npc_pack__Platform_Key__c field with the provided platform key
• Always executed regardless of configuration settings
• Used for external system tracking and duplicate detection

Configuration logic patterns#

Conditional field assignment#

The flow uses a consistent pattern for configurable field assignment:

Pattern:

IF (
    Config_Set[Field] = true
    AND (
        Config_Replace[Field] = true
        OR (Config_Replace[Field] = false AND [Field] is null)
    )
) THEN
    Set [Field] = [Value]

Behaviour:

• Set = false: Field is never updated
• Set = true, Replace = true: Field is always updated
• Set = true, Replace = false: Field is updated only if currently null

Default configuration values#

Protection mechanisms#

The flow includes protection fields to prevent overwriting existing data:

• md_npc_pack__Protect_Name__c: Prevents name updates when enabled
• Configuration-based protection for other fields through replace flags

Error handling#

• Uses conditional logic to handle null values gracefully
• Skips field assignment when conditions are not met
• Validates configuration settings before processing each field
• Currency code validation through dedicated components

Dependencies#

• movedata__CurrencyCodeComponent (Apex action)
• movedata__SetValueComponent (Apex action)

Related articles#

• Catalog name flow
• Catalog platform key flow
• Catalog record match flow
• Non-Profit Cloud Metadata Reference