Conditionally include coupons in emails

Question

I have created an email with SFMK with coupons.

This is:

%%[
var @couponRow,  @couponCode , 

set @email = AttributeValue("Email Address")
set @FirstName = AttributeValue("First Name")
set @LastName = AttributeValue("Last Name")
set @AssetNumber = AttributeValue("Asset Number")

set @couponRow = ClaimRow('Data_Extension_Code','IsClaimed', 'Email Address', @email, 'First Name', @FirstName, 'Last Name', @LastName, 'Asset Number', @AssetNumber)

if empty(@couponRow) then
RaiseError('No coupons available', false)
else
SET @couponCode = Field(@couponRow,'CouponCode')
endif
]%%

But I need that if there are no coupons available that the coupon is not shown, how can I do it.

Because all costumers receive that email but not all have a coupon.

Thanks.

Answer 1

You want to update the IF statement to show alternative content, and not raise an error. If an error is raised, the email is not sent.

%%[

set @email = AttributeValue("Email Address")
set @FirstName = AttributeValue("First Name")
set @LastName = AttributeValue("Last Name")
set @AssetNumber = AttributeValue("Asset Number")
SET @Eligible = AttributeValue("Eligible")

IF @Eligible == "true" THEN
set @couponRow = ClaimRow('Data_Extension_Code','IsClaimed', 'Email Address', @email, 'First Name', @FirstName, 'Last Name', @LastName, 'Asset Number', @AssetNumber)

ENDIF

if @Eligible == "false" then
]%%

You shall not receive any codes today!

%%[
ELSE IF (@Eligible == "true" AND NOT empty(@couponRow)) THEN
]%%

Your code is %%=Field(@couponRow,'CouponCode')=%%

%%[
ELSE
RaiseError('No coupons available', false)
endif
]%%

Above code will allow you to send emails, even though no unclaimed rows are available. However, based on your statement: Because all costumers receive that email but not all have a coupon. You also need to add another level of logic to your email, as you need to claim rows only for recipients who are eligible to receive the code. So, if you assume a field Eligible on the sendable data extension, you can check this, an only claim if the recipient is eligible for the code.

If your recipient IS eligible, but you have run out of codes, you can use RaiseError to prevent the email from being sent. But all this depends of course on what type of business logic you want to implement.