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

Currently Filtered by

Category

Hearing Protection

Refine Search

  GO
 
Brand

Howard Leight(20)

E-A-R(13)

3M(6)

Peltor(6)

Aearo(2)

 
Color

Yellow(17)

Black(8)

Orange(7)

Neon Yellow(4)

Pink(4)

Green(3)

Red(3)

Blue(3)

Multi(2)

White(1)

Black/Green(1)

Blue Stem(1)

Black Band(1)

Bright Green(1)

High Visibility Red Cup(1)

 
Size

Medium(1)

 
Recycled

No(46)

 
Packaged Quantity

200 / Box(16)

1 Each(11)

100 / Box(8)

1000 / Bottle(2)

1 / Each(2)

20 / Pack(2)

10 / Box(2)

120 / Box(2)

100 / Bag(1)

60 / Box(1)

 
Assembly Required

No(1)

 
Limited Warranty

1 Year(17)

 
Weight (Approximate)

6.50 oz(2)

10.72 oz(2)

12.35 oz(1)

8.25 oz(1)

6 oz(1)

6.23 oz(1)

10.65 oz(1)

4 lb(1)

 
Compatibility

E-A-R Dispenser:

  • One Touch 391-1000
  • One Touch Pro 391-0000
(1)

 
Manufacturer Part Number

3121201(1)

3121219(1)

3121250(1)

3121252(1)

3111252(1)

3111250(1)

3101060(1)

3101103(1)

311-1101(1)

3111115(1)

3121260(1)

3181003(1)

H7P3E(1)

X1A(1)

X4A(1)

X5A(1)

H6FV(1)

H10A(1)

3212101(1)

3404004(1)

3911001(1)

3911004(1)

310-1001(1)

29009(1)

LL1(1)

LL30(1)

LPF1(1)

LPF30(1)

DPAS30R(1)

DPAS1(1)

1010970(1)

1011993(1)

1013461(1)

1013941(1)

1006202(1)

MAX1(1)

R01680BX(1)

1100(1)

1110(1)

29008(1)

R01680(1)

R01669BX(1)

MAX30(1)

QB2HYG(1)

QM24PLUS(1)

R01669(1)

1010924(1)

 
Country of Origin

United States(31)

China(5)

Mexico(5)

Brazil(3)

Poland(2)

Slovakia(1)

 
Material

Foam(16)

Polyurethane(8)

Vinyl Cord(7)

Polyurethane Foam(5)

Plastic(5)

Foam Earplug(3)

Polyvinyl Chloride (PVC)(3)

Polyurethane Earplug(3)

Stainless Steel Headband(3)

Acrylonitrile Butadiene Styrene (ABS) Earcup(3)

Acrylonitrile Butadiene Styrene (ABS)(3)

Steel(2)

Soft Foam(2)

Foam Liner(2)

Thermoplastic Elastomer (TPE)(2)

Polymer(1)

Polyurethane Band(1)

Acrylonitrile Butadiene Styrene (ABS) Band(1)

Steel Band(1)

ABS Plastic(1)

Steel Cord(1)

Nonwoven(1)

Foam Cap(1)

Polyvinyl Chloride (PVC) Earplug(1)

Textile(1)

Soft Foam Cushion(1)

Polyethylene Foam(1)

Metal(1)

Steel Headband(1)

Polyurethane Ear Pad(1)

Foam Headband(1)

Polyvinyl Chloride (PVC) Headband(1)

 
Height

8.1"(1)

15.2"(1)

6.6"(1)

 
Width

4.4"(1)

7.5"(1)

4.2"(1)

 
Depth

7"(1)

 
Protection Type

Noise(35)

Noise Reduction Rating(9)

Dirt(2)

Blast(1)

Ear(1)

 
Closure

Strap(1)

 
 
 
 
 

© 2019-2020 Bayshore Office Products, Inc., All Rights Reserved