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 ('CYO040384','AAGW1148B707','AAGSK240019','SAN22480PP','SAN39108PP','AAGSD38179','EPI234','SAN1735801','REDC1731V','AAGD1141705','ACM12975','AAGD1141704','BLS100009','BICWOELP10','OXF161648','CYO586501','OXF161647','REDC1811001','AAGYP90513','LRNLER8904','LRNLER2937','FIPDYM74','AAG1131201','PENBL407XABX','CYO586502','FCIFA101844FS','SAN2033573','PAP2027189','PIL44155','EII8888','AAGDR111804042','ZEB29811','SAN2021193','PAP2027233','TOM68695','ZEB65111','VEK70188','CIIPA11','CIIPA219','CYO682005','PIL44158','CDP145103','AVT37818','MEA97046','CYO990028','TOM56187','ACM15983','PAC103646','VEK30631','FIPFWX12','AVT37817','BICVCGB11BE','CDP145104','TOP406462','MEA98222','MEA2301937','VEK70191','LRNLER6708','ZEB80111','TCR20834','PAC103645','LRNLER2843','CDP145097','PACCAR40011','MEA59317','TCR77871','BICPMIPJ11BK','FIPDWL34','TOM61500','CDP145095','MEA59293','SAN2018335','VEK70183','TCR77873','TCR77350','PAC57532','PAP2017521','TCR77875','TCR77326','TCR2152','MBLFWK22','LRNLER2857','LRNLER2858','VEK30033','CDP145109','MEA98216','EII1776','VEK70192','TCR77872','CDP145105','PENAL27USAPC12M','PACAC6053','TCR77325','LRNLER7289','TCR20836','CYO990026','SAN2018324','RYL59802','TEP8350','EII5085','MEA97044','DBE01052','VEK30636','PAC5546','JDK400110530','TOP161630','TOP161631','ROA16722','HAN882255','CDP145106','CDP145107','LRNLER9221','LRNLER9222','LRNLER9227','LRNLER2863','LRNLER2935','RYL59801','MTTFLB35','MTTFLB80','CDP145090','TCR9460','CDP419331','CDP419461','CDP102614','CDP697961','MBLFLY44','MBLFLY43','PACCAR12080','CDP145096','DBE01009','MER7456','HAN882560','MBLGCT50','LRNLER9287','PACAC9307','CDP140350','LRNLER9288','EII1714','EII5286','RYL45020','FIPDYM76','EII3663','EII4129','CUI12650','FIPFNR97','PAC1001002','PAC1001001','PAC100103','PAC100104','PAC100105','PACCAR39717','MEA2301938','PAC57533','EPI2024692','EPI2062244','')) 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 '%NewYearNewProducts' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('NewYearNewProducts' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+NewYearNewProducts' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"NewYearNewProducts"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"NewYearNewProducts"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"NewYearNewProducts"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"NewYearNewProducts"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+NewYearNewProducts' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='NewYearNewProducts',`category_4` ='NewYearNewProducts') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'NewYearNewProducts,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('NewYearNewProducts', `pinfo`.`desc_title`)) DESC

Currently Filtered by

New_Year_New_Products

New_Year_New_Products

Refine Search

  GO
 
Category

Creative Learning(26)

Bulletin Board Sets(12)

Craft Kits(9)

Indoor/Outdoor games(8)

Appointment Books & Planners(7)

Permanent Markers(7)

Memo / Subject Notebooks(6)

Learning Books(5)

Art Markers(5)

Wall Calendars(4)

Paints(3)

Felt-tip/Porous Point Pens(3)

Storage Boxes & Containers(3)

Colored Pencils(3)

Desk Calendars(3)

Puzzles(2)

Hook & Loop/VELCRO Tapes(2)

Learning Boards(2)

Construction Paper(2)

Poster Boards(2)

Art Paper Rolls and Sheets(2)

Foam Boards(2)

Public Address Systems(2)

Aprons(2)

Correction Tapes(2)

Stickers(2)

Crayons(2)

Beverage Dispensers/Coolers(2)

Ballpoint Retractable Pens(2)

Desktop Organizers(2)

Multipurpose Labels(1)

Mechanical Pencils(1)

Pen-Style Highlighters(1)

Ballpoint Stick Pens(1)

Car Organizers(1)

Erasable Notes & Markers(1)

Flipchart Markers(1)

Rubber Cement(1)

Letter, Legal & Jr. Pads(1)

Scissors(1)

Rulers & Yardsticks(1)

Business Diaries(1)

Paper Trimmers(1)

Handwriting Paper(1)

Reference Books(1)

Rugs(1)

All-Purpose Glues(1)

Sketch Pads & Drawing Paper(1)

Art Pencils(1)

 
Brand

Learning Resources(14)

Teacher Created Resources(11)

Carson-Dellosa(11)

At-A-Glance(8)

Sharpie(7)

VELCRO® Brand(7)

Educational Insights(6)

Pacon(6)

Crayola(6)

Mead(5)

Mega Bloks(4)

Rourke Educational(4)

Derwent(3)

Paper Mate(3)

BIC(3)

Zebra Pen(3)

Tombow(3)

Roylco(3)

Learn It By Art™(3)

Laugh & Learn(3)

Elmer's(3)

Fadeless(2)

Riverside(2)

Advantus(2)

Pentel(2)

Oxford University Press(2)

dbest(2)

Califone(2)

Westcott(2)

Little Mommy(2)

Handy Art(2)

Roaring Spring(1)

Flagship Carpets(1)

Trend(1)

Filofax(1)

GeoSafari(1)

Oxford(1)

CARL(1)

Think & Learn(1)

Blue Sky(1)

Merriam-Webster(1)

Little People(1)

Mind Sparks(1)

Ghostline(1)

Pilot(1)

FriXion(1)

Black n' Red(1)

Brownline(1)

 
Color

Multi(29)

White(15)

Assorted(14)

Multicolor(14)

Black(10)

Blue(7)

Gray(6)

Pink(4)

Brown(4)

Navy(3)

Silver(3)

Red(3)

Orange(3)

Yellow(2)

Light Blue(2)

Green(2)

Gold(2)

Natural(1)

Flame(1)

Cobalt(1)

Brilliant Green(1)

Azure(1)

Brilliant Blue(1)

Indigo(1)

Gunmetal Gray(1)

Magenta(1)

Deep Purple(1)

Canary(1)

Apple Green(1)

Lime(1)

Royal Blue(1)

Neon(1)

Deep Orange(1)

Crimson(1)

Light Brown(1)

Brilliant Red(1)

Yellow Ochre(1)

Teal(1)

Rose Gold(1)

Peach(1)

Burnt Umber(1)

Turquoise(1)

Deep Black(1)

Leaf Green(1)

Light Peach(1)

Red Brown(1)

Cyanine(1)

Violet(1)

Shamrock(1)

Blue Purple(1)

 
Recycled

No(122)

Yes(4)

 
Sheet Size

9" x 11"(2)

6" x 8"(1)

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved