SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('277')) 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_cost`=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 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(19)

Bostitch(12)

Rapid(10)

MAX(5)

Arrow(4)

Stanley(3)

Universal(2)

AbilityOne(1)

Color(s)

Steel(52)

Silver(2)

Assorted(1)

Country of Origin

CN(33)

TW(7)

US(7)

JP(5)

SE(4)

Material

Steel(54)

For Use With

Standard Full-Strip Staplers(8)

Rapid 02892(4)

Arrow T50 Staplers(3)

Stanley TR150(3)

Bostitch 00540, B310HDS, 03201(2)

Swingline 39(2)

Bostitch B8 Staplers(2)

Standard Half-Strip Staplers(2)

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

Rapid 5080e(1)

Swingline 90010(1)

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

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

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

Swingline 502e(1)

Swingline 270(1)

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

Swingline 33801, 33811(1)

Swingline 77701, 77715, 87875, 48210(1)

Rapid S50, K1, K2, R90E(1)

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

Rapid M2OU, MS610(1)

Bostitch B8130(1)

Bostitch B875(1)

Bostitch B380HD(1)

Bostitch PHD-60(1)

PaperPro 1300(1)

PaperPro 1200, 1210(1)

Max EH-50F(1)

MAX MXBEH110F(1)

Rapid Supreme Omnipress SO60(1)

Rapid 5025e Electric Stapler(1)

AbilityOne 2729662(1)

Max EH-70F(1)

Max Vaimo 80 Stapler(1)

Rapid 5050e(1)

Sheet Capacity

25(7)

30(4)

60(4)

20(4)

120(3)

40(3)

50(3)

90(3)

70(3)

100(2)

80(2)

55(1)

160(1)

210(1)

75(1)

65(1)

180(1)

130(1)

45(1)

28(1)

Leg Length

0.25"(19)

0.38"(11)

0.5"(8)

0.31"(7)

0.75"(1)

0.94"(1)

0.3"(1)

0.63"(1)

0.56"(1)

0.88"(1)

0.41"(1)

0.47"(1)

Strip/Cartridge Count

1500(1)

Staple Type

Electric-Stapler Cartridge(1)

Color Family

Silver(54)

Multicolor(1)

Crown Size

0.5"(51)

0.38"(4)

Interpack Quantity Description

210/Cartridge, 5 Cartridges/Pack(4)

5,000/Box, 5 Boxes/Pack(1)

1,500/Cartridge, 2 Cartridges/Box(1)

4,000/Cartridge, 2 Cartridges/Box(1)

Point Style

Chisel(5)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved