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

Currently Filtered by

Category

Craft Supplies

Refine Search

  GO
 
Brand

Creativity Street(72)

Roylco(20)

Hygloss(17)

Pacon(9)

Trend(6)

Teacher Created Resources(5)

Deflecto(4)

Blum(4)

Crayola(2)

Educational Insights(1)

Elmer's(1)

Grumbacher(1)

Handy Art(1)

Carson-Dellosa(1)

Three Bear Family(1)

Learning Resources(1)

Trait-tex(1)

Plast'r Craft(1)

ChenilleKraft(1)

Sparco(1)

 
Color

Assorted(63)

White(17)

Multicolor(13)

Natural(10)

Clear(10)

Yellow(8)

Blue(8)

Red(6)

Black(6)

Green(6)

Bright Assorted(4)

Orange(3)

Silver(3)

Brown(3)

Gold(2)

Multi(2)

Assorted Metallic(2)

Purple(2)

Pink(2)

Blonde(1)

Violet(1)

Gray(1)

Tan(1)

Neon(1)

Dark Green(1)

 
Recycled

No(127)

 
Height

0.10"(4)

12"(4)

6"(4)

3"(3)

11"(2)

6.6"(2)

4.5"(2)

4.50"(1)

4"(1)

0.6"(1)

10.5"(1)

5.25"(1)

8.5"(1)

0.4"(1)

24"(1)

5"(1)

18"(1)

8"(1)

9"(1)

5.5"(1)

 
Depth

3"(2)

6"(1)

8.5"(1)

1.50"(1)

2"(1)

 
Diameter

0.2"(8)

2"(2)

0.6"(1)

0.5"(1)

 
Manufacturer Part Number

26011669(1)

52710(1)

00470(1)

00520(1)

00590(1)

25330(1)

25500(1)

52550(1)

52720(1)

0000880(1)

AC4344(1)

AC435006(1)

AC4359(1)

AC5200(1)

AC5201(1)

AC711002(1)

00130(1)

LER3372(1)

AC711006(1)

29306(1)

17018(1)

29129(1)

29302(1)

29303(1)

29304(1)

29305(1)

29307(1)

LER0744(1)

29310(1)

29606(1)

36100(1)

51102(1)

51504(1)

5516(1)

67632(1)

AC711003(1)

AC711208(1)

17013(1)

77204(1)

R5839(1)

R5842(1)

R5843(1)

R59650(1)

99825(1)

20671(1)

77206(1)

R5815(1)

77207(1)

77212(1)

10652(1)

10653(1)

10654(1)

10801(1)

10805(1)

R5823(1)

R5804(1)

AC711601(1)

R21145(1)

AC9084(1)

AC9085(1)

AC918201(1)

R15630(1)

R15665(1)

R2111(1)

R-2132(1)

R5803(1)

R2143(1)

R39100(1)

R48231(1)

R48235(1)

R52076(1)

R54460(1)

R5725(1)

17014(1)

900003(1)

26011676(1)

4190(1)

377502(1)

377601(1)

377602(1)

3904(1)

390701(1)

4170(1)

4310(1)

377401(1)

4313(1)

4318(1)

4380(1)

4389(1)

4502(1)

4503(1)

4505(1)

377501(1)

3685-01(1)

5100(1)

343801(1)

26011683(1)

26011690(1)

5528(1)

3400(1)

CKC3407(1)

3409(1)

343802(1)

367202(1)

344601(1)

344602(1)

344607(1)

3584(1)

3645-02(1)

3658-01(1)

367201(1)

4514(1)

6114(1)

B420(1)

9774(1)

9030(1)

9110-01(1)

911201(1)

9116-01(1)

9762(1)

9771(1)

045854(1)

818101(1)

570016(1)

350201(1)

3900CR(1)

3901CR(1)

5901(1)

1234(1)

2078431(1)

820001(1)

818001(1)

6118(1)

7110-05(1)

6120(1)

6129(1)

6400(1)

710001(1)

711001(1)

711004(1)

7110-08(1)

811601(1)

7110-10(1)

711201(1)

711202(1)

711203(1)

716001(1)

718001(1)

7184(1)

10867(1)

 
Country of Origin

China(74)

United States(54)

Taiwan(10)

Vietnam(5)

Canada(5)

United Kingdom(1)

Mexico(1)

 
Width

6"(5)

0.3"(4)

1"(4)

0.4"(4)

8.5"(3)

3"(3)

9"(2)

12"(2)

7"(2)

4"(2)

4.5"(2)

8.3"(2)

5.25"(1)

4.50"(1)

7.5"(1)

48"(1)

6.30"(1)

17.6"(1)

8"(1)

0.2"(1)

0.8"(1)

9.50"(1)

 
Material

Wood(15)

Plastic(15)

Polyester(14)

Foam(6)

Metal Spring(2)

Acrylic(2)

Paper(2)

Styrofoam(2)

Natural Wood(1)

Foil(1)

Cardboard(1)

Fabric(1)

 
Weight (Approximate)

3 lb(10)

1 lb(7)

4 oz(3)

0.16 oz(1)

1.12 oz(1)

6.90 lb(1)

1 oz(1)

1.28 oz(1)

3 oz(1)

0.50 oz(1)

12.80 oz(1)

5.44 oz(1)

6 oz(1)

5 lb(1)

20 lb(1)

15.70 oz(1)

 
Shape

Assorted(3)

Star(2)

36 x Star(1)

18 x Dog(1)

36 x Acorn(1)

72 x Leaves(1)

24 x Acorn(1)

24 x Log(1)

24 x Squirrel(1)

36 x Log(1)

36 x Owl(1)

18 x Paw(1)

55 x Letter(1)

8 x Label(1)

20 x Label(1)

Flower(1)

Circle(1)

Heart(1)

Crown(1)

96 x Bear(1)

24 x Person(1)

18 x Cat(1)

 
Length

12"(15)

6"(4)

8"(4)

1"(2)

7"(2)

6.5"(2)

5.4"(1)

72"(1)

11"(1)

9.5"(1)

5"(1)

4"(1)

23.60"(1)

11.7"(1)

396 ft(1)

450 ft(1)

10.4"(1)

300 ft(1)

3.4"(1)

180 ft(1)

12.8"(1)

15"(1)

16.5"(1)

18"(1)

19.5"(1)

4.5"(1)

3.8"(1)

2.9"(1)

 
Thickness

236.2 mil(7)

750 mil(1)

2"(1)

157.5 mil(1)

 
Placement

Desktop(1)

 
Size Standard

Mini(2)

 
Basis Weight

1 lb(2)

10 lb(1)

 
Skill Learning

Creativity(7)

Decoration(5)

Classroom(5)

Classroom Management(3)

Sorting(3)

Patterning(3)

Graphing(3)

Celebration(2)

Game(1)

Size Differentiation(1)

Birthday(1)

Art(1)

Exploration(1)

 
Total Number of Compartments

6(1)

9(1)

 
Number of Plys

3(1)

 
Number of Pieces

100(5)

41(4)

72(3)

125(2)

24(2)

5(1)

10000(1)

6(1)

26(1)

80(1)

1000(1)

1800(1)

560(1)

96(1)

30(1)

400(1)

4(1)

 
Theme/Subject

Learning(8)

Fun(5)

Encouragement(3)

Nature(1)

 
Mount Type

Magnetic(4)

 
Educational/Developmental Toy Type

Learning Toy(2)

 
Printed Design/Pattern/Texture

Chevron(1)

Dot(1)

 
Product Type

Stem(22)

Shape(11)

Rubbing Plate(9)

Craft Sand(9)

Wiggly Eye(8)

Wood Craft Stick(7)

Activity Kit(5)

Clothes Pin(5)

Clay Tool(4)

Foam Sheet(4)

Feather(4)

Button(4)

Yarn(4)

Craft Hair(3)

Craft Weaving Strip(3)

Decorative Magnet(3)

Desktop Organizer(3)

Decorative Accent(3)

Pom Pom(3)

Sequin and Spangle(3)

Pattern Rolling Pin(2)

Skill Developmental Toy(2)

Doily(2)

Mask Activity Kit(2)

Felt Sheet(2)

Paint Cup(2)

Craft Shape(1)

Quilt Block(1)

Art/Craft Straw(1)

Plaster Craft Strip(1)

Craft Rice(1)

Art Pipette(1)

Beads(1)

Magnetic Letter(1)

Craft Noodle(1)

Wood Shape(1)

Plaster Craft(1)

Wax Stick(1)

Craft Cord(1)

Craft Ball(1)

Marker Bottle(1)

Color Wheel(1)

Slime Activator Liquid(1)

Craft Paper(1)

Craft Fluff(1)

Dough(1)

Decorative Light Filter(1)

 
Packaged Quantity

1 Pack(22)

1 Each(21)

100 / Pack(17)

6 / Pack(6)

1 Box(5)

1 Kit(4)

1000 / Box(4)

30 / Pack(4)

16 / Pack(3)

600 / Bag(3)

72 / Pack(3)

5 / Set(3)

24 / Pack(3)

