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

Currently Filtered by

Category

Markers

Refine Search

  GO
Brand

Sharpie(140)

EXPO(67)

BIC(45)

Crayola(36)

Pilot(35)

AbilityOne(30)

Avery(28)

Paper Mate(25)

Universal(24)

SARGENT ART(23)

Sanford uni-Paint(23)

Quartet(13)

Markal(13)

DYKEM(11)

Mr. Sketch(10)

Zebra(6)

U Brands(6)

Pentel(6)

Pentel Arts(5)

Staedtler(5)

Stride(3)

deflecto(2)

Prang(2)

Carter's(1)

Dixon(1)

Prismacolor(1)

Color(s)

Assorted(7)

Orange(1)

Assorted|FFFFFF(1)

Blue(1)

Refillable

Nonrefillable(70)

Ink Color(s)

Black(2)

Orange(1)

Green(1)

Red(1)

Blue(1)

Country of Origin

US(241)

CN(93)

MX(57)

JP(52)

VN(40)

KR(24)

DE(7)

IT(7)

IN(6)

TN(5)

MY(4)

FR(2)

TW(1)

Tip Type

Chisel(6)

Broad(3)

Bullet Medium(2)

Fine(2)

Bullet(2)

Pocket Clip

Yes(64)

No(6)

Pen Style

Stick(70)

Visible Ink Supply

No(60)

Yes(10)

Special Ink Type

Free-flowing Liquid(23)

Permanent Liquid(15)

Water-Based Liquid(8)

Liquid(8)

Permanent Water-resistant Liquid(6)

Dry Erase(5)

Erasable Gel(4)

Waterproof Liquid(3)

Gel(2)

Permanent(1)

Washable Liquid(1)

Age Recommendation

Ages 4 and up(18)

Ages 3 and up(12)

Ages 8 and up(11)

Ages 5 and Up(9)

Ages 6 and up(8)

Ages 3 and Up(6)

Artist Quality/School Grade

School Grade(5)

Refill For Series

BeGreen V Board Master(5)

Pilot Jumbo Refillable Permanent Markers(1)

Tip Size

Fine(3)

Broad(2)

Pink Comments

You can help Sharpie reach our goal donation of $200,000 or more to City of Hope for breast cancer research, treatment and education. Through December 31, 2018, 10 from each marker/highlighter purchase will go toward that donation.(1)

Pen Type

Porous Point Pen(70)

Pen Point Size

0.7 mm(19)

0.4 mm(14)

0.5 mm(13)

0.3 mm(8)

0.8 mm(6)

2.5 mm(4)

1.4 mm(3)

0.2 mm(3)

Ink Types

Washable(3)

Permanent(2)

Non-Washable(1)

Dry Erase(1)

Marker Type

Art(6)

Industrial/Specialty(2)

Art Markers(1)

Dry Erase(1)

Pen Refill Type

Dry Erase Marker(5)

Permanent Marker(1)

Color Family

Multicolor(211)

Black(131)

Red(56)

Blue(56)

White(20)

Green(19)

Yellow(12)

Silver(8)

Purple(5)

Orange(4)

Gold(3)

Pink(1)

Bronze(1)

Multicolor|FFFFFF(1)

Brown(1)

Special Features

Value Pack-Stock up and save!(19)

Tank-Style(8)

Ergonomic Rubber Grip(5)

Value Pack-24 for the price of 20!(4)

Limited Edition Tropical Vacation Colors(4)

Value Pack(4)

Versatile Chisel Tip-Fine, chisel tip draws bold details and allows users to draw 3 line widths.(3)

Limited Edition Sharpie Color Burst Permanent Markers-Crank up the color with the intensely bright, supercharged shades of Limited Edition Sharpie Color Burst Permanent Markers!(2)

Classic Colors-Black, blue, brown, green, orange, red, violet and yellow.(2)

Ultra Fine Tip-For precise marking tasks.(2)

StixT-The 0.8mm tip makes illustrating and lettering precise.(1)

216-Count School Pack-Includes 18 of each color.(1)

Fine Tip-For detailed lines.(1)

Versatile Chisel Tip with Low Odor Ink-Versatile chisel tip allows users to draw 3 line widths, while low odor ink creates a pleasant user experience.(1)

Convenient 36-Count Classroom Pack-Stock up and save!(1)

20 Color Set(1)

10 Color Set(1)

42 Color Set(1)

Chisel Tip-For broad, medium or fine lines.(1)

Comprehensive 192-Count Full Classroom Set-Stock up and save!(1)

Classic Assortment-Bold and vivid traditional colors.(1)

Bold Colors(1)

200-Count Classpack-Includes 25 of each color and 12 extra marker caps.(1)

Classic Colors-Black, blue, brown, gray, green, orange, pink, red, violet and yellow.(1)

Classic Colors(1)

Classic Colors-Black, blue, blue lagoon, brown, gray, green, orange, pink, red, sandy tan, violet and yellow.(1)

256-Count Classpack-Includes 16 of each Crayola Classic Color.(1)

200-Count Classpack-Includes 20 of each color and 12 extra marker caps.(1)

Fine(1)

Pocket-Style(1)

Broad(1)

Value Pack-Stock Up and Save!(1)

Value Pack-36 for the price of 30!(1)

Desk/Pen Style Combo-Value Pack -- 24 for the price of 20!(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor

© 2019-2020 United Supply Corp, All Rights Reserved