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

Currently Filtered by

Category

Staples

Refine Search

  GO
 
Brand

Swingline(18)

Bostitch(12)

Rapid(9)

Arrow(4)

MAX(4)

Stanley(3)

Universal(2)

 
Color(s)

Steel(51)

Assorted(1)

 
Manufacturer Part Number

1901(1)

35440(1)

73158(1)

90003(1)

90220(1)

35108(1)

35123(1)

35312(1)

35314(1)

35318(1)

35319(1)

35320(1)

35450(1)

11830700(1)

35550(1)

35556(1)

35665(1)

50050(1)

50051(1)

69495(1)

79392(1)

79398(1)

90009(1)

79000(1)

5000594(1)

02904(1)

1913(1)

STCR130XHC1M(1)

1962(1)

225(1)

504(1)

505(1)

50824(1)

SB351/21M(1)

SB351/25M(1)

SB35PHD-5M(1)

SB38HD-1M(1)

SBS1914CP(1)

STCR21153/8(1)

02903(1)

STCR75XHC1M(1)

STCRP211514(1)

TRA704T(1)

TRA706T(1)

TRA708T(1)

50-FE(1)

NO11-1M(1)

NO1180(1)

NO-70-FE(1)

02897(1)

02900(1)

79000VP(1)

 
Country of Origin

CN(32)

US(7)

TW(7)

JP(4)

SE(2)

 
Material

Steel(51)

 
For Use With

Standard Full-Strip Staplers(7)

Rapid 02892(4)

Arrow T50 Staplers(3)

Stanley TR150(3)

Swingline 39(2)

Bostitch 00540, B310HDS, 03201(2)

Bostitch B8 Staplers(2)

Standard Half-Strip Staplers(2)

GBC 224XHD, 390, 415; Swingline 900XD(1)

Bostitch 03201; Boston 73131; GBC 224XHD, 213HD; Rapid HD170, 90E, 100E; Swingline 113XD, 900XD, 13-16, 390, 414(1)

Bostitch 03201, 00540, B310HDS; Boston 73131; GBC 224HXD, 213HD; Swingline 113XD, 900XD, 13-16, 390(1)

Swingline 33801, 33811(1)

Swingline 900XD; GBC 224XHD; Bostitch 00540(1)

Swingline 77701, 77715, 87875, 48210(1)

Swingline 520e, 690e, 790, Zephyr, 5000 Series(1)

Swingline 502e(1)

Swingline 270(1)

Bostitch 00540, B310Hds; Boston 73131; GBC 224XHD, 213HD; Swingline 113XD, 900XD, 13-16, 390, 415; Universal 43043(1)

Rapid Supreme Omnipress SO60(1)

Rapid 5080e(1)

Rapid S50, K1, K2, R90E(1)

Rapid 5050e(1)

PaperPro 1300(1)

Rapid M2OU, MS610(1)

Max EH-70F(1)

Max Vaimo 80 Stapler(1)

Max EH-50F(1)

Bostitch B875(1)

Bostitch B8130(1)

Bostitch B380HD(1)

Bostitch PHD-60(1)

PaperPro 1200, 1210(1)

Swingline 90010(1)

 
Sheet Capacity

25(6)

30(4)

60(4)

120(3)

90(3)

20(3)

40(3)

70(3)

50(3)

80(2)

160(1)

55(1)

28(1)

100(1)

75(1)

45(1)

130(1)

180(1)

65(1)

210(1)

 
Leg Length

0.25"(18)

0.38"(11)

0.5"(8)

0.31"(7)

0.88"(1)

0.41"(1)

0.47"(1)

0.3"(1)

0.75"(1)

0.94"(1)

0.63"(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved