Use Quartzy serial numbers (or your own) to create barcode labels

Use barcodes and a scanner to easily find items in your Inventory and Order Requests. All you have to do is assign barcodes and labels to your items.

If you do not already have barcode labels, create new ones using Quartzy serial numbers.

Tip: If you have your own serial numbers, add a custom "serial number" field to the Types in your inventory.

1. Export your Quartzy inventory and use the numbers in the Serial Number field to create your barcode labels. 

2. In Excel, download a new font called IDAutomationHC39M. Here is where we downloaded the font from. This font will automatically turn your serial numbers into barcodes. If you already have a program that creates barcode font, you can use that.

3. Create an Excel spreadsheet with your list of serial numbers, either from Quartzy or using your own numbers. Include * before and after the numbers and that will turn the numbers into barcodes within the Excel cells. Also, make sure to add a column header like "Serial Number"

4. Open a new Word document and from the Template options, choose Labels and then Label Wizard.

5. Pick the label type (Ex. Avery 5160) that you will be printing with and then choose Mail Merge.

6. Click Get List and then Open Data Source... to select the Excel spreadsheet file from your computer that has your serial numbers.

7. Follow the steps to open your file and choose the set of data that you want to place on your labels.

8. Click the icon under Complete Merge to Merge to New Document.

9. You may need to choose the IDAutomationHC39M font again in order for the barcodes to show up correctly. Your labels are now ready! 

 

Next Up: Learn how to import inventory details including custom serial numbers to Quartzy

 

More questions? Contact us

Have more questions? Submit a request

Comments

  • Avatar
    Shawn Wright Weaver

    Method not working: Mail Merge of data to Word document gives me a document that repeats "Next Record" in each label spot.

  • Avatar
    Monica Velarde

    Hi Shawn,

    Sorry you're having some trouble with this! You might want to check the steps in a Microsoft Word Support document to see if your system uses the same steps for this process. These steps are completed outside of Quartzy and while we have tested this process many times, different operating systems may have different requirements.

    It may be that all of the data from Excel is not being used since the 'Next Record' is not being recognized. Hopefully checking the process will help you out with this. :)

  • Avatar
    Shawn Wright Weaver

    I got some help from someone more familiar with this version of Office than I, and got where I needed to go. Thank you.

  • Avatar
    Todd Hillman

    Hello,

    Would you also be able to include an item name on the label? That way you know what item should be associated with the barcode.
    Thanks

  • Avatar
    Monica Velarde

    Hi Todd,

    That would be up to you! You can definitely include as much information on the label as you like if you want to use it for identification purposes. The instructions on this page are just meant as a guide if you were interested in doing something like this for your items.

    Many Quartzy users showed interest in creating barcode labels for their inventory items through the site and since that's not a feature we have right now, this set of instructions was the next best thing we could offer. I hope they're helpful! You can email support@quartzy.com if you have any other questions specific to your account. Thanks!