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_36` 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 ('113284')) AND `pinfo`.`status` IN ('active','discontinued') 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 '%Lanyards' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Lanyards' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Lanyards' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Lanyards"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Lanyards"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Lanyards"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Lanyards"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Lanyards' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Lanyards',`category_4` ='Lanyards') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Lanyards,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Lanyards', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Lanyards

Refine Search

  GO
 
Brand

Advantus(22)

SICURIX(22)

SKILCRAFT(11)

DURABLE(6)

Champion Sport(4)

Champion Sports(2)

Swingline GBC(1)

Ergodyne(1)

 
Color

Black(45)

Blue(9)

Silver(6)

Natural(2)

Tan(2)

Red(2)

Dark Green(1)

Ochre(1)

Assorted(1)

Coral(1)

 
Packaged Quantity

1 Dozen(14)

12 / Pack(11)

1 Each(10)

24 / Box(8)

10 / Box(8)

100 / Box(7)

12 / Box(3)

100 / Pack(2)

1 / Pack(1)

1 / Dozen(1)

25 / Pack(1)

20 / Box(1)

10 / Pack(1)

 
Limited Warranty

90 Day(21)

 
Weight (Approximate)

1 lb(4)

0.48 oz(3)

0.32 oz(2)

0.16 oz(2)

0.80 oz(1)

1.76 oz(1)

1.44 oz(1)

18 lb(1)

1.60 lb(1)

12.16 oz(1)

12 oz(1)

1.28 oz(1)

12.80 oz(1)

1.60 oz(1)

 
Warranty

Manufacturer's 90-day warranty.(1)

 
Compatibility

Badges

(2)

Identification Badge(2)

Safety Glasses:

  • Ergodyne Odin
  • Dagr
  • Kvasir
  • Valkyrie
(1)

 
Manufacturer Part Number

601(1)

501(1)

401(1)

BP401(1)

BP601(1)

8127135(1)

812701(1)

126BLK(1)

98000(1)

69136(1)

69011(1)

68939(1)

69137(1)

69309(1)

69409(1)

69321(1)

8127136(1)

812728(1)

8455016452729(1)

8455016452728(1)

9905016134242(1)

8455016452730(1)

8455016452731(1)

3747478(1)

6485709(1)

8455016130199(1)

8455016130197(1)

830901(1)

812732(1)

59991(1)

8455016130192(1)

8455016130196(1)

8455016130195(1)

68909(1)

68903(1)

75662(1)

75574(1)

75571(1)

91153(1)

97126(1)

97128(1)

97127(1)

75549(1)

75547(1)

75421(1)

75404(1)

75403(1)

75423(1)

75424(1)

75426(1)

75425(1)

97129(1)

97130(1)

65603(1)

65564(1)

65549(1)

65609(1)

65613(1)

68902(1)

65619(1)

65543(1)

65534(1)

97132(1)

97131(1)

97183(1)

65509(1)

65524(1)

65514(1)

75401(1)

 
Country of Origin

China(50)

United States(11)

Taiwan(6)

CN(1)

United Kingdom(1)

 
Material

Nylon(27)

Metal(16)

Plastic(11)

Woven(5)

Polyester(3)

Cotton(3)

Nickel Plated(2)

Steel(2)

Elastic(1)

Metal - Ring(1)

Bamboo(1)

 
Height

1"(1)

 
Width

0.8"(3)

0.4"(3)

0.6"(1)

2"(1)

0.3"(1)

 
Depth

1"(1)

 
Length

36"(46)

34"(3)

10"(1)

 
Fastener Style

Lobster Claw Hook(1)

 
Fastener Material

Metal(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved