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 ('60318')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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(22)

Parker(11)

Pentel(10)

Zebra(10)

uniball(8)

AbilityOne(4)

Waterman(4)

Cross(1)

fisher SPACE PEN(1)

Iconex(1)

Sharpie S-Gel(1)

 
Special Ink Type

Gel(3)

 
Refill For Series

Pentel EnerGel Retractable Liquid Gel Ink Pens(8)

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

Parker Roller Ball Pens(5)

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

Parker Ballpoint Pens(4)

AbilityOne SKILCRAFT VISTA Gel Ink Pens(3)

Zebra F-301 Ballpoint Pens, F-301A Ballpoint Pens, F-301 Ultra Ballpoint Pens, F-402 Ballpoint Pens, F-701 Ballpoint Pens, Spiral Ballpoint Pens(3)

Zebra JK G-301 Gel Ink Pens(2)

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

Waterman Roller Ball Pens(2)

Pilot G2 Gel Ink Pens(2)

Pilot Precise V5 RT Roller Ball Pens(2)

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

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

EnerGel Pens(2)

Parker Retractable Gel Ink Roller Ball Pens(2)

Zebra GR8 Gel Ink Pens, Jimnie Gel RT, Orbitz Gel Pens, Sarasa Gel Pens, Sarasa SE Gel Pens, ecoSarasa Clip Gel Pens, Z-Grip Gel Pens, Z-Grip MAX Gel Pens(2)

uni-ball Vision Elite Roller Ball Pens(2)

Zebra F-301 Ballpoint Pens, F-301A Ballpoint Pens, F-301 Ultra Ballpoint Pens, F-402 Ballpoint Pens, Spiral Ballpoint Pens(1)

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

Waterman Ballpoint Pens(1)

Waterman Fountain Pens(1)

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

Cross Ballpoint Pens(1)

uni-ball Gel IMPACT Pens(1)

uni-ball JetStream RT Ballpoint Pens(1)

Sharpie S-Gel Pens(1)

fisher SPACE PEN(1)

Pilot Precise V7 RT Roller Ball Pens(1)

Pilot Dr Grip Center of Gravity Ballpoint Pens(1)

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

Pilot Plumix Fountain Pens(1)

AbilityOne SKILCRAFT Aviator Pens(1)

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

Pilot B2P Gel Pens, BeGreen Gel Pens, G2 Gel Pens, G2 Limited Gel Pens, G2 Pro Gel Pens, G6 Gel Pens, Dr Grip LTD Gel Pens, Dr. Grip Gel Pens, G-Knock Gel Pens(1)

 
Country of Origin

JP(44)

GB(9)

US(7)

FR(6)

ID(4)

CN(2)

MX(1)

 
Tip Type

Conical(3)

Metal(2)

 
Ink Color(s)

Blue(3)

Black(1)

Red(1)

 
Point Type

Medium(3)

Bold(2)

 
Pen Refill Type

Roller Ball(3)

Ballpoint(2)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved