Article 1 — Reference Article

Title: Bartender & Datamax: Setup and Label Spreadsheet Reference

Search Keywords: bartender setup, datamax printer driver, all label information spreadsheet, label format, nutrition request, FDA labeling

Body:

What Bartender Is

Bartender is the software that prints your product labels. It's database-driven, meaning it pulls information from a source file rather than having label content typed in each time you print.

• The database is your All Label Information spreadsheet — an Excel file containing every product's name, weight, ingredients, and nutrition graphic. It downloads automatically when you install the Great Harvest Bartender Software (GHBS) and already contains your opening product line. You'll keep adding to it as you develop new recipes.
• Label templates are pre-built layouts (already FDA-compliant) that Bartender fills in automatically from the spreadsheet. You won't need to build new templates — just pick the right size for your product:

Bartender reads the product Title from the spreadsheet and drops it into the template's title field; it looks up the Nutrition Facts image filename listed in the spreadsheet and inserts that specific graphic into the label's nutrition panel placeholder — same logic for every other field.

Initial Setup (one-time)

1. Install Bartender from the install disk (option 1 on the installer menu).
2. Install the Datamax printer driver, also from the install menu. Then set the correct port:
   • Plug the Datamax's USB cable into your computer and power it on.
   • Open Printers and Faxes (or Devices and Printers, depending on your OS).
   • Right-click the Datamax → Printer Properties → Ports tab.
   • Select a USB port from the list, click Apply, then go to the General tab and click Print Test Page.
   • If nothing prints, go back and try a different port, then test again. Repeat until a test page prints — that port is now your permanent Datamax port.
3. Install the Great Harvest Bartender Software (GHBS) from its disk. This downloads all Great Harvest label files to the correct location and creates desktop shortcuts automatically.
4. Confirm everything downloaded by opening the Great Harvest Bartender Files 2.0 folder on the desktop. You should see:
   • Backgrounds folder — background images so you can preview what labels will look like
   • Nutrition Facts Labels 2.0 folder — where every nutrition panel image you receive gets saved
   • All Label Information 2.0 — your spreadsheet/database
   • All the blue-icon files — label templates, named by product type and size

Note on Fresh Ground Mix (FGM) labels: these aren't in the spreadsheet at all, because their labels need baking/mixing directions printed at the top. The first time you use an FGM label, you'll open it and manually enter the ingredient list, contains statement, and nutrition panel directly in that template — see Article on Fresh Ground Mix printing below.

The All Label Information Spreadsheet — Column Reference

Never rename, edit, or alter Row 1 (the field name headers).

First-Time Setup Per Label Format

Each back-label format needs two one-time adjustments before its first real print run:

Update contact info: Open the label, double-click the contact/address text box → Data Source tab → enter your correct info in Screen Data → OK. Don't touch anything else in that box.

Set print speed and temperature: File → Print → Document Properties → Options tab → set Print Speed to 4.00 in/sec in every box, and Print Head Temperature to 16. (Too hot burns through your print head bulbs faster; too cool prints too light.) Save before closing the format — you only need to do this once per format.

Printing Labels

1. Open the Great Harvest Bartender folder on the desktop, then double-click the label format you want (or open the Fresh Ground Mix folder first if printing an FGM label).
2. File → Print (or Print Preview).
3. In the Print Wizard, click Select Records if it doesn't open automatically.
4. There's usually a default "1" next to every product — that means one of every label would print. Deselect that by clicking the book icon with the red X, then manually enter the quantity you want in the # column for just the products you're printing.
5. Click OK, then Print or Preview.

(This assumes your Datamax is connected, loaded with labels, and calibrated — see the individual troubleshooting articles if you're setting up for the first time.)

Requesting Nutrition Information

You need a new nutrition request whenever you finalize a new recipe, change the cut/net weight, or otherwise change an existing recipe's ingredients. Even previously-tested Breadboard recipes need a nutrition request if they're not already in your spreadsheet — you generally won't need to request nutrition for your opening lineup, since it's pre-loaded.

1. Email your recipe (full ingredient specifics, flour added at the mixer, cut weight, and the label size you'll use) to the Nutrition Specialist in Dillon.
2. You'll receive back a nutrition facts panel (.bmp image) and a Word document with the ingredient statement and contains statement.
3. Save the .bmp into your Nutrition Facts Labels folder.
4. Open your All Label Information spreadsheet, right-click the row number where you want to insert, choose Insert, and fill in every column for the new row (see the column reference above).
5. Save and fully close the spreadsheet. Bartender can't read the file while Excel has it open — if Excel is still open when you try to print, you'll get an error and won't be able to print at all.
6. You're ready to print.

For more detail on submitting recipes for analysis: Breadboard → Operations tab → Nutrition and Labeling → Submitting a Recipe for Nutritional Analysis.

FDA Labeling Basics

You need a label when:

• The product is packaged (wrapped, bagged, clamshell — anything that preserves freshness)
• It's available for the customer to pick up already packaged
• It's sold outside the bakery that made it, or sold wholesale
• It makes a health claim ("light," "low fat," "high fiber," "healthy," etc.)

You're exempt when:

• It's unpackaged behind the counter or in the sweets case
• It's placed in a wrapper/carryout box/other non-durable container solely to make handling easier (a cookie sleeve, a box of scones for carrying)
• It's a made-to-order ready-to-eat item (like a sandwich)
• It's being given away

Labeling systems: a one-label system puts every required element on the Principal Display Panel (the side most visible to the customer). A two-label system puts just the Name + Statement of Identity + Net Weight on the front, with the remaining required elements (ingredients, contains statement, nutrition panel, responsible party) on the back.

Required elements (already built into every GH label format):

• Name + Statement of Identity (e.g. "Honey Whole Wheat" + "100% Whole Wheat Bread") — on both front and back
• Net Weight in lbs/oz (grams) — cut weight minus 3 oz — on both front and back
• Ingredients statement (descending order by weight, exactly as sent by the Dietitian) + Contains statement for allergens
• Responsible party — your bakery name, address, and phone (web address optional)
• Nutrition Facts panel — not actually required for a bakery unless you're making a health claim, shipping the product, or selling it outside the bakery that made it, but it's built into the GH label formats regardless