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_id` IN ('277')) 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 '%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(17)

Rapid(12)

Bostitch(9)

Max(4)

PaperPro(3)

Stanley(3)

Universal(2)

Arrow(2)

SKILCRAFT(1)

 
Color

Silver(1)

 
Recycled

No(1)

 
Quantity

5,000 per box(23)

1,000 per box(14)

1,050 per pack(4)

2,500 per box(2)

1,250(2)

3,000 per box(2)

25,000 per pack(1)

3,750 per pack(1)

1,200 per box(1)

6,000 per pack(1)

 
Manufacturer Part Number

35312(1)

35123(1)

35314(1)

35318(1)

35319(1)

35108(1)

90220(1)

5000594(1)

5000589(1)

73121(1)

73158(1)

90003(1)

35320(1)

35440(1)

79398(1)

79392(1)

90009(1)

79000(1)

79000VP(1)

69495(1)

50050(1)

35450(1)

35550(1)

35556(1)

35665(1)

11830700(1)

11825700(1)

SBS1914CP(1)

SB38HD-1M(1)

STCR130XHC1M(1)

STCR21153/8(1)

STCR75XHC1M(1)

SB35PHD-5M(1)

SB351/25M(1)

1962(1)

1913(1)

504(1)

506(1)

SB351/21M(1)

STCRP211514(1)

TRA704T(1)

02897(1)

7510002729662(1)

02900(1)

02903(1)

02904(1)

NO-70-FE(1)

NO1180(1)

TRA706T(1)

TRA708T(1)

50-FE(1)

NO11-1M(1)

1901(1)

 
Country of Origin

CN(31)

TW(8)

JP(4)

US(4)

SE(3)

DE(2)

United States(1)

 
Material

Steel(1)

 
For Use With

All Standard Full-Strip Staplers(7)

Rapid Heavy-Duty Cartridge Stapler 02892(4)

Stanley TR150(3)

All Standard Half-Strip Staplers(2)

Rapid M2OU Hobby Staple Gun;Rapid MS610 Handy Staple Gun(2)

Bostitch B8 Staplers(2)

Bostitch 00540, B310HDS, 03201; Most Heavy-Duty Staplers(2)

Swingline Heavy-Duty 270(1)

Swingline 39 and other Heavy-Duty Staplers(1)

Swingline 39 and Other Heavy-Duty Staplers(1)

Swingline Heavy-Duty 90010(1)

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

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

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

Swingline 77701, 77715, 87875, 48210(1)

Swingline 33801, 33811(1)

Rapid 5080e Heavy-Duty, Flat-Clinch Electric Stapler(1)

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

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

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

Rapid Supreme Omnipress SO30 Staplers(1)

Bostitch PHD-60(1)

Bostitch B380HD(1)

Arrow T50WA Stapler(1)

Arrow T50 Staplers(1)

PaperPro 1300(1)

PaperPro 1200, 1210(1)

Bostitch B8130(1)

Bostitch B875(1)

Rapid 5025e Electric Stapler(1)

Rapid 5050e Heavy-Duty, Flat-Clinch Electric Stapler(1)

Max Flat-Clinch Electronic Cartridge Stapler (EH-70F)(1)

Max HD-11UFL(1)

Max Electronic Cartridge Stapler (EH-50F)(1)

Rapid S50 High-Capacity SuperFlatClinch Half Strip Desktop Stapler, K1 Pliers, K2, R90E(1)

 
Sheet Capacity

25(6)

20(5)

40(4)

50(3)

70(3)

90(3)

60(3)

30(3)

120(3)

80(2)

55(1)

160(1)

210(1)

75(1)

65(1)

100(1)

180(1)

130(1)

45(1)

28(1)

 
Certifications & Standards

TAA Compliant(1)

 
Leg Length

1/4"(19)

3/8"(10)

1/2"(7)

5/16"(5)

3/4"(1)

5/8"(1)

0"(1)

15/16"(1)

13/32"(1)

3/16"(1)

0.25"(1)

15/32"(1)

19/64"(1)

 
Strip/Cartridge Count

210(14)

100(13)

5000(7)

105(7)

250(2)

125(1)

1500(1)

50(1)

 
Staple Per Strip

210(1)

 
Staple Cartridge Type

Standard(2)

Light Duty(2)

 
Sheet Capacity Range

55 to 85(2)

2 to 130(1)

2 to 75(1)

2 to 20(1)

2 to 80(1)

2 to 180(1)

10 to 65(1)

2 to 60(1)

40 to 100(1)

 
Product Type

Staples(1)

 
Packaged Quantity

5000 / Box(1)

 
Assembly Required

No(1)

 
Staple Size

5mm(1)

 
Staple Type

Heavy-Duty(14)

Electric-Stapler Cartridge(9)

Standard(6)

Staple Gun(5)

B8(4)

Cartridge(2)

Heavy Duty(2)

Optima High-Capacity(1)

Optima Standard(1)

Arched Crown(1)

S.F. 4 Premium Staples(1)

Steel(1)

High-Capacity(1)

Mini(1)

High Capacity(1)

Colored(1)

S.F. 3 Premium Staples(1)

 
Crown Width

0.50"(1)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved