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 ('QRTP558AP2','QRTP557AP2','QRTP554AP2','QRTP553AP2','QRTP558MP2','QRTP557MP2','QRTP554MP2','QRTP553MP2','QRTP558BP2','QRTP557BP2','QRTP554BP2','QRTTE548AP2','QRTTE547AP2','QRTTE544AP2','QRTTE543AP2','QRTTE548MP2','QRTTE547MP2','QRTTE544MP2','QRTTE543MP2','QRT2548','QRT2547','QRT2545','QRT2544','QRT2543','QRT2548B','QRT2547B','QRT2545B','QRT2544B','QRT2543B','QRTB247LC','QRTB244LC','QRTB243LC','QRTB247G','QRTB244G','QRTB243G','QRT2308','QRT2307','QRT2305','QRT2304','QRT2303','QRT2308B','QRT2307B','QRT2305B','QRT2304B','QRT2303B','QRTS538','QRTS537','QRTS535','QRTS534','QRTS533','QRTS537B','QRTS535B','QRTS534B','QRTS533B','QRTP563T','QRTP564T','QRTP567T','QRTP568T','QRTB364T','QRTB367T','MEA06327','MEA06328','MEA45007','MEA45008','MEA06122','MEA59880','MEA59882','MEA06180','MEA45484','MEA06206','MEA06210','MEA06208','MEA17010','MEA05510','MEA05512','MEA06622','MEA06900','MEA05514','MEA06710','MEA06546','MEA06780','MEA06542','MEA17208','MEA06544','MEA06594','MEA06674','WLJ86610PP2','WLJ86611PP2','WLJ86660PP2','WLJ86661PP2','WLJ86620PP2','WLJ86621PP2','WLJ86630PP2','WLJ86631PP2','WLJ363-14-1797PP','WLJ363-14WAPP1','WLJ363-14-7462PP','WLJ363-14BAPP1','WLJ363-34-1797PP','WLJ363-34WAPP1','WLJ363-34-7462PP','WLJ363-34BAPP1','WLJ363-44-1797PP','WLJ363-44WAPP1','WLJ363-44-7462PP','WLJ363-44BAPP1','WLJ363-49WAPP1','WLJ363-49BAPP1','ACC72360','ACC72500','ACC72380','ACC72385','ACC72580','ACC72585','AAG70950X05','AAG70260X05','AAG7012005','AAG7021405','AAG7026005','AAG70260G05','AAG7080005','AAG7095005','AAG70950G05','AAG70EP0105','AAG760105','AAG760605','AAG7695005','AAGSD37613','AAGSD38913','AAGSK14X00','AAGE71250','AAGE717T50','AAGGG250000','AAGSK117000','AAGSK1400','AAGSK2400','AAGSK32G00','AAGSK70000','AAGSW20000','AAGPM2X28','AAGDMW20028','AAGPM1128','AAGPM128','AAGPM17028','AAGPM228','AAGPM2628','AAGPM328','AAGPM428','AAGPM5028','AAGPM628','AAGPM828','AAGSK800','AAGSW11528','')) 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 '%ProudlyCrafted' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ProudlyCrafted' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ProudlyCrafted' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ProudlyCrafted"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ProudlyCrafted"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ProudlyCrafted"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ProudlyCrafted"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ProudlyCrafted' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ProudlyCrafted',`category_4` ='ProudlyCrafted') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ProudlyCrafted,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ProudlyCrafted', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Proudly-Crafted

Proudly Crafted

Refine Search

  GO
 
Category

Dry-Erase Boards(35)

Memo / Subject Notebooks(22)

Cork/Fabric Bulletin Boards(13)

Wall Calendars(11)

Appointment Books & Planners(9)

Paper Clips(6)

Calendar Desk Pads(6)

Bulletin Boards(5)

Boards(4)

Appointment Books(4)

Combination Bulletin/Dry-Erase Boards(3)

Calendars(2)

Letter, Legal & Jr. Pads(2)

Business Diaries(2)

Desk Calendars(1)

Calendar Refills(1)

Desk Calendar Refills(1)

Wall Planners & Organizers(1)

Handwriting Paper(1)

Filler Papers(1)

 
Brand

Quartet(60)

At-A-Glance(31)

Mead(25)

AT-A-GLANCE(7)

Acco(5)

Wilson Jones(1)

Five Star(1)

 
Color

Black(8)

White(8)

Silver(6)

Blue(3)

Red(1)

Gray(1)

Buff(1)

Yellow(1)

 
Size

12 x 17(1)

22 x 17(1)

4 1/2 x 7 3/8(1)

8 1/4 x 10 7/8(1)

8 7/8 x 11(1)

8 x 4 7/8(1)

6 7/8 x 8 3/4(1)

 
Size

Letter(5)

 
Recycled

No(87)

Yes(32)

 
Sheet Size

8 1/2" x 11"(6)

8" x 10 1/2"(4)

6" x 9 1/2"(3)

11" x 8 1/2"(3)

8 1/2" x 11 3/4"(2)

5" x 7"(2)

9 1/2" x 6"(1)

 
 
 

© 2018-2019 Dawkins Office Supply, All Rights Reserved