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 ('Puzzles','Calendars & Planners','Teaching Flash Cards','Learning Boards','Educational Record Books','Stickers','Terrific Trimmers','Handwriting Paper','Learning Books','Reference Books','Creative Learning','Library Pockets','Teaching Aids','Teaching Calendars & Planners')) 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_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 '%TeachingSupplies' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('TeachingSupplies' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+TeachingSupplies' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"TeachingSupplies"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"TeachingSupplies"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"TeachingSupplies"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"TeachingSupplies"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+TeachingSupplies' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='TeachingSupplies',`category_4` ='TeachingSupplies') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'TeachingSupplies,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('TeachingSupplies', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Teaching Supplies

Refine Search

  GO
 
Brand

Trend(43)

Pacon(19)

Carson-Dellosa(4)

Zaner-Bloser(3)

Mead(2)

Creativity Street(2)

Roaring Spring(2)

Advantus(1)

Rainbow(1)

Avery®(1)

Quality Park(1)

 
Color

Assorted(19)

Multi(8)

Red(3)

White(2)

Yellow(1)

Blue(1)

Purple(1)

Green(1)

Multicolor(1)

Cream(1)

Black(1)

Silver(1)

 
Size

Letter(2)

 
Recycled

No(42)

Yes(2)

 
Packaged Quantity

1 Each(26)

500 / Ream(7)

100 / Pack(6)

1 / Box(5)

1 Pack(4)

10 / Pack(4)

432 / Pack(2)

500 / Pack(2)

30 / Pack(2)

1 / Set(2)

480 / Pack(1)

5100 / Pack(1)

1 Set(1)

648 / Pack(1)

435 / Pack(1)

300 / Pack(1)

1300 / Pack(1)

250 / Box(1)

800 / Pack(1)

1 Roll(1)

12 / Set(1)

100 / Box(1)

600 / Pack(1)

250 / Pack(1)

6 / Pack(1)

440 / Pack(1)

25 / Chart(1)

1000 / Pack(1)

7 / Set(1)

 
Assembly Required

No(53)

 
Limited Warranty

90 Day(1)

 
Weight (Approximate)

4.80 oz(5)

3 lb(4)

12.48 oz(3)

1.40 lb(2)

7.20 oz(2)

3.36 oz(2)

0.16 oz(2)

12.96 oz(2)

1.38 lb(1)

1.41 lb(1)

6.08 oz(1)

1.76 oz(1)

12.32 oz(1)

9.28 oz(1)

4.56 lb(1)

 
Recycled Content

0%(6)

 
Basis Weight

20 lb(1)

 
Date Format

Daily(1)

 
Sheet Color

White(10)

Assorted(2)

 
Sheet Height

11 1/32"(1)

 
Skill Learning

Vocabulary(3)

Time(3)

Language(3)

Spelling(2)

Mathematics(2)

Number(2)

Reading(1)

Multiplication(1)

Alphabet(1)

Rhyming(1)

Word(1)

Early Skill Development(1)

Shape(1)

Addition(1)

Matching(1)

Science(1)

Sorting(1)

Operation(1)

Patterning(1)

Inequalities(1)

Motivation(1)

Classroom(1)

Classifying(1)

Computation(1)

Geography(1)

Color Matching(1)

 
Cover Color

Assorted(1)

 
Recommended Age

5+(3)

4-7 Year(3)

3 Year(3)

6+(3)

8+(2)

8-13 Year(2)

9-13 Year(2)

4 Year & Up(1)

5-8 Year(1)

6-9 Year(1)

4-6 Year(1)

5-9 Year(1)

7-14 Year(1)

10-13 Year(1)

7+(1)

6-8 Year(1)

9-11 Year(1)

10-14 Year(1)

 
Theme/Subject

Learning(18)

 
Mount Type

Self-adhesive(11)

Pin-up(6)

 
Cover Material

Chipboard(1)

 
Front Ruling Type

Wide Ruled(1)

 
Educational/Developmental Toy Type

Learning Clock(2)

 
Game Type

Educational(15)

 
Manufacturer Part Number

T53101(1)

T53015(1)

T53014(1)

T53103(1)

T53105(1)

T58001(1)

T580(1)

T53106(1)

T53004(1)

T46910(1)

6137(1)

6136(1)

6132(1)

63901(1)

T089(1)

T46826(1)

T1671(1)

T1670(1)

T58007(1)

T6061(1)

T91408(1)

T83905(1)

T79001(1)

T91410(1)

T91411(1)

T91414(1)

T91413(1)

T91412(1)

T6491(1)

T6490(1)

T6067(1)

T6064(1)

T6062(1)

T6068(1)

T6069(1)

T6480(1)

T6135(1)

T6071(1)

6131(1)

6072(1)

2418(1)

2402(1)

1733(1)

2420(1)

2421(1)

51450(1)

2424(1)

2422(1)

1731(1)

70102(1)

0768223202(1)

0768223199(1)

97189(1)

140044(1)

140045(1)

48556(1)

4384(1)

340301(1)

51480(1)

5157(1)

62273(1)

ZP2613(1)

ZP2612(1)

12144(1)

72900(1)

53109(1)

38930(1)

38913(1)

ZP2611(1)

74734(1)

5185(1)

5166(1)

5165(1)

5186(1)

73400(1)

74731(1)

74170(1)

74150(1)

6007(1)

 
Country of Origin

United States(69)

China(9)

Mexico(1)

 
Material

Paper(15)

Plastic(1)

Foam(1)

Foil(1)

 
Height

3"(8)

1"(2)

22"(1)

0.50"(1)

 
Width

24"(9)

2.25"(6)

17"(1)

1"(1)

1.25"(1)

 
Sheet Size

10 1/2" x 8"(5)

8" x 10 1/2"(2)

24" x 16"(1)

3 1/2" Width x 4 1/8" Length(1)

24" x 32"(1)

12" x 9"(1)

6" x 9"(1)

8" x 10"(1)

8 1/2" x 11"(1)

 
Shape

Rectangle Topped With Waves(6)

432 x Round(1)

432 x Assorted(1)

83 x Capital Letter(1)

28 x Punctuation Marks(1)

Smiles & Stars(1)

Round(1)

432 x Varied(1)

Assorted(1)

Rectangle(1)

432(1)

480 x Assorted(1)

1300 x Star(1)

Varied(1)

Star(1)

 
Length

390"(6)

16"(1)

32"(1)

 
Number of Sheets

500(8)

25(2)

100(1)

 
Sheet Width

8 1/2"(1)

 
Grade

4 to 8(3)

2(3)

3 to 8(2)

3(2)

1 to 3(2)

1(1)

2-8(1)

2 to 3(1)

5-8(1)

K-1(1)

 
Adhesive Type

Removable(1)

 
Number of Pages

40(1)

 
Number of Pieces

96(1)

 
 
 

© 2019-2020 Edwards Office System, All Rights Reserved