Zebra Programming and Label Format
- Daryl Saunders (Unlicensed)
- Allison Derome (Unlicensed)
- Alana Arnold (Unlicensed)
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)
| Command | Description |
|---|---|
| Setup the print initialisation details | |
| ^XA | start format |
| ^PRx,x | print rate x"/sec (default is 2"/sec) C=4";D=6";E=8" |
| ^MDx | media darkness (-30 to +30) <-- head temperature |
| ^POI | print orientation invert 180 |
| ^LL643 | label length 643 dots (not quite accurate!) |
| ^LHx,y | label home (after invert) |
| ^XB | Suppress backfeed (note that this instruction should be removed from the last label in the print run) |
| ^FS | field separator |
| ^XZ | end format |
| Add the print line details | |
| ^XA | start format |
| ^FOx,y | field origin (top left of box) |
| ^FTx,y | field textline base (lower left of text) |
| ^A0r,h,w | scalable alphanumeric font rotation,height,width |
| ^CInn | change internat font 0=USA, 13=codepage850 |
| ^FBw,l,s,j,m | format block: width,lines,line spacing -9999 to +9999, justify,2nd line margin |
| ^FDmy data | format data (data to print) |
| ^FS | field separator |
| ^BYi,j,b | barcode defaults narrow width 1-10, wide ratio 2.0-3.0, height |
| ^B2a,b,f,g,e | barcode interleave 2 of 5: rotation,height,interpretation line,above barcode,add mod10 check digit |
| ^SNn,i,z | serialisation 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,o | print quantity: total labels,pause count,copies,override pause |
| ^XZ | end format |
Sample Label Data
| Header | Barcode (usually 16 digits) | Order Date | Order No/Revision/LineNo | Customer Name | Order Ref | Product | Location | Dimensions | Print Qty | End 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. | 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:
- Pos Supply
T (07) 3885 8028 | F (07) 3054 6610
W www.possupply.com.auE 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