facebook
 
 
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_name` IN ('Dry-Erase Kits/Holders','Dry Erase Markers','Overhead Transparency Markers','Permanent Markers','Specialty Markers','Flipchart Markers')) 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 '%MarkersandDryErase' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('MarkersandDryErase' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MarkersandDryErase' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MarkersandDryErase"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MarkersandDryErase"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MarkersandDryErase"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MarkersandDryErase"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MarkersandDryErase' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MarkersandDryErase',`category_4` ='MarkersandDryErase') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MarkersandDryErase,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MarkersandDryErase', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Markers And Dry Erase

Refine Search

  GO
 
Brand

Sharpie(93)

Expo(56)

Avery®(23)

BIC(23)

Sanford(17)

Uni-Ball(16)

Integra(16)

Quartet(12)

Pilot(9)

Marvy(7)

Take Note!(7)

Ticonderoga(5)

CLI(5)

Pentel(4)

Zebra Pen(4)

Lorell(4)

Crayola(4)

Marks-A-Lot(2)

Lumocolor(2)

Staedtler(2)

Uchida(2)

Helix(1)

Flipside(1)

Dixon(1)

Creativity Street(1)

U Brands(1)

The Board Dudes(1)

SKILCRAFT(1)

 
Color

Blue(1)

Silver(1)

Black(1)

 
Recycled

No(312)

Yes(2)

 
Height

6"(3)

7.5"(2)

0"(2)

1"(1)

8.5"(1)

7"(1)

7.6"(1)

 
Depth

0.1"(2)

3"(1)

 
Refillable

No(70)

Yes(6)

 
Manufacturer Part Number

7886(1)

32001BX(1)

32175PP(1)

32174PPBG(1)

32174PP(1)

32003BX(1)

32003(1)

32002BX(1)

32002(1)

32001(1)

32701(1)

30665PP(1)

30078(1)

30072(1)

30008(1)

30006(1)

30004(1)

30003(1)

32175PPBG(1)

32701DZ(1)

30001(1)

33861PP(1)

37001(1)

35558(1)

35554(1)

35543(1)

35533(1)

35113PP(1)

34971PP(1)

33002(1)

32702(1)

33001(1)

32730PP(1)

32726PP(1)

32707(1)

32703DZ(1)

32703(1)

32702DZ(1)

30002(1)

22480PP(1)

37003(1)

1944745(1)

1983254(1)

1983252(1)

1983251(1)

1983180(1)

1983179(1)

1944748(1)

1944746(1)

1944741(1)

2003893(1)

1944729(1)

1944728(1)

1944658(1)

1944657(1)

1944656(1)

1944654(1)

1927526(1)

1983255(1)

2003894(1)

22478(1)

2018335(1)

22474(1)

2083007(1)

2082960(1)

2029679(1)

2029678(1)

2029673(1)

2029665(1)

2018328(1)

2003895(1)

2018326(1)

2018324(1)

2017818(1)

2011580(1)

2010953(1)

2003995(1)

2003898(1)

37002(1)

37371PP(1)

1927322(1)

63603(1)

63607(1)

63606DZ(1)

63606(1)

63605DZ(1)

63605(1)

63604(1)

63603DZ(1)

63602(1)

63613(1)

318 WP4(1)

318-9(1)

316-9(1)

305FWP41(1)

86674K(1)

86603(1)

86074(1)

63611(1)

63613DZ(1)

86002(1)

4300S1(1)

78115(1)

78101(1)

65111(1)

5606A(1)

56030A(1)

51244A(1)

4300S3(1)

300S-0(1)

63614(1)

3006C(1)

3006B(1)

3006A(1)

2913U0012(1)

63631(1)

63630(1)

63614DZ(1)

86003(1)

86001(1)

37675PP(1)

44002(1)

80002(1)

80001(1)

75847(1)

75846(1)

44003BX(1)

44003(1)

44002BX(1)

44001BX(1)

80004(1)

44001(1)

39109PP(1)

39108PP(1)

39100(1)

38203(1)

38202(1)

38201(1)

80003(1)

80008(1)

85018(1)

80699(1)

85005(1)

82074(1)

82003(1)

82002(1)

82001(1)

81503(1)

81045(1)

80678(1)

1826087(1)

80675(1)

80661(1)

80653(1)

80556(1)

80174(1)

80078(1)

80074(1)

1927432(1)

1926876(1)

7887(1)

54-6203(1)

586598(1)

586597(1)

586549(1)

586548(1)

586547(1)

586546(1)

586545(1)

2080(1)

985906(1)

PMR11BKDZ(1)

PMR11BK(1)

PMIT11BK(1)

PMIPK11BK(1)

PMIPJ11BK(1)

GPMUP12ASST(1)

GPMU11-BK(1)

58-8173(1)

985912(1)

GPMM11-BK(1)

01019(1)

30017(1)

30016(1)

30015(1)

30012(1)

30011(1)

30010(1)

30009(1)

01017(1)

92101(1)

741804(1)

32008(1)

92180(1)

92140(1)

92108(1)

92107(1)

92104(1)

GPMM36BK(1)

GPMAP12-AST(1)

33308(1)

24148BX(1)

29857(1)

27178(1)

24878(1)

24459(1)

24411(1)

24409(1)

24408(1)

24148(1)

29870(1)

24147BX(1)

24147(1)

08888(1)

8887(1)

8886(1)

8885(1)

7888(1)

29860(1)

98088(1)

GPM11-BK(1)

GDE11-BE(1)

GPM11-BE(1)

GELITP41-AST(1)

GELIT11BK(1)

GDEMP41-AST(1)

GDEM11-BK(1)

GDE11-RD(1)

GDE11-BK(1)

DECP41ASST(1)

98187(1)

DEC11RD(1)

DEC11BK(1)

DEC11BE(1)

CXY73(1)

98207(1)

98206(1)

98188(1)

30018(1)

33309(1)

1921559(1)

1735790(1)

1735801BX(1)

1735801(1)

1735792DZ(1)

1735792(1)

1735791DZ(1)

1735791(1)

1735790DZ(1)

16078(1)

1741920(1)

16074(1)

16004(1)

16003(1)

16002(1)

16001(1)

15003(1)

15002(1)

1741919(1)

1742025(1)

14075(1)

1871133(1)

1921062(1)

1921061(1)

1920940(1)

1920937(1)

1919848(1)

1884739(1)

1884309(1)

1871131(1)

1751669(1)

1860443(1)

1829202(1)

1823887(1)

1823815(1)

1785294(1)

1760445(1)

1752226(1)

15001(1)

13601(1)

33310(1)

55643(1)

NXS15PGBP4A(1)

100W-S(1)

100W(1)

7520-01-519-5769(1)

99732(1)

75628(1)

55644(1)

76840ST(1)

11045(1)

74541(1)

47814(1)

47804(1)

35040(1)

33328(1)

33327(1)

33311(1)

NXS15PGBP4M(1)

41700(1)

85377(1)

51-659312Q(1)

85376(1)

79553(1)

79552(1)

79551(1)

659511Q(1)

558(1)

51-989692Q(1)

5001M(1)

41800(1)

5001-2M(1)

5001-10M(1)

45100(1)

44102(1)

43924(1)

43923(1)

43922(1)

43917(1)

80111(1)

 
Country of Origin

United States(128)

China(84)

Mexico(33)

Japan(24)

Vietnam(20)

South Korea(13)

Korea(7)

Germany(5)

France(4)

Brazil(1)

 
Width

2.8"(2)

2.3"(2)

0"(2)

1"(1)

5"(1)

0.3"(1)

0.6"(1)

 
Material

Plastic(14)

Polypropylene(2)

Aluminum(1)

Metal(1)

Gold Plated(1)

 
Limited Warranty

1 Year(19)

Lifetime(2)

 
Weight (Approximate)

10.72 oz(6)

0.80 oz(4)

3.20 oz(4)

0.96 oz(2)

0.64 oz(2)

1 lb(1)

4.64 oz(1)

8 oz(1)

0.48 oz(1)

 
Length

1.6"(2)

0.6"(2)

5.9"(1)

0.3"(1)

0.5"(1)

 
Retractable

No(65)

Yes(28)

 
Barrel Material

Plastic(17)

Polypropylene(4)

Stainless Steel(1)

 
Marker Point Style

Chisel(105)

Bullet(36)

Wedge(6)

Narrow(4)

Tapered(3)

Brush(1)

 
Lead Color

Black(1)

 
Tip Material

Metal(3)

Fiber(2)

Felt(2)

Acrylic Fiber(1)

Acrylic(1)

Plastic(1)

 
Product Type

Permanent Marker(146)

Dry Erase Marker(119)

Paint Marker(27)

Waterbased Marker(11)

Marker(5)

Marker Refill(4)

Chalk Holder(2)

Poster Marker(1)

Dry Erase Kit(1)

Marker/Eraser Kit(1)

Porous Point Pen(1)

Multi Purpose Holder(1)

Portable Whiteboard Kit(1)

 
Packaged Quantity

12 / Dozen(69)

1 Each(45)

4 / Set(21)

4 / Pack(19)

12 / Pack(10)

8 / Set(10)

6 / Set(10)

12 / Box(9)

8 / Pack(9)

12 / Set(9)

5 / Pack(6)

36 / Box(6)

36 / Pack(6)

24 / Box(5)

1 Dozen(4)

1 / Each(4)

5 / Set(4)

2 / Pack(3)

3 / Set(3)

1 / Kit(2)

80 / Pack(2)

24 / Set(2)

16 / Set(2)

24 / Bag(2)

12 / Display Box(1)

4 / Card(1)

15 / Each(1)

10 / Pack(1)

30 / Set(1)

8 / Box(1)

3 / Card(1)

72 / Box(1)

44 / Box(1)

192 / Pack(1)

115 / Box(1)

3 / Pack(1)

6 / Pack(1)

40 / Box(1)

2 / Set(1)

24 / Pack(1)

168 / Box(1)

1 Pack(1)

 
Assembly Required

No(310)

Yes(4)

 
Product Model

PX-20(5)

1752226(1)

22474(1)

22478(1)

32701(1)

37001(1)

80078(1)

85005(1)

85018(1)

86603(1)

305(1)

PM-701(1)

 
Product Line

Marks-A-Lot(20)

Uni-Paint(14)

Great Erase(8)

Mark-it(7)

Vis--Vis(6)

PRO(5)

Magnum(5)

Expo(4)

DecoColor(4)

Sharpie(4)

Intensity(4)

EnduraGlide(3)

Flip Chart(3)

Precision(2)

Graffiti(2)

LePen(2)

Mean Streak(2)

Metallic(2)

Magic Marker(2)

Mildliner(2)

PROGear(2)

Creative(2)

Premium(2)

Super Color(1)

Classpack(1)

2 in 1(1)

Lumocolor(1)

V Board Master(1)

Extreme(1)

Carter's(1)

Twin Tip(1)

ReWritables(1)

Glo-write(1)

Cosmic Color(1)

Stick(1)

King Size(1)

Mini(1)

 
Ink Color

Black(111)

Blue(71)

Red(70)

Assorted(62)

Green(45)

Yellow(17)

Orange(14)

Purple(11)

White(11)

Brown(10)

Aqua(7)

Lime(7)

Silver(6)

Turquoise(6)

Berry(5)

Tangerine(5)

Pink(5)

Magenta(5)

Mint(4)

Gold(4)

Metallic Silver(3)

Neon Pink(3)

Violet(3)

Navy Blue(3)

Plum(3)

Nano Blue(3)

Ultra Violet(3)

Olive Green(2)

Peach(2)

Burgundy(2)

Marigold(2)

Brilliant Blue(2)

Racey Red(2)

Lilac(2)

Sky Blue(2)

Supersonic Yellow(2)

Jetset Jade(2)

Slate Gray(2)

Valley Girl Violet(2)

Jellie Pink(2)

Neon Yellow(2)

Neon Blue(2)

Neon Green(2)

Neon Orange(2)

Navy(1)

Pale Violet(1)

Rosemarie(1)

Light Green(1)

Light Blue(1)

Blush Pink(1)

Peppermint(1)

Pastel Peach(1)

Pale Blue(1)

Cream Yellow(1)

Brown/Pink(1)

Venus Green(1)

Plum/Lime(1)

Garnet/Green(1)

Boysenberry(1)

Bronze(1)

Optic Orange(1)

Techno Blue(1)

Electric Pink(1)

Sapphire/Aquamarine(1)

Jupiter Red(1)

Hot Purple(1)

 
Barrel Color

White(19)

Black(13)

Silver(12)

Assorted(11)

Red(6)

Blue(5)

Green(4)

Gold(1)

 
Ink Type

Alcohol Based(46)

Oil Based(26)

Water Based(7)

Pigment-based(6)

Liquid(1)

 
Pen Point Size

0.3 mm(1)

 
Package Type

Bulk(4)

 
Marker Point Size

4.7625 mm(10)

1 mm(5)

15.875 mm(4)

0.5 mm(4)

15.87 mm(3)

0.6 mm(3)

3 mm(2)

0.3 mm(2)

16.93418 mm(1)

4.7 mm(1)

1.4986 mm(1)

1.1 mm(1)