Skip to main content

Add UPC numbers to the File that Bartender Uses for Printing

How to Create Labels With UPC Barcodes for Sports South

1.

Adding UPC Numbers to the File That Bartender Uses for Printing

  1. If the product is not assigned a UPC code, obtain one from GS1.

    2. 2.     

  2. Enter the UPC code in Sage 100.100 Itunder is entered in Item Maintenance.Maintenance See→ Action tab.

    tab    .

    3. 3.     

  3. Add the item code, the UPC numbernumber, and the pack description to the CSV file located inat: L:\User Shared Folders\AcuSport\Bartender Labels. The file name is Labels\UPC BT Master List.csv
    4. (see
  4. ⚠️ below).CRITICAL Edit— Read this before opening the CSV in Excel. Excel will silently corrupt the UPC column if you open the file usingby Notepaddouble-clicking orit. ExcelIt converts long numbers like 816506000123 into scientific notation (8.16506E+11) and addpermanently deletes all digits beyond the item15th code,significant UPCdigit number,when you save. The trailing digits get replaced with zeros, and packthe description.original UPCs cannot be recovered from that file. Use one of these safe methods instead:
    • Best: Edit in Notepad. Right-click the file → Open with → Notepad. The UPCs stay as text. Add your new rows in the format SKU,UPC,Qty and save.
    • If you must use Excel,Excel: makeImport surevia Power Query. Open a blank Excel workbook → Data → Get Data → From File → From Text/CSV → select the file. In the preview window, click the UPC column header and change the data type to saveText before clicking Load. When saving, use Save As → CSV UTF-8 and overwrite the file.
    • Never double-click the CSV to open it in Excel. Even if you don't edit the UPC column, saving the file will corrupt every UPC in it.
  5. Save the file in the CSV format.format Save(not the.xlsx).
    6. file.

    A screenshot of a computer AI-generated content may be incorrect.

    4.     

  6. Open the Label Template.btw file (see above image). The new item will appear in the record selection window when Print is selected within Bartender.

If You Suspect a UPC Has Already Been Corrupted

Open the CSV in Notepad (not Excel) and check whether the UPC column shows full numeric strings or scientific notation. If you see entries like 8.16506E+11 or UPCs ending in multiple zeros where they shouldn't, those records need to be re-entered from Sage 100 or the original source.

Back to top