QuickBooks

Printing QuickBooks Barcode Labels with WaspLabeler +2D

Written by Charlie Russell

I haven’t written much about barcode labeling and QuickBooks so far, but I think that this is going to be an important topic of discussion as we move forward. So, today, let’s talk about printing barcode labels using the WaspLabeler +2D product from Wasp Barcode Technologies.

From a very simplistic point of view there are two aspects to working with barcodes:

  • Printing your data (such as from QuickBooks) in a barcode format (in a report, or on labels).
  • Scanning the barcode data to enter it in a program or database.

Today I’m going to focus on the printing barcodes from your QuickBooks data.

In relation to QuickBooks, we want to print data that we have in our QuickBooks database. Scanning, however, might not be restricted to just QuickBooks. For example, you might be printing barcodes to put on shipping labels needed by your customer, or product labels on the boxes that you ship.

A Very Quick Overview of Barcodes.

So you want to use barcodes in your business? Or clients come to you and say that they need to use barcodes in their business? Let’s take a quick look at barcode printing technology to give you a starting point. This article isn’t a tutorial on barcodes – that would take many, many articles to cover.

How Will You Use The Barcodes?

That should always be the first question. How will you be using barcodes?

You may have a requirement to print barcodes in a particular format for your customer, such as on a shipping label or labels for the items themselves. Many larger companies have specific requirements as to the content, arrangement and type of barcode that you use.

You may want to print barcodes for tracking items as they move through your warehouse or manufacturing facility.

Perhaps you have a Point of Sale system that would work more efficiently if you can scan barcodes when you sell items.

Don’t worry about how to print barcodes until you determine what your need is, and what requirements you have for the barcodes you want to print. What is the task you are trying to accomplish?

What Barcode Symbology Will You Use?

Barcodes can take many different forms, and each form may have a variety of options. The collection of rules for creating a barcode is referred to as the “Symbology”. Some barcodes allow only numeric characters. Others allow upper and lower case letters, numbers and special symbols. Some have built in error checking features, some are simple. Some are better than others at providing detailed information in a small amount of space.

Here are a few common samples (there are many more than I’m showing here). In some samples the actual text value will print below the barcode.

Code 39

Code 39 is a very commonly used and simple barcode. It has variations that will allow you to use upper/lower case letters, numbers and special symbols.

 

Code 128

Code 128 is used widely in inventory control and shipping situations. It has similar characteristics as Code 39 but can create slightly more compressed barcodes.

 

UPC-A

UPC-A is one of several similar barcodes used in retail environments. There are several variations, and some similar barcodes that would be used if you are working with the European community.

 

 

 

Postnet

Postnet is used for USPS mailing applications.

 

 

QR Code

QR Codes are a relatively new symbology, used extensively in advertising to provide web site URL’s to smartphone and tablet users. This is a “two dimensional” code used to convey a large amount of information in a small space.

 

 

The choice of the symbology you will use depends on the requirements of the person who will do the scanning, the type of application you will be using, and the content of the information you will be including in the barcode. Your customer may specify a particular symbology to use. Some kinds of barcodes can’t accommodate certain kinds of data, such as lower case letters or symbols. Length of information is important – you wouldn’t use Code 39 to hold long web site URLs.

Another requirement to consider is what type of scanning hardware will be used. You’ll often find that scanners can only work with certain barcode symbologies, so you need to understand the hardware requirements as well.

Printing Barcodes with WaspLabeler +2D

The WaspLabeler +2D product from Wasp Barcode Technologies is a very flexible, low cost and simple to use barcode printing program. It works reasonably well with QuickBooks and provides many of the features that you would need to print barcode labels.

Installation of the program was very simple. One note – after installing I recommend that you click on the Check for Updates icon in the File menu bar, as you will need the latest version if you want to work with QuickBooks. I used version 7.0.2 in my tests, the earlier version that I was given originally didn’t handle QuickBooks data properly.

There are four tabs in the program that you will use to create an manage your barcode labels:

Wasp Labeler Tabs

  • File is used to manage the label file itself. Check for Updates is an important feature, particularly after you initially install the program. Example Templates has a number of different preformatted labels that you may find useful as a starting point.
  • Design is a WYSIWYG label designer that I found to be very easy to use. You’ll add your fields and set their properties.
  • Data is used to connect the label to a database.
  • Print is where you will (big surprise!) print the labels.

Designing a Label

Clicking on the Example Templates button in the File tab opens a list of preformatted labels that you can work with. There are a number of labels already prepared for working with QuickBooks data, such as the shipping label shown here.

QuickBooks Shipping Label

The Design tab provides a reasonable number of options for adding elements to the label. You can add text, graphic figures, imported pictures and (of course) barcode fields.

Design Tab

If you aren’t starting with one of the built in formats one of the first things you should do is to click on the Layout icon in this tab. This allows you to specify the dimensions of the label. There are formats already set up for a variety of labels (a long list of standard Avery labels for example).

Label layout

When you drag a barcode field onto the form you see the properties on the right side. There are three tabs in the properties pane. The barcode tab is where you can select the barcode symbology to use. The properties will vary depending on the symbology. For example, with Code 39 as shown here, you can control if there is a check digit.

barcode properties

Connecting to Data

On the Data tab you will select the database to connect to the label form. Note that you do not HAVE to connect to a database, you can use this program to design a “static” label that has the same information on all copies (such as printing return address labels).

Wasp Labeler Data Sources

The program has an excellent range of choices for data sources, not limited to just QuickBooks.

If you select QuickBooks as a data source you want to have the QuickBooks company file open with the Admin password, the first time that you use this program with a company file. QuickBooks will display a security screen asking if it is OK for the program to access the data (this is true for all SDK based add-on programs).

When I first saw the list of QuickBooks tables that the program can work with I was dismayed. It’s a short list! And the Item List isn’t included!

QuickBooks tables

However, they do provide access to much more data than what is shown here. I have no idea why this particular screen shows so few tables (an earlier version listed more, but that version didn’t work properly).

The program now displays the data, with a dropdown for the table at the upper left, and a list of the fields you can work with on the right.

QuickBooks item data

The tables that are supported are: Account, Bill, Check, Credit Memo, Customer, Customer Bill Address, Customer Ship Address, Customer Type, Employee, Estimate, Invoice, Item List (split into different tables by type), Job Type, Line Item, Line Item Group, Other Name, Payment Method, Payroll Item Wage, Purchase Order, Sales Receipt, Sales Rep, Sales Tax Code, Ship Method, Vendor, Vendor Address, Vendor Credit, Vendor Type.

There are a couple of shortcomings here. I didn’t do a comprehensive review, but some fields and tables are missing. Two important examples would be the manufacturer’s part number in the Inventory Part table (very important in some cases) and the lack of custom fields. I can understand why custom fields aren’t there, because they are handled in a very odd way in QuickBooks. However, not having them for the item list is a serious drawback for some people.

I didn’t explore the ODBC data source – if you have Enterprise you have access to two QuickBooks ODBC data sources, and that would let you get to more data (you can purchase an ODBD driver if you are using Pro or Premier).

To connect your barcode field to a data source field you go back to the Design tab and click Content in the properties window. Click the database button and select the field from the dropdown list.

Connecting the data source to the barcode

The field names they provide here are straight from the QuickBooks SDK. Do you understand the difference between the Name and FullName fields? It can be a bit confusing (Name is the lowest level name, FullName includes the higher levels if this is a subitem of another item).

The Data tab has some sophisticated tools for sorting, filtering, and creating “joins” between data tables (a more complicated process).

Printing Labels

Go to the Print tab to see a preview of the label on the page, and to print it. This preview will include the data from your data source. Oops! “Invalid barcode value”?

Print Preview

This highlights one of the issues you have when selecting a barcode symbology to match the data you are printing. I selected Code 39, but I didn’t check the extended box, which allows for lower case letters. My fault! Once I select the proper options, my barcodes appear.

Here’s what the QuickBooks Item Label sample template looks like, using Code 128 and the item Name field

QuickBooks Item Label

Technical Support

I did run into a problem with the program at the beginning of my test, and I submitted a support request via their website. I received an answer (which solved the problem) via email within just an hour of submitting my request. Very good!

Their website states that they provide free, unlimited tech support.

Technical Details

The product supports a wide variety of barcodes (including several 2D barcodes), including AztecCode, Codabar, Code 128, Code 39, Code 93, DataMatrix, EanJan13, EanJan8, Interleaved2of5, Isbn, Itf14, MaxiCode, MicroPDF417, MicroQRCode, Msi, PDF417, Postnet, QRCode, GS1, GS1Stacked, GS1Omnidirectional, GS1Truncated, GS1Expanded, GS1Limited, UCCEAN128, UPC-A, UPC-E, DataMatrix, MaxiCode, MicroPDF, MicroQRCode, PDF417, Aztec Code and QRCode.

You don’t need a special barcode printer, it supports any laser, dot matrix, thermal or ink jet printer that uses a standard Windows printer driver.

It works with QuickBooks Windows Desktop products from 2008 and later. This is a QuickBooks SDK based product. I didn’t see any information on non-US version support, but I would expect that it would work with most current versions (but try it first). A demo/trial copy is available through their website.

At this time pricing is a low $149.00 for a single user license, with options for a 5 user, 10 user and unlimited user license.

I Like It!

For the price, this is a great barcode labeling product:

  • Easy to use designer.
  • Flexible layouts for label format.
  • Lots of barcode symbologies.
  • Good technical support (based on my one incident).
  • Access to many QuickBooks tables.
  • Support for a variety of data sources.

It isn’t perfect:

  • It doesn’t support ALL fields that are available from QuickBooks.
  • Field names can be a bit cryptic.
  • It has just the basic tables, no “generated” tables that combine tables. For instance, if you want labels for the lines of an invoice, along with information from the invoice header, you have to create your own “join” for the tables. This can be tricky in some cases. You can do it, but it might not be simple

If you need to print barcodes from QuickBooks data this is worth looking at. However, you need to define what exactly you want to print first, so that you can try the trial product to determine if it can do what you want.


Save pagePDF pageEmail pagePrint page

About the author

Charlie Russell

Charlie Russell has been involved with the small business software industry since the mid 70's, and remembers releasing his first commercial accounting software product when you had an 8-bit microcomputer with one 8 inch floppy disk drive. He has a special interest in inventory and manufacturing software for small businesses. Charlie is a Certified Advanced QuickBooks ProAdvisor with additional certifications for QuickBooks Online and QuickBooks Enterprise, as well as being a Xero Certified Partner. Charlie started blogging about QuickBooks in 2008 (Practical QuickBooks) and has been the managing editor and primary writer for the Accountex Report (formerly the Sleeter Report) since 2011. Charlie can be reached at [email protected]

Visit his CCRSoftware web site for information about his QuickBooks add-on products. He is also the author of the California Wildflower Hikes blog.

13 Comments

  • I really appreciated your “Printing QuickBooks Barcode Labels with WaspLabeler +2D” article. We’re a small tea importer/wholesaler out of Portland (OR) and have been using QB since our business’s inception. We’re now at the point of needing a bar (or QR – haven’t figured out which yet) generation and printing system for inventory control. I haven’t sussed it all out yet, but your article helped. I’m still trying to find a way to create a unique bar code for each ingredient we bring in, then another unique bar code for every blend we’re creating from multiple ingredients, THEN a way to scan that directly into QB Premier Manuf & Whsl, vs. the data entry we have to do now. I’ll start by investigating WASP. Thanks again!

    • Chuck, if you enter “barcode” in the search box at the top right of this page, you will see that we have several articles on the subject. Take a look at the articles about “SmartScan” – several reviews of data entry products by Baus Systems that use barcodes very effectively.

  • Russell, We have a label requirement to use information taken from a sales order to show what is contained in a carton being shipped to, customer PO, item, item description. These labels are needed prior to generating an invoice so we can box items as they are completed and then invoice for the total order when ready to ship. I purchased Wasplabeler but found the data
    file list is not much more than what you show and does not include sales orders as a choice. Any suggestions? Thank you.

      • charlie,
        I also have a need to print labels that use information from the QB sales order for data. I’m getting ready to move to Enterprise from Premiere and am trying to identify software for this. We use several zebra printers so I’d like to use something that works with the zebra line of pruners.
        Thanks,
        Jerry

  • This is actually an incredibly powerful program. It’s shortcomings are minimal – and the latest version (7.1) supports custom fields from the Items record. It works great with the Zebra LP 2824.

    The bar code printing program with QB Enterprise Advanced Inventory is extremely limited, almost useless.

    This is a great add on and well worth the $149.

    • Did you figure out how to print the existing bar codes from QuickBooks through Wasp Labeler? It works fine to print Barcodes that it generates, but I can’t get it to register the bar codes that I already have for my QB Enterprise. Thank you!

      • You’ll have to talk to Wasp about that. Until recently, Intuit didn’t make that “barcode number” field available to developers. Relatively recently, Intuit updated their programming interface to make the field available, so programs can be updated to incorporate that feature. This isn’t, however, a simple task. Moving up to a new version of Intuits SDK can be complicated – because Intuit introduced new bugs that created problems for SOME applications. Even if those new bugs don’t cause problems for you, there is still the task of incorporating the new features, updating your software, testing it, and more. I don’t know if Wasp is looking to do this. It doesn’t just come to you automatically.

        There is one labeling program that is being tested that has the ability to print from that field, but it is very different than the Wasp product. If you are interested in finding out about this, contact me at the email address in my author bio.

  • Although the solution above “gets the job done” the solution shown below does the same thing with about half as many steps. A few things that I see that are not easy are: QuickBooks users like to be able to keep it simple and enter an Invoice number or Packing slip number and just press “print” ( one click) and have the system print out labels for the entire order. The label connector product at the link below pulls up the invoice data much the same way that QuickBooks presents this so that users can already be familiar with the data because it looks like QuicKBooks. We have also found that the multiples of labels to be printed for each line item, and the qty to show on the label may be special to their business. We have prepared an ability to users to use “factors” of the total item quantity. if the order quantity is “10” then maybe they only want 2 labels each with qty “5” on the label for example. Label connector can also be used to query data from web services on the internet anywhere. Maybe it is worth a look? Lastly the Label connector is integrated with “bartender labeling software” which is a much more comprehensive product for more advanced label designs. We find that QuickBooks users ( especially QuickBooks enterprise users) have label requirements that can sometimes be a bit complex because of the somewhat advanced systems being used by their customers for scanning the labels upon receipt of the product. Wasp is low cost. But not everyone wants low end solution. Many QuickBooks customers are shipping Millions of dollars worth of product to some of their customers.

  • Charlie,
    when do you think QuickBooks will give in and start to refer QuickBooks enterprise users over to Companies like Accuware to get the much needed help that they require? ( with Add ons) It has been a few years now since they shut down the marketplace for Desktop add on’s , and yet Intuit is still no where close to replacing Enterprise functionality into QBO. Is there someone at QB support that Accuware could speak to about making our solution available when users need more powerful Labeling solutions.
    By the way , I always enjoy your helpful articles. I just read another one today about Assembly items vs. Group type items so I could aid one of our many growing QB customers in learning how to manage their success and use of QuickBooks. Most users find us off the internet and the first thing they say is “why does QuickBooks make it so hard to find guys like Accuware?”

Leave a Comment