How to show your SKU on your Royal Mail Courier Labels.

How to show your SKU on your Royal Mail Courier Labels.

1. Go to the menu option Courier, Courier setup, Setup Couriers, Click and Drop

2. Paste the following SQL into the Notes field

#!#SELECT TOP 1 TOrderLine.sSKU+' -'+Trim(Str(TOrderLine.nQty))+IIf(TOrder.nTotalLines>1,'- CHECK', '') FROM TOrder INNER JOIN TOrderLine ON TOrder.nOrderSeq = TOrderLine.nOrderSeq WHERE TOrder.nOrderSeq=[%ORD_ID%]#!#

This will show the first SKU and quantity if there is more than one item on the order this will show check.