You can print the barcodes for any Purchase Option or product in your business from the Inventory on Hand Report.

Staff members can use a printed sheet of barcodes at the point of sale to quickly access and scan barcodes for items instead of scanning the barcode on the item during checkout.

Getting Started

To print a barcode label, you must complete the following steps:

Create a barcode label design using the DYMO Label v.8 software.
Export the Inventory on Hand Report from WellnessLiving as either a .csv or Excel file.
Import the file into the DYMO Label v.8 software and print your barcode labels.

Requirements

A DYMO® 550 Turbo
Microsoft Excel or a compatible spreadsheet application
DYMO Label v.8 software

Key tips

You may need to search your computer for the DYMO Label v.8 software. Look for the DYMO icon.
WellnessLiving isn’t responsible for any changes to the DYMO Label v.8 software and for any resulting discrepancies in these instructions.
Shorten the name of the exported report and/or shorten the number of digits assigned to barcodes in the barcode column of the report as much as possible. This keeps things organized and prevents errors in the DYMO software.
The barcode printer only prints in black and white. Any color you have set up in your design won’t be printed in color.

Create a barcode label design

To create a barcode label design:

Open the DYMO Label v.8 software.
Click the Labels tab on the left side of the screen, click Shelving 25mm x 89mm, and then select the blank label.

3. Click the Insert tab then drag and drop Barcode to the blank design.

4. Double click the inserted barcode.

5. In the popup window, select Code 128 Auto from the Barcode type list, and then click OK.

6. On the side menu, under the Insert tab, drag and drop text boxes onto the barcode design for each value you want to include on the printed barcode, such as Product Name, Cost, or Location.

7. On the Insert side menu, under Clip Art, scroll down to find your currency symbol.

8. Drag and drop the currency symbol onto the barcode design next to the text field that will contain the price of the item.

9. On the top menu, click File, select Save As, and enter a name for your barcode label design. You will be able to open the design any time you need to print new barcode labels.

Export the Inventory on Hand report

To export the Inventory on Hand Report:

Open the App Drawer then click View All > Reports > Sales > Inventory on Hand.
Click Export and select the file format to which you want to export the report. Both .csv and Excel file formats can be imported to the DYMO Label software.
Save this document in an easily accessible location.

Print a barcode label

To print a barcode label:

Open the DYMO Label v.8 software. At this stage, please ensure that your DYMO printer is connected to your computer.
On the top menu, click Open, and select your saved barcode label design.
On the top menu, click File, select Import Data and Print, and then select New.
On the Select Data File and Label Layout page, click Browse, select your exported Inventory On Hand Report file, then click Next.
On the Arrange Data Fields on the Label Layout page, under Data fields, select the Use first row as field names checkbox.
Drag and drop each data field you want displayed on the label into the appropriate box on the label design.
If you are using Windows, delete the small blue dot at the end of each data field and click Next.
On the Select Data to Print page, select the checkbox next to each barcode you want to print.
Click Print.

Print multiple barcode labels by modifying the Inventory on Hand Report

To print multiple barcode labels by modifying the Inventory on Hand Report:

If you haven’t already, create a barcode label design.
Export the Inventory on Hand Report.
Open the document, then copy the row that includes the barcode information.
Paste the information on new rows. The number of rows should reflect the number of copies that you want to print.
Print your barcode labels as usual.

Print multiple barcode labels by modifying your barcode label

To print multiple barcode labels by modifying your barcode label:

Create a barcode label design and click the items in the preview window to enter the appropriate information, such as name, price, and barcode number.
If you want to reuse this design, on the top menu, click File, select Save As, and enter a name for your barcode label design.
Under Number of copies, enter the number of copies you want to print, then click Print. Your barcode labels will be printed from your DYMO LabelWriter.