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(39)

ergodyne(23)

DuPont(17)

Boardwalk(14)

MCR Safety(8)

AmerCareRoyal(6)

KleenGuard*(3)

Anchor Brand(2)

Medline(2)

Atlantis Plastics(1)

Baumgartens(1)

Creativity Street(1)

Champion Sports(1)

OccuNomix(1)

 
Color(s)

White(65)

Lime(14)

Blue(13)

Orange(9)

Yellow(3)

Fluorescent Lime w/Silver Stripe(3)

Denim Blue(3)

Orange/Silver(1)

Lime Green/Silver(1)

Assorted;Assorted Bright Color Design(1)

Bright Orange/Lime;Silver Reflective Strips(1)

Gold(1)

Gray(1)

Camo(1)

Red Western(1)

Dark Brown(1)

 
Manufacturer Part Number

90002XL(1)

38941(1)

44335(1)

44334(1)

44333(1)

44325(1)

44324(1)

44323(1)

44317(1)

44316(1)

44314(1)

44305(1)

44304(1)

44303(1)

38939(1)

44445(1)

38938(1)

36920(1)

36885(1)

36811(1)

36550(1)

23610(1)

22027(1)

22025(1)

22023(1)

22017(1)

22015(1)

22013(1)

44336(1)

44481(1)

21067(1)

48977(1)

RPH144LTDBPK(1)

RP110NW(1)

RCC2W(1)

DA2846(1)

DA2442(1)

SBR100(1)

NON24355(1)

CRI2002(1)

58537(1)

58535(1)

58505(1)

49116(1)

48976(1)

44490(1)

48975(1)

46002(1)

45356(1)

45355(1)

45096(1)

45095(1)

45094(1)

45026(1)

45005(1)

45004(1)

45003(1)

44494(1)

21125(1)

21065(1)

90102XL(1)

DAK2855(1)

NP1GD(1)

VCL2SLXL2(1)

VCL2SLXL(1)

VCL2SLL(1)

V201R(1)

CL2LCXL(1)

CL2LCM(1)

CL2LCL(1)

9378TE(1)

5207(1)

H42XL(1)

H42M(1)

BC924(1)

NG120SL(1)

390(1)

0032XXL(1)

00036(1)

00035(1)

00032XL(1)

00032S(1)

00032L(1)

00031XL(1)

00031L(1)

00030(1)

64620(1)

2BBCZF(1)

FC450S(1)

TY120S2XL(1)

21063(1)

12304(1)

21057(1)

21055(1)

20979(1)

20977(1)

20975(1)

20973(1)

20967(1)

20965(1)

20963(1)

20040(1)

12420(1)

12305(1)

TY500S(1)

TY120S3XL(1)

TY450S(1)

TY127SXL(1)

TY127SL(1)

TY127S3XL(1)

TY127S2XL(1)

TY125SL(1)

TY125S2XL(1)

TY122SXL(1)

TY122SL(1)

TY122S2XL(1)

TY120SXL(1)

TY120SL(1)

RPH144LTWPK(1)

 
Country of Origin

CN(53)

MX(23)

ID(21)

VN(16)

US(2)

LK(2)

HK(1)

VI(1)

 
Material(s)

Polyester(19)

High-Density Polyethylene(16)

Polypropylene(13)

Polyester Mesh(11)

Microporous Film Laminate(8)

MICROFORCE* Barrier SMS Fabric(6)

Breathable Microporous Film Laminate(6)

Nylon(4)

Film Laminate(4)

Polyethylene(3)

SMS-Based Material(3)

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

Cotton(3)

MICROFORCE* Barrier SMS Fabric(2)

Breathable, patented MICROFORCE* barrier SMS fabric(2)

PVC/Polyester(2)

Spun-Bonded Polypropylene(2)

Plastic(1)

Microporous Film Laminate/Polypropylene(1)

Kevlar(1)

Vinyl(1)

Tissue Poly Tissue (Tpt)(1)

Polyetheline(1)

Crepe Paper(1)

 
Size Group

One Size Fits All(22)

2X-Large(18)

Large(16)

X-Large(15)

3X-Large(9)

2XL/3XL(4)

S/M(4)

L/XL(4)

4X-Large(3)

Large/X-Large(3)

Medium(3)

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

24 in.(2)

Standard(2)

Children's(1)

One Size(1)

Small(1)

Small/Medium(1)

Regular Size(1)

XXL(1)

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

X-Large/2X-Large(1)

30 in. x 42 in.(1)

21"(1)

Large (20")(1)

 
Suggested Use

Food Service(6)

Food Handling; Maintenance(6)

Safety & Visibility(4)

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

Surface Prep Areas; Paint Application Areas(3)

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

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

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

Foodservice; Hospitals; Institutions(2)

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

Maintenance; Manufacturing(2)

Manufacturing; Cleaning; Handling Liquids(2)

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

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

Food Service;Hospitals;Laboratories;Manufacturing(2)

Food Processing; Maintenance(2)

Food Service; Hospitals; Laboratories; Manufacturing(1)

Fuel Depots/Stations;Maintenance;Manufacturing(1)

Labs; Pesticide Spraying; Manufacturing(1)

Hospitals; Laboratories; Manufacturing; Food Service(1)

Cut Protection(1)

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

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

Hospitals;Laboratories;Maintenance;Manufacturing(1)

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

Fiberglass Manufacturing(1)

Food Processing; General Maintenance; Manufacturing(1)

Welding(1)

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

 
Washable

Yes(37)

No(35)

 
Apparel Type

Coverall(40)

Vest(30)

Headwear(10)

Coveralls(9)

Apron(7)

Shoe Cover(5)

Protective Sleeve(2)

Shoe Covers(2)

Lab Coat(2)

Footwear(2)

Rainsuit(1)

Caps(1)

Cooling Towel(1)

Sleeve(1)

Coat(1)

Raincoat(1)

Artist Smock(1)

Beard Net(1)

Disposable Bibs(1)

Gown(1)

 
 
 

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