facebook
 
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, 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_1` 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_name` IN ('Lanyards','Name Badge Holders','Name Badges/Systems','Photo ID Kits & Accessories')) 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_pricing_check`=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 `pinfo`.`sku` LIKE '%BadgesandHolders' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('BadgesandHolders' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+BadgesandHolders' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"BadgesandHolders"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"BadgesandHolders"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"BadgesandHolders"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"BadgesandHolders"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+BadgesandHolders' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='BadgesandHolders',`category_4` ='BadgesandHolders') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'BadgesandHolders,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('BadgesandHolders', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Badges And Holders

Refine Search

  GO
 
Brand

Advantus(80)

Avery®(36)

C-Line(17)

DURABLE(17)

SICURIX(12)

Business Source(12)

Champion Sports(5)

Trend(5)

Xstamper(3)

Carson-Dellosa(2)

SKILCRAFT(2)

Scotch(1)

Teacher Created Resources(1)

Ashley(1)

Command(1)

GBC(1)

Fellowes(1)

Ergodyne(1)

Dymo(1)

 
Color

Clear(59)

Black(42)

White(32)

Blue(13)

Silver(9)

Red(7)

Multicolor(5)

Black/Clear(5)

Transparent(3)

Neon Pink(3)

Neon Green(3)

Neon Yellow(3)

Smoke(3)

Neon Orange(3)

Dark Blue(2)

Frosted(2)

Gold(2)

Assorted(2)

Clear Pouch(1)

White Band(1)

Translucent(1)

Translucent Blue(1)

Translucent Red(1)

Translucent Assorted(1)

Green(1)

Gold Metallic Border(1)

Ochre(1)

Coral(1)

Dark Green(1)

Gray(1)

 
Recycled

No(52)

 
Height

3"(7)

0.3"(2)

4"(2)

2.3"(2)

1"(2)

7"(1)

3.9"(1)

6"(1)

0.1"(1)

3.5"(1)

0.31"(1)

1.6"(1)

4.5"(1)

3.50"(1)

0.8"(1)

1.5"(1)

 
Depth

0.5"(1)

2.2"(1)

2.5"(1)

2.9"(1)

2.6"(1)

1"(1)

0.3"(1)

21"(1)

 
Manufacturer Part Number

10407(1)

19184BD(1)

68902(1)

68903(1)

01379(1)

01379BD(1)

01615(1)

01615BD(1)

19180(1)

19180BD(1)

19184(1)

19700BADGE(1)

68754(1)

19700BADGEBD(1)

26144(1)

26146(1)

119027(1)

9413(1)

87587(1)

92234(1)

92245(1)

92263(1)

92264(1)

68824(1)

68424(1)

92266(1)

97579(1)

97126(1)

97127(1)

97128(1)

97129(1)

97130(1)

97131(1)

97132(1)

97183(1)

97302(1)

97583(1)

68010BX(1)

97587(1)

97588(1)

97589(1)

97590(1)

47810(1)

47820(1)

47840(1)

65619(1)

67830(1)

68010(1)

92265(1)

92277(1)

97102(1)

HOM21SES(1)

854023(1)

854223(1)

891819(1)

891919(1)

892419(1)

30911(1)

59991(1)

52054(1)

1122897(1)

MMM LS852G(1)

850401(1)

8455016258998(1)

8455016259782(1)

4040(1)

68905(1)

68906(1)

68907(1)

T-68022(1)

T-68070(1)

J21(1)

J22(1)

850407(1)

850207(1)

92365(1)

401(1)

92377(1)

92823(1)

92843(1)

92943(1)

95523(1)

95543(1)

97005(1)

97009(1)

126BLK(1)

501(1)

850201(1)

BP401(1)

BP601(1)

812319(1)

812701(1)

8127135(1)

8127136(1)

812728(1)

812732(1)

818701(1)

830901(1)

97121(1)

97101(1)

2920(1)

8780(1)

74472(1)

74520(1)

CB7-4C(1)

CC10-4C(1)

CB7-OC(1)

8395(1)

8520(1)

8522(1)

8720(1)

75403(1)

74461(1)

75404(1)

75406(1)

75410(1)

75418(1)

75423(1)

75424(1)

75425(1)

75426(1)

75450(1)

75451(1)

74471(1)

74459(1)

75453(1)

5390(1)

2921(1)

2922(1)

2923(1)

5095(1)

5140(1)

5144(1)

5146(1)

5362(1)

5384(1)

5392(1)

71210(1)

5395(1)

5895(1)

71200(1)

71201(1)

71202(1)

71203(1)

71204(1)

71205(1)

71206(1)

71209(1)

75452(1)

75456(1)

97100(1)

97027(1)

91119(1)

91128(1)

91129(1)

91130(1)

91131(1)

91132(1)

91153(1)

91161(1)

97002(1)

97033(1)

76416(1)

97063(1)

97064(1)

97065(1)

97066(1)

97067(1)

97068(1)

97096(1)

97097(1)

97098(1)

97099(1)

76417(1)

76076(1)

75457(1)

75553(1)

75464(1)

75471(1)

75472(1)

75473(1)

75523(1)

75524(1)

75545(1)

75551(1)

75552(1)

75603(1)

76075(1)

75604(1)

75648(1)

75649(1)

75656(1)

75657(1)

75662(1)

75666(1)

75667(1)

75683(1)

75684(1)

J23(1)

 
Country of Origin

China(131)

United States(30)

Germany(11)

Mexico(9)

Canada(9)

Taiwan(7)

Denmark(1)

 
Width

4"(14)

3"(10)

0.5"(4)

3.5"(3)

2.4"(2)

1.8"(2)

4.3"(2)

2.3"(2)

3.8"(2)

1.3"(1)

2"(1)

0.4"(1)

4.5"(1)

11.4"(1)

2.9"(1)

2.6"(1)

11.50"(1)

 
Material

Plastic(34)

Vinyl(28)

Nylon(20)

Metal(19)

Woven(5)

Cotton(3)

Polypropylene(3)

Steel(2)

Paper(2)

Elastic(2)

Acrylonitrile Butadiene Styrene (ABS)(1)

ABS Plastic(1)

Polyvinyl Chloride (PVC)(1)

Polyvinyl Chloride (PVC) Holder(1)

Plastic Holder(1)

Poly(1)

Acrylic(1)

Polystyrene(1)

 
Limited Warranty

90 Day(71)

1 Year(4)

 
Weight (Approximate)

1.44 oz(4)

12.64 oz(1)

12.16 oz(1)

1 lb(1)

4.48 oz(1)

12 oz(1)

1.28 oz(1)

10.40 oz(1)

0.48 oz(1)

0.80 oz(1)

0.32 oz(1)

1.76 oz(1)

0.16 oz(1)

 
Shape

Rectangle(26)

Rectangular(5)

 
Length

36"(19)

34"(2)

17.50"(1)

10"(1)

 
Maximum Load Capacity

5 lb(1)

 
Sheet Size

3 1/2" x 2 1/4"(3)

4" x 3"(3)

1" x 3"(2)

8 1/2" x 11"(1)

 
Print Technology

Laser(23)

Inkjet(23)

 
Media Size Supported

4" x 3"(6)

2.13" x 3.38"(4)

3.38" x 2.13"(4)

2.25" x 3.50"(3)

3.35" x 2.13"(3)

3.50" x 2.25"(3)

3.25" x 2"(3)

2" x 3.25"(3)

3.75" x 2.58"(2)

2.50" x 3.50"(2)

3.50" x 2.50"(2)

2.25" x 1.13"(2)

2.88" x 1.50"(2)

3" x 4"(2)

2.58" x 3.75"(1)

3.75" x 2.63"(1)

4" x 2.75"(1)

2.88" x 3.88"(1)

3.50" x 2.37"(1)

2.37" x 3.50"(1)

2.62" x 3.75"(1)

2.50" x 1.13"(1)

2.88" x 1.25"(1)

4" x 2.80"(1)

 
Placement

Pocket(1)

Hanging(1)

 
Skill Learning

Name(1)

Alphabet(1)

Vocabulary(1)

Word(1)

 
Tag Width

2.50"(2)

 
Tag Length

3"(2)

 
Number of Labels per Roll

250(1)

 
Adhesive Type

Removable(13)

Self-adhesive(3)

 
Number of Labels per Sheet

8(8)

2(3)

 
Mount Type

Self-adhesive(1)

 
Print/Message

Hello My Name Is(2)

Visitor(2)

 
Carbonless Copy

Yes(1)

 
Total Number of Labels

40(1)

 
Product Type

Badge Holder(78)

Lanyard(31)

Name Badge Label(26)

Laser/Inkjet Badge Insert(11)

Name Badge Kit(9)

Name Badge Holder(9)

Name Badge(7)

Card Holder(7)

Whistle(3)

ID Tag(2)

Retractable Belt Clip(2)

Strap Holder(2)

Strap Clip(2)

Name Plate(2)

Picture Holder(1)

Safety Strap(1)

Card Sleeve(1)

Log Book(1)

Media Holder Kit(1)

Tent Card(1)

Key Ring(1)

Strap Clip Adapter(1)

 
Packaged Quantity

100 / Box(26)

50 / Pack(17)

12 / Pack(16)

25 / Pack(14)

10 / Box(12)

50 / Box(10)

25 / Box(9)

20 / Pack(8)

24 / Box(8)

1 Each(8)

6 / Pack(8)

10 / Pack(7)

100 / Pack(5)

12 / Box(5)

1 Dozen(4)

20 / Box(4)

400 / Box(4)

4 / Pack(3)

250 / Bundle(3)

108 / Pack(3)

200 / Box(2)

400 / Pack(2)

1 / Pack(2)

500 / Bundle(2)

36 / Pack(2)

1 / Each(1)

5 / Pack(1)

24 / Pack(1)

120 / Pack(1)

30 / Pack(1)

40 / Pack(1)

160 / Pack(1)

1 / Box(1)

2 / Pack(1)

300 / Box(1)

40 / Box(1)

250 / Roll(1)

1(1)

30 / Box(1)

25(1)

 
Assembly Required

No(8)

 
Product Model

5362(1)

75451(1)

75456(1)

75457(1)

75523(1)

92943(1)

812319(1)

 
Product Line

Premium(5)

Terrific Labels(3)

Deluxe(2)

Times Up!(2)

Quick Stick(1)

Skullerz(1)

 
Package Type

Retail(1)

 
Adjustable

Yes(2)