Create your own price tags Easily design Barcode price tags In this tutorial you will learn how to design your own price tags of your products. Starting with a very basic label price tag designer in store use only, and then gradually moving to a more complex design that will feature a connection to an underlying data source, which contains the data to be printed on the labels. In this example we use the Devauzet 63P paper layout, featuring 12 2. Price tag designer barcodes will only have a meaning within your business and will be meaningless elsewhere. In this case, you can use a Code 128 barcode symbol that encodes most alphanumeric values up to 255 characters. To generate these types of symbols, you first have to purchase a serial number from your local authority. This serial number can be used in Labeljoy to generate the corresponding barcode symbol. Select the correct symbology from the list and price tag designer the serial number that you want to encode in the symbol: In this example of a Warehouse label, we use the Code 128 symbology and encode a serial number from our system that corresponds to the article for which the label is being created. Move the two elements to center them horizontally and vertically and enter the number of labels to be printed in the upper left text box. The upper-left text box in the toolbox displays the total number of labels to be printed. In this case 12, which is an entire sheet. The warehouse labels are ready to print. If the labels are also seen by customers, you might want to add additional information to make the labels visually more appealing. Add some text to describe the article. Move the items until you get the following result: Add an image to better describe the article in question. Click the Insert Graphic button in the toolbox and draw a rectangle in the upper right area. The default image will be inserted: Note: Depending on the settings in the Option window of the Main tab — Show editor after Item added, each time you add a new item, the property window automatically pops up. If not, just double-click on the newly added item to customize its appearance. Open the image editor and click on the Clipart button. The clipart selection will be displayed. Select the Tools category and select the image of the screwdriver. Move and scale the clipart to fit it on the label and move the barcode slightly up to make some room in the lower area. Your price tag should now look like this: Now add a company logo and a company name in the lower part of the label. First add your logo by inserting a new Graphic element. In the image editing window, click the File button and select your company logo from the corresponding folder on your computer. Most times however, you will 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, a spreadsheet or a professional database system. For example, suppose that your hardware store has to print labels for each item in a large supply of tools that have just been delivered by a supplier. In a realistic scenario, this data would be stored somewhere in the system, for example in an Excel file, and the labels should reflect the data according to the contents of the Excel file. In addition, you only want to print as many labels as items supplied. Use this data to print the individual price tags. First, the Labeljoy file needs to be linked to this file. We use the Data Connection Wizard to gather all the information Labeljoy needs to connect to the data source. Click the appropriate Toolbox button to start the wizard: In the first step you will be asked to define the type of data source you are using. The data is in a file or in the clipboard: The second step is to specify the file type to use. Select Excel: Next you will be asked for the type of Excel you are using. Select the first option as we are working with an Excel 2007 file: In the following the path of the Excel file containing the data has to be specified. Click on Browse and select the Excel file containing the data to be connected: Skip the next 3 steps leaving all the default settings and stop at Quantity. As seen earlier, the Excel file contains a column with the number of articles we need to print labels for. That information will be used to tell Labeljoy to generate the correct number of labels for each article. Select Quantity from the drop down menu: Now proceed through the next steps until you arrive at the Data review screen. Here you can see the data loaded from the Excel file, before actually linking it to the fields: Click Next to confirm and then Ok to exit the wizard. The Data source has now successfully been connected to your labels. Now this information has to be displayed on the price tags. Start by adjusting the price tag designer text in the top left section. Double-click the text to display the editor and delete the text of the screwdriver, which is still there. In its place we will insert a field from the external data source: the Name field. Click the Field button and price tag designer Name: Click Ok to confirm. Note that the top-left control for entering the label quantity is now disabled. Instead the number 33 which is the total number of labels generated with the current data source settings. After applying the first text change, the ninth position on the sheet now displays hammer. That is because according to the excel file there are 8 screwdrivers and 5 hammers. Now edit the smaller description texts in order to incorporate the data from the data source. By replacing part of the existing text with fields from the data source, you ensure that each label contains the correct data to be printed. Now connect the top right image with the Image field from the data source so that each label displays the correct image. Double-click the image of the screwdriver, click the Field button and select the Image that is defined in the Excel file: Click Ok price tag designer confirm. At this point, the first page of your Labeljoy file should look something like this: Now the barcode has to be adapted 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. The price tag is now ready for printing with your standard laser or inkjet printer. Here you can see pages 2 and 3 of the job:.
