Whirlpool - Greenville: Pallet ID Printing

Work Order - Roll Out Details

1. Make a copy of Google Sheet "** Roll-Out Details Template **" in the folder Google Shared Drive > Strategic > Strategic Resources > WORK ORDERS and save with the name "SOXXXXX - Whirlpool" 

2. Select the Media Details 

   • Add Check for Printing/Encolding

   • Add Check for Re-Roll/ Rewind

   • In Other add number of batches to be printed

   • In Syntax, copy and paste the URL link for the Google Drive spreadsheet located in Google Drive 

     • Shared Drives > Strategic > Technical Services > Customer Files > Whirlpool > Greenville > Label Configuration Worksheet - Whirlpool Order TEMPLATE.xlsx > Create a copy / Save As Label Configuration Worksheet - Whirlpool Order SO######.xlsx > Copy the share link for the Spreadsheet

   • In Printer Used type ZT411R 

   • Save

Pre-Printing Confirmation

• Access the previous Label Configuration worksheet for the last sales order and note the Barcode end number ID + 1 for example FS00052500 so the Barcode start number ID for the new order will be FS00052501. 

• Email the customer to confirm the Starting ID:

Email Subject: Whirlpool - Pallet ID Labels - SO######

To: tammy_j_phillips@whirlpool.com

CC: stephen_w_brewer@whirlpool.com , paula_a_price@whirlpool.com , craig_e_lacey@whirlpool.com , chanin_e_stump@whirlpool.com , david@sstid.com , solutionsengineering@sstid.com 

Email Body: 

Hi Tammy,

We have received a new order for Pallet ID Pre-Printed labels. Please review below details and confirm IDs to print. 

Starting ID:  FS000#####

Site Location: GREENVILLE

Printing 7,500 labels: the final ID determined after completion

Thanks,

• Once the customer confirms the starting ID update the  Label Configuration Worksheet - Whirlpool Order SO######.xlsx and Save

  • Barcode start number

  • Human readable start number

  • EPC start number - HEX Value

    1. To update the HEX value, open the Tagprinting.xlsx 

    2. Update the first value in A2 to the new start ID

    3. Then copy down the ID to auto increment by one

    4. Column B will update with the HEX Value

    5. Save 

Open Bartender Template and Setup Database connection

• 1. Open Bartender template

     • File → Open

     • This PC → Google Drive → Shared drives → Strategic → Tech services → Customer files → Caterpillar → RFIDTagPrinting → Asset Tracking → CAT-LABEL.BTW

  2.  Connect Database batch

     • File → Database connection

     • Create a New database connection

     • MS Excel → Select file

     • This PC → Google Drive → Shared drives → Strategic → Tech services → Customer files → Caterpillar → RFIDTagPrinting → Asset Tracking → open S0XXXX folder and select the Excel Sheet

     • Open > Next > uncheck use automatic field

     • Next > if multiple sheets start w/ the first one (first batch), uncheck first row has fields (if there is no header) > Next →  finish

     • Press OK

  3. Double click Barcode in label template to open Barcode properties  

  4. Confirm or Update Embedded data to Database Connection

     • On Type: section select the Change Data Source type icon

     • Select New Type 

     • From Dropdown: Database field 

     • Next > confirm A & Sample # → Finish → Close 

Begin Print Job

• 1. Perform print of first Record

     • Ctrl + P to print

     • Under Record Selection Section click on select records

     • uncheck first check box to deselect all

     • Check box for record value 1

     • select OK

     • Select Print

     • Confirm print is successful and the ID is printed for the barcode 

  2. Print remaining Records of the Batch

     • Ctrl + P to print

     • Under Record Selection Section click on select record 

     • Check first check box to select all → uncheck box for record value 1

     • select ok

     • Select Print 

  3. During large print job, begin to loosely hand Roll the labels → once labels run out, printer will show media out

     • open printhead

     • remove labels and core

     • set aside for boxing

     • open new box

     • Follow step 2 from Load Printer with Media

     • Printing will resume

  4. Continue hand roll

  5. Once print job batch finishes, press feed button once, and use box cutter to cut between the last blank label and spacer

  6. Box up label roll(s) following the steps from Boxing up label Batches

  7. Print next Batch

     • Select Database Setup

     • Select Tables

     • Select the existing table and select Change Table

     • Select the next batch from the sheet dropdown → select OK

     • Press OK

  8. Follow Steps 1-7 to complete existing batch and start the next until completed with all batches

  9. Once Completed, follow steps to Disconnect the Database and Close Template

Boxing up Label Batches

• 1. After completing print Job of Batches →  Use existing boxes, bubble wrap and stickers in the same method used for the black labels

  2. Write outside the box Box# and site name

  3.  Boxing 

     • for large batches use the original label boxes

     • for smaller batches use 8×6×4 boxes w/ paper from shipping Desk  

Disconnect Database and close Bartender Template

• 1. Disconnect the Database and Save & close bartender template

     • Open File → Database connection setup

     • Select red X on bottom left corner

     • Select Yes

     • Select OK

     • Close Template

     • Select Yes to Save