This negated having to “eyeball” where to drag the fields to, and resulted in quick, perfectly aligned fields. While dragging a field into place, some background rulers lit up to show and help align with the other fields. Variable fields were the P/N, Description, Customer P/N, Cage Code, and serial number for each batch of labels.īartender made it easy to accurately place the fields onto the format. They had their company name, a Made In USA field, and the P/N and S/N text as the fixed fields. The fields that remain the same across all label jobs are referred to as fixed data fields-the data remains static. The label format was a 3” x 1” size, and required both fixed data fields and variable data fields. The next step was to re-create the label format in Bartender. Step 2: Create the New Label Format Utilizing Fixed and Variable Data Fields I set this up in Excel, to be used as a database file. I also included a “packaging instructions” column, which would associate instructions pertaining to each part number. Each part number’s database record would include columns for P/N, Description, Customer P/N, Cage Code, and Qty per Unit. The first line of business here was to create a simple database to house all of the part numbers. Step 1: Create a Database to Import Label Data at Print Time Obviously, for handling 3800 different part numbers, this method was too laborious and error prone. After he printed the labels, he would then have to ascertain which packaging instructions to associate with each label job. When the operator was ready to print labels he would open the label format, enter the part number, then he would enter the other fields of data. These instructions would somehow need to be presented along with the label printing. Finally, each part number may have its own set of packaging instructions.

He also wanted the part number’s description, gov’t CAGE code, and serial number to be printed on each label.

The prospect wanted the ability to scan a barcode part number and have that part number print on the label. The software was not set up to be used to its full potential.

The prospect is an existing Bartender 10 user, who most likely purchased his software from a catalogue house rather than from a value added reseller. He described his situation as a logistical nightmare, due to the fact that they were printing labels for 3800 different part numbers, and having trouble ascertaining the packaging instructions required for each part number. A new prospect contacted me for a solution to his label printing woes.

Serial number bartender 10.0