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 ('250')) 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 ('Pencils' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Pencils' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Pencils"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Pencils"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Pencils"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Pencils"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Pencils' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Pencils',`category_4` ='Pencils') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Pencils,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Pencils', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Pencils

Refine Search
  GO
Brand

Pentel(66)

Prismacolor(28)

Paper Mate(25)

BIC(23)

AbilityOne(23)

Ticonderoga(17)

Zebra(13)

Universal(11)

Dixon(9)

Prang(9)

Moon Products(9)

Staedtler(6)

Crayola(5)

SARGENT ART(3)

Pilot(3)

Markal(3)

Mr. Sketch(3)

Tombow Mono(2)

Koh-I-Noor(1)

Tombow(1)

Refillable

No(14)

Yes(4)

Country of Origin

US(62)

CN(54)

MX(49)

JP(45)

TW(12)

IN(12)

ID(5)

BR(5)

VN(4)

KR(3)

FR(3)

TH(2)

CZ(1)

Pocket Clip

No(15)

Yes(3)

Barrel Color(s)

Assorted(8)

Black(2)

Yellow(1)

Assorted|FFFFFF(1)

Treasure Assortment(1)

Silver(1)

Blue(1)

White(1)

Green(1)

Motivational Assortment(1)

Retractable

No(14)

Yes(4)

Suggested Use

General Use(3)

Coloring Pictures(1)

Marking All Types of Metal Surfaces(1)

Barrel Material

Wood(13)

Plastic(5)

Age Recommendation

Ages 6 and Up(4)

Ages 3 and Up(3)

K-12(1)

3+ years(1)

Ages 6 and up(1)

Lead Diameter

0.5 mm(2)

0.9 mm(1)

2.9 mm(1)

0.7 mm(1)

3.3 mm(1)

3 mm(1)

Mechanism

Mechanical(4)

Twistable(1)

Lead Degree (Hardness)

HB(13)

Soft(3)

H(1)

Lead Color(s)

Black(12)

Assorted(3)

Assorted|FFFFFF(1)

Silver(1)

Red(1)

Graphite(1)

Artist Quality/School Grade

School Grade(12)

Artist Quality(2)

Artist Quality; Drawing(1)

Artist Quality; School Grade(1)

Mfr. Refill Number (Item Number)

PAP66381PP, PAP66379PP, PAP66401PP(1)

PAP66378PP, PAP66380PP, PAP66400PP(1)

Lead Hardness (Number)

#2(12)

#3(1)

Special Packaging

Blister Pack(5)

Classpack(3)

Reusable Tin(1)

Assorted Barrel Color

Amaranth; Black; Blue; Brown; Dark Pink; Gray; Green; Light Blue; Light Green; Light Pink; Light Purple; Orange; Pink; Purple; Red; Teal; White; Yellow|E52B50(1)

150 Assorted Colors(1)

2 Lime; 2 Pink; 2 Purple; 2 Red; 1 Royal Blue; 1 Sky Blue; 2 Yellow(1)

Clear with Green Accents and Four Interchangeable Colored Tops - Yellow; Orange; Pink; Blue(1)

Neon Pink;Neon Orange;Neon Green;Neon Yellow;Neon Yellow/Orange(1)

Pink Comments

Pentel will donate 5¢ from the purchase of this pack, up to $15,000 to The Breast Cancer Research Foundation.(1)

Barrel Message

Attendance Award(1)

Caught Doing Good; Excellent Work; Super Reader; Star Student(1)

Assorted Glitz; Kid Camouflage; Magical Nights; Neon-delic Holographic Designs(1)

Excellent Work(1)

Caught Doing Good(1)

Teacher's Pencil(1)

Kindergartners are #1(1)

Star Student(1)

Assorted Lead Colors

Amaranth; Black; Blue; Brown; Dark Pink; Gray; Green; Light Blue; Light Green; Light Pink; Light Purple; Orange; Pink; Purple; Red; Teal; White; Yellow|E52B50(1)

150 Assorted Colors(1)

Grip Type

Smooth(2)

Hexagonal Barrel(1)

Cushioned(1)

Triangular(1)

Textured Rubber Grip(1)

Packaging

Single(11)

Pencil Type

Woodcase(11)

Mechanical(4)

Drawing(2)

Colored(1)

Welder's(1)

Eraser

Yes(13)

No(5)

Sleeve

Fixed(2)

Retractable(1)

No(1)

Color Family

Black(195)

Multicolor(31)

Blue(4)

Red(3)

Silver(2)

White(1)

Green(1)

Yellow(1)

Special Features

Value Pack-Stock up and save!(6)

11/32" Barrel(2)

Value Pack(2)

Value Pack-24 for the price of 18.(2)

Value Pack-Buy 18, get 6 for free.(2)

Medium Lead(1)

0.7 mm Tip-Writes medium lines.(1)

Smear-Proof Lead(1)

Double-Ended Pencil(1)

Master Pack-24 of each color.(1)

Without Eraser(1)

240-Count Classpack-Includes 20 of each color.(1)

Long Length Pencil(1)

252-Count Classpack-Includes 20 of each color and 12 handheld sharpeners.(1)

462-Count Classpack-Includes 33 of each color and 12 handheld sharpeners.(1)

With Eraser(1)

Presharpened(1)

Golf Pencil(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp