Barcode

Barcoding using a Dymo printer, as described here, is the strongly recommended approach.

One of the most valuable features of CellarTracker is the ability to print individual barcode labels for each bottle in your cellar. Using these barcodes, you can easily and accurately record consumed bottles as well as exercise the ability to batch update location and bin with the assistance of a barcode scanner. You can also add wine to your cellar by scanning an Existing UPC.

Using Labels

There are three screens where CellarTracker barcodes can be used:

As mentioned above, you can also add wine to your cellar by scanning an Existing UPC.

There are three types of labels:

  1. Unique per-bottle barcodes. This is what is pictured on this page.
  2. Per-wine/size barcodes. You can optionally generate these. They are less specific than the prior labels. If you have 7 x 750ml bottles of the same wine, you will have 7 different per-bottle barcodes. However, you will have only 1 per-wine barcode (which you would print out 7 times in concept). Please note that these are NOT supported on the dual-barcode labels and in fact ONLY print on the 30336 label template.
  3. You can also generate barcodes for your storage locations and bins. This allows you to scan bottles. You can then relocate these bottles by scanning a location or bin.

Generating Labels with a Dymo Printer

The strongly preferred barcode printing solution is to use a Dymo printer, as this offers the most automated and easiest solution.

Recommended Equipment

NOTE: The Dymo labels currently use Interleaved 2 of 5 (ITF) as the barcode format for single-bottle labels and Code 128 Auto for per-wine labels, so make sure any barcode scanner you plan to use supports this symbology and it is currently enabled in the scanner.
People using Socket barcode scanners also need to enable support for scanning ANY LENGTH of ITF barcode. That can be done with PDF configuration file here. Just scan the proper barcode. Mac users of OSX with CipherLab scanners need to configure their scanner to 'Transmit By Character' with this PDF configuration file.

Installation

Installation for Windows Users - Automated install troubleshooter - Troubleshooting guide

  1. Install the latest DYMO software for Windows. (Download: v8.5.3)
  2. As of December 17, 2015, we no longer support the legacy DYMO software (anything prior to v8.3).

Installation for Macintosh Users - Automated install troubleshooter - Troubleshooting guide

  1. Install the latest DYMO software for Mac. (Download: v8.5.2)
  2. You MUST RESTART YOUR MACINTOSH after you install the Dymo software.


Usage Instructions

  1. Go to CellarTracker and from the QUICK LINKS menu (under the search box), select the PRINT LISTS AND LABELS option. Or, navigate to the barcode labels view and click PRINT.
  2. With the Print dialog open, make sure the BARCODE LABELS tab is selected. This will give you a preview of the labels tagged to be printed, and allow you to specify your desired label options. NOTE: if the Dymo printer option is greyed out, then there is a problem with your Dymo installation. Please try the troubleshooter to diagnose the problem.
  3. To take things in smaller bite-sized chunks you may want to do 100 at a time. Fill out the QUANTITY box with the number of labels you'd like to print at a time (NOTE: this is not the quantity of EACH label, but rather the total quantity of labels to print). Then, click PRINT to commit the print job.
  4. If you'd like to print a different set of labels than what is displayed, click the Customize in Label View link in the print dialog. From there, you can apply various filters to get the list of wines you'd like to print. You can also use the checkboxes to select individual labels to print.
  5. Once you are caught up, the label printing user interface, by default, will only show you bottles for which you haven't yet printed labels. You can however toggle to show all labels.
  6. By default, the print dialog will attempt to preview all unprinted labels. However, if you launch the print dialog from any Wine Detail page, we will attempt to print labels for ALL bottles of that wine. Additionally, in most bottle views, you can use the checkboxes to select bottles and click PRINT to just print labels for those bottles.

Instructions for CLASSIC site

  1. Go to CellarTracker! and click on Print barcode labels in the Actions section of the navigation bar.
  2. Press the PRINT USING DYMO button. This will give you a preview.
  3. To take things in smaller bite-sized chunks you may want to do 100 at a time. Fill out the "Show # of labels" edit control on that first page of pending labels. Press the PRINT USING DYMO button to commit the print job.
  4. Once you are caught up, the label printing user interface, by default, will only show you bottles for which you haven't yet printed labels. You can however toggle to show all labels.


Label Customization

The site allows you to control many aspects of the information that will appear on the labels, so make sure to click on the link to Change Label Settings. More adventurous users can also modify the label templates that are loaded by the Dymo software as described here.

Generating Avery Labels with a Regular Printer

The preferred solution is to use a Dymo printer, as this offers the most automated and easiest solution. However, if you do not own a Dymo, you can also export data from the site to be used for a Microsoft Word mail merge to comparable Avery labels using the site, but this is ONLY recommended for those users who are quite technical.