Overview#

Flow name: MoveData_Commerce_Catalog_Post Label: [MoveData] Commerce: Catalog - Post-Upsert Type: Auto-Launched Flow Template API version: 56.0 Status: Active

This flow manages post-processing operations for product catalog records in Salesforce, with a primary focus on price book entry management.

Purpose#

The flow performs several critical functions:

• Validates that an active Standard Price Book exists
• Creates or updates price book entries for products
• Manages pricing with multi-currency support
• Ensures products are configured for sales operations
• Synchronises prices between external platforms and Salesforce
• Maintains comprehensive audit logs

Salesforce fields#

Input variables#

Output variables#

Flow logic#

1. Standard Price Book validation#

The flow validates the Standard Price Book's existence:

• Error: "Must have an active Standard Price Book" terminates processing if validation fails
• Ensures products can be properly priced within Salesforce

2. Currency code processing#

The flow applies formula logic:

• If CurrencyType is blank, uses Order_CurrencyType as fallback
• Otherwise uses CurrencyType

3. Price book entry lookup#

An Apex component (GetPriceBookEntryFlowComponent) searches for existing entries using:

• Currency code
• Price book ID
• Product ID

4. Price book entry processing decision#

Scenario A - Existing entry found:

• Compares existing UnitPrice with incoming Price value
• Updates only when prices differ
• Skips unnecessary updates

Scenario B - No entry found:

• Creates new PricebookEntry SObject
• Sets IsActive = true
• Assigns Product2Id, Pricebook2Id, UnitPrice
• Determines and assigns currency code if available

5. Currency code management#

• movedata__CurrencyCodeComponent validates currency codes
• The flow only sets CurrencyIsoCode when valid currency is determined using movedata__SetValueComponent

6. Logging and tracking#

• Logs currency determination steps
• Documents price book entry operations
• Tracks created/updated record IDs for downstream processing
• Uses movedata__WriteToLogFlowComponent and movedata__WriteObjectToLogComponent

Configuration requirements#

Standard Price Book setup#

• Organisation must have an active Standard Price Book
• StandardPriceBookId must be provided to the flow
• Price book must be marked as Standard and Active
• User permissions must allow price book management

Currency configuration#

• Flow handles multi-currency dynamically
• Supports fallback currency logic
• Validates currency codes before assignment
• Requires multi-currency enablement for currency field availability

Price management strategy#

• Updates only when prices differ from existing values
• Automatically creates entries for new products
• Ensures immediate availability for sales processes
• Maintains Salesforce standard price history tracking

Error handling#

Missing Standard Price Book#

• Symptom: Flow terminates with validation error
• Resolution: Verify price book exists in Setup > Products > Price Books; confirm it is marked active and standard

Currency code issues#

• Causes: Invalid codes, disabled multi-currency, validation failures
• Troubleshooting: Review logging output; verify multi-currency settings; check active currency codes

Price book entry creation failures#

• Causes: Inactive product, permission issues, invalid currency, duplicate entries
• Troubleshooting: Verify product status; check user permissions; validate price format; review detailed logs

Dependencies#

• GetPriceBookEntryFlowComponent (Apex action)
• movedata__CurrencyCodeComponent (Apex action)
• movedata__SetValueComponent (Apex action)
• movedata__WriteToLogFlowComponent (Apex action)
• movedata__WriteObjectToLogComponent (Apex action)

Related articles#

• Catalog mapping flow
• Catalog record match flow
• Non-Profit Cloud Metadata Reference