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_27` 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','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 '%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®(31)

Pentel®(22)

Cross®(12)

Parker®(10)

Zebra®(10)

uni-ball®(8)

BIC®(3)

MMF Industries™(3)

Waterman(3)

Iconex™(1)

 
Ink Color(s)

Black(3)

Blue(1)

Purple(1)

 
Manufacturer Part Number

FRM41(1)

77242(1)

77330(1)

77285(1)

77279(1)

77278(1)

77274(1)

77273(1)

77271(1)

77245(1)

77244(1)

77243(1)

77241(1)

77332(1)

77240(1)

77234(1)

77233(1)

77232(1)

77228(1)

77227(1)

77223(1)

77222(1)

77221(1)

77217(1)

77331(1)

77335(1)

77211(1)

1964019(1)

88112(1)

87032(1)

87022(1)

87012(1)

85522(1)

85512(1)

85422(1)

85412(1)

82712(1)

S0944480(1)

1964018(1)

77336(1)

71207PP(1)

70207PP(1)

65874PP(1)

65873PP(1)

65808(1)

61234PP(1)

61233PP(1)

35972(1)

05077(1)

77346(1)

77215(1)

77210(1)

MRM41(1)

8521(1)

1950364(1)

1950362(1)

1950324(1)

1950323(1)

1950322(1)

1950321(1)

258404R04(1)

258402R04(1)

258401R08(1)

8523(1)

8514-2(1)

1950368(1)

8513-2(1)

8512-2(1)

8511-2(1)

8444(1)

8443(1)

8442(1)

8441(1)

8101-2(1)

8100-2(1)

RRLCP21-BK(1)

1950367(1)

1950369(1)

69100(1)

LR7B(1)

LRN7V(1)

LRN7-C(1)

LRN7-B(1)

LRN7-A(1)

LRN5V(1)

LRN5-C(1)

LRN5B(1)

LRN5-A(1)

LR7V(1)

LR7-C(1)

LR7-A(1)

1950371(1)

LR10-C(1)

LR10-B(1)

LR10-A(1)

BXM7HC(1)

BXM7HA(1)

BXM5HA(1)

BKL10-C(1)

BKL10-B(1)

BKL10-A(1)

BKC10BPA(1)

88122(1)

 
Country of Origin

JP(54)

CN(17)

GB(10)

MX(6)

FR(5)

US(5)

ID(5)

IN(1)

 
For Use With

Pentel® EnerGel® Pens(15)

Pilot® FriXion Ball and FriXion Clicker(5)

Pentel® R.S.V.P.®(3)

Pentel® Vicuña®(3)

Pentel® Client™(1)

Pilot® Downforce Pens(1)

ZEB27310(1)

ZEB27211(1)

ZEB27221(1)

ZEB27110, ZEB27112, ZEB29210, ZEB29212(1)

ZEB27120, ZEB27122, ZEB29220, ZEB29222(1)

ZEB44110, ZEB14410(1)

ZEB44120(1)

ZEB44130(1)

ZEB41311(1)

ZEB41321(1)

 
Tip Type

Conical(4)

 
Special Ink Type

Washable(44)

Permanent(5)

Quink®(4)

Low-Viscosity(3)

Gel(2)

 
Refill For Series

Pentel® EnerGel® Retractable Liquid Gel Ink Pens(15)

Pilot® Q7, G2, G2 Limited, G2 Pro, G2 Fashion, G6, Precise Gel BeGreen®, Dr Grip® LTD, Dr Grip® Gel, B2P Gel and MR Metropolitan Gel Ink Pens(7)

Cross® Ballpoint Pens(6)

Zebra® F-301®, F-301® Ultra, F-402®, 301A and Spiral Ballpoint Pens(5)

Pilot® FriXion Erasable, FriXion Ball, FriXion Clicker and FriXion LX Gel Ink Pens(5)

Pilot® Dr Grip®, Dr Grip® Center of Gravity, Dr Grip® Neon, Easytouch Retractable, The Better Retractable, B2P and Rex Grip BeGreen® Retractable Ballpoint Pens(4)

Cross® Selectip® Porous Point Pens(4)

Parker® Roller Ball Pens(4)

Parker® Ballpoint Pens(4)

Zebra® Jimnie® Gel RT, Sarasa™, Sarasa SE, ecoSarasa™ Clip Gel, Orbitz Gel, Z-Grip® Gel, Z-Grip® MAX Gel and GR8 Gel Ink Pens(3)

Pilot® Refillable Stick Ballpoint Pens(3)

Pentel® RSVP® Ballpoint Pens(3)

Pentel® Vicuña® Advanced Ink Ballpoint Pens(3)

4-Color Multifunction Retractable Ballpoint Pens(2)

uni-ball® Gel 207™ IMPACT RT Gel Ink Pens(2)

uni-ball® Vision Elite™ Roller Ball Pens(2)

Pilot® Precise V5 RT Roller Ball Pens(2)

uni-ball® Signo Gel 207™, 207™ Premier and Gel RT Pens(2)

Waterman Roller Ball Pens(2)

Pilot® Precise V7 RT Roller Ball Pens(2)

Zebra® JK G-301 Gel Ink Pens(2)

Cross® Selectip® Gel Ink Roller Ball Pens(2)

MMF Industries™ Jumbo Jogger Ballpoint Pens(2)

All Pilot® Refillable Stick Ballpoints(2)

Parker® Retractable Gel Ink Roller Ball Pens(2)

Pilot® Dr Grip® Center Of Gravity, Full Black, Pure White, Axiom and MR Ballpoint Pens(1)

Pentel® Client™ Ballpoint Pens(1)

Waterman Ballpoint Pens(1)

MMF Industries™ Security Ballpoint Pens(1)

Pilot® Plumix Fountain Pens(1)

uni-ball® Gel IMPACT™ Pens(1)

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

uni-ball® JetStream™ RT Ballpoint Pens(1)

PM Company® PMC® Preventa®, MMF Kable® and Sentry Counter Ballpoint Pens(1)

Pilot® Downforce Ballpoint Pens(1)

V Ball RT Roller Ball(1)

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

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

 
Point Type

Fine(3)

Medium(2)

 
Pen Refill Type

Roller Ball(3)

Ballpoint(2)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved