Zebra Programming and Label Format

Overview

The format of the labels is controlled by the Label tab in the Excel Job Sheet for the Inventory Group this document is for people who wish to change the label format and may make it possible to change it for a different printer.

The language used is called ZPL-II and the manual can be found in Zebra Programming Guide

The command text is sent as a single string to the printer although the spreadsheet shows multiple columns, this is for documentation purposes.

Barcode labels are 16 digits long

On this page:

The Commands Used

Zebra Stripe Printer (8 dot/mm)

CommandDescription

Setup the print initialisation details
^XAstart format
^PRx,xprint rate x"/sec (default is 2"/sec) C=4";D=6";E=8"
^MDxmedia darkness (-30 to +30) <-- head temperature
^POIprint orientation invert 180
^LL643label length 643 dots (not quite accurate!)
^LHx,ylabel home (after invert)
^XBSuppress backfeed (note that this instruction should be removed from the last label in the print run)
^FSfield separator
^XZend format

Add the print line details
^XAstart format
^FOx,yfield origin (top left of box)
^FTx,yfield textline base (lower left of text)
^A0r,h,wscalable alphanumeric font rotation,height,width
^CInnchange internat font 0=USA, 13=codepage850
^FBw,l,s,j,mformat block: width,lines,line spacing -9999 to +9999, justify,2nd line margin
^FDmy dataformat data (data to print)
^FSfield separator
^BYi,j,bbarcode defaults narrow width 1-10, wide ratio 2.0-3.0, height
^B2a,b,f,g,ebarcode interleave 2 of 5: rotation,height,interpretation line,above barcode,add mod10 check digit
^SNn,i,zserialisation data: startno (rhs max 12 digits),inc/dec value,add leading zeros, this is impacted by the ^PQr funtion and can impact the order line number
^PQq,p,r,oprint quantity: total labels,pause count,copies,override pause 
^XZend format

Sample Label Data

HeaderBarcode (usually 16 digits)Order DateOrder No/Revision/LineNoCustomer NameOrder RefProductLocationDimensionsPrint QtyEnd Format
^XA^LH0,0^PRB,D^MD20^JMA^FS^BY2,2.7,13^FO506,20^B2N,132,Y,N,N^SN0016455660010011,N,Y^FS^FO20,20^A0N,28,37^CI13^FD23/5/2014^FS^FO220,20^A0N,41,48^CI13^FD1004047A/002^FS^FO20,55^A0N,30,30^CI13^FDTest123^FS^FO20,95^A0N,30,30^CI13^FDtest^FS^FO20,135^A0N,30,30^CI13^FDPanel Glide Betta 5Th Avenue Blockout Avocado^FS^FO20,175^A0N,30,30^CI13^FDLounge^FS^FO300,175^A0N,30,30^CI13^FDW:2000 H:2100^PQ1,0,1,Y^XZ
Labels Tab Formulas (Can be used to return to original (standard) layout)These are the Excel formulas that produce the line above once the Data tab is loaded.








=IF(OR(Data!$AV11="",Data!$AW11>999),"","^XA^LH0,0^PRB,D^MD20^JMA^FS")

=IF(A11<>"","^BY2,2.7,13^FO506,20^B2N,132,Y,N,N^SN"&BarcodeValue(Data!BC$5,Data!BD$5,Data!AW11,1)&",N,Y^FS","")

OLD=IF(A11<>"","^BY2,2.7,13^FO506,20^B2N,132,Y,N,N^FD"&BarcodeValue(Data!BC$5,Data!BD$5,Data!AW11,1)&"^FS","")

=IF(A11<>"","^FO20,20^A0N,28,37^CI13^FD"&TEXT(Data!AZ$5,"d/m/yyyy")&"^FS","")=IF(A11<>"","^FO220,20^A0N,41,48^CI13^FD"&Data!$BC$5&Data!$BD$5&"/"&RIGHT("000"&Data!AW11,3)&"^FS","")=IF(A11<>"","^FO20,55^A0N,30,30^CI13^FD"&Data!$BF$5&"^FS","")=IF(A11<>"","^FO20,95^A0N,30,30^CI13^FD"&Data!AX$5&"^FS","")=IF(A11<>"","^FO20,135^A0N,30,30^CI13^FD"&Data!BE11&"^FS","")=IF(A11<>"","^FO20,175^A0N,30,30^CI13^FD"&Data!AY11&"^FS","")=IF(A11<>"","^FO300,175^A0N,30,30^CI13^FD"&"W:"&Data!BA11&" H:"&Data!BB11,"")

=IF(A11<>"","^PQ"&Data!AZ11&",0,0,Y","")

or 

=IF(A11<>"","^PQ1,0,1,Y","") (to print multiple labels in the order line sequence)

or

=IF(A11<>"","^PQ1,0,"&Data!$F$14&",Y","")

(to print multiple labels)


=IF(A11<>"","^XZ","")

BarcodeValue handles 12 digits so the Serialization can then add the next 4 digits to make a total of 16 digits.
An order number with 5 digits gets 2 digits added to make a total of 7 digits so any order number up to 7 digits will be correct.
Barcode is made up of
ordernumber -> 7 digits | ordernumber suffix -> 2 digit ASCII character | orderline number -> 3 digits | Serialized number -> 4 digits (based on the previous 12 digits).








For multiple labels the data settings also need to be updated. For more information on how to print multiple labels click here.



Notes

There can be issues with labels printing for orders with multiple quantities on 1 order line due to the to the zpl-II ^SN function (serializing the data) and the PQ r function then adding the next digit making the 13th 14th & 15th digits 002.

The 002 doesn't match the order line number and therefore will not scan in Job Tracking or Dispatch Tracking as BUZ doesn't recognise the barcode.

Open the order and expand the lines refer to Expand Order Lines for further help

Label Specification

Size:  100mm x 25mm existing

Description: White thermal transfer printer labels (requires ink ribbon)

Adhesive: Removable

Printer model: Zebra ZT230 or S4M

Qty per roll: 3500

(supplied as 2 rolls of labels and 1 roll of 110mm x 300 metre ribbon)

Recommended Supplier:

  1. Pos Supply

    T (07) 3885 8028 | F (07) 3054 6610
    W www.possupply.com.au

    E orders@possupply.com.au

2. Randall Bayfield
LLADNAR PRINTING SYSTEMS
PH: 02 9620 5366
Fax: 02 9620 5377
Mob: 0419 664 971
Unit 26/14-16 Stanton Road
Seven Hills NSW 2147

Email: lladps@bigpond.net.au
Website: www.labelprintingmachines.com.au


Scanner Setup LI4278 (Pos Supply)

This document takes you through the setup of your LI4278 scanner for use of BUZ Programming Barcode_LI4278_ITF_POS_supply.pdf