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)

Memo / Subject Notebooks(8)

Permanent Markers(7)

Appointment Books & Planners(7)

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)

Roylco(3)

BIC(3)

Zebra Pen(3)

Oxford(3)

Tombow(3)

Learn It By Art™(3)

Elmer's(3)

Laugh & Learn(3)

Califone(2)

Fadeless(2)

Handy Art(2)

Advantus(2)

Westcott(2)

Riverside(2)

Pentel(2)

dbest(2)

Oxford University Press(2)

Little Mommy(2)

Merriam-Webster(1)

CARL(1)

Flagship Carpets(1)

Trend(1)

Black n' Red(1)

Little People(1)

Think & Learn(1)

GeoSafari(1)

Filofax(1)

Mind Sparks(1)

Blue Sky(1)

Ghostline(1)

FriXion(1)

Brownline(1)

Pilot(1)

Roaring Spring(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(118)

Yes(5)

 
Sheet Size

9" x 11"(2)

6" x 8"(1)

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved