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 (`pinfo`.`sku` IN ('SAN30001','PAP8430152','SAN30002','PAP8410152','PAP8420152','PAC001318','SPR23810','PAP1928605','BSN82977','SAN25005','DEF421103','STX70105U06C','PAC001309','TEPT6480','AVT34004','AVT34104','PAC001327','CLI32004','CLI32005','PAC001308','HUB910L','AVT34007','DEF329003BB','HUBSA98','PAC1733','PAC001310','AVT40309','CEP2006950110','SPR23811','PAC001316','AKM10126','CLI32006','PAC5166','HUB18','AVT37530','PAC001312','BSN82979','PAC74170','MEA59010','STX00941U06C','HUB91018','HUB67L','STX62012U03C','LRNLER0477','TEPT73901','HUB16','MEA20038','PAC20010','TEPT83901','TEPT73902','MPD7940B','TEPT83905','DEF350201','CDPCD5615','DEF350501','MEA59016','MEA20040','LRNLER3776','LRNLER2418','TEPT2951','LRNLER6900','TEPT1945','MPD8207','BSN82980','MEA59012','STX62406U06C','USS4630','LRNLER2206','MEA59014','BAU77042','MPD8210','LRNLER4275','AVE18701','CDP158161','TEPT46917','CEP2006760110','PAC20360','MPD7917B','TCR6644','MPD7904B','STX70109U06C','MPD7928B','TCR9028','DEF3901CR','TEPT1942','LRNLER3806','CDP158158','AVT5703','CDPCD5644','ASH10400','CTC6686','TCR20736','TEPT2965','MPD7500B','PAC20410','TEPT68070','HYX15730','HYX15630','LRNLER2255','DEF3900CR','ASH10403','PAC20800','CTC7425','TEPT81019','CDP158567','LRNLER6447','LRNLER0678','CTC7424','TEP69401','TEPT8107','CDP122029','TEPTA67909','TEPT68022','MPD2117B','TEP25212','TCR20738','TEPT81401','HYX43510','TCR9029','MPD7662B','CDP158563','TEP25202','CDP158565','CDP9413','MPD52060B','MPD52039B','TEP69402','TEPT25044','CTC5649','TEPT25053','TCR2152','')) 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 '%UltimateLearningEnvironment' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('UltimateLearningEnvironment' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+UltimateLearningEnvironment' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+UltimateLearningEnvironment' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='UltimateLearningEnvironment',`category_4` ='UltimateLearningEnvironment') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'UltimateLearningEnvironment,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('UltimateLearningEnvironment', `pinfo`.`desc_title`)) DESC

Currently Filtered by

UltimateLearningEnvironment

UltimateLearningEnvironment

Refine Search

  GO
 
Category

Charts(12)

Stickers(8)

Desktop Organizers(8)

Wood Pencils(8)

Storage Boxes & Containers(7)

Certificates(5)

Posters(5)

Memo / Subject Notebooks(4)

Learning Boards(4)

Felt-tip/Porous Point Pens(4)

Decorative Banners(4)

Educational Record Books(3)

Creative Learning(3)

Art Pencils(3)

Teaching Calendars & Planners(3)

Mailroom Sorters & Tables(3)

Craft Supplies(3)

Name Badges/Systems(3)

Report Covers(3)

Portable Storage Files & Bins(2)

Hanging Pockets(2)

Permanent Markers(2)

Pocket Charts(2)

Wall Organizers/Sorters(2)

Teacher/Classroom Management(2)

Wall Organizer Systems(2)

Self-Inking Stamps(2)

Vinyl/Plastic Pockets & Sleeves(2)

Portable File Caddies(1)

Tank-Style Highlighters(1)

Nameplates(1)

Literature Organizers/Sorters(1)

Carts(1)

Mobile File Carts & Cabinets(1)

Appointment Books & Planners(1)

Storage Systems(1)

Copier/Laser/Inkjet Index Dividers(1)

Index Dividers(1)

Wall Files, Pockets & Accessories(1)

Stamp Pads(1)

Dry-Erase Boards(1)

Note Cards(1)

Tool Storage & Organization(1)

Magazine Files(1)

Desktop File Sorters(1)

Binder Pockets(1)

Teaching Flash Cards(1)

 
Brand

Trend(22)

Moon Products(11)

Learning Resources(10)

Carson-Dellosa(9)

Pacon(7)

Classroom Keepers(7)

Deflecto(6)

Teacher Created Resources(6)

Ward(6)

Advantus(5)

Storex(5)

Paper Mate(4)

Creative Teaching Press(4)

Cambridge(4)

Sharpie(3)

Hygloss(3)

C-Line(3)

Business Source(3)

Ashley(2)

Five Star(2)

Sparco(2)

CEP(2)

Stamp-Ever(1)

Gem Office Products(1)

Baumgartens(1)

Akro-Mils(1)

 
Color

Assorted(15)

Clear(12)

Multicolor(11)

Blue(10)

White(9)

Red(6)

Green(4)

Purple(4)

Yellow(3)

Clear Pocket(3)

Black(3)

Assorted Bright(2)

Clear Label Holder(2)

Off White(2)

Multi(2)

Dark Green(2)

Neon Green(1)

Neon Yellow(1)

Neon Orange(1)

Neon Pink(1)

Neon Blue(1)

Silver(1)

Gold(1)

Transparent(1)

Smoke/Matte Gray(1)

Teal(1)

Lime(1)

Aqua(1)

 
Size

8.50" Width x 5.50" Length(3)

8.50" Width x 11" Length(2)

9" Height(1)

 
Size

Letter(3)

 
Recycled

No(104)

Yes(10)

 
Sheet Size

8 1/2" Width x 11" Length(7)

11" x 8 7/8"(1)

3" x 5"(1)

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved