facebook
 
 
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_name` IN ('Eraser Refills','Ink','Pen Refills','Pencil Grips & Cushions','Lead Refills','Pencil Holders')) 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 '%WritingAccessories' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('WritingAccessories' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+WritingAccessories' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"WritingAccessories"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"WritingAccessories"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"WritingAccessories"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"WritingAccessories"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+WritingAccessories' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='WritingAccessories',`category_4` ='WritingAccessories') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'WritingAccessories,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('WritingAccessories', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Writing Accessories

Refine Search

  GO
 
Brand

Pentel(60)

Pilot(25)

Cross(13)

Zebra Pen(10)

uni-ball(10)

The Pencil Grip(9)

Montblanc(8)

CEP(6)

Parker(6)

Lorell(5)

SKILCRAFT(5)

Waterman(4)

Artistic(3)

BIC(3)

OIC(2)

Higgins(2)

Fellowes(2)

Integra(2)

Onyx(2)

Expo(1)

Victor(1)

Business Source(1)

TOPS(1)

Schneider(1)

EXPO(1)

Kantek(1)

Sharpie(1)

Deflecto(1)

Paper Mate(1)

Advantus(1)

Moon Products(1)

ICONEX(1)

MMF Industries(1)

MMF(1)

Rolodex(1)

 
Color

Black(17)

Assorted(8)

White(4)

Gray(3)

Blue(2)

Silver(2)

Green(1)

Purple(1)

Pink(1)

Clear(1)

Green Edge(1)

Transparent(1)

Gunmetal(1)

Neon(1)

Metallic(1)

Red(1)

 
Recycled

No(125)

Yes(32)

 
Height

3.8"(6)

4"(3)

3.5"(3)

0.1"(3)

4.5"(2)

3"(2)

5.6"(1)

4.9"(1)

4.3"(1)

0.9"(1)

0.8"(1)

1"(1)

0.3"(1)

2.5"(1)

10"(1)

4.4"(1)

 
Depth

2.9"(5)

0.5"(5)

3"(4)

3.5"(1)

2.8"(1)

4.1"(1)

3.1"(1)

35.5"(1)

3.8"(1)

4.5"(1)

5.3"(1)

3.3"(1)

0.2"(1)

1"(1)

3.9"(1)

 
Manufacturer Part Number

ART20005(1)

77215(1)

LRN7-C(1)

LRN7CBX(1)

MG8-A(1)

PDE1(1)

43500(1)

48500(1)

69100(1)

77210(1)

77211(1)

77221(1)

LRN7-B(1)

77227(1)

77228(1)

77232(1)

77233(1)

77234(1)

77240(1)

77241(1)

77242(1)

77243(1)

LRN7BBX(1)

LRN7ABX(1)

77245(1)

LR7-A(1)

C505-HB(1)

C505HBBX(1)

C505HBX(1)

C525-HB(1)

E10BP-K6(1)

L100BPHB-K6(1)

LR10-A(1)

LR10-B(1)

LR10-C(1)

LR7ABX(1)

LRN7-A(1)

LR7-B(1)

LR7BBX(1)

LR7-C(1)

LR7CBX(1)

LR7V(1)

LRN5-A(1)

LRN5ABX(1)

LRN5-C(1)

LRN5CBX(1)

77244(1)

77271(1)

C5052HBX(1)

1964018(1)

61233PP(1)

65808PP(1)

65873PP(1)

65874PP(1)

70161(1)

70162(1)

70207PP(1)

71207PP(1)

9505-5(1)

1964019(1)

35972(1)

82712(1)

85412(1)

85422(1)

85512(1)

85522(1)

87012(1)

87022(1)

87032(1)

88112(1)

35973(1)

21212(1)

77272(1)

9287KF(1)

77289(1)

77290(1)

77330(1)

77331(1)

77336(1)

E23569(1)

3611BL(1)

3612BL(1)

2141127(1)

9387(1)

21112(1)

08503(1)

PENPAL1(1)

11112(1)

11412(1)

12012(1)

12712(1)

16412(1)

16512(1)

17712(1)

C505-H(1)

C505-2H(1)

ART20014(1)

AD20(1)

8924(1)

34204(1)

22307(1)

8032301(1)

44011(1)

44201(1)

94190043(1)

38014BX(1)

38015BX(1)

55631(1)

8910-1(1)

80656(1)

80668(1)

84149(1)

84149BX(1)

258-402R-04(1)

258404R04(1)

107862(1)

107865(1)

107866(1)

8910-2(1)

8523-2(1)

107877(1)

1005300351(1)

ART43005(1)

37680(1)

MRCP2BE(1)

MRCP2BK(1)

MRM41(1)

32355(1)

1005300021(1)

1005300301(1)

1005300321(1)

1005300371(1)

8521-2(1)

1005310021(1)

8100-2(1)

8101-2(1)

8442(1)

8443(1)

8511-2(1)

8512-2(1)

8513-2(1)

8514-2(1)

107869(1)

107878(1)

C29BPHB3(1)

C257BPHB6(1)

50-H(1)

50-HB(1)

50HBBX(1)

50HBX(1)

BKC10BPA(1)

BKL10-A(1)

BKL10-C(1)

BKL7-A(1)

BKL7-C(1)

C25BPHB3K6(1)

50-B(1)

C25BPHB3K6BX(1)

C25-HB(1)

C25HBBX(1)

C27BPHB3-K6(1)

C27BPHB-K6(1)

C27-HB(1)

C27HBBX(1)

C29BPHB(1)

C29BPHB2(1)

50BBX(1)

509HBBX(1)

107881(1)

66401PP(1)

107882(1)

ST36(1)

7510-01-317-6421(1)

7510-01-317-6422(1)

6849430(1)

6849431(1)

6850103(1)

22292(1)

93681(1)

1950323(1)

50-9-HB(1)

1950324(1)

1950367(1)

1950368(1)

1950369(1)

1950371(1)

50-2H(1)

502HBX(1)

50-4H(1)

504HBX(1)

88122(1)

 
Country of Origin

Japan(96)

China(49)

France(15)

Germany(11)

United States(9)

Mexico(6)

Indonesia(5)

CN(1)

India(1)

 
Width

2.9"(5)

0.3"(4)

3"(4)

1"(4)

3.5"(3)

1.5"(2)

3.9"(2)

1.3"(1)

0.2"(1)

8"(1)

5.3"(1)

5"(1)

2.8"(1)

6"(1)

2.3"(1)

3.1"(1)

4.4"(1)

5.6"(1)

 
Material

Polystyrene(7)

Steel(5)

Metal(4)

Plastic(3)

Aluminum(2)

Glass(2)

Wood(2)

Leather(1)

Acrylic(1)

Polyurethane(1)

Steel Wire Mesh(1)

Mesh(1)

Felt(1)

Rubber(1)

Soft Foam(1)

Gel(1)

 
Limited Warranty

5 Year(7)

Lifetime(5)

1 Year(2)

90 Day(1)

3 Year(1)

 
Weight (Approximate)

2.08 oz(1)

8.48 oz(1)

3.20 oz(1)

0.16 oz(1)

3.84 oz(1)

0.96 oz(1)

11.20 oz(1)

 
Shape

Tripod(3)

 
Length

2.4"(15)

1"(2)

1.5"(2)

0.8"(2)

2.3"(1)

 
Orientation

Vertical(1)

 
Special Ink Type

Washable(1)

 
Lead Diameter

0.7 mm(18)

0.5 mm(15)

0.9 mm(5)

 
Pen Refill Point Type

Medium(48)

Fine(32)

Bold(13)

Broad(3)

Extra Fine(3)

 
Mount Type

Wall Mountable(1)

 
Lead Color

Black(34)

Graphite Black(1)

Graphite(1)

 
Refill For Series

MMF Industries Security Ballpoint Pens(1)

 
Pencil Refill Grade

HB(16)

#2(4)

2H(4)

H(4)

4H(2)

B(2)

 
Pencil Refill Point Type

Medium(14)

Fine(12)

Bold(5)

 
Lead Type

Hard(3)

 
Product Type

Gel Pen Refill(45)

Ballpoint Pen Refill(43)

Pencil Refill(37)

Pen/Pencil Holder(23)

Rollerball Pen Refill(17)

Pencil Grip(10)

Eraser Refill(3)

Porous Point Pen Refill(2)

Fountain Pen Refill(2)

Calligraphy Pen Refill(2)

Marker Refill(2)

Organizer Basket(1)

Dry Erase Board Eraser Refill(1)

Accessory Tray(1)

Marker Holder(1)

Pen Refill(1)

Note/Pen Holder(1)

 
Packaged Quantity

1 Each(61)

2 / Pack(39)

2 Pack(16)

144 / Box(10)

3 / Pack(9)

12 / Pack(9)

12 / Box(9)

12 Tub(7)

12 / Tub(4)

360 / Box(2)

6 / Pack(2)

1 / Pack(2)

5 Tub(1)

10 / Box(1)

1 Pack(1)

60 / Pack(1)

30 / Pack(1)

180 / Box(1)

90 / Pack(1)

30 Tub(1)

36 / Box(1)

15 Tub(1)

105 / Pack(1)

36 / Pack(1)

6 / Box(1)

4 / Pack(1)

50 / Pack(1)

 
Assembly Required

No(167)

 
Product Model

44011(1)

BKL7-A(1)

BKL7-C(1)

LR7(1)

PDE1(1)

3611BL(1)

3612BL(1)

9387(1)

JK(1)

 
Product Line

Super Hi-Polymer(31)

EnerGel(19)

Dr. Grip(6)

R.S.V.P.(4)

Gloss(4)

Selectip(4)

Vista(3)

Jetstream RT(2)

207 Gel Impact RT(2)

207 Gel(2)

Easy Glide(2)

Vision Elite(1)

207 Gel Impact(1)

Topball(1)

Distinctions(1)

Rolling Writer(1)

Energel(1)

Architect(1)

Client(1)

Twist-Erase(1)

Premium Hi-Polymer(1)

Fusion(1)

Quinkflow(1)

Jumbo Jogger(1)

Black Mesh/Wire(1)

Acrylic(1)

Preventa(1)

Office Suites(1)

Perf-ect(1)

Sustainable Office(1)

4-Color(1)

Midnight Black(1)

 
Finishing

Powder Coated(1)

 
Ink Color

Black(58)

Blue(43)

Red(9)

Purple(2)

Assorted(1)

Violet(1)

Green(1)

Pink(1)

Turquoise(1)

 
Ink Type

Gel(52)

Oil Based(1)

Water Based(1)

 
Pen Refill Point Size

0.70 mm(33)

1 mm(18)

0.50 mm(9)

0.80 mm(1)

1.60 mm(1)

 
Ink Volume

1 fl oz(4)

No(1)