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

Currently Filtered by

Category

Hammers

Refine Search

  GO
 
Brand

Stanley Tools(22)

NUPLA(18)

Estwing(16)

Jackson(15)

PROTO(10)

Atlas Welding Accessories(8)

Ampco Safety Tools(5)

Armstrong Tools(3)

Vaughan(2)

Garland Manufacturing(2)

Great Neck(1)

Lenco(1)

 
Color(s)

Blue/Yellow/Steel(10)

Orange(7)

Black(4)

Black/Yellow(4)

Natural/Black(4)

Black/Natural(4)

Natural(3)

Carbon-Steel/Yellow/Black(3)

Red(2)

Blue(2)

Polished Steel/Blue(2)

Brass/Yellow/Black(1)

Black/Red(1)

Blue/Black(1)

Safety Red(1)

Yellow/Black(1)

Cream(1)

 
Diameter

1 1/2"(2)

2"(2)

 
Manufacturer Part Number

2002400(1)

2044600(1)

1199900(1)

1199800(1)

1199700(1)

2046300(1)

09120(1)

13120(1)

10063(1)

10045(1)

09505(1)

1199600(1)

1199300(1)

HG16C(1)

1149800(1)

31004(1)

11004(1)

T318(1)

1150000(1)

1150300(1)

1199100(1)

1197900(1)

1197400(1)

1197000(1)

15156(1)

15208(1)

1431DB(1)

1431G(1)

1430G(1)

1430DB(1)

1332PGD(1)

1432DB(1)

1432G(1)

WC12(1)

SDF48(1)

1435G(1)

1434G(1)

1316PGD(1)

30540(1)

27040(1)

27045(1)

27035(1)

27030(1)

21032(1)

27047(1)

27540(1)

30040(1)

29035(1)

27805(1)

27804(1)

T312(1)

E3WC(1)

51621(1)

54012(1)

51616(1)

WH40(1)

WH30(1)

54024(1)

54032(1)

56218(1)

56204(1)

54716(1)

54524(1)

WH10(1)

S30(1)

M2FG(1)

69515(1)

H72FG(1)

H70FG(1)

H4FG(1)

69517(1)

69532(1)

S20(1)

L(1)

H(1)

A(1)

56808(1)

56810(1)

E320S(1)

E322P(1)

E320BLC(1)

E316S(1)

E314P(1)

E322S(1)

E323LP(1)

E3R(1)

E340L(1)

E330SM(1)

E324BP(1)

B34LBL(1)

B33LB(1)

57532(1)

57533(1)

57531(1)

57530(1)

57522(1)

57534(1)

57540(1)

57594(1)

57554(1)

57552(1)

57550(1)

H3FG(1)

 
Country of Origin

US(79)

IN(8)

CN(6)

MX(5)

TW(4)

VN(1)

 
For Use With

NULPA IMPAX Hammers and Quick-Change Hammers(1)

Nupla Quick-Change Hammers(1)

Replaceable Tip For Nupla Quick-Change Hammer(1)

 
Type

Construction - Sledge(20)

Ball Pein(12)

Knife Edge(11)

Construction - Soft Face(9)

Brass(7)

Construction - Drilling(7)

Carpenter(7)

Construction - Dead Blow(7)

Geological(4)

Mallet(4)

Back-Out Punch(3)

Replacement Handle(3)

Replacement Face/Tip(2)

Tinner(2)

Cross Pein(2)

Engineer(2)

Rigger's Axe(1)

 
Finish

Black Oxide(5)

Gloss(4)

UV Coating(4)

Lacquered(4)

Oil(2)

 
Handle Material

Fiberglass(39)

Hickory(25)

Steel/Nylon-Vinyl(14)

Steel(11)

Urethane/Non-Ferrous Metal/Steel(6)

Wood(2)

Nuplaglas(1)

Graphite(1)

 
Handle Type

Straight(55)

Shock Reduction Grip(13)

Contoured Rubber Grip(7)

Coil(5)

Tapered(4)

Classic SG Grip(4)

Contoured(4)

Ergo-Power(3)

Classic CS Grip(1)

Bricklayer Grip(1)

Cushion Grip(1)

Tapered Fiberpro(1)

 
Head Type

Sledge(19)

Ball Pein(13)

Soft Face(7)

Dead Blow(6)

Double Face Sledge(6)

Mallet(5)

Dead Blow Mallet(5)

Carpenter(4)

Backing Out Punch(3)

Drilling/Engineer(3)

Cone/Chisel(3)

Tinner(2)

Slugging/Engineer's(2)

Engineer's(2)

Chisel/Cross Chisel(2)

Rock Pick(2)

Claw(2)

Cone/Cross Chisel(2)

Chisel/Brush(1)

Chipping(1)

Soft Brass(1)

Cross Pein/Sledge(1)

Cross Chisel/Pick(1)

Lineman(1)

Dead Blow Sledge(1)

Curved Claw(1)

Mason(1)

Pick/Mallet(1)

Axe/Hammer(1)

Cross Peen(1)

Cross Chisel/Mallet(1)

 
Handle Color

Yellow/Black(20)

Natural(11)

Blue/Yellow(10)

Blue(7)

Orange(7)

Black(4)

Yellow(4)

Brass(1)

Red(1)

Safety Red(1)

 
Handle Length

14"(11)

16"(7)

36"(6)

5"(4)

12"(4)

4"(3)

32"(2)

11"(2)

34"(2)

14 3/8"(1)

10 1/2"(1)

15 1/2"(1)

18"(1)

13 3/4"(1)

14 1/2"(1)

 
Head Width

6"(2)

6 3/4"(2)

5"(2)

1 1/2"(1)

5 3/4"(1)

2 7/16"(1)

1 7/8"(1)

2"(1)

3"(1)

1 3/4"(1)

2.1"(1)

7 3/4"(1)

6 1/2"(1)

8 1/4"(1)

1.6"(1)

4.125"(1)

1.8"(1)

2 1/2"(1)

 
Head Material

Steel(54)

High Carbon Steel(6)

Urethane/Non-Ferrous Metal(6)

Brass(5)

Steel/Rubber(3)

Rubber(3)

Rawhide(2)

Soft Brass(1)

Plastic(1)

Forged Steel(1)

 
 
 

© 2017-2018 Legal Name, All Rights Reserved