Create your own price tags
Design Barcode price tags in easy way
In this tutorial we are going to design our own price tags to be deployed with our products.
We’ll start with a very basic label for in store use only and we’ll gradually move to a more complex design that will feature a connection to an underlying data source, containing data to be printed on labels.
1 – Choosing the right size
As always, the first step is to select or design the appropriate paper layout, based on the type of paper you’ll be printing on.
In this example we’ll be using the Devauzet 63P paper layout, which features 12 2.5 by 2.5 inch price labels on an A4 sheet.
2 – Choosing the barcode symbology
This is the tricky part, if you’ve never worked with barcodes you might be wondering where to start.
Basically there are 2 ways to go about this:
- PRIVATE USE: You need to have an in store only barcode symbol on your labels that will enable you to scan a serial number into your system, for warehouse use or whenever a customer wants to buy one of your products.
Your barcodes will have meaning only within your business and will be meaningless to the outside world.
In this case, you can use a Code 128 barcode symbol which will encode most alpha-numeric values, up to 255 characters. Obviously you need to have built some kind of digital infrastructure that manages product codes and is able to respond to a barcode scan, by showing you the type of product scanned and optionally increase a customer cart list, retrieve information on the product, such as the price, and so on.
- PUBLIC USE: Your products will be shipped to the outside world and the barcode symbol must uniquely identify your products throughout the entire world.
In this case you need to implement a UPC barcode (North America, UK, Australia and New Zealand) or an EAN 13 barcode (rest of the world). To be able to generate this kind of symbol, you first need to purchase a serial number from your local GS1 authority.
The serial number(s) you’ll purchase will contain a series of digits that will uniquely identify your products all over the world, and will contain additional information such as country ID, company ID and your own unique product codes. This serial number can be used in Labeljoy to generate the appropriate barcode symbol.
3 – Warehouse label
If you want to print a warehouse label that can be read by a barcode scanner within your business, then all you need to do is customize the 2 default elements found on the labels: a text element and a barcode element.
Double click on the Double click to edit text and enter a description of the item:
Click Ok to apply the changes:
Now let’s work on the Barcode.
Double click on it to bring up its editor. Choose the right symbology from the list and enter the serial number you want to encode in the symbol:
In this Warehouse label example we’ll just use the Code 128 symbology and encode a serial number that in our system corresponds to the article we’re printing labels for.
Click Ok to apply the changes.
We will move the 2 elements to center them horizontally and vertically and we’ll enter the amount of labels we need to print in the upper left text box.
The upper-left text box in the toolbox indicates the total number of labels you want to print, in this case 12 which is an entire sheet.
We are ready to print your in store warehouse labels.
4 – Price tag label
The above label works well for a behind the curtains scenario, for example in a warehouse where the labels are used to manage goods by company only personnel.
When the labels are seen by your customers as well, you might want to add some more information and make them a bit more appealing to the eye.
Let’s start by adding some more textual data to better describe the article.
Let’s copy and paste the text element to create a second copy of it.
Select it and use the Copy and Paste buttons found on the left toolbox:
Let’s double click on the newly created text and modify it by first changing the text to:
Let’s also reduce the font size and left align the text:
We’ll also change the caption of the larger text element by removing the “Size 12” line and by left aligning it.
We’ll move things around a bit to obtain something like this:
Now let’s add an image that will better convey the type of article being purchased.
Click on the Insert graphic button in the toolbox and draw a rectangle in the upper-right area. The default image is added:
Note: depending on the settings found in the Option window – Main tab – Show editor after item add, each time you add a new element, its properties window might automatically pop-up. If it doesn’t, just double click the newly added element to customize its appearance.
Open the editor form for the image and click on the Clipart button.
The Clipart selection form is displayed.
Select the Tools category and select the screwdriver image.
Click Ok to confirm and click Ok again in the image editor form to confirm the changes.
Move and resize the clipart to nicely fit it into the label and also move the barcode up a bit to make some room in the lower section.
Your price tag should now look something like this:
We’re now going to add a company logo and name in the lower part of the label.
First, add your logo by adding a new Graphic object. In the image editor window, click on the File button and browse your computer folders to locate your company logo image file.
Select it and click Ok:
Finally, let’s add your company name and additional information, using 2 center-aligned text elements with different font size and a grey color:
5 – Data linked price label tag
So far we have seen how to build static labels, labels that are replicated identical for each position throughout the entire sheet.
Most times though we’ll need to print similar labels displaying different contents, based on data stored in an external database, such as an Excel file, an Access file, an address list or a table or view of a professional database system.
For example, suppose that your hardware store needs to label each single item of a batch of hardware tools that was just shipped to you by one of your suppliers.
In a realistic scenario, we’d have this data stored somewhere in your system, for example an Excel file, and we’d want your labels to print data according to the contents of the Excel file. Also, we’d probably want to print as many labels as needed.
We’ll use the following Excel file as data source for the price tags:
This brief Excel 2007 file contains the following columns:
- Item code: the item code that uniquely identifies the article within your business.
- Quantity: the amount received for each article.
- Name: the main name of the article.
- Size: the size of the article.
- Description: a brief description of each article.
- Price: the article price.
- Image: the path and file name of the article image.
Let’s now use this data to print our customized price tags.
First we need to connect the Labeljoy file to this data file.
We’ll use the Data connection wizard feature to gather all the information Labeljoy needs to connect to the data source.
Let’s click on the appropriate toolbox button to start the data wizard:
In the first step we’ll be asked to define the type of data source we’ll be using, we’ll select The data is in a file or in the clipboard:
The second step we’ll ask us to define the type of file we’ll be using. We’ll select Excel:
Next we’ll be asked to define the type of Excel file we’ll be using. We’ll select the first option as we are working with an Excel 2007 file:
Next we’ll be asked to browse to the Excel file that contains the data. Click the Browse button and locate the Excel file that holds the data we want to connect to:
Now, skip the next 3 steps leaving all the default settings and stop at the Quantity step. As we saw earlier, the Excel file contains a column that holds the amount of items we need to print labels for. We’ll use that information to tell Labeljoy to generate the correct amount of labels for each article.
Select the Quantity field from the drop down:
Now let’s move through the next few steps until we get to the Data review screen. Here we can see the data that was loaded from the Excel file before it is actually connected to the labels:
Click Next to confirm and then Ok to exit the Wizard.
We have now successfully connected your data source to your labels.
All we have to do now is display this information on the price tags.
We’ll start by customizing the larger text in the upper-left section. We double click on it to display its editor window and we remove the current Screwdriver text.
In its place we’ll add a field from the underlying data source: the Name field.
Click the Field button and select Name:
Click Ok to confirm.
Note that the upper-left control used to enter label quantity is now disabled. It displays 33 which is the total number of labels generated with the current data source settings.
Also, after applying this first text change, the 9th position on the sheet now displays Club hammer. That is because as seen in the Excel source file, we have 8 screwdrivers and than 5 Club hammers.
Let’s now work on the smaller description text to incorporate data from the data source.
By replacing part of the existing text with fields from the data source, we ensure that each label will present the right data to be printed.
Let’s now connect the upper-right image to the Image field of the data source, so that each label will display the right tool image.
Double click on the screwdriver image, click the Field button and select the field Image as defined in the Excel file:
Click Ok to confirm.
At this point, your Labeljoy file should look something like this, in the first page:
All we have left now is adapt the barcode to the data source.
Double click on the barcode and remove the last 4 digits of the text. Then select the field Item code by clicking the Field button.
This way we’re telling Labeljoy to generate a barcode that will be made up of a static section followed by a dynamic 4-digit part:
Click Ok to confirm the changes.
The price tag is now complete. All you have to do now is print the labels using your standard ink-jet or laser printer and attach the labels on the articles.
Download this dynamic price tag file
Here’s page 2 and page 3 of the job: