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

Currently Filtered by

Category

Apparel

Refine Search

  GO
 
Brand

KleenGuard(46)

KleenGuard*(31)

DuPont(27)

ergodyne(22)

Boardwalk(14)

MCR Safety(9)

Anchor Brand(8)

AmerCareRoyal(6)

Medline(4)

3M(4)

Champion Sports(2)

Fibre-Metal by Honeywell(2)

Royal(2)

Comeaux(1)

Atlantis Plastics(1)

Creativity Street(1)

Baumgartens(1)

OccuNomix(1)

 
Color(s)

White(103)

Blue(25)

Lime(14)

Yellow(9)

Orange(9)

Denim Blue(3)

Fluorescent Lime w/Silver Stripe(3)

Black(2)

Gray(2)

Lime Green/Silver(2)

White/Blue(2)

Assorted(1)

Bright Orange/Lime;Silver Reflective Strips(1)

Assorted;Assorted Bright Color Design(1)

Gold(1)

Red Western(1)

Green(1)

Orange/Silver(1)

Dark Brown(1)

 
Manufacturer Part Number

90002XL(1)

45024(1)

44452(1)

44481(1)

44490(1)

44494(1)

45003(1)

45004(1)

45005(1)

45023(1)

45025(1)

44443(1)

45026(1)

45094(1)

45095(1)

45096(1)

45355(1)

45356(1)

45357(1)

46002(1)

44445(1)

44336(1)

46103(1)

42528(1)

36880(1)

36885(1)

36890(1)

36920(1)

38938(1)

38939(1)

38941(1)

42526(1)

44304(1)

44335(1)

44313(1)

44314(1)

44316(1)

44317(1)

44323(1)

44324(1)

44325(1)

44333(1)

44334(1)

46005(1)

46105(1)

36811(1)

4520BLKXL(1)

58535(1)

58537(1)

CRI2002(1)

NON24248(1)

NON24355(1)

NON24356(1)

4520BLKL(1)

4520BLKM(1)

4520BLKXXL(1)

58523(1)

SBR100(1)

DA2442(1)

DA2846(1)

RCC2W(1)

RCH10(1)

RP110NW(1)

RPH144LTDBPK(1)

RPH144LTWPK(1)

SCH7(1)

58524(1)

58505(1)

46115(1)

48964(1)

46117(1)

46123(1)

46124(1)

46125(1)

46126(1)

46127(1)

48962(1)

48963(1)

48975(1)

58504(1)

48976(1)

48977(1)

49006(1)

49007(1)

49114(1)

49115(1)

49116(1)

49117(1)

49125(1)

36870(1)

36550(1)

90003XL(1)

VCL2SLXL2(1)

2000R714PK(1)

9378TE(1)

CL2LCL(1)

CL2LCM(1)

CL2LCXL(1)

V201R(1)

VCL2SLL(1)

VCL2SLXL(1)

NP1BL(1)

H42XL(1)

NP1GD(1)

FC450S(1)

FC454S(1)

IC501BWB(1)

NG120SL(1)

NG127SNP2X(1)

QC127S2XL(1)

TM127S-2XL(1)

TM127S-3XL(1)

5207(1)

H42M(1)

TY120S3XL(1)

00030(1)

90004XL(1)

9000L(1)

9000XL(1)

90102XL(1)

9010XL(1)

AR100(1)

2BBCZF(1)

64620(1)

00031L(1)

DAK2855(1)

00031XL(1)

00032L(1)

00032S(1)

00032XL(1)

00035(1)

00036(1)

0032XXL(1)

390(1)

BC924(1)

TY120S2XL(1)

TY120SL(1)

36214(1)

22013(1)

20977(1)

20979(1)

21055(1)

21057(1)

21063(1)

21065(1)

21067(1)

21125(1)

22015(1)

20973(1)

22017(1)

22023(1)

22025(1)

22027(1)

FM68(1)

FM69(1)

10039(1)

23610(1)

23873(1)

20975(1)

20967(1)

TY120SM(1)

TY127S3XL(1)

TY120SXL(1)

TY122S2XL(1)

TY122SL(1)

TY122SXL(1)

TY125S2XL(1)

TY125S4XL(1)

TY125SL(1)

TY127S2XL(1)

TY127SL(1)

20965(1)

TY127SXL(1)

TY212SL(1)

TY212S-XL(1)

TY450S(1)

TY500S(1)

12305(1)

12420(1)

20040(1)

20963(1)

VCL2SLX4(1)

 
Country of Origin

CN(77)

MX(48)

ID(22)

VN(21)

US(7)

VI(3)

LK(2)

HK(1)

TW(1)

 
Width

30"(1)

 
Material(s)

MICROFORCE* Barrier SMS Fabric(27)

High-Density Polyethylene(21)

Polyester(20)

Polypropylene(13)

Polyester Mesh(11)

Microporous Film Laminate(10)

SMS-Based Material(10)

PVC/Polyester(7)

Breathable Microporous Film Laminate(6)

Cotton(5)

Nylon(5)

Film Laminate(4)

Spun-Bonded Polypropylene/Breathable Microporous Film Laminate(3)

Polyethylene(3)

Tissue Poly Tissue (Tpt)(3)

Paper(2)

Tempro Fabric(2)

Spun-Bonded Polypropylene(2)

Microporous Film Laminate; SMS(2)

MICROFORCE Barrier SMS fabric(2)

Breathable, patented MICROFORCE* barrier SMS fabric(2)

MICROFORCE* Barrier SMS Fabric(2)

Crepe Paper(1)

Polyetheline(1)

Tyvek FC Fabric(1)

Plastic(1)

Tyvek Flashspun Polyethylene(1)

Kevlar(1)

Hycar(1)

Microporous Film Laminate/Polypropylene(1)

Vinyl(1)

 
Length

16 in(1)

18 in(1)

21"(1)

10 in(1)

7"(1)

 
Size Group

2X-Large(28)

One Size Fits All(28)

Large(27)

X-Large(27)

3X-Large(13)

4X-Large(11)

Medium(7)

2XL/3XL(4)

L/XL(4)

S/M(4)

Large/X-Large(3)

30 in. x 42 in.(2)

2X-Large/3X-Large(2)

One Size Fits Most(2)

One Size(2)

Standard(2)

24 in.(2)

Size 7 1/4 in.(1)

Regular Size(1)

XXL(1)

Small/Medium(1)

Small(1)

Large (20")(1)

4X-Large/5X-Large(1)

X-Large/2X-Large(1)

30 in. x 21 in.(1)

Children's(1)

XX-Large(1)

21 in.(1)

 
Suggested Use

Laboratories; Decontamination Modesty Garment; Remediation; Pesticides; Heavy Dust Environments(8)

Food Service(8)

Food Handling; Maintenance(6)

Food Service; Laboratories; Liquid, Particle Protection; Maintenance; Manufacturing(6)

Fiberglass Manufacturing; Tank Cleaning; Utilities; Liquid Handling; Pressure Washing; Maintenance; General Manufacturing(5)

Pharmaceutical Research; Dry Particle Contamination; Aerospace; Maintenance; General Manufacturing(4)

Asbestos Abatement and Inspection; Exposure to Radioactive Particles; Lead Abatement; Mold Remediation/Mold Spores; Animal Waste (Solid); Fertilizer Application (Dry/Granular); Pesticide Application (Dry/Granular); Dirt (General); General Industrial Clean-up and Processing; Grease (General); Light-duty Building Cleaning; Machine or Vehicle Maintenance; Coal Dust; Electronics/Ciruit Board Assembly; Fiberglass/Cellulose Insulation Installation; Food Processing; General Industrial Clean-up and Processing; General Powder Handling; Lime Handling; Warehousing; Woodworking; Non-hazardous Aerosols (Sprays); Non-hazardous Liquids; Non-hazardous Solids; Metal particulate (chromium beryllium, and more); Metal Polishing(4)

Safety & Visibility(4)

Animal Research; Emergency Medical Response; Crime Scene Cleanup; Embalming / Forensics; Tank Cleaning; Fiberglass Manufacturing; Liquid Handling; Food Processing(3)

Maintenance; Manufacturing(3)

Surface Prep Areas; Paint Application Areas(3)

Aerospace; Maintenance; Manufacturing; Pharmaceutical Research(3)

Liquid Handling; Pressure Washing; Maintenance; General Manufacturing(3)

Fuel Depots/Stations; Laboratories; Maintenance; Manufacturing; Pesticide/Herbicide Application(3)

Maintenance; Manufacturing; Pharmaceutical Research(2)

Labs; Pesticide Spraying; Manufacturing(2)

Fuel Depots/Stations;Maintenance;Manufacturing(2)

Foodservice; Hospitals; Institutions(2)

Wind Blade Manufacturing; Maintenance; General Manufacturing(2)

Laboratories; Maintenance; Manufacturing; Refining(2)

Food Processing; Maintenance(2)

Food Service;Hospitals;Laboratories;Manufacturing(2)

Clean Rooms;Food Service;Laboratories;Manufacturing;Medical Facilities(2)

Railway; Construction; Utility Workers; Survey Crews(2)

Fiberglass Manufacturing;Tank Cleaning;Liquid Handling; Pressure Washing; General Manufacturing(1)

Food Service; Hospitals; Laboratories; Manufacturing(1)

Hospitals; Laboratories; Manufacturing; Food Service(1)

Fuel Depots/Stations; Maintenance; Manufacturing(1)

Cut Protection(1)

Biotech; Pharmaceutical; Medical Device Manufacturing; Electronics Industries(1)

Food Processing; Manufacturing(1)

Liquid, Particle Protection; Maintenance; Manufacturing(1)

Laboratories; Decontamination Modesty Garment; Remediation; Pesticides;Heavy Dust Environments(1)

Food Processing; General Maintenance; Manufacturing(1)

Food Service;Laboratories;Maintenance;Manufacturing(1)

Hospitals;Laboratories;Maintenance;Manufacturing(1)

Fiberglass Manufacuring; Tank Cleaning; Utilities; Liquid Handling; Pressure Washing; Maintenance; General Manufacturing(1)

Fiberglass Manufacturing(1)

Welding(1)

Manufacturing; Cleaning; Handling Liquids(1)

Art;Crafts;Elementary Schools;Recreation Centers(1)

Chemistry; Janitorial; Maintenance; Manufacturing(1)

 
Washable

No(61)

Yes(46)

 
Apparel Type

Coverall(70)

Vest(32)

Coveralls(17)

Headwear(14)

Apron(8)

Rainsuit(5)

Shoe Cover(5)

Lab Coat(5)

Footwear(3)

Coat(3)

Protective Sleeve(3)

Raincoat(2)

Shoe Covers(2)

Gown(2)

Sleeve(1)

Artist Smock(1)

Cooling Towel(1)

Beard Net(1)

Jacket(1)

Shirt(1)

Boot Cover(1)

Hood(1)

Caps(1)

Disposable Bibs(1)

Cape(1)

 
Batteries Included

No(3)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved