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(40)

Pilot(18)

The Pencil Grip(10)

Cross(10)

Montblanc(10)

Uni-Ball(8)

Zebra Pen(7)

Parker(6)

CEP(6)

Lorell(5)

Waterman(4)

Expo(2)

Onyx it!(2)

Artistic(2)

OIC(2)

Integra(2)

Paper Mate(1)

Advantus(1)

Moon Products(1)

MMF(1)

Kantek(1)

Storex(1)

TOPS(1)

Deflecto(1)

Creativity Street(1)

Victor(1)

Business Source(1)

 
Color

Black(13)

Assorted(9)

White(4)

Gray(3)

Blue(2)

Transparent(1)

Metallic(1)

Neon(1)

Assorted Bright(1)

Clear(1)

Green Edge(1)

Silver(1)

Clear Top(1)

Pink(1)

Purple(1)

Green(1)

Red(1)

 
Recycled

No(91)

Yes(22)

 
Height

3.8"(6)

4"(3)

3"(2)

3.5"(2)

5.6"(1)

0.9"(1)

0.8"(1)

4.5"(1)

2.5"(1)

10"(1)

1.9"(1)

4.4"(1)

 
Depth

2.9"(5)

0.5"(5)

3"(3)

1"(2)

2.8"(1)

4.1"(1)

35.5"(1)

3.8"(1)

5.3"(1)

3.3"(1)

0.2"(1)

3.9"(1)

 
Manufacturer Part Number

ART20005(1)

77234(1)

77210(1)

77211(1)

77227(1)

77228(1)

77232(1)

77233(1)

77240(1)

PDE1(1)

77241(1)

77242(1)

77243(1)

77244(1)

77245(1)

77271(1)

48500(1)

LRN7CBX(1)

77290(1)

LR7-C(1)

LR10-A(1)

LR10-C(1)

LR7-A(1)

LR7ABX(1)

LR7-B(1)

LR7BBX(1)

LR7CBX(1)

LRN7-C(1)

LRN5-A(1)

LRN5ABX(1)

LRN5-C(1)

LRN5CBX(1)

LRN7-A(1)

LRN7ABX(1)

77289(1)

77330(1)

C505HBBX(1)

1964018(1)

65808PP(1)

65873PP(1)

65874PP(1)

70207PP(1)

71207PP(1)

9505-5(1)

1964019(1)

35973(1)

82712(1)

85412(1)

85422(1)

85512(1)

85522(1)

87012(1)

61233PP(1)

35972(1)

3611BL(1)

11112(1)

3612BL(1)

9287KF(1)

9387(1)

00160E06C(1)

PENPAL1(1)

003(1)

11412(1)

21212(1)

12012(1)

12712(1)

16412(1)

16512(1)

17712(1)

21112(1)

E10BP-K6(1)

C505-HB(1)

ART43005(1)

80656(1)

8910-2(1)

34204(1)

38014BX(1)

38015BX(1)

AD20(1)

55631(1)

80668(1)

8523-2(1)

84149(1)

84149BX(1)

258-402R-04(1)

105165(1)

107862(1)

107865(1)

8910-1(1)

8521-2(1)

107869(1)

1005300371(1)

37680(1)

32355(1)

1005300021(1)

1005300301(1)

1005300321(1)

1005300351(1)

1005310021(1)

8514-2(1)

5148(1)

8100-2(1)

8101-2(1)

8511-2(1)

8512-2(1)

8513-2(1)

107866(1)

107877(1)

C5052HBX(1)

C25-HB(1)

50BBX(1)

50-H(1)

50-HB(1)

50HBBX(1)

50HBX(1)

C257BPHB6(1)

C25HBBX(1)

509HBBX(1)

C27BPHB3-K6(1)

C27BPHB-K6(1)

C27-HB(1)

C27HBBX(1)

C29BPHB2(1)

C505-2H(1)

50-B(1)

50-9-HB(1)

107878(1)

66401PP(1)

107881(1)

107882(1)

107884(1)

ST36(1)

22292(1)

93681(1)

1950323(1)

502HBX(1)

1950324(1)

1950367(1)

1950368(1)

1950369(1)

1950371(1)

50-2H(1)

88112(1)

 
Country of Origin

Japan(67)

China(43)

Germany(10)

France(7)

Indonesia(5)

United States(3)

Canada(1)

 
Width

3"(5)

2.9"(5)

1"(3)

3.9"(2)

1.3"(2)

1.5"(2)

2.8"(1)

4.4"(1)

2.3"(1)

6"(1)

5"(1)

5.3"(1)

8"(1)

0.2"(1)

5.6"(1)

 
Material

Polystyrene(7)

Plastic(4)

Steel(3)

Metal(2)

Aluminum(2)

Wood(2)

Acrylic(2)

Glass(2)

Leather(1)

Polyurethane(1)

Steel Wire Mesh(1)

Mesh(1)

Felt(1)

Rubber(1)

Soft Foam(1)

Gel(1)

 
Limited Warranty

1 Year(4)

5 Year(4)

Lifetime(2)

90 Day(1)

 
Weight (Approximate)

2.08 oz(1)

0.16 oz(1)

11.20 oz(1)

 
Shape

Tripod(3)

 
Length

2.4"(11)

1"(2)

1.5"(2)

0.8"(2)

1.3"(1)

2.3"(1)

 
Placement

Wall Mountable(1)

 
Lead Diameter

0.7 mm(15)

0.5 mm(8)

0.9 mm(3)

 
Pen Refill Point Type

Medium(32)

Fine(26)

Bold(10)

Broad(3)

Extra Fine(3)

 
Lead Color

Black(23)

Graphite Black(1)

 
Pencil Refill Grade

HB(10)

2H(4)

#2(2)

B(2)

H(2)

 
Pencil Refill Point Type

Medium(12)

Fine(6)

Bold(3)

 
Lead Type

Hard(1)

 
Product Type

Ballpoint Pen Refill(32)

Gel Pen Refill(31)

Pencil Refill(25)

Pen/Pencil Holder(19)

Rollerball Pen Refill(16)

Pencil Grip(11)

Eraser Refill(3)

Paint Brush Holder(1)

Accessory Tray(1)

Marker Refill(1)

Marker Holder(1)

Organizer Basket(1)

Dry Erase Board Eraser Refill(1)

Pen Tray(1)

Note/Pen Holder(1)

 
Packaged Quantity

1 Each(45)

2 / Pack(42)

12 / Pack(9)

144 / Box(8)

12 / Box(7)

12 / Tube(4)

1 Pack(3)

3 / Pack(3)

360 / Box(2)

1 / Each(2)

30 / Tube(2)

12 / Tub(2)

6 / Pack(1)

180 / Box(1)

15 / Tube(1)

90 / Pack(1)

30 / Pack(1)

60 / Pack(1)

105 / Pack(1)

5 / Tube(1)

36 / Pack(1)

5 / Set(1)

6 / Box(1)

1 / Pack(1)

1(1)

 
Assembly Required

No(123)

 
Product Model

LR7(1)

PDE1(1)

3611BL(1)

3612BL(1)

9387(1)

 
Product Line

Super Hi-Polymer(22)

EnerGel(16)

Dr. Grip(5)

Gloss(4)

Selectip(2)

Architect(1)

Fusion(1)

Sustainable Office(1)

Acrylic(1)

Black Mesh/Wire(1)

Jumbo Jogger(1)

Quinkflow(1)

Twist-Erase(1)

Vision Elite(1)

Midnight Black(1)

 
Finishing

Powder Coated(1)

 
Ink Color

Black(43)

Blue(30)

Red(4)

Pacific Blue(1)

Green(1)

Purple(1)

 
Ink Type

Gel(36)

Oil Based(1)

 
Pen Refill Point Size

0.70 mm(23)

0.50 mm(8)

1 mm(8)

0.80 mm(1)

1.60 mm(1)

 
Ink Volume

No(1)

1 fl oz(1)