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)

Permanent Markers(7)

Memo / Subject Notebooks(6)

Learning Books(5)

Art Markers(5)

Appointment Books & Planners(4)

Paints(3)

Felt-tip/Porous Point Pens(3)

Storage Boxes & Containers(3)

Colored Pencils(3)

Wall Calendars(3)

Puzzles(2)

Hook & Loop/VELCRO Tapes(2)

Public Address Systems(2)

Learning Boards(2)

Foam Boards(2)

Poster Boards(2)

Art Paper Rolls and Sheets(2)

Aprons(2)

Construction Paper(2)

Desktop Organizers(2)

Ballpoint Retractable Pens(2)

Stickers(2)

Beverage Dispensers/Coolers(2)

Crayons(2)

Correction Tapes(2)

Mechanical Pencils(1)

Multipurpose Labels(1)

Flipchart Markers(1)

Car Organizers(1)

Pen-Style Highlighters(1)

Ballpoint Stick Pens(1)

Erasable Notes & Markers(1)

Rugs(1)

Appointment Books(1)

Letter, Legal & Jr. Pads(1)

Scissors(1)

Rulers & Yardsticks(1)

Desk Calendars(1)

Paper Trimmers(1)

Handwriting Paper(1)

Reference Books(1)

Rubber Cement(1)

All-Purpose Glues(1)

Sketch Pads & Drawing Paper(1)

Art Pencils(1)

 
Brand

Learning Resources(14)

Carson-Dellosa(11)

Teacher Created Resources(11)

Sharpie(7)

VELCRO® Brand(7)

Crayola(6)

Pacon(6)

Educational Insights(6)

Derwent(4)

Mega Bloks(4)

Mead(4)

Rourke Educational(4)

Roylco(3)

Paper Mate(3)

Laugh & Learn(3)

Learn It By Art™(3)

BIC(3)

Elmer's(3)

Tombow(3)

Zebra Pen(3)

Fadeless(2)

dbest(2)

Westcott(2)

Oxford University Press(2)

Pentel(2)

Advantus(2)

Riverside(2)

Califone(2)

Handy Art(2)

At-A-Glance(2)

Little Mommy(2)

Little People(1)

Black n' Red(1)

Trend(1)

Oxford(1)

GeoSafari(1)

Flagship Carpets(1)

Roaring Spring(1)

Think & Learn(1)

Brownline(1)

Ghostline(1)

Mind Sparks(1)

Merriam-Webster(1)

CARL(1)

FriXion(1)

Blue Sky(1)

Pilot(1)

Filofax(1)

 
Color

Multi(29)

Assorted(13)

Multicolor(13)

White(12)

Black(10)

Blue(6)

Brown(4)

Red(3)

Pink(3)

Gray(3)

Silver(3)

Orange(2)

Yellow(2)

Light Blue(2)

Green(2)

Gold(2)

Flame(1)

Natural(1)

Brilliant Green(1)

Royal Blue(1)

Azure(1)

Cobalt(1)

Indigo(1)

Gunmetal Gray(1)

Magenta(1)

Deep Purple(1)

Apple Green(1)

Lime(1)

Canary(1)

Red Brown(1)

Light Brown(1)

Burnt Umber(1)

Turquoise(1)

Crimson(1)

Deep Orange(1)

Peach(1)

Yellow Ochre(1)

Brilliant Red(1)

Violet(1)

Shamrock(1)

Leaf Green(1)

Light Peach(1)

Blue Purple(1)

Deep Black(1)

Teal(1)

Neon(1)

Cyanine(1)

Brilliant Blue(1)

 
Size

11 x 8 1/2(1)

 
Recycled

No(116)

Yes(3)

 
Sheet Size

9" x 11"(2)

6" x 8"(1)

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved