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

Currently Filtered by

Category

Pliers And Cutters

Refine Search

  GO
 
Brand

RIDGID(15)

H.K. Porter(7)

Klein Tools(5)

CHANNELLOCK(3)

Imperial(3)

KNIPEX(2)

Guardair(1)

IRWIN(1)

 
Manufacturer Part Number

326BULK(1)

30088(1)

14213(1)

14218(1)

14223(1)

14228(1)

14233(1)

14238(1)

31642(1)

7101200(1)

32820(1)

32825(1)

32840(1)

32870(1)

32915(1)

33055(1)

33175(1)

8801250(1)

D2489ST(1)

337BULK(1)

0990T(1)

480BULK(1)

100K25(1)

0190MC(1)

0290MC(1)

0390MC(1)

0590MC(1)

1490MC(1)

D20009ST(1)

2690GP(1)

312FC(1)

S75046(1)

TC1000SP(1)

63041(1)

63060(1)

D20007CST(1)

2078306(1)

 
Country of Origin

US(26)

CN(7)

DE(3)

TW(1)

 
Weight

0.57 lb(1)

3.81 lb(1)

11.3 lbs(1)

5.25 lbs.(1)

1 lb(1)

8.8 oz.(1)

.63 lb(1)

1.09 lbs(1)

0.74 lbs.(1)

3.375 lbs.(1)

5.875 lbs.(1)

13.5 lbs.(1)

 
Tool Type

Bolt Cutters(12)

Tube Cutter(9)

Ironworker's Pliers(3)

Diagonal Cutters(2)

Tongue-and-Groove Pliers(2)

Strap Cutters(2)

Needle-Nose Pliers(1)

Gasket Cutter Kit(1)

Cutter Wheels(1)

Tube Cutters(1)

Cable & Wire Rope Cutters(1)

Ratcheting Cable Cutter(1)

Tube Cutter Wheel(1)

 
Mechanism

Screw(8)

Toggle Joint(7)

Lap Joint(5)

Bolt/Pinset-Nut Pivot Joint(3)

Internal Cam Joint(3)

Enclosed Rivet-Pivot Joint(1)

PermaLock Tongue-and-Groove(1)

Lever Action Toggle Joint(1)

Thrust-Bearing Feed(1)

Ratchet(1)

Lever Action Joint(1)

Box Joint(1)

Ratcheting(1)

 
Jaw Material

Steel(18)

Tool Steel(4)

Cast Iron(4)

High-Carbon C1080 Steel(3)

Chrome Vanadium Steel(2)

Steel/Aluminum(1)

Aluminum(1)

Chromium-Vanadium Steel(1)

 
Tool Length

24"(2)

30"(2)

42"(2)

14"(2)

6.1"(1)

9 3/8"(1)

38"(1)

26"(1)

19"(1)

9.84"(1)

7.87"(1)

9 3/16"(1)

25 1/2"(1)

9 1/4"(1)

10"(1)

7"(1)

5"(1)

5 1/2"(1)

9"(1)

36"(1)

20 1/4"(1)

6"(1)

 
Cut Type(s)

Straight(19)

Shear(8)

Beveled(3)

Diagonal(1)

Center; Straight(1)

Compression(1)

 
Cut Direction(s)

In-Line With Tool(32)

 
Jaw Length

13/16"(2)

2.08"(1)

0.79"(1)

3"(1)

1 1/2"(1)

1 1/8"(1)

1 9/32"(1)

1 19/32"(1)

 
Replacement Cutter Wheel

0113C(1)

S75015; S75046(1)

E-1240(1)

E-3469(1)

 
Finish

Red/Black(7)

Black Oxide(5)

Black Oxide/Red(4)

Red(4)

Electrocoat(3)

Red/Black Oxide(3)

Gray(2)

Chrome/Blue(1)

Nickel-Chrome(1)

Gray/Polished(1)

Aluminum(1)

Dull Satin(1)

 
Handle Material

Tubular Steel(12)

Plastic-Dipped Steel(5)

Cast Iron(4)

High-Carbon C1080 Steel(3)

Steel(3)

Aluminum(2)

Chrome Vanadium Steel(2)

Plastic(1)

Fiberglass(1)

TPR-Covered Steel(1)

 
Handle Type

Black Rubber-Covered Grips(5)

Screw-Knob(4)

T-Handle(4)

CHANNELLOCK BLUE Grips(3)

Black Vinyl Grips(3)

Black Plastic Grips(3)

Red Plastic Grips(2)

Blue Plastic Grips; Hook-Bend(2)

Rubber Hand-Grips(1)

Blue Twist-Grip Axel(1)

Vinyl Grips(1)

Nonslip-Finger-Formed Grips(1)

Plastic Coated(1)

Red Rubberized Grips(1)

Scissor Lever(1)

ProTouch Grips(1)

 
Opening Size

1/2"(2)

5 1/2"(1)

5/8"(1)

3/8"(1)

7/16"(1)

3/4"(1)

3/16"(1)

2" x 0.05"(1)

1 5/8"(1)

1 1/4"(1)

1 3/8"(1)

0.24"(1)

2"(1)

9/16"(1)

11/16"(1)

 
Lock Type

12-Point Tongue-and-Groove(1)

Spring Clip(1)

9-Point Dual-Guide Box Joint(1)

 
Cutting Capacity

1/8" to 2"(2)

7/16"(2)

3/8"(2)

5/16" Brinell 300/Rockwell C31; 7/16" Brinell 455/Rockwell C48(1)

0.2"(1)

1/8" to 1"(1)

3/4" to 2"(1)

2" to 4"(1)

1/4" to 2 5/8"(1)

1/2" to 2 3/8"(1)

9/16"(1)

400 MCM(1)

25/32"(1)

500 MCM(1)

1/8" to 1 1/8"(1)

1/4" to 1 5/8"(1)

2" x 0.05"(1)

3/16"(1)

3/4" Wide(1)

1/2"(1)

1/4" to 2 3/8"(1)

 
 
 

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