SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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_cost`=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 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(38)

Pentel(22)

Zebra(12)

Parker(12)

Cross(12)

uni-ball(5)

BIC(4)

MMF Industries(3)

Waterman(3)

AbilityOne(1)

Iconex(1)

PM Company(1)

Ink Color(s)

Black(13)

Blue(6)

Red(4)

Black;Blue(1)

Purple(1)

Black;Blue;Green;Red(1)

Country of Origin

JP(59)

CN(17)

GB(10)

MX(8)

US(7)

FR(7)

ID(5)

IN(1)

For Use With

Pentel EnerGel Pens(15)

Pilot FriXion Ball and FriXion Clicker(5)

Pentel Vicuņa(2)

ZEB44120(1)

ZEB44110, ZEB14410(1)

ZEB44130(1)

ZEB41311(1)

ZEB41321(1)

ZEB27120, ZEB27122, ZEB29220, ZEB29222(1)

ZEB27211(1)

Pilot Downforce Pens(1)

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

ZEB27310(1)

Pentel Client(1)

ZEB27221(1)

ZEB27110, ZEB27112, ZEB29210, ZEB29212(1)

Tip Type

Conical(22)

Special Ink Type

Washable(39)

Permanent(5)

Gel(4)

Quink(4)

Low-Viscosity(3)

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)

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

Parker Ballpoint Pens(4)

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

Cross Selectip Porous Point Pens(4)

Parker Roller Ball Pens(4)

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

V Ball RT Roller Ball(3)

Waterman Roller Ball 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)

Pilot Precise V5 RT Roller Ball Pens(2)

Pilot Precise V7 RT Roller Ball Pens(2)

Signo Gel 207, 207 Premier, Gel RT Ballpoints(2)

Zebra JK G-301 Gel Ink Pens(2)

Pilot Refillable Stick Ballpoint Pens(2)

MMF Industries Jumbo Jogger Ballpoint Pens(2)

Parker Retractable Gel Ink Roller Ball Pens(2)

Pentel RSVP Ballpoints(2)

Cross Selectip Gel Ink Roller Ball Pens(2)

Pentel Vicuņa Advanced Ink Ballpoint Pens(2)

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

MMF Industries Security Ballpoint Pens(1)

JetStream RT Ballpoints(1)

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

Vision Elite Roller Balls(1)

Waterman Ballpoint Pens(1)

Jimnie Clip Retractable Ballpoints(1)

Telescopic Ballpoints & StylusTwist Pens(1)

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

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

4-Color Multifunction Retractable Ballpoint Pens(1)

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

4-Color Retractable Ballpoint Pen(1)

Pentel RSVP 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)

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

Vicuņa(1)

Pilot Downforce Ballpoint Pens(1)

Pilot G2 Gel Ink Pens(1)

Parker Washable Ink Fountain Pens(1)

All Parker Permanent Ink Fountain Pens(1)

Pilot Acroball(1)

Point Type

Medium(11)

Fine(10)

Bold(3)

Extra Fine(1)

Pen Refill Type

Ballpoint(19)

Roller Ball(6)

Fountain(1)

Color Family

Black(41)

Blue(31)

Red(9)

Multicolor(4)

Purple(3)

Green(1)

Special Features

For All EnerGel Pens(15)

For Q7, G2, G2 Limited, G2 Pro, G2 Fashion, G6, Precise Gel BeGreen, Dr Grip LTD, Dr Grip Gel, B2P Gel, G-Knock and MR Metropolitan Gel Rollers(8)

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

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

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

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved