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

Pentel(19)

Cross(12)

Parker(10)

Zebra(10)

uni-ball(8)

BIC(3)

MMF Industries(3)

Waterman(3)

Iconex(1)

 
Ink Color(s)

Red(2)

Blue(2)

Black(1)

Purple(1)

 
Manufacturer Part Number

FRM41(1)

77242(1)

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

77229(1)

77228(1)

77227(1)

77223(1)

77222(1)

77221(1)

77331(1)

77335(1)

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

77217(1)

77215(1)

MRC21-BE(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)

MRM41(1)

1950367(1)

1950369(1)

77212(1)

LR7V(1)

77211(1)

77210(1)

69100(1)

LRN7V(1)

LRN7-C(1)

LRN7-B(1)

LRN7-A(1)

LRN5-C(1)

LRN5B(1)

LRN5-A(1)

LR7-C(1)

1950371(1)

LR7B(1)

LR7-A(1)

LR10-C(1)

LR10-B(1)

LR10-A(1)

BXM7HC(1)

BKL10-C(1)

BKL10-B(1)

BKL10-A(1)

BKC10BPA(1)

88122(1)

 
Country of Origin

JP(52)

CN(16)

GB(10)

MX(7)

US(6)

FR(5)

ID(5)

IN(1)

 
For Use With

Pentel EnerGel Pens(14)

Pilot FriXion Ball and FriXion Clicker(5)

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

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

 
Special Ink Type

Washable(45)

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)

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

Zebra F-301, F-301 Ultra, F-402, 301A and Spiral Ballpoint 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)

Pentel RSVP Ballpoint Pens(3)

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)

All Pilot Refillable Stick Ballpoints(3)

Pilot Refillable Stick Ballpoint Pens(3)

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

Pilot Precise V5 RT Roller Ball 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)

4-Color Multifunction Retractable Ballpoint 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)

Dr Grip, Dr Grip Center of Gravity, Dr Grip Neon, Easytouch Retractable, The Better Retractable, B2P Ball Point and Rex Grip BeGreen Retractable(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)

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)

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)

Pilot Plumix Fountain Pens(1)

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

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

Pentel Vicuņa Advanced Ink Ballpoint Pens(1)

 
Point Type

Fine(4)

Medium(2)

 
Pen Refill Type

Ballpoint(5)

Roller Ball(1)

 
 
 

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