SELECT `pinfo`.`sku`,`pinfo`.`vendor`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('348')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('NameBadgeKits' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+NameBadgeKits' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"NameBadgeKits"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"NameBadgeKits"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"NameBadgeKits"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"NameBadgeKits"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+NameBadgeKits' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='NameBadgeKits',`category_4` ='NameBadgeKits') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'NameBadgeKits,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('NameBadgeKits', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Name Badge Kits

Refine Search

  GO
Brand

Avery(47)

Advantus(30)

C-Line(20)

AbilityOne(10)

Universal(9)

SICURIX(9)

Durable(6)

Schoolgirl Style(1)

MACO(1)

Country of Origin

CN(64)

MX(30)

US(23)

CA(11)

DE(5)

For Use With

Avery 5390, 5392(5)

Orientation

Horizontal(89)

Vertical(31)

Horizontal/Vertical(12)

Side Release Buckle(1)

Sheet Width

8.5"(41)

8 1/2"(8)

4"(6)

4.25"(3)

2 1/8"(2)

2 5/8"(2)

8"(2)

2 1/2"(2)

8.63"(2)

3"(1)

11"(1)

Printed Text

Visitor(5)

Hello my name is(2)

"Hello"(1)

Hello, my name is(1)

Name Badge Label Color(s)

White(48)

Assorted(8)

White/Blue(8)

Clear(5)

White/Red(3)

White/Gold(2)

Black/White(1)

White/Assorted(1)

Name Badge Label Length

2.33"(17)

3"(16)

1"(11)

2.25"(10)

4"(5)

6"(4)

3 1/2"(3)

2"(3)

3 4/5"(2)

3.5"(2)

3 3/8"(2)

2.38"(2)

2 1/3"(1)

1.88"(1)

3 11/16"(1)

2.5"(1)

2 1/8"(1)

2 1/4"(1)

Name Badge Label Material(s)

Paper(51)

PVC(3)

Plastic(2)

PVC-Free Poly(2)

Name Badge Label Width

3"(19)

3.38"(17)

4"(16)

3.5"(10)

2 1/4"(3)

3 3/8"(2)

2 1/8"(2)

2.25"(2)

2 1/2"(2)

3.68"(2)

4.25"(2)

4 1/4"(1)

3.63"(1)

3 1/2"(1)

4.5"(1)

3 1/4"(1)

2 5/16"(1)

Name Badges Per Sheet

8(23)

6(17)

2(14)

20(8)

1(4)

3(3)

10(2)

4(2)

Load Style

Top(30)

Snap-on(9)

Top/Side(3)

Side; Top(2)

Side(1)

Top-loading(1)

Name Badges per Unit

50(28)

100(24)

25(11)

10(10)

12(6)

400(6)

20(5)

40(3)

24(2)

150(2)

200(2)

1(2)

120(2)

160(2)

4(2)

30(2)

96(1)

48(1)

250(1)

60(1)

56(1)

300(1)

75(1)

80(1)

6(1)

Sheet Length

11"(54)

6"(6)

3 4/5"(2)

3 3/8"(2)

3 3/4"(2)

11.13"(2)

2.5"(1)

8 1/2"(1)

Name Badge Holder Material(s)

Plastic(35)

Vinyl(13)

PVC-Free Poly(9)

Polycarbonate(9)

Polypropylene(9)

Acrylic(3)

Nylon(3)

Vinyl/Elastic(2)

Paper/Laminate(2)

Vinyl; Cotton; Nylon; Metal(2)

PVC Plastic(2)

Vinyl/Plastic/Metal(2)

PVC(2)

RF Proof Plastic(1)

Polystyrene(1)

Plastic; Nylon(1)

Cord Length

36"(6)

30"(2)

48"(2)

18"(2)

37"(1)

Name Badge Holder Color(s)

Clear(67)

Black(8)

Silver(6)

Black/Clear(5)

Gold(3)

Clear/Smoke(2)

White/Clear(2)

Tan(1)

Green/Black(1)

White(1)

Name Badge Holder Length

3"(27)

4"(8)

2.25"(5)

2 1/8"(5)

3.5"(4)

2 1/4"(4)

5"(4)

3 1/2"(4)

2.38"(3)

4.13"(3)

6"(3)

3.75"(3)

2 1/2"(2)

3 3/4"(2)

3 3/8"(2)

4.25"(2)

3.38"(2)

3 4/5"(2)

2.5"(1)

4 3/4"(1)

2 5/8"(1)

5.13"(1)

4.38"(1)

4.88"(1)

3.88"(1)

3.68"(1)

2.75"(1)

4 1/2"(1)

3 11/16"(1)

5 1/2"(1)

Name Badge Holder Width

4"(18)

3"(10)

1"(9)

3.68"(8)

3.5"(7)

3 3/8"(5)

3 3/4"(5)

2.25"(4)

4.13"(3)

2 1/2"(3)

2 5/8"(2)

2 1/4"(2)

2 1/8"(2)

3 1/4"(2)

3.75"(2)

4.25"(2)

2.75"(1)

2.13"(1)

3.13"(1)

5.5"(1)

2.68"(1)

2 5/16"(1)

2 3/4"(1)

4.5"(1)

5"(1)

3 1/2"(1)

2.5"(1)

2.38"(1)

3.8"(1)

Special Features

Border-Style(6)

Complete Kit for Laser Printers(5)

Plain-Style(4)

Clip Style-Horizontal orientation with easy-to-load pocket design and garment-friendly clip-holds firmly without damaging fabric.(3)

Complete Kit for Inkjet Printers(3)

Clip-Style(3)

Prepunched for Chain or Clip(2)

Black(2)

Lanyard Style-Vertical orientation with easy-to-load large-pocket design and 18 lanyard. Ideal for carrying agendas, site maps and more during conferences and special events.(2)

With 30" Carabiner Style Cord Reel(2)

Clip/Pin Combo-Dual Swiveling Clip/Pin Style(2)

With 36" Lanyard with J Hook(2)

Pin Style-Horizontal orientation with easy-to-load pocket design.(2)

Clip Style-Includes proprietary Avery Garment Friendly clip.(2)

Hanging Style-Horizontal orientation with easy-to-load pocket design and 36 non-elastic neck cord.(2)

Hello(2)

Border-Style-8.5 x 11 sheets(2)

Plain-Style-8.5 x 11 sheets(2)

Horizontal or Vertical Style(2)

Clear(2)

Safe Clips-Clips are pre-attached to badge holder with an unique design to prevent clothes from snagging.(2)

With Combination Clip and Pin(1)

Secure Badge Holder w/Garment-Safe Clips-Loop-style, snag-less clips hold ID within the holder so it cannot fall out. Clips attach separately through holder for added security.(1)

Reel(1)

Clip(1)

Visitor(1)

Neck Lanyards-Keep your badge handy without attaching it to your clothing.(1)

Tan(1)

Lanyard(1)

Overall Area Color Alert(1)

With Double Magnets(1)

Black with Lanyard-36" long.(1)

Holds One Card(1)

For Laser Printers(1)

Vertical Style with Perforated Tickets-Larger badge for more information such as agendas. Tickets included are great as complimentary drink, parking or raffle tickets.(1)

For Inkjet Printers(1)

Badge Holders Only(1)

Hanging Style-Includes 36 non-elastic cord.(1)

Border-Style-4 x 6 sheets(1)

Border-Style-8.5 x 11 sheets.(1)

Hello-8.5 x 11 sheets.(1)

Hanging-Style-Elastic Cord(1)

Adjustable Bolo Executive-Style(1)

With Magnetic Strip(1)

Holds Two Cards(1)

With Clip(1)

Spot Area Color Alert(1)


50(16)

4(7)

15(3)

20(3)

5(3)

10(3)

6(2)

7(1)

102(1)

38(1)

8(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved