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

Currently Filtered by

Category

Crayons

Refine Search

  GO
Brand

Crayola(11)

Dixon(10)

Markal(10)

Sharpie(4)

Prang(4)

Stride(2)

Mr. Sketch(2)

AbilityOne(1)

SARGENT ART(1)

Color(s)

Assorted(10)

White(5)

Yellow(4)

Black(4)

Red(3)

64 Assorted(2)

Fluorescent Orange(2)

Blue(2)

8 Assorted(2)

Fluorescent Red(1)

18 Assorted(1)

12 Assorted(1)

Carbon Black(1)

152 Assorted(1)

24 Assorted(1)

4 Assorted Colors(1)

16 Assorted(1)

Black (Thin Lead)(1)

Green(1)

Width

0.31"(8)

Country of Origin

US(22)

MX(14)

KR(6)

IT(2)

Length

3.63"(4)

Size Group

Standard(28)

Large(3)

Medium(2)

Regular(1)

Age Recommendation

Ages 4 and up(11)

Ages 2 and up(2)

Adult(2)

Ages 4 and Up(1)

Ages 10 and Up(1)

Crayon Size

3.63 x 0.31(7)

3/8" x 6"(4)

11/16" x 4 3/4"(3)

3 5/8 x 5/16(2)

4 1/2" x 1/2"(2)

4 x.44(1)

3 5/8" x 5/16"(1)

4 3/4 x 3/8"(1)

1/2" x 4 5/8"(1)

3/8" x 4"(1)

7 x 0.69"(1)

11/16" x 6"(1)

3 5/8" 5/16"(1)

Temp. Range

Soften at 105 F; Melt at 128 F(10)

-50F to 150F(4)

0F to 140F(3)

-20F to 150F(1)

175 F(1)

Applicable Material

Ceramics; Glass; Metal; Rubber; Wood(4)

Cardboard; Concrete; Glass; Metal; Paper; Plastic; Rubber; Wood(4)

Wood(2)

Steel(1)

Cardboard; Ceramics; Concrete; Glass; Metal; Paper; Plastic; Rubber; Wood(1)

Film; Glass; Metal; Paper; Plastic; Rubber; Tile(1)

Color Family

Multicolor(19)

Black(6)

White(4)

Yellow(3)

Red(2)

Green(1)

Blue(1)

Colored Material Type

Paraffin Wax(4)

Vegetable Oil/Paint(4)

Wax(4)

Oiled Clay(1)

Special Features

Peggable Retail Pack(3)

64 colors, 13 of each color, sharpener included(1)

18-Pack Assortment-Assorted scents and colors make for a fabulously fun coloring experience.(1)

50 of each color(1)

12-Pack Assortment-Assorted scents and colors make for a fabulously fun coloring experience.(1)

100 of each color(1)

Classic Flip-Top Pack with Built-In Sharpener(1)

Classpack-128 Ultra-Clean WashableT Markers in 8 different colors and 128 Large Crayons in 8 different colors.(1)

Tuck Box(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved