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') 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(28)

Pentel(21)

Cross(12)

Parker(10)

Zebra(10)

MMF Industries(3)

Waterman(3)

BIC(2)

Iconex(1)

 
Ink Color(s)

Purple(1)

 
Manufacturer Part Number

FRM41(1)

77233(1)

77271(1)

77245(1)

77244(1)

77243(1)

77242(1)

77241(1)

77240(1)

77234(1)

77232(1)

77274(1)

77228(1)

77227(1)

77223(1)

77221(1)

77217(1)

77211(1)

77210(1)

69100(1)

77273(1)

77278(1)

LRN7-C(1)

82712(1)

88112(1)

87032(1)

87022(1)

87012(1)

85522(1)

85512(1)

85422(1)

85412(1)

S0944480(1)

77279(1)

1964019(1)

1964018(1)

05077(1)

77346(1)

77336(1)

77335(1)

77332(1)

77331(1)

77330(1)

LRN7V(1)

LRN7-B(1)

MRM41(1)

8521(1)

1950324(1)

1950323(1)

1950322(1)

1950321(1)

258404R04(1)

258402R04(1)

258401R08(1)

8523(1)

8514-2(1)

1950364(1)

8513-2(1)

8512-2(1)

8511-2(1)

8444(1)

8443(1)

8442(1)

8441(1)

8101-2(1)

8100-2(1)

1950362(1)

1950367(1)

LRN7-A(1)

LR10-C(1)

LRN5V(1)

LRN5-C(1)

LRN5B(1)

LRN5-A(1)

LR7V(1)

LR7-C(1)

LR7B(1)

LR7-A(1)

LR10-B(1)

1950368(1)

LR10-A(1)

BXM7HC(1)

BXM7HA(1)

BXM5HA(1)

BKL10-C(1)

BKL10-B(1)

BKC10BPA(1)

1950371(1)

1950369(1)

88122(1)

 
Country of Origin

JP(45)

CN(16)

GB(10)

FR(5)

MX(5)

ID(5)

US(3)

IN(1)

 
For Use With

Pentel EnerGel Pens(15)

Pilot FriXion Ball and FriXion Clicker(5)

Pentel Vicuņa(3)

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

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

 
Special Ink Type

Washable(40)

Permanent(5)

Quink(4)

Low-Viscosity(3)

Gel(1)

 
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)

Cross Selectip Porous Point Pens(4)

Parker Roller Ball Pens(4)

Parker Ballpoint Pens(4)

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)

Pilot Refillable Stick 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)

Pentel Vicuņa Advanced Ink Ballpoint Pens(3)

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)

Parker Retractable Gel Ink Roller Ball Pens(2)

Pentel RSVP Ballpoint Pens(2)

MMF Industries Jumbo Jogger Ballpoint Pens(2)

Cross Selectip Gel Ink Roller Ball Pens(2)

Zebra JK G-301 Gel Ink Pens(2)

Pilot Plumix Fountain 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)

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

Pentel Client Ballpoint Pens(1)

Pilot Downforce Ballpoint Pens(1)

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

MMF Industries Security Ballpoint Pens(1)

Waterman Ballpoint Pens(1)

 
Point Type

Fine(1)

 
Pen Refill Type

Roller Ball(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved