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

Pentel(22)

Cross(12)

Zebra(12)

Parker(11)

BIC(4)

MMF Industries(3)

Waterman(3)

uni-ball(2)

PM Company(1)

Iconex(1)

 
Ink Color(s)

Black(3)

Blue(1)

Black;Blue(1)

 
Manufacturer Part Number

FRM41(1)

77241(1)

77283(1)

77279(1)

77278(1)

77274(1)

77273(1)

77271(1)

77245(1)

77244(1)

77243(1)

77242(1)

77240(1)

77286(1)

77234(1)

77233(1)

77232(1)

77229(1)

77228(1)

77227(1)

77223(1)

77222(1)

77221(1)

77217(1)

77216(1)

77285(1)

77330(1)

77212(1)

82712(1)

88112(1)

87032(1)

87022(1)

87012(1)

85913(1)

85612(1)

85522(1)

85512(1)

85422(1)

85412(1)

S0944480(1)

77331(1)

1964019(1)

1964018(1)

65808(1)

61234PP(1)

05077(1)

05073(1)

77347(1)

77346(1)

77336(1)

77335(1)

77332(1)

77215(1)

77211(1)

MRC21-BE(1)

8521(1)

1950362(1)

1950324(1)

1950323(1)

1950322(1)

1950321(1)

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

MRM41(1)

MRC21-BK(1)

1950364(1)

1950368(1)

77210(1)

LR7B(1)

69100(1)

LRN7V(1)

LRN7-C(1)

LRN7-B(1)

LRN7-A(1)

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

BXM7HA(1)

BXM5HA(1)

BKL10-C(1)

BKL10-B(1)

BKL10-A(1)

BKC10BPA(1)

1950371(1)

88122(1)

 
Country of Origin

JP(55)

CN(17)

GB(10)

MX(8)

FR(6)

US(6)

ID(5)

IN(1)

 
Tip Type

Conical(4)

 
Special Ink Type

Washable(53)

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

Pilot Refillable Stick Ballpoint Pens(6)

Cross Ballpoint Pens(6)

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

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 RSVP Ballpoint Pens(3)

Pentel Vicuņa Advanced Ink Ballpoint Pens(3)

Pilot Precise V5 RT Roller Ball Pens(2)

4-Color Multifunction Retractable Ballpoint Pens(2)

Pilot Precise V7 RT Roller Ball Pens(2)

Waterman Roller Ball Pens(2)

Pilot VBall and VBall RT Roller Ball Pens(2)

Zebra JK G-301 Gel Ink Pens(2)

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

Cross Selectip Gel Ink Roller Ball Pens(2)

Parker Retractable Gel Ink Roller Ball Pens(2)

MMF Industries Jumbo Jogger Ballpoint Pens(2)

Vision Elite Roller Balls(1)

Jimnie Clip Retractable Ballpoints(1)

Zebra Telescopic & StylusTwist Ballpoint Pens(1)

Waterman Ballpoint Pens(1)

MMF Industries Security Ballpoint Pens(1)

Preventa 05051, 05054, 05074, 05075, MMF Kable, Sentry Counter Pens(1)

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

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

Pilot AcrobColors and AcrobPro Ballpoint Pens(1)

Pilot Downforce Ballpoint Pens(1)

Parker Washable Ink Fountain Pens(1)

V Ball RT Roller Ball(1)

Pentel Client Ballpoint Pens(1)

Pilot Plumix Fountain Pens(1)

Pilot Q7, G2 Limited, G2 Pro, Precise Gel BeGreen, Dr Grip LTD and Dr Grip Gel Ink Pens(1)

 
Point Type

Bold(2)

Medium(2)

Fine(1)

 
Pen Refill Type

Roller Ball(3)

Ballpoint(2)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved