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

Currently Filtered by

Category

Punch Heads

Refine Search

  GO
 
Brand

Swingline(12)

Sparco(3)

CARL(3)

Business Source(3)

Rapesco(2)

 
Color

Silver(8)

Black(5)

Gray(1)

 
Recycled

No(23)

 
Packaged Quantity

1 Each(8)

1 Set(6)

9 / Set(2)

6 / Set(2)

3 / Set(2)

1 / Kit(1)

6 / Pack(1)

3 / Pack(1)

 
Assembly Required

No(23)

 
Limited Warranty

1 Year(5)

 
Weight (Approximate)

1.50 lb(1)

 
Compatibility

Swingline High Capacity Adjustable Punch A7074650(1)

Swingline High Capacity Heavy Duty Punch A7074550(1)

Swingline Accented/Lever Handle Heavy Duty Punch:

  • A7074400
  • A7074350
(1)

Swingline LightTouch Heavy Duty Punch A7074357(1)

Swingline ProFile Desktop Punch A7074070(1)

Swingline Extra Heavy Duty 2-Hole Punch A7074190(1)

Swingline Extra Heavy Duty 2-Hole Punch A7074192(1)

Swingline Extra Heavy Duty 3-Hole Punch A7074194(1)

Swingline Lever Handle Heavy Duty Punches:

  • A7074400
  • A7074350
(1)

Fits - SWI74650 Paper Punch

(1)

Fits - SPR 01328 Paper Punch

(1)

Rapesco Hole Punch P3100(1)

Rapesco Hole Punches:

  • P3100
  • P1100
  • P2200
(1)

Sparco SPR06525 Hole Punch(1)

Sparco Heavy-duty Two-hole Punch(1)

Swingline® Easy Touch® Heavy Duty Punches:

  • A7074300
  • A7074250
  • A7074150
(1)

Swingline® 2 - 4 Hole Heavy Duty Punches:

  • A7074450
  • A7074440
(1)

Carl XHC-2100 Paper Punch(1)

 
Recycled Content

0%(19)

 
Punch Size

0.28"(16)

0.34"(2)

0.25"(1)

 
Manufacturer Part Number

A7074871(1)

A7074867(1)

A7074866(1)

A7074857B(1)

A7074872(1)

A7074873(1)

A7074889(1)

A7074888(1)

A7074887(1)

A7074876(1)

A7074855(1)

A7074854(1)

60005(1)

60004(1)

62894(1)

55550(1)

60006(1)

1294(1)

39281(1)

06526(1)

01531(1)

1295(1)

16509(1)

 
Country of Origin

China(15)

Taiwan(5)

Japan(3)

 
Height

2.6"(1)

 
Width

3.1"(1)

 
Depth

3.1"(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved