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','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(27)

Pentel(19)

Cross(12)

Parker(10)

Zebra(10)

uni-ball(8)

MMF Industries(3)

Waterman(3)

BIC(2)

Iconex(1)

 
Ink Color(s)

Black(1)

Purple(1)

 
Manufacturer Part Number

FRM41(1)

77244(1)

77332(1)

77331(1)

77330(1)

77279(1)

77278(1)

77274(1)

77273(1)

77271(1)

77245(1)

77243(1)

77336(1)

77242(1)

77241(1)

77240(1)

77234(1)

77233(1)

77232(1)

77228(1)

77227(1)

77221(1)

77335(1)

77346(1)

77211(1)

S0944480(1)

88112(1)

87032(1)

87022(1)

87012(1)

85522(1)

85512(1)

85422(1)

85412(1)

82712(1)

1964019(1)

05077(1)

1964018(1)

71207PP(1)

70207PP(1)

65874PP(1)

65873PP(1)

65808(1)

61234PP(1)

61233PP(1)

35972(1)

77217(1)

77210(1)

MRM41(1)

8521(1)

1950362(1)

1950324(1)

1950323(1)

1950322(1)

1950321(1)

258404R04(1)

258402R04(1)

258401R08(1)

8523(1)

8514-2(1)

1950367(1)

8513-2(1)

8512-2(1)

8511-2(1)

8444(1)

8443(1)

8442(1)

8441(1)

8101-2(1)

8100-2(1)

1950364(1)

1950368(1)

69100(1)

LR7B(1)

LRN7V(1)

LRN7-C(1)

LRN7-B(1)

LRN7-A(1)

LRN5-C(1)

LRN5B(1)

LRN5-A(1)

LR7V(1)

LR7-C(1)

LR7-A(1)

1950369(1)

LR10-C(1)

LR10-B(1)

LR10-A(1)

BXM7HC(1)

BKL10-C(1)

BKL10-B(1)

BKL10-A(1)

BKC10BPA(1)

1950371(1)

88122(1)

 
Country of Origin

JP(50)

CN(16)

GB(10)

MX(6)

FR(5)

ID(5)

US(2)

IN(1)

 
For Use With

Pentel EnerGel Pens(14)

Pilot FriXion Ball and FriXion Clicker(5)

Pentel R.S.V.P.(2)

Pentel Client(1)

Pentel Vicuņa(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(2)

 
Special Ink Type

Washable(42)

Permanent(5)

Quink(4)

Low-Viscosity(1)

Gel(1)

 
Refill For Series

Pentel EnerGel Retractable Liquid Gel Ink Pens(14)

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)

Parker Ballpoint Pens(4)

Cross Selectip Porous Point Pens(4)

Parker Roller Ball 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)

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

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

uni-ball Vision Elite Roller Ball Pens(2)

Waterman Roller Ball Pens(2)

Pilot Precise V7 RT Roller Ball Pens(2)

Pilot Precise V5 RT Roller Ball Pens(2)

4-Color Multifunction Retractable Ballpoint Pens(2)

Zebra JK G-301 Gel Ink Pens(2)

Pilot Refillable Stick Ballpoint Pens(2)

Cross Selectip Gel Ink Roller Ball Pens(2)

MMF Industries Jumbo Jogger Ballpoint Pens(2)

Pentel RSVP Ballpoint Pens(2)

Parker Retractable Gel Ink Roller Ball Pens(2)

uni-ball Gel IMPACT Pens(1)

Waterman Ballpoint Pens(1)

MMF Industries Security Ballpoint Pens(1)

Pentel Client Ballpoint Pens(1)

Pentel RSVP Ballpoints(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)

Pentel Vicuņa Advanced Ink Ballpoint Pens(1)

Pilot Plumix Fountain Pens(1)

Pilot Dr Grip Center Of Gravity, Full Black, Pure White, Axiom and MR Ballpoint 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

Medium(1)

Fine(1)

 
Pen Refill Type

Ballpoint(1)

Roller Ball(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved