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

Currently Filtered by

Category

Ear Plugs

Refine Search

  GO
Brand

3M(30)

Moldex(18)

Howard Leight by Honeywell(18)

AbilityOne(1)

Jackson Safety*(1)

Boardwalk(1)

Color(s)

Yellow(16)

Green(6)

Orange(6)

Blue(5)

Random Color Patterns(4)

Yellow/Blue(4)

Purple(3)

Bright Green(3)

Magenta/Yellow(3)

Coral(3)

Yellow/Red(3)

Camo(2)

Purple/Bright Green(2)

Orange/Blue(2)

Blue/Yellow(1)

Neon Yellow(1)

Fluorescent Orange;Light Green(1)

Bright Green/Blue(1)

Blue/White(1)

Green/White(1)

Red/Yellow(1)

Country of Origin

US(53)

MX(12)

BR(2)

TW(2)

Material(s)

Foam(16)

Polyurethane Foam(15)

PVC(5)

Polyurethane(5)

PVC Foam(5)

Molded Rubberized Foam/Plastic(4)

Molded Rubberized Foam(4)

Foam/Plastic(2)

CMT Polymer(2)

Molded Foam/Plastic(2)

Polyvinyl Chloride(1)

PVC/EPDM/Polypropylene(1)

TPE(1)

Elastomeric Polymer(1)

Molded Foam(1)

Polyurethane Foam; Brass(1)

Polyurethane Foam With Encased Metal Ball(1)

ABS/Polyurethane(1)

Rubberized Molded Foam/Plastic(1)

Shape

Flanged(14)

Tapered(12)

Bullet(11)

Cylinder(9)

T(7)

Bell(5)

Pod(4)

Cylindrical(1)

Supra-Aural Pod(1)

Tapered Cylindrical(1)

Band with Pod(1)

Cone(1)

Multi-Flange(1)

Size Group

One Size Fits All(44)

Regular(9)

One Size Fits Most(6)

Large(4)

Small(2)

Noise Reduction Rate (NRR)

33 dB(25)

25 dB(10)

29 dB(8)

27 dB(8)

32 dB(7)

28 dB(4)

30 dB(4)

20 dB(1)

26 dB(1)

31 dB(1)

Noise Protection

Yes(2)

Corded/Cordless

Corded(37)

Cordless(19)

Uncorded(11)

Banded(2)

Special Features

PlugStation Dispenser(3)

Leight Source 500 Refill(3)

Blue Grips/Cords(2)

Blue Cords/Carry Cases(1)

Red Polycord(1)

Safety cord helps prevent loss-One pair per polybag.(1)

Paired.(1)

One pair per Pillow PakT(1)

Blue/White(1)

Green/White(1)

White Nylon Cords(1)

SuperFit 33(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved