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

Currently Filtered by

Category

Work Gloves

Refine Search

  GO
 
Brand

Memphis(16)

Anchor Brand(4)

AnsellPro(4)

Mechanix Wear(2)

MCR Safety(2)

Honeywell(1)

MAPA(1)

 
Color(s)

Blue(5)

White/Gray(3)

Blue Striped/White(3)

Black(2)

White(2)

Gray(2)

Pearl Gray; Striped Back(1)

Cream(1)

Blue/White(1)

Brown(1)

Beige/White(1)

White/Red(1)

Red/Blue Striped/Tan(1)

Red(1)

Yellow/Gray(1)

Green(1)

Gold/Green Stripe(1)

Black/Blue(1)

 
Quantity

1 dz(1)

 
Manufacturer Part Number

2150(1)

1950L(1)

9780L(1)

9688L(1)

9683M(1)

9124K(1)

9018C(1)

7800(1)

6820(1)

6218(1)

5330S(1)

5310(1)

4600(1)

3205L(1)

1936M(1)

3000(1)

1936L(1)

1935M(1)

1700L(1)

1200XL(1)

MG03009(1)

MG02011(1)

KV18A10050(1)

3715510CT(1)

321058(1)

198L9CT(1)

1180011(1)

CW777(1)

7400(1)

334949(1)

 
Country of Origin

CN(19)

MY(3)

MX(2)

VN(2)

PK(2)

TH(1)

LK(1)

 
Material(s)

Cowhide; Cotton(3)

Pigskin(2)

Cotton(2)

Nitrile(2)

Spandex; Rubber(2)

Leather; Cotton; Kevlar(1)

Nitrile; Cotton(1)

Cotton; Polyester; Latex(1)

Nitrile; Nylon(1)

Cotton Jersey(1)

Cotton Canvas; Latex(1)

PVC(1)

Nitrile; Flock(1)

Leather; Canvas(1)

Cowhide(1)

Leather(1)

Leather; Jersey Cotton(1)

Cotton; Leather(1)

Kevlar; Leather(1)

Nitrile; Fabric(1)

Latex(1)

Foam Nitrile; Fabric(1)

PVC; Jersey Cotton(1)

Neoprene; Fabric(1)

 
Length

13"(1)

18"(1)

 
Style

Work(25)

Welding(2)

Disposable(1)

Cut-Resistant(1)

Drivers'(1)

 
Thickness

5.9 mil(1)

15 mil(1)

11 mil(1)

18 mil(1)

 
Size Group

Large(14)

Men's(4)

Medium(4)

X-Large(3)

Size 10(2)

Size 11(1)

Size 8(1)

Size 11/2X-Large(1)

 
Wrist Style

Gauntlet(9)

Knit(9)

Safety(6)

Shirred(3)

Straight(2)

 
Thumb Style

Straight(7)

Wing(4)

Keystone(1)

 
Hand Specific

Pair(29)

Ambidextrous(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved