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(11)

Craft Kits(9)

Indoor/Outdoor games(8)

Permanent Markers(7)

Memo / Subject Notebooks(6)

Learning Books(5)

Art Markers(5)

Appointment Books & Planners(4)

Felt-tip/Porous Point Pens(3)

Storage Boxes & Containers(3)

Colored Pencils(3)

Wall Calendars(3)

Paints(3)

Hook & Loop/VELCRO Tapes(2)

Puzzles(2)

Learning Boards(2)

Poster Boards(2)

Art Paper Rolls and Sheets(2)

Foam Boards(2)

Construction Paper(2)

Aprons(2)

Beverage Dispensers/Coolers(2)

Desktop Organizers(2)

Ballpoint Retractable Pens(2)

Correction Tapes(2)

Public Address Systems(2)

Crayons(2)

Stickers(2)

Pen-Style Highlighters(1)

Erasable Notes & Markers(1)

Multipurpose Labels(1)

Mechanical Pencils(1)

Car Organizers(1)

Flipchart Markers(1)

Ballpoint Stick Pens(1)

Rubber Cement(1)

Appointment Books(1)

Decorative Banners(1)

Scissors(1)

Rulers & Yardsticks(1)

Desk Calendars(1)

Letter, Legal & Jr. Pads(1)

Paper Trimmers(1)

Rugs(1)

Reference Books(1)

All-Purpose Glues(1)

Sketch Pads & Drawing Paper(1)

Handwriting 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