36 / Pack(3)

50 / Pack(3)

10 / Pack(2)

40 / Pack(2)

12 / Pack(2)

12 / Box(2)

6 / Set(2)

250 / Pack(2)

1 / Pack(2)

1 Set(2)

500 / Box(2)

8 / Set(1)

20 / Set(1)

480 / Box(1)

18 / Set(1)

20 / Pack(1)

228 / Box(1)

6000 / Pack(1)

15 / Pack(1)

55 / Pack(1)

108 / Pack(1)

6 / Box(1)

1146 / Pack(1)

48 / Pack(1)

96 / Set(1)

560 / Set(1)

400 / Set(1)

1 Bag(1)

12 / Bag(1)

3 / Pack(1)

6 / Carton(1)

24 / Each(1)

1800 / Box(1)

288 / Pack(1)

96 / Pack(1)

152 / Set(1)

68 / Set(1)

26 / Set(1)

 
Assembly Required

No(33)

 
Product Model

343801(1)

377502(1)

6400(1)

710001(1)

 
Product Line

Wonderfoam(6)

Classic Accents(3)

WoodCrafts(2)

Creations(1)

Colossal(1)

Bucket O'Buttons(1)

All About Me Family Counters(1)

Art-A-Roni(1)

Really Big Buttons(1)

BlockStars(1)

 
Package Contents

  • Zippered Case
  • 1 x Box Of Six No. 2 Hb Graphite Pencil
  • 7 x Eraser Caps/Point Protector
  • 1 x Pair Of Scissor
  • 1 x Box Of Crayon
  • 1 x Bi-Color Dry-Erase Marker
  • 1 x Twin-Tip Highlighter
  • 1 x Glue Stick
  • 1 x Pink Wedge Eraser
  • 1 x Sharpener
  • 1 x Plastic Ruler
  • 6 x Bi-Colored Pencils In 12 Assorted Color
  • 6 x Twin-Tip Marker
(4)

  • Junior Rubbing Plates
  • Idea Guide
(2)

  • 24 x Squirrel
  • 24 x Log
  • 24 x Acron
(1)

  • 36 x Owl Designs
  • 36 x Logs
(1)

  • 6 x Bug Rubbing Plate
  • Guide
(1)

  • 6 x Fossil Rubbing Plate
  • Guide
(1)

  • 4 x Texture Rubbing Plate
  • 8 x Design
  • 1 x Guide with Craft Ideas
(1)

  • 6 x Dinosaur Shape Rubbing Plates
  • Guide
(1)

  • 16 x Leaf Shape Rubbing Plate
  • Guide
(1)

  • 16 x Flower Shape Rubbing Plates
  • Guide
(1)

  • 16 x Insect Shape Rubbing Plate
  • Guide
(1)

  • 6 x Reproducible Black and White Quilt Block
  • 1140 x Square and Triangle
  • Guide
(1)

  • Stacking Jar Wiggle Eye
  • 288 x Round Eyes (5mm)
  • 144 x Round Eyes (7mm)
  • 72 x Round Eyes (10mm)
  • 36 x Round Eyes (10mm)
  • 20 x Oval Black Eyes (20mm)
(1)

  • Mosaic Squares
  • Guide
(1)

  • Chenille Stems
  • Project Idea/Instructions Sheet
(1)

  • Plaster Craft Strip
  • Full Instructions
(1)

  • Plaster Craft Gauze
  • 5 lb. Fan fold dispenser box
(1)

  • Treasure Chest of Wood
  • Dowels
  • Spindles
  • Blocks
  • Petal-like Shapes
(1)

  • Counters Rainbow Set
  • Reusable Storage Container
  • 24 x Papa Bear
  • 24 x Mama Bear
  • 48 x Baby Bear
(1)

  • Cube Organizer
  • Divider
  • Clip
(1)

  • Flower Roller
  • Round Cutting Roller
  • Zig Zag Cutting Roller
  • Double-sided Large Hobby Craft Tool
  • Plastic Blade
(1)

  • 25 x 7mm Wiggly Eye
  • 25 x 10mm Wiggly Eye
  • 25 x 12mm Wiggly Eye
  • 25 x 15mm Wiggly Eye
(1)

  • 40 x 20mm Wiggle Eye
  • 60 x 7mm Wiggle Eye
  • 100 x 10mm Wiggle Eye
  • 100 x 12mm Wiggle Eye
  • 100 x 15mm Wiggle Eye
(1)

  • 36 x Acron
  • 72 x Leaves
(1)

 
 
 

© 2020-2021 Crawford Office Supply, All Rights Reserved