Scenario


I have an Amazon B2B order in Linnworks with a Purchase Order Number and would like to display it on the shipping label.


Solution


The Purchase Order Number is saved as an Order Extended Property if the channel provides it. To send it to the Vendor, use Order Property mapping. Each vendor has its own field name for this, so check the correct one below. You only need to set the mapping once - after that, the value will be used automatically.


This article lists Vendors that support showing the Purchase Order Number on labels. It will be kept up-to-date as the feature will be added to more integrations.


Vendors that currently support it:

  • DHL Express
  • DPD UK and DPD Local
  • FedEx
  • UPS


DHL Express


In Shipping > Integrations > three dots > Properties, there is an Order Extended Property called Reference. You can link it to PurchaseOrderNumber to show it on the label:



DPD UK and DPD Local


In Shipping > Integrations > three dots > Properties, there is an Order Extended Property called LabelRefOrderEP. You can link it to PurchaseOrderNumber to show it on the label:



FedEx


In Shipping > Integrations > three dots > Properties, there is an Order Extended Property called CustomerReference. You can link it to PurchaseOrderNumber to show it on the label:



UPS


In Shipping > Integrations > three dots > Properties, there is an Order Extended Property called TransactionReference. You can link it to PurchaseOrderNumber to show it on the label:



Another workaround

If the field is in use or cannot be used for any other reason, you can use the Integrated Invoices option. When printing the invoice, the label will be printed with an extra element. Place this element in an empty area on the label; do not cover barcodes, addresses, tracking numbers, or other important information. Run a few test prints to find the best spot and then continue using this method.


How to add the required element on the label:

  1. Go to Settings > Template Designer, create an Invoice Template, and add a Label element.

  2. Use Labels and Variables to insert on the label.


  3. Then, double-click on the box that appears and add an Extended Property.


  4. Pick Property Type as Attribute and Property Name as PurchaseOrderNumber.


    Once this is done, hit OK to save changes.

    More details are available here.


You can use one Invoice Template for all Vendors, but since each Vendor's label layout is different, you will need to add multiple boxes in different spots. Each box should have a condition to show only for the correct courier.


For example, place a box in the empty space for Vendor, then double-click on it and add an If Statement under the Formula tab.



In our case, we will use Royal Mail and Evri Corporate as two Vendors for one Invoice Template.

The formula example for Royal Mail: EVAL{BEGIN}IIF[[{ShippingVendor}]="RoyalMail","PO:",""]{END} EVAL{BEGIN}IIF[[{ShippingVendor}]="RoyalMail",[{OEP.ATTRIBUTE.PURCHASEORDERNUMBER}],""]{END}


The formula example for Evri Corporate: EVAL{BEGIN}IIF[[{ShippingVendor}]="Evri Corporate","PO:",""]{END} EVAL{BEGIN}IIF[[{ShippingVendor}]="Evri Corporate",[{OEP.ATTRIBUTE.PURCHASEORDERNUMBER}],""]{END}


This is how it looks on the label:


There are two boxes, one for Royal Mail and one for Evri Corporate. After testing and printing, we found the empty spaces where the extra elements can go.


The formula checks which Vendor is on the Order, and only one box will show the details.


If the Vendor is Royal Mail:


If the Vendor is Evri Corporate:


As shown, only the box for the selected Vendor will display details. The others will stay blank.


If any questions or errors, feel free to contact Linnworks Technical Support!