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

Pentel(12)

Parker(11)

Zebra(10)

uniball(8)

AbilityOne(4)

Waterman(4)

Iconex(1)

Sharpie S-Gel(1)

 
Packaged Quantity

1 Each(1)

 
Assembly Required

No(1)

 
Compatibility

Waterman Rollerball Pens

(1)

 
Ink Color

Blue(1)

 
Pen Refill Point Type

Fine(1)

 
Special Ink Type

Gel(1)

 
Refill For Series

Pentel EnerGel Retractable Liquid Gel Ink Pens(11)

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 Ballpoint 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 Roller Ball Pens(4)

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)

AbilityOne SKILCRAFT VISTA Gel Ink Pens(3)

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

uniball 207 Impact RT Gel Retractable Pens(2)

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

Pilot Precise V5 RT Roller Ball Pens(2)

Pilot G2 Gel Ink Pens(2)

uni-ball Vision Elite 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)

Zebra JK G-301 Gel Ink Pens(2)

Parker Retractable Gel Ink 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)

Waterman Ballpoint Pens(1)

Waterman Fountain Pens(1)

Waterman Roller Ball Pens(1)

uniball 207 Impact Gel Stick Pens(1)

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

uni-ball JetStream RT Ballpoint Pens(1)

Sharpie S-Gel Pens(1)

Pilot Acroball(1)

AbilityOne SKILCRAFT Aviator 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)

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 Dr Grip Gel Pens, Dr Grip LTD Gel Pens, G2 Limited Gel Pens, G2 Pro Gel Pens, Precise Gel BeGreen Pens, Q7 Gel Pens(1)

Pilot Plumix Fountain Pens(1)

EnerGel Pens(1)

Zebra F-Series(1)

 
Country of Origin

JP(47)

GB(9)

US(6)

FR(4)

ID(4)

CN(3)

Germany(1)

MX(1)

 
Tip Type

Metal(1)

 
Ink Color(s)

Blue(1)

Black(1)

 
Point Type

Bold(1)

Fine(1)

 
Pen Refill Type

Roller Ball(1)

Ballpoint(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander