咨询修改Linnworks邮件收据代码:匹配以XYZ开头的SKU生成链接
Adjust Linnworks EVAL Code for SKU Starting with "XYZ"
Got it! Since you want to target any SKU that starts with "XYZ" (followed by any numbers) instead of an exact match, you can tweak your existing Linnworks EVAL code using the LEFT function to check the first 3 characters of the SKU.
Here's the updated code:
EVAL{BEGIN}IIF[LEFT["[{ORDERITEMS.SKU}]",3]="XYZ", "Click here for <a href='HTTP://LINK'> guide</a>", ""]{END}
Breakdown of the change:
LEFT["[{ORDERITEMS.SKU}]",3]: This part grabs the first 3 characters from the order item's SKU.- We compare this 3-character substring to
"XYZ"— if they match, the link is inserted into the email receipt; if not, it returns an empty string just like your original code did for non-matching SKUs.
If you ever need to target a longer prefix (like "XYZA" instead of "XYZ"), just adjust the number 3 in the LEFT function to the length of your desired prefix (e.g., 4 for "XYZA").
内容的提问来源于stack exchange,提问作者Alan BTS
相关产品推荐
相关产品推荐

