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;
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:
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:
Any help would be greatly appreciated.