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

Currently Filtered by

Category

Pen Refills

Refine Search

  GO
 
Brand

Pilot(44)

Pentel(24)

Zebra(15)

Paper Mate(14)

uni-ball(14)

Cross(12)

Parker(12)

BIC(9)

PM Company(4)

MMF Industries(3)

Waterman(3)

Schneider from Stride(1)

Sharpie(1)

 
Ink Color(s)

Black(74)

Blue(54)

Red(16)

Violet(3)

Black;Blue;Green;Red(2)

Green(2)

Assorted(2)

Black;Blue(1)

Orange(1)

Purple(1)

 
Manufacturer Part Number

77274(1)

77278(1)

77279(1)

77273(1)

77271(1)

77243(1)

77244(1)

77245(1)

77283(1)

77284(1)

77335(1)

77336(1)

77346(1)

77332(1)

77331(1)

77285(1)

77286(1)

77330(1)

77242(1)

77241(1)

77215(1)

77216(1)

77217(1)

77212(1)

77211(1)

48500(1)

69100(1)

77210(1)

77221(1)

77222(1)

77233(1)

77234(1)

77240(1)

77232(1)

77229(1)

77223(1)

77227(1)

77228(1)

77347(1)

05058(1)

85422(1)

85512(1)

85522(1)

85412(1)

82712(1)

540951PP(1)

54096P(1)

834254(1)

85612(1)

85913(1)

87322(1)

88112(1)

88122(1)

87312(1)

87032(1)

85923(1)

87012(1)

87022(1)

175501(1)

74396PP(1)

35973(1)

42082PP(1)

42083PP(1)

35972(1)

1800730(1)

05064(1)

05073(1)

05077(1)

45574PP(1)

61233PP(1)

65874PP(1)

70207PP(1)

71207PP(1)

65873PP(1)

65809(1)

61234PP(1)

65808(1)

43926(1)

43925(1)

1747206(1)

1807421(1)

1807422(1)

1747205(1)

258404R04(1)

8523(1)

258401R08(1)

258402R04(1)

1815034(1)

1815035(1)

5640736PP(1)

9712431PP(1)

9732431PP(1)

4932431PP(1)

4912431PP(1)

1815236(1)

1815237(1)

4332431PP(1)

8521(1)

8514-2(1)

RRT5P21BK(1)

RRT7P21BE(1)

RRT7P21BK(1)

RRT5P21BE(1)

RRLCP21-BK(1)

MRC21-BE(1)

MRC21-BK(1)

MRM41(1)

8100-2(1)

8101-2(1)

8511-2(1)

8512-2(1)

8513-2(1)

8444(1)

8443(1)

8441(1)

8442(1)

1782467(1)

1782468(1)

LR7-C(1)

LR7V(1)

LRN5-A(1)

LR7B(1)

LR7-A(1)

LR10-A(1)

LR10-B(1)

LR10-C(1)

LRN5B(1)

LRN5-C(1)

43922(1)

43923(1)

43924(1)

LRN7V(1)

LRN7-C(1)

LRN5V(1)

LRN7-A(1)

LRN7-B(1)

KLR7-A(1)

BXM7HC(1)

3021531(1)

3022331(1)

3022531(1)

3021331(1)

3016031PP(1)

1782469(1)

1782470(1)

3011031PP(1)

30525PP(1)

30526PP(1)

BXM5HA(1)

BXM5HC(1)

BXM7HA(1)

BKL10-C(1)

BKL10-B(1)

BKC10BPA(1)

BKL10-A(1)

FRM41(1)

 
Country of Origin

JP(94)

CN(30)

MX(11)

GB(10)

FR(7)

KR(2)

DE(1)

IN(1)

 
Tip Type

Conical(102)

Needle(9)

Metal(7)

Chisel(5)

Stainless Steel(1)

 
Special Ink Type

Gel(46)

Dry Erase(5)

Low-Viscosity(4)

Quink(4)

Permanent(2)

ViscoGlide Advance Ink Technology(1)

Washable(1)

 
Refill For Series

EnerGel Pens(15)

For Pilot Q7, G2, G2 Limited, G2 Pro, G2 Fashion, G6, Precise Gel BeGreen, Dr Grip LTD, Dr Grip Gel, B2P Gel, MR Metropolitan Gel Roller(8)

Cross Ballpoint Pens(6)

Dr Grip, Dr Grip Center of Gravity, Dr Grip Neon, Easytouch Retractable, The Better Retractable, B2P Ball Point and Rex Grip BeGreen Retractable(6)

All Pilot Refillable Stick Ballpoints(6)

BeGreen V Board Master(5)

Pilot FriXion Erasable, FriXion Ball, FriXion Clicker, FriXion LX(5)

F-301, F-301 Ultra, F-402, 301A, Spiral Ballpoints(5)

All Parker Roller Balls(4)

Vicua(4)

Selectip Porous Point Pens(4)

V Ball RT Roller Ball(4)

All Parker Ballpoint Pens(4)

BIC Triumph Roller Ball Pens(4)

Aspire, PhD, PhD Ultra Ballpoint Pens(3)

Pentel RSVP Ballpoints(3)

Paper Mate InkJoy Ballpoint 300 RT and 550 RT Pens(3)

Paper Mate InkJoy Ballpoint 500 RT and 700 RT Pens(3)

Jimnie Gel RT, Sarasa, ecoSarasa Clip Gel, Sarasa SE, Orbitz Gel, Z-Grip Gel, Z-Grip MAX Gel, GR8 Gel Roller Balls(3)

Selectip Gel Roller Ball Pens(2)

Profile RT Ballpoint(2)

Precise V5 RT Roller Ball(2)

Precise V7 RT Roller Ball(2)

Gel 207 Impact RT Roller Balls(2)

PowerTank RT Ballpoints(2)

Preventa 05051, 05054, 05074, 05075, MMF Kable, Sentry Counter Pens(2)

JetStream Ballpoints(2)

Vision Elite Roller Balls(2)

Signo Gel 207, 207 Premier, Gel RT Ballpoints(2)

4-Color Retractable Ballpoint Pen(2)

Jimnie Clip Retractable Ballpoints(2)

Retractable Gel Ink(2)

FlexGrip Elite and Ultra Ballpoint Pens(2)

G301 Retractable Rollerballs(2)

JetStream RT Ballpoints(2)

Z-Mulsion EX(2)

BIC For Her, Velocity, Pro+, Atlantis Original Retractable Ballpoint Pens(2)

Waterman Roller Ball Pen(2)

Waterman Ballpoint Pen(1)

Telescopic Ballpoints & StylusTwist Pens(1)

All Schneider from Stride Retractable Pens(1)

Dr Grip Center Of Gravity Pen, Full Black, Pure White, Axiom and Pilot MR Ball Point(1)

Pentel HyperG(1)

Pilot Jumbo Refillable Permanent Markers(1)

Pentel Client Pens(1)

All Parker Washable Ink Fountain Pens(1)

Paper Mate Ballpoint Pens(1)

All Parker Permanent Ink Fountain Pens(1)

Plumix Fountain Pen(1)

BIC Velocity, Triumph and Atlantis Retractable Gel Roller Pens(1)

Standard PMC05057 Counter Pens(1)

PMC-05059 Plus and PMC-05062 Deluxe Counter Pens(1)

Pilot Acroball(1)

Pilot Downforce(1)

For Q7, G2 Limited, G2 Pro, Precise Gel BeGreen, Dr Grip LTD and Dr Grip Pens(1)

Sharpie Stainless Steel(1)

 
Ink Color(s) Assortment

Pink; Purple;Turquoise(1)

Black; Blue; Red(1)

 
Point Type

Medium(65)

Fine(50)

Bold(16)

Extra Fine(11)

Broad(2)

Super Bold(2)

Extra Bold(1)

 
Pen Refill Type

Ballpoint(82)

Roller Ball(60)

Dry Erase Marker(5)

Porous Point(4)

Fountain(3)

Permanent Marker(2)

 
 
 

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