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

Currently Filtered by

Category

Eye Care And Protection

Refine Search

  GO
 
Brand

Honeywell Uvex(19)

Honeywell(17)

Crews(15)

Harley-Davidson(3)

Guardian(2)

3M(2)

Boardwalk(1)

PhysiciansCare by First Aid Only(1)

First Aid Only(1)

MSA(1)

Pac-Kit(1)

 
Height

14"(2)

17.5"(1)

26"(1)

24"(1)

15"(1)

4"(1)

30"(1)

20 1/2"(1)

90"(1)

13 1/2"(1)

 
Depth

4.5"(2)

3.75"(1)

19.5"(1)

19.75"(1)

11"(1)

14"(1)

17 1/4"(1)

20"(1)

9"(1)

3 3/4"(1)

 
Quantity

12 per box(4)

20 per carton(1)

100 per carton(1)

1 each(1)

 
Packing Type

Bottle(9)

Cartridge(3)

Carton(1)

 
Manufacturer Part Number

54842(1)

S1369(1)

320011000000(1)

G1540(1)

G1902P(1)

HD502(1)

HD700(1)

HD702(1)

132500000020(1)

TGV01100(1)

697514(1)

24102(1)

S1112(1)

S1179(1)

S135(1)

S1604(1)

320010000000(1)

S1900(1)

S213(1)

S2500C(1)

S3201(1)

S3203(1)

S3207(1)

S3209(1)

S3240(1)

S3300(1)

S39610C(1)

S4411(1)

S535(1)

S536(1)

320010500000(1)

320005130000(1)

2410F(1)

T411R(1)

98150(1)

CL119(1)

F2110(1)

KD113(1)

LCS1(1)

S2110AF(1)

S21150(1)

ST112AF(1)

ST1130(1)

ST1150(1)

T311R(1)

T4112AF(1)

T411G(1)

7006(1)

3200046200CT(1)

FAE6011(1)

320002000000(1)

320002300000(1)

320004000000(1)

320004010000(1)

320004520000(1)

320004520CT(1)

320004540000(1)

320004540CT(1)

320004550000(1)

3200045500EA(1)

320004610000(1)

3200046100EA(1)

S6900(1)

 
Country of Origin

US(40)

TW(17)

CA(3)

CN(3)

 
Width

13"(3)

19"(2)

10.75"(1)

19.5"(1)

29"(1)

22"(1)

9"(1)

16 1/2"(1)

 
Material(s)

Vinyl; Foam(1)

Polycarbonate/Elastomer/Neoprene(1)

 
For Use With

32-000455-0000-H5(4)

32-000513-0000-H5(2)

Fendall Flash Flood Eyewash Stations 32-000400-0000, 32-000400-0022(1)

 
Capacity (Volume)

32 oz(5)

16 oz(4)

4 oz(3)

16 gal(3)

1 gal(2)

1 oz(1)

180 oz(1)

7 Gal(1)

3 1/2 gal(1)

8 oz(1)

1.8 gallons(1)

 
Style

Wraparound(26)

Squared-Lens(3)

Replacement Lens(2)

Indirect Vented(1)

Wraparound Lens(1)

Half-frame(1)

Frameless(1)

Flip-Up(1)

Curved(1)

Vented(1)

Framless;Wraparound(1)

 
Size Group

One Size(21)

One Size Fits Most(1)

Standard(1)

 
Mounting

Wall(8)

Wall Mountable(1)

Wall;Counter(1)

Floor(1)

 
Description

Eye Wash Solutions(5)

Buffered eyewash saline solution in a convenient and portable 4 oz bottle.(2)

Buffered eyewash saline solution in a convenient and portable 16 oz bottle.(2)

4 oz Bottle(1)

12" x 10" x 13"(1)

Eyewash cartridge providing purified, buffered saline solution for full 15 minutes of flushing.(1)

 
Lens Material

Polycarbonate(36)

Plastic(1)

 
Lens Tint

Clear(15)

Gray(8)

Green(3)

Fire(2)

Mirror(2)

Indoor/Outdoor(1)

Light Blue(1)

Green 3.0(1)

Emerald(1)

Brown Mirror(1)

Clear/Shade 5.0 Flip-Up(1)

Espresso(1)

Green 3.0; Infra-Dura(1)

 
Lens Coating/Filter

Ultra-Dura(6)

Anti-Scratch; Hard Coat(5)

Duramass Scratch-Resistance(4)

Hard Coat(4)

Duramass Scratch-Resistant(3)

Anti-Fog(3)

Ultra-Dura Hard Coat(2)

Anti-Scratch/Anti-Fog(1)

Duramass Scratch-Resistant Coating(1)

Anti-Fog;Anti-Scratch(1)

Uncoated(1)

Tuff-Stuff Anti-Scratch(1)

Ultra-Dura Scratch-Resistant Coating(1)

Anti-Scratch(1)

Uvextreme/Anti-Fog/Anti-Scratch/Anti-Static(1)

Ultra-Dura Anti-Scratch Coating(1)

 
Adjustability Features

Strap(2)

 
Coated Lenses

Yes(2)

 
Side Protection

Yes(2)

 
Diopter Strength

5(3)

 
Frame Color

Black(15)

Clear(3)

Silver(3)

Gunmetal Matte(2)

Green(1)

Frost Black(1)

Black Matte(1)

Chrome(1)

Brass(1)

Platinum(1)

Silver Matte(1)

Teal(1)

Red/White/Blue(1)

Blue-Vapor(1)

Metallic Red/Silver(1)

 
Frame Material

Nylon(17)

Metal(5)

Polycarbonate(4)

Metal/Nylon(3)

Plastic(1)

Duoflex(1)

PVC(1)

 
Fits

Over Glasses(1)

 
Wall-Mountable

No(1)

 
Frame Finish

Gray(1)

Teal(1)

 
Antifog

No(1)

Yes(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved