Trouble with Lookup functions in AMPscript

Question

Hope you're well and having a great day!

I'm working through a communication to our contacts that are experiencing shipping delays due to supply chain issues with our supplier. Though we're pulling our contact data from two Sales Cloud objects; Opportunity and WorkOrder. I've had to resolve an issue where the Opportunity (Classic sign-ups) contains a product code and name but not one we can surface to the customer (Product_Commercial_Name) which is present on the Work Order (our Lightning-based sign-ups). To get around this, I've created a reference Data Extension with the required SKU information which I was hoping to look up and print in the email i.e. your %%=v(@incentiveName)%% is delayed...

Here's my AMPscript:

%%[
var @classicIncentive, @productName, @incentiveName, @lightningSignUp

SET @lightningSignUp = WorkOrder_Id

IF EMPTY(@lightningSignUp) THEN
  SET @classicIncentive = '1'
ENDIF

IF @classicIncentive == '1' THEN
  SET @productName = Product_Commercial_Name__c
  SET @incentiveName = Lookup("Classic Incentive SKU Table","Product_Code","Product_Name",@productName)
ELSE 
  SET @incentiveName = Product_Commercial_Name__c
ENDIF]%%

The reference data extension contains three columns:

• Product_Name
• Product_Code
• Product_Commercial_Name

I was hoping to pul the Product_Commercial_Name value for Classic sign-ups. BUT I'm having trouble getting my lookup function to work (it's probably just me being a newb). I've reviewed the following resources to try to get it sorted but no luck just yet:

• Salesforce Developer

• Sprignaturemoves

• The AMPscript Guide

Any help would be greatly appreciated.

Answer 1

I'd suggest adding some debugging output -- in addition to wrapping your personalization strings in AttributeValue.

%%[ 

SET @WorkOrder_Id = AttributeValue("WorkOrder_Id")

output(concat("<br>WorkOrder_Id: ", @WorkOrder_Id))

IF EMPTY(@WorkOrder_Id) THEN
  SET @classicIncentive = '1'
ENDIF

output(concat("<br>classicIncentive: ", @classicIncentive))

IF @classicIncentive == '1' THEN

  SET @productName = AttributeValue("Product_Commercial_Name__c")
  output(concat("<br>productName: ", @productName))

  SET @incentiveName = Lookup("Classic Incentive SKU Table","Product_Code","Product_Name", @productName)
ELSE 
  SET @incentiveName = AttributeValue("Product_Commercial_Name__c")
ENDIF

output(concat("<br>incentiveName: ", @incentiveName))

]%%

What output do you get if you add those statements?