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','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 '%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(15)

E-A-R(10)

Peltor(5)

3M(3)

Aearo(1)

 
Color

Yellow(14)

Black(5)

Orange(5)

Pink(4)

Green(3)

Blue(2)

Red(2)

Multi(2)

Neon Yellow(2)

Blue Stem(1)

White(1)

Black/Green(1)

 
Size

Medium(1)

 
Recycled

No(33)

 
Packaged Quantity

200 / Box(12)

100 / Box(6)

1 Each(5)

20 / Pack(2)

120 / Box(2)

1000 / Bottle(2)

1 / Each(2)

10 / Box(1)

60 / Box(1)

100 / Bag(1)

 
Limited Warranty

1 Year(13)

 
Weight (Approximate)

6.50 oz(2)

6.23 oz(1)

4 lb(1)

8.25 oz(1)

12.35 oz(1)

 
Compatibility

E-A-R Dispenser:

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

 
Manufacturer Part Number

1010970(1)

3101103(1)

X4A(1)

X1A(1)

H6FV(1)

H10A(1)

3911004(1)

3911001(1)

3404004(1)

3181003(1)

3121260(1)

3121250(1)

3121219(1)

3121201(1)

3111250(1)

311-1101(1)

3101060(1)

1013461(1)

MAX1(1)

DPAS1(1)

DPAS30R(1)

LL1(1)

LL30(1)

LPF1(1)

LPF30(1)

MAX30(1)

29009(1)

QB2HYG(1)

R01669(1)

R01669BX(1)

R01680(1)

R01680BX(1)

1100(1)

X5A(1)

 
Country of Origin

United States(25)

Mexico(4)

Poland(2)

Slovakia(1)

China(1)

Brazil(1)

 
Material

Foam(12)

Polyurethane(5)

Polyurethane Foam(5)

Vinyl Cord(4)

Plastic(3)

Polyurethane Earplug(2)

Foam Liner(2)

Acrylonitrile Butadiene Styrene (ABS)(2)

Stainless Steel Headband(2)

Steel(2)

Polyvinyl Chloride (PVC)(2)

Soft Foam(2)

Thermoplastic Elastomer (TPE)(2)

Acrylonitrile Butadiene Styrene (ABS) Earcup(2)

Steel Band(1)

Polyvinyl Chloride (PVC) Earplug(1)

Polymer(1)

Polyurethane Ear Pad(1)

Foam Earplug(1)

 
Height

3.3"(1)

8.1"(1)

 
Width

15"(1)

4.4"(1)

 
Depth

1.3"(1)

 
Length

5.6"(1)

 
Protection Type

Noise(25)

Noise Reduction Rating(7)

Dirt(1)

Blast(1)

 
 
 
 
 

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