# Add UPC numbers to the File that Bartender Uses for Printing

### 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. Enter the UPC code in Sage 100 under **Item Maintenance → Action tab**.
3. Add the item code, UPC number, and pack description to the CSV file located at: `L:\User Shared Folders\AcuSport\Bartender Labels\UPC BT Master List.csv`
4. **<span style="text-decoration: underline;"><span style="color: rgb(224, 62, 45);">⚠️ CRITICAL — Read this before opening the CSV in Excel. </span></span>**Excel will silently corrupt the UPC column if you open the file by double-clicking it. It converts long numbers like `816506000123` into scientific notation (`8.16506E+11`) and **permanently deletes all digits beyond the 15th significant digit** when you save. The trailing digits get replaced with zeros, and the 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: Import via 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 **Text** before clicking **Load**. When saving, use **Save As → CSV UTF-8** and overwrite the file.
    - <span style="color: rgb(224, 62, 45);">**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.</span>
5. Save the file in CSV format (not .xlsx).
6. Open `Label Template.btw`. 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.