You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

咨询修改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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.05.15 03:46:01