0

Banner1 Banner1
 
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_1` LIKE 'Office Supplies') AND (`category_2` LIKE 'Staplers & Punches') AND `pinfo`.`is_recycled` LIKE 'Y' 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 '%StaplersandPunches' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('StaplersandPunches' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+StaplersandPunches' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"StaplersandPunches"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"StaplersandPunches"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"StaplersandPunches"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"StaplersandPunches"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+StaplersandPunches' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='StaplersandPunches',`category_4` ='StaplersandPunches') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'StaplersandPunches,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('StaplersandPunches', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Staplers And Punches

Refine Search

  GO
 
Brand

Rapid(3)

MAX(3)

Bostitch(3)

Bostitch PaperPro(2)

Swingline(1)

Officemate(1)

 
Color(s)

Black(6)

Black/Gray(2)

Black/Gray/Green(1)

Red(1)

Slate Gray(1)

Ice Blue(1)

Blue(1)

 
Manufacturer Part Number

73110(1)

90115(1)

73140(1)

73159(1)

54501(1)

HD11FLKRD(1)

HD-11FLKBK(1)

B210-BLK(1)

1752(1)

B210RBLUE(1)

B210RGRAY(1)

HD11FLKBE(1)

1710(1)

 
Country of Origin

CN(6)

TH(3)

TW(2)

US(1)

SE(1)

 
Material(s)

Metal; Plastic(4)

Plastic; Metal; Rubber(3)

Plastic(3)

Recycled ABS Plastic/Metal(2)

Recycled ABS Plastic; Metal(1)

 
Length

16 15/16"(1)

 
Sheet Capacity

20(5)

35(3)

80(1)

15(1)

130(1)

30(1)

220(1)

 
Power Source(s)

Manual(10)

AC Adapter(1)

 
Throat Depth

2 1/2"(2)

3.63"(2)

2"(1)

4.5"(1)

 
Type of Staple Used

Standard(9)

Heavy-Duty(3)

 
Staple Loading

Top(9)

Front(2)

 
Replacement Staples

Bostitch SBS191/4CP(3)

MAX NO111M(3)

PaperPro 1901(2)

Rapid 90204, 90205(2)

Swingline 35108, 35450, 35556(1)

Rapid 90204, 90205, 09051(1)

 
Operating Method

Electric(1)

 
Number of Holes

2-3(1)

 
Clippings Receptacle

Removable Chip Tray(1)

 
Throat Reach

1/2"(1)

 
Cord Length

8 ft and 9"(1)

 
Stapler Type

High Capacity(2)

 
Staple Capacity

Full Strip (210 Staples)(5)

Half Strip (100 Staples)(3)

Cartridge (1,500 Staples)(1)

Half Strip (105 Staples)(1)

 
Batteries Required

No(2)

 
Batteries Included

No(2)

 
Punch Shape

Round(1)

 
Hole Diameter

9/32"(1)

 
Hole Size

9/32"(1